Logical Database Design Principles

Front Cover
CRC Press, May 12, 2005 - Computers - 200 pages
0 Reviews
Until now, almost all books on logical database design focused exclusively on relational design. However, modern database management systems have added powerful features that have driven a movement away from truly normalized database design. Logical Database Design Principles reflects these recent changes. The book begins by covering traditional logical design principles, followed by an analysis of the normalizing and modeling of data. It then examines designing for specific purposes, such as object-oriented databases, online transaction processing (OLTP), and data warehouses. As the text progresses, it moves from the purely logical into some physical design, as determined by how the features of modern databases are implemented.

Because this is a logical-design book, the authors attempt to make the examples database-neutral. Because various vendors implement features in different ways, this volume sometimes offers examples from a specific database management system. When necessary, it highlights a specific application, clearly demonstrating the concept being discussed.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

CHAPTER 1 INTRODUCTION TO LOGICAL DATABASE DESIGN
1
CHAPTER 2 SYSTEM DESIGN AND IMPLEMENTATION
17
CHAPTER 3 CONVERTING THE LOGICAL DATA MODEL
35
CHAPTER 4 FORMAL DATA NORMAILIZATION
55
CHAPTER 5 DATA DENORMALIZATION
73
CHAPTER 6 OBJECTORIENTED DESIGN
83
CHAPTER 7 OBJECTREALTIONAL DESIGN
101
CHAPTER 8 DESIGNING REPLICATED DATABASES
121
CHAPTER 9 DESIGN OF THE OLTP DATABASE
139
CHAPTER 10 DESIGN OF DATA WAREHOUSES AND DECISION SUPPORT SYSTEM DATABASES
155
INDEX
173
Back cover
181
Copyright

Other editions - View all

Common terms and phrases

Popular passages

Page ii - Information Security Architecture Jan Killmeyer Tudor ISBN: 0-8493-9988-2 Information Security Management Handbook, 4th Edition, Volume 2 Harold F. Tipton and Micki Krause, Editors ISBN: 0-8493-0800-3 IS Management Handbook, 7th Edition Carol V. Brown, Editor ISBN: 0-8493-9820-7 Information Technology Control and Audit Frederick Gallegos, Sandra Allen-Senft, and Daniel P. Manson ISBN: 0-8493-9994-7...
Page ii - A Technical Guide to IPSec Virtual Private Networks James S. Tiller ISBN: 0-8493-0876-3 Using the Common Criteria for IT Security Evaluation Debra S.

About the author (2005)

Don Burleson (Kittrell, NC) has 20 years of full-time experience as a database administrator and has written 12 books on database. Don is also the Editor-in-Chief of Oracle Internals, a popular Oracle journal, and he has published more than 100 articles in national database magazines. A former adjunct professor of Information Systems, Don has taught more than 100 University courses and regularly conducts in-house Oracle training. John Garmany, Jr. (Golden, CO) is a graduate of West Point and a retired Lt. Colonel with 20+ years of IT experience. John is an expert in Oracle and Java technologies and is OCP Certified. He has contributed numerous articles to international Oracle periodicals and has exceptional teaching skills, and has a Master Degree in Information Systems, a Graduate Certificate in Software Engineering, and a BS degree in electrical engineering from the United States Military Academy at West Point.

Bibliographic information