Chapter 7. Physical Database Design
7.1. Introduction
The transition from logical to physical database design marks a change in focus and in the skills required. In this chapter, we are going to develop a set of data structures, making those structures perform on a particular hardware platform using the facilities of our selected database management system (DBMS). Instead of business and generic data structuring skills, we require a detailed knowledge of general performance-tuning techniques and of the facilities provided by the DBMS. Frequently this means that a different, more technical person will take on the role of database design. In this case, the data modeler's role will be essentially to advise on the impact of changes to tables and ...
Get Database Design: Know It All now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
