databases

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

Submitted by jordi on Wed, 08/25/2010 - 23:56

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)

Submitted by jordi on Sun, 08/08/2010 - 22:56

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

Submitted by jordi on Tue, 07/27/2010 - 16:10

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

Submitted by jordi on Tue, 07/20/2010 - 07:11

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?

Submitted by jordi on Tue, 07/13/2010 - 08:13

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.

UML to VoltDB - New DBMS for the SQL DDL generation service

Submitted by jordi on Tue, 07/13/2010 - 05:50

VoltDB provides a very fast, scalable, fault-tolerant and ACID-compliant, distributed SQL database for transactional (OLTP) applications.

LiquiBase - Version control for database schemas

Submitted by jordi on Fri, 05/14/2010 - 12:45

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

Submitted by jordi on Wed, 04/21/2010 - 19:33

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)

Subscription to the UMLtoDB service now open

Submitted by jordi on Mon, 03/29/2010 - 12:24

You can now subscribe to the professional version of the UMLtoDB service (the simplest way to create your database schemas!). As explained in a previous post , subscription process is managed using FastSpring

A special reduced price is available for subscriptions done before the end of April.

On commit triggers - Am I the only one missing them?

Submitted by jordi on Tue, 12/15/2009 - 07:28

databases

Neither the SQL standard nor any of the major database vendors provide an ON COMMIT trigger (i.e. a trigger that fires when a transaction commits). The only exception (AFAIK) is Firebird

Content

Services

Ads

Links