Category Archives: databases

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

sql to ocl

Valerio Cosentino and Salvador Martinez presented in the International Workshop on OCL, Model Constraint and Query Languages (OCL 2013) co-located with MODELS 2013 their work on the extraction of OCL integrity constraints and derived types from relational databases. Valerio briefly describes their approach. The goal of this work is to complement existing works on reverse

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


Telosys Tools ( is a simple and pragmatic code generator. Provided as an Eclipse Plugin ( ), it uses an original approach mixing “database first scaffolding” and classical model driven engineering. Laurent Guérin, one of the key people behind the project tells us more about it. This tool aims to provide an alternative to the

Reverse engineering of database security policies


Continuing with our research line on model-driven reverse engineering (notably around our MoDisco Eclipse project), Salvador describes our recent work on the automatic extraction of database security policies. As a result we produce a RBAC-like database-specific security model. The paper will be presented at the DEXA’13 conference and has been co-authored by Salvador Martínez, Valerio

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 García Molina ) for the reverse engineering of relational databases. Note that, ulike other approaches, the goal is not to get a model representing the database schema but to transform the database data into a model (conforming to a

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 from within a Java application (i.e. I want to let users upload a .sql file in the application and import this file, similarly I want them to be able to create a dump of the database they uploaded before)

Exhaustive list of data modeling tools


I use UML for data(base) modeling (see this post for a discussion on the suitability of UML for this task) but many many people (specially with a strong database babckground) still prefers to use the ER language or any of its variants for data modeling. If you are one of them, I’m pretty sure you’ll

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 the (static) conceptual schema of your system. UML class diagrams (with a little bit of help from OCL) can be regarded as a superset of the ER language, which explains why ER is slowly disappearing (e.g. some years ago,

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.

A new video for UMLtoDB – the online SQL code generation service

Now you can see a video OF the UMLtoDB online generation service showing how easy IS TO generate your database SCHEMA FROM a simple UML model (ONLY a class diagram IS needed; forget about USING stereotypes OR ad hoc UML extensions).

See the video below:

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.

Powered by WordPress