CHAPTER 7Physical Database Design

In most people's vocabularies, design means veneer. It's interior decorating. It's the fabric of the curtains and the sofa. But to me, nothing could be further from the meaning of design. Design is the fundamental soul of a man-made creation that ends up expressing itself in successive outer layers of the product or service.

—Apple CEO Steve Jobs, interviewed in Fortune magazine; January 24, 2000

The two stages of database design are logical and physical design. Logical database design, also referred to as data modeling, is done first. It is the process of studying the workings of a business organization, constructing a set of tables to store the business data, and understanding the constraints on the data, ...

Get Beginning Oracle Database 11g Administration: From Novice to Professional 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.