IBM Support

Differences between a data model and a logical data model in XDE

Troubleshooting


Problem

This technote describes the major difference between a data model and a logical data model in IBM® Rational XDE™.

Resolving The Problem

In logical data modeling, it is possible to use information gathered from analyzing business needs to identify entities, define attributes that describe the entities, and create relationships between the entities. It is also possible to use a logical data model as a basis for implementing a database solution that meets business needs.

In XDE, it is possible to create a logical data model by modeling Unified Modeling Language™ (UML) classes that represent data modeling entities, and modeling attributes and relationships for those classes. Transforming the UML classes generates physical data model tables, and XDE maps those tables to the UML classes.

In XDE, a physical data model is called a data model. It is possible to model tables with columns that store data, and relationships that relate the tables to each other. It is also possible to model tablespaces that manage the physical device space for storing data, and assign tables to a tablespace or directly to a database component. All these elements require a physical implementation through either a database management system (DBMS) language or the ANSI® SQL 92 standard. The language used in the data model is determined by setting the default database target or by specifying a database target for your database in the Properties window.




[{"Product":{"code":"SSSHYJ","label":"Rational XDE Developer"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2003.06.00;2003.06.01;2003.06.12;2003.06.13;2003.06.14;2003.06.15","Edition":"All Editions","Line of Business":{"code":"LOB67","label":"IT Automation & App Modernization"}},{"Product":{"code":"SSSHYJ","label":"Rational XDE Developer"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"","label":"All Platforms"}],"Version":"2003.06.00;2003.06.01;2003.06.12;2003.06.13;2003.06.14;2003.06.15","Edition":"All Editions","Line of Business":{"code":"LOB67","label":"IT Automation & App Modernization"}},{"Product":{"code":"SSSJ2Z","label":"Rational XDE Java"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":"All Platforms"}],"Version":"2003.06.00;2003.06.01;2003.06.12;2003.06.13;2003.06.14;2003.06.15","Edition":"All Editions","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSAVLQ","label":"Rational XDE Professional .NET Edition"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":"All Platforms"}],"Version":"2003.06.00;2003.06.01;2003.06.12;2003.06.13;2003.06.14;2003.06.15","Edition":"All Editions","Line of Business":{"code":"","label":""}},{"Product":{"code":"SUNSET","label":"PRODUCT REMOVED"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":"All Platforms"}],"Version":"2003.06.00;2003.06.01;2003.06.14","Edition":"All Editions","Line of Business":{"code":"","label":""}},{"Product":{"code":"SS5LUU","label":"Rational Rose XDE Developer for Java"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":"All Platforms"}],"Version":"2003.06.00;2003.06.01;2003.06.14","Edition":"All Editions","Line of Business":{"code":"","label":""}},{"Product":{"code":"SS5LVL","label":"Rational Rose XDE Developer for Visual Studio"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":"All Platforms"}],"Version":"2003.06.00;2003.06.01;2003.06.14","Edition":"All Editions","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSSHYJ","label":"Rational XDE Developer"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"","label":"All Platforms"}],"Version":"2003.06.00;2003.06.01;2003.06.14","Edition":"All Editions","Line of Business":{"code":"LOB67","label":"IT Automation & App Modernization"}}]

Document Information

Modified date:
16 June 2018

UID

swg21152684