CHAPTER15Implementing the Universal Data Models
In this book, numerous models have been provided that can help jump-start data modeling efforts. But what are the purposes for these models, and how can the enterprise use them to build higher-quality operational and data warehouse databases? The models in this book, as well as those in Volume 2, can facilitate the building of more integrated systems, help the enterprise better manage its information, and can lead to higher-quality database designs in shorter periods of time. This chapter will cover the life cycle of the model from the development of an enterprise data model, to the development of the logical data model for a project, to the development of a physical database design which is the basis for implementing a database. Using these models for data warehouse implementations will also be discussed.
Effective methods for incorporating the Universal Data Models can be summarized as follows:
- Develop the enterprise data model by customizing and adding to the Universal Data Models using the business terms that are commonly known in the enterprise and adding appropriate information requirements.
- Build the appropriate logical data models for each project according to the business requirements for that specific application.
- Create the necessary physical database designs based on the logical data model and the technical requirements.
- Customize the database design to the appropriate target DBMS (database management system).
Questions ...
