databases Archive

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.

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.