🛢DBMS: Physical Design (Definitions)

"The phase of a database design following the logical design that identifies the actual database tables and index structures used to implement the logical design." (Ralph Kimball & Margy Ross, "The Data Warehouse Toolkit" 2nd Ed , 2002)

"The actual tables, columns, indexes, and other data structures used to store information in a SQL Server database. Development projects typically progress from a logical database design to a physical database design." (Robert D. Schneider and Darril Gibson, "Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies", 2008)

"The actual tables, columns, indexes, and other data structures used to store information in a SQL Server database. Development projects typically progress from a logical database design to a physical database design. See also logical design." (Robert D Schneider & Darril Gibson, "Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies", 2008)

"The step in the database life cycle involved with the physical structure of the data; that is, how it will be stored, retrieved, and updated efficiently. In particular, it is concerned with issues of table indexing and data clustering on secondary storage devises (disk)." (Toby J Teorey, ", Database Modeling and Design 4th Ed", 2010)

"A stage of database design that maps the data storage and access characteristics of a database. Since these characteristics are a function of the types of devices supported by the hardware, the data access methods supported by the system (and the selected DBMS) physical design is both hardware- and software-dependent. See also physical model." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management 9th Ed", 2011)

"Physical design structures (PDSs) include items such as indexes, indexed VIEWs, and partitioning. These are referenced in the Database Engine Tuning Advisor, which is used to evaluate a database and can recommend the implementation of different types of physical design structures for better performance." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)

"States how the system will perform its functions, with actual physical specifications." (Linda Volonino & Efraim Turban, "Information Technology for Management 8th Ed", 2011)