Foundation Db2 and Python: Access Db2 with Module-Based API Examples Using Python

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021

W. D. AshleyFoundation Db2 and Pythonhttps://doi.org/10.1007/978-1-4842-6942-8_4

4. Database Physical Design

W. David Ashley¹  

(1)

Austin, TX, USA

 

The physical design of a relational database is a two-phase project. The first phase involves the design of the tables and their relationships. The second phase lays out the table design onto the physical drives provided by the system. Both of these phases are necessary for proper optimization of the database information. But there are inevitable conflicts between the two phases that will need to be resolved during performance testing.

This chapter will cover each of these phases and highlight where possible conflicts ...