Logical Database Design Principles

✍ Scribed by John Garmany, Jeff Walker, Terry Clark

• Publisher: Auerbach Publications
• Year: 2005
• Tongue: English
• Leaves: 200
• Series: Foundations of Database Design
• Edition: 1
• Category: Library

✦ Synopsis

A proper logical data model is the single most important aspect of database performance, and this text is a complete guide to designing databases to utilize database structures, using examples from the Oracle database. More than the standard rehash of logical database design, Logical Database Design Principles is a complete guide to the logical design of databases for optimal performance. It combines IT theory with pragmatic techniques and covers all aspects of logical database design, including translation of data flow diagrams into data models, formal data normalization and object orientation within a logical data model.

✦ Table of Contents

Front cover......Page 1
DEDICATION......Page 6
CONTENTS......Page 8
ACKNOWLEDGMENTS......Page 14
INTRODUCTION......Page 16
ABOUT THE AUTHORS......Page 18
CHAPTER 1. INTRODUCTION TO LOGICAL DATABASE DESIGN......Page 20
CHAPTER 2. SYSTEM DESIGN AND IMPLEMENTATION......Page 36
CHAPTER 3. CONVERTING THE LOGICAL DATA MODEL......Page 54
CHAPTER 4. FORMAL DATA NORMAILIZATION......Page 74
CHAPTER 5. DATA DENORMALIZATION......Page 92
CHAPTER 6. OBJECT-ORIENTED DESIGN......Page 102
CHAPTER 7. OBJECT-REALTIONAL DESIGN......Page 120
CHAPTER 8. DESIGNING REPLICATED DATABASES......Page 140
CHAPTER 9. DESIGN OF THE OLTP DATABASE......Page 158
CHAPTER 10. DESIGN OF DATA WAREHOUSES AND DECISION SUPPORT SYSTEM DATABASES......Page 174
INDEX......Page 192
Back cover......Page 200