databases Archive

Programming & Modeling news (January 2016 edition)

Some links to tools/posts/news I've found interesting these past few days, including why I don't like MVCs, a free database book and more

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

UML class diagrams easier to understand than ER diagrams

Greg Wilson pointed me to the paper A. De Lucia, C. Gravino, R. Oliveto, G. Tortora, An Experimental Comparison of ER and UML Class Diagrams for Data Modelling, Empirical Software Engineering (2010) 15:455–492 (if you cannot access the paper, you may try directly contacting the authors).

The paper presents the results of three sets of controlled experiments aimed at analyzing whether UML class diagrams are more comprehensible than ER diagrams during data models maintenance.

VoltDB: Is a database without foreign keys useful enough for you?

IN the previous post we have announced the availability OF our UML TO VoltDB TRANSLATION service . However, if you try it, you may GET the feeling that the generated SQL script looks incomplete.

LiquiBase – Version control FOR database schemas

Thanks to Lothar Behrens , I discover LiquiBase a "an open source (LGPL), database-independent library for tracking, managing and applying database changes" (by database changes, they mean changes on the database schema).

LiquiBase offers version control support for database schemas and includes the possibility of checking the differences between two schema versions. For some schema changes, LiquiBase is even able to generate also the SQL script required to update the database data.

SQL Pretty Printer

SQL Pretty Printer IS a SQL formatting tool (used AS a stand-alone OR integrated WITH your own tool through its API) TO easily GET your favourite SQL code layout WITH MORE than 60 formatting options AND several layout templates.

It would have been nice TO discover this tool before I wrote the simple formatting class FOR my SQL generation service (though I'd need a Java API version of the tool)