Chapter 10. Constructing the Data Model

This chapter outlines how to construct the data model with Oracle SQL Data Modeler (a free standalone product or embedded within Oracle SQL Developer from Oracle) using a top-down and bottom-up approach. Oracle SQL Data Modeler will be used to build your database logical and physical models. This can be used by Oracle Warehouse Builder and Oracle Data Integrator. Oracle Business Intelligence Enterprise Edition (OBIEE) will be used to map the physical database model to the the presentation data model used for reporting. The following recipes focus on the database logical and physical data models:

  • Connecting Oracle SQL Data Modeler to Subversion
  • Importing data models into Subversion
  • Checkout data models from ...

Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.