A logical data model should be used as the blueprint for designing and creating a physical database. But the physical database cannot be created properly with a simple logical to physical mapping. Many physical design decisions need to be made by the DBA before implementing physical database structures. This may necessitate deviating from the logical data model. But such deviation should occur only based on in-depth knowledge of the DBMS and the physical environment in which the database will exist.
Read this article..
Craig S. Mullins is a data management strategist, researcher and consultant. He is president and principal consultant of Mullins Consulting, Inc., and has nearly three decades of experience in all facets of database systems development.
Craig has worked with mainframe DB2 since V1 and has experience with several other DBMS products, including SQL Server, Sybase and IMS. You may know Craig from his popular books: DB2 Developer's Guide
, which has more than 1,500 pages of in-depth technical information on DB2 for z/OS, and Database Administration: The Complete Guide to Practices and Procedures
- the industry's only comprehensive guide to heterogeneous database administration.
More information on Craig is available at www.craigsmullins.com
comments powered by