Explore BrainMass

Explore BrainMass

    Database Related Quotes

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com March 4, 2021, 7:06 pm ad1c9bdddf

    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 ...

    Solution Summary

    The expert describes how quotes relate to databases.