Abstract
This chapter discusses the physical design methodologies and tools most popular for relational databases. Examples from the most common systems—Oracle, DB2 (IBM), and SQL Server (Microsoft)—have been used to illustrate the basic concepts. Knowledge of logical data modeling and physical database design techniques is important for database practitioners and application developers. The database life cycle shows steps that are needed in a methodical approach to database design from logical design to physical design that is based on maximizing the performance of the database under various workloads. The database life cycle incorporates the basic steps involved in designing a logical database from conceptual modeling of user requirements through database management system (DBMS) specific table definitions, and a physical database that is indexed, partitioned, clustered, and selectively materialized to maximize real performance. For a distributed database, physical design involves allocating data across a computer network.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
