Database Reference
In-Depth Information
CHAPTER 13
SPECIAL IMPLEMENTATION
CONSIDERATIONS
CHAPTER OBJECTIVES
•
Study the role of languages in the implementation of a data model
•
Discuss in detail SQL, the relational standard
•
Learn how SQL is used for data definition, manipulation, maintenance, and
control
•
Review examples of simple and complex queries in SQL
•
Examine how a query is optimized and executed
•
Understand the various aspects of database deployment
When you review the phases of the database development life cycle (DDLC),
physical design is the last stage in the design phase. In Chapter 12, we discussed
physical design in considerable detail. You learned how to transform the logical
model into the physical model of a relational database system. You studied how the
physical model conforms to the target DBMS and the configuration of the com-
puter system where the database has to reside.
Once physical design is completed, you are ready to implement the database
system. Implementation brings all the efforts during the different phases of DDLC
to culmination. You have moved from the generic data model to the relational
model. You know that both of these form the logical data model. After that stage,
you moved to the physical model, taking into account the features of the DBMS
and the computer system. The data models must be implemented as the resultant
database management system.
First, try to understand the significance and meaning of implementing the data
model. Find out why we need languages for implementation. We need languages
Search WWH ::
Custom Search