O'Reilly logo

Database Design: Know It All by Graham Witt, Graeme Simsion, Markus Schneider, Patrick O'Neil, Elizabeth O'Neil, Bonnie O'Neil, Thomas P. Nadeau, Tony Morgan, Jim Melton, Sam S. Lightstone, W.H. Inmon, Jan L. Harrington, Terry Halpin, Ralf Hartmut Güting, Lowell Fryman, Stephen Buxton, Toby J. Teorey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required