Share
Explore BrainMass

Database Related Quotes

Please see the quotes below and describe how they relate to database.

quote1-Physical constraints
quote2-The principle of mapping
quote3-cultural constraints
quote4-Make things visible
quote5-great precision is not required

Solution Preview

Physical constraints
----------------------
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 (physical constraints) in which the database will exist. See also [1].

The principle of mapping
----------------------------
Assuming that the logical data model is complete, though, what must be done to implement a physical database? The first step is to create an initial physical data model by transforming the logical data model into a physical implementation based on an understanding of the DBMS to be used for deployment. To successfully create a physical database design you will need to have a good working knowledge of the features of the DBMS including:
In-depth knowledge of the database objects supported by the DBMS and the physical structures and files required to support those objects.
Details regarding the manner in which the DBMS supports indexing, referential integrity, constraints, data types, and other features that augment the functionality of database objects.
Detailed knowledge of new and obsolete features for particular versions or releases of the DBMS to be used.
Knowledge of the DBMS configuration parameters that are in place.
Data definition language (DDL) skills to translate the physical design into actual database objects.
Armed with the correct information, you can create an effective and efficient ...

$2.19