databases Archive

Big Data and modeling: Are they mutually compatible?

Ten thngs to keep in mind when mixing modeling and big data. Modeling is as important as ever when dealing with big data but it must be adapted

MetaScience: Holistic Approach for Research Modeling and Analysis

Our work “MetaScience: an Holistic Approach for Research Modeling” has been accepted at ER2016. This article

UMLtoGraphDB: Mapping UML to NoSQL Graph Databases

Few solutions target UML to NoSQL code-generation and even less consider OCL constraints. We present a UML/OCL transformation to Blueprints, an abstraction layer on top of a variety of graph databases

NeoEMF: a multi NoSQL Persistence Framework for Very Large Models

In this post we present our latests updates on NeoEMF, our solution to store and access

Mogwaï: Querying large models via an OCL to NoSQL / GraphDB transformation

Mogwaï is framework to store large models in a GraphDB NoSQL backend (thanks to NeoEMF) and efficiently query those models by means of a OCL to Gremlin (a query language for some NoSQL databases) transformation.

SQL Database for your Git repository (slides)

Export your Git repositories to a relational database for a simpler data analysis using standard SQL tools. Easy integration with other tools

EMF views (database views ported to the modeling world) – ER 2015 slides available

Slides of our work on EMF Views – A View Mechanism for Integrating Heterogeneous Models presented

Gitana: a SQL-based Git Repository Inspector

Export your Git repositories to a relational database for a simpler data analysis using standard SQL tools. With Incremental synchronization

Q: OCL to SQL tools

Do you know modeling tools with an OCL to SQL code generation feature?. The list of OCL tools is small, and few of them include code-generation for OCL. Let's review what we have

EMF Views – A View Mechanism for Integrating Heterogeneous Models

Modeling complex systems involves dealing with several heterogeneous and interrelated models defined using a variety of languages. Similarly to the concept of views in databases, we introduce EMF Views an approach for defining views on potentially heterogeneous models.

From SQL to OCL – Extracting constraints and derivation rules from relational DBs

Valerio Cosentino and Salvador Martinez presented in the International Workshop on OCL, Model Constraint and Query

Telosys Tools : the concept of “lightweight model” for code-generation

Telosys Tools (http://tools.telosys.org/) is a simple and pragmatic code generator. Provided as an Eclipse Plugin (http://marketplace.eclipse.org/content/telosys-tools

Reverse engineering of database security policies

Continuing with our research line on model-driven reverse engineering (notably around our MoDisco Eclipse project), Salvador

From Relational Databases to Models: Reverse engineering with ScheMoL

Javier Cánovas talks today about ScheMoL, his approach (co-authored with Oscar Díaz, Gorka Puente and Jesús

No Java API to import / export sql files (really?)

I was looking for a way to import and export sql files to/from a mysql database

Exhaustive list of data modeling tools

I use UML for data(base) modeling (see this post for a discussion on the suitability of

The only thing I miss from the ER language

The Entity-relationship was (well, still is in the database domain) a popular modeling language to define

Modeling and generating spatial databases with MOSKitt

MOSKitt , a free modeling platform FOR Eclipse (see this detailed interview TO know MORE about it AND the people behind the project) can now be used TO model AND generate spatial databases.

NO two programmers use the same notation (experiment)

Zuzel Vera Pacheco, a Master Student AT the University OF Toronto under the supervision OF Greg Wilson has been working ON the Back-annotation OF DATA models AT run-TIME . FOR a short description OF her project see also this presentation ON slideshare.

Complaint about my code-generation strategy to implement many-to-many associations in relational databases

I got a complaint about the translation of many-to-many UML associations to SQL tables in my UMLtoSQL online service .

More specifically, the complaint was that in the translation of this UML class diagram:

Example