Synonyms
Clustering; Database design; Database implementation; Database materialization; Indexing; Materialized query tables; Materialized views; Multidimensional clustering; Range partitioning; Table design; Table normalization
Definition
Physical database design represents the materialization of a database into an actual system. While logical design can be performed independently of the eventual database platform, many physical database attributes depend on the specifics and semantics of the target DBMS. Physical design is performed in two stages:
- 1.
Conversion of the logical design into table definitions (often performed by an application developer): includes pre-deployment design, table definitions, normalization, primary and foreign key relationships, and basic indexing.
- 2.
Post deployment physical database design (often performed by a database administrator): includes improving performance, reducing I/O, and streamlining administration tasks.
Generally speaking, physical database...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Astrahan MM, Blasgen MW, Chamberlin DD, Jim Gray W, King FII, Lindsay BG, Lorie RA, Mehl JW, Price TG, Putzolu GR, Schkolnick M, Selinger PG, Slutz DR, Strong HR, Tiberio P, Traiger IL, Bradford W, Yost WRA. System R: a relational data base management system. IEEE Comput. 1979;12(5):42–8.
Bayer R, McCreight EM. Organization and maintenance of large ordered indexes. SIGFIDET Workshop; 1970. p. 107–41.
Finkelstein S, Schikolnick M, Tiberio P. Physical database design for relational databases. ACM Trans Database Syst. 1988;13(1):91–128.
Jun R, Chun Zhang, Megiddo N, Lohman GM. Automating physical database design in a parallel database. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2002. p. 558–69.
Lightstone S, Bishwaranjan B. Automated design of multi-dimensional clustering tables for relational databases. In: Proceedings of the 30th International Conference on Very Large Data Bases; 2004. p. 1170–181.
Lightstone S, Teory T, Nadeau T. Physical database design: the database professional’s guide to exploiting indexes, views, storage, and more. Morgan Kaufmann; 2007.
Markos Z, Cochrane R, Lapis G, Hamid P, Monica U. Answering complex SQL queries using automatic summary tables. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2000. p. 105–16.
Sanjay A, Surajit C, Narasayya VR. Automated selection of materialized views and indexes in SQL databases. In: Proceedings of the 26th International Conference on Very Large Data Bases; 2000. p. 496–505.
Sriram P, Bishwaranjan B, Malkemus T, Cranston L, Huras M. Multi-dimensional clustering: a new data layout scheme in DB2. In: Proceedings of the ACM SIGMOD International Conference on Management of Data. p. 637–41.
Surajit C, Narasayya VR. AutoAdmin “What-if” index analysis utility. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1998. p. 367–78.
Surajit C, Narasayya VR. Microsoft index tuning wizard for SQL Server 7.0. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1998. p. 553–4.
Teorey T, Lightstone S, Nadeau T. Database modeling & design: logical design. 4th ed. Morgan Kaufmann; 2005.
Zilio DC, Jun R, Lightstone S, Lohman GM, Storm AJ, Garcia-Arellano Christian, Fadden Scott. DB2 design advisor: integrated automatic physical database design. In: Proceedings of the 30th International Conference on Very Large Data Bases; 2004. p. 1087–97.
Zilio DC, Zuzarte C, Lightstone S, Wenbin Ma, Lohman GM, Cochrane R, Hamid P, Latha SC, Gryz J, Alton E, Liang D, Valentin G. Recommending materialized views and indexes with IBM DB2 design advisor. In: Proceedings of the 1st International Conference on Autonomic Computing; 2004. p. 180–8.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Lightstone, S.S. (2018). Physical Database Design for Relational Databases. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_644
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_644
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering