The Rational UML Data Modeling Profile was designed by Rational Software, Inc. with their CASE tool Rational Rose in mind. It was the first data modeling profile to be developed. It avoids the use of the “tagged value” extension of UML, which Rose does not support, in favor of a scheme involving automated generation of methods with complex names and numbers to represent relationships .
The Agile Data UML Profile for Data Modeling was created by Scott Ambler of Ronin international, Inc. The idea of the Agile Data Model is to provide a grass roots standard while hoping that OMG eventually comes out with an official data modeling profile. It is use to re present conceptual data model, logical data model and physical data model.
Some projects that were examined for similar ideas are called ZsqlML, UML2SQL and XMI2SQL.
UML2SQL: Dr. Ingo Kegel of ejtechnologies, GmbH, wrote unified Modeling Language to Structured Query Language (UML2SQL). This implementation updates the content of a database in real time as the model is created. At the time, UML2SQL project was developed, no standard UML Profiles were available. For that reason a proprietary UML Profile was used. This proprietary UML Profile helped with the problem of conversion from XMI to SQL, and executed SQL commands for a specific DBMS server.
ZsqlML: Zenark Structured Query Language Modeling Language (ZsqlML) is written by Adrian Geissel of Zenark Ltd. from the project’s website SourceForge.net. ZsqlML is defined as an XML DTD allowing you to specify relational database structure using an XML object hierarchy.” However, since ZsqlML was not designed for forward engineering, it could not be used.
XMI2SQL: this tool is developed by Sam Chung and Eric Hartford to bridge the gap between data model and its implementation. This tool is also closer to implementation so its input is logical schema (entity) in XMI format and output is DDL/SQL (database...