Logical Data Object Models
A logical data object model describes the structure and use of data in an enterprise. The model contains logical data objects and defines relationships between them.
Define a logical data object model to create a unified model of data in an enterprise. The data in an enterprise might reside in multiple disparate source systems such as relational databases and flat files. A logical data object model represents the data from the perspective of the business regardless of the source systems. Create a logical data object model to study data, describe data attributes, and define the relationships among attributes.
For example, customer account data from American Bank resides in an Oracle database, and customer account data from California Banks resides in an IBM DB2 database. You want to create a unified model of customer accounts that defines the relationship between customers and accounts. Create a logical data object model to define the relationship.
You can import a logical data object model from a modeling tool. You can also import a logical data object model from an XSD file that you created in a modeling tool. Or, you can manually create a logical data object model in the Developer tool.
You add a logical data object model to a project or folder and store it in the Model repository.
To allow end users to run SQL queries against a logical data object, include it in an SQL data service. Make the logical data object the source for a virtual table. To allow end users to access a logical data object over the Web, include it in a web service. Make the logical data object the source for an operation.
Creating a Logical Data Object Model
Create a logical data object model to define the structure and use of data in an enterprise. When you create a logical data object model, you can add logical data objects. You associate a physical data object with each logical data object. The Developer tool creates a logical data object read mapping for each logical data object in the model.
1. Select a project or folder in the Object Explorer view.
2. Click File > New > Logical Data Object Model.
The New dialog box appears.
3. Select Logical Data Object Model and click Next.
The New Logical Data Object Model dialog box appears.
4. Enter a name for the logical data object model.
5. To create logical data objects, click Next. To create an empty logical data object model, click Finish.
If you click Next, the Developer tool prompts you to add logical data objects to the model.
6. To create a logical data object, click the New button.
The Developer tool adds a logical data object to the list.
7. Enter a name in the Name column.
8. Optionally, click the Open button in the Data Object column to associate a physical data object with the logical data object.
The Select a Data Object dialog box appears.
9. Select a physical data object and click OK.
10. Repeat steps 6 through 10 to add logical data objects. 11. Click Finish.
The logical data object model opens in the editor.
Importing a Logical Data Object Model from a Modeling Tool
You can import a logical data object model from a modeling tool or an XSD file. Import a logical data object model to use an existing model of the structure and data in an enterprise.
1. Select the project or folder to which you want to import the logical data object model.
2. Click File > New > Logical Data Object Model.
The New Logical Data Object Model dialog box appears.
3. Select Logical Data Object Model from Data Model.
4. Click Next.
5. In the Model Type field, select the modeling tool from which you want to import the logical data object model.
6. Enter a name for the logical data object model.
7. Click Browse to select the location of the logical data object model.
8. Click Next.
9. Browse to the file that you want to import, select the file, and click Open.
10. Configure the import properties.
11. Click Next.
12. Add logical data objects to the logical data object model.
13. Click Finish.
The logical data objects appear in the editor.