Logical Database Design Principles
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.
CHAPTER 1 INTRODUCTION TO LOGICAL DATABASE DESIGN
CHAPTER 2 SYSTEM DESIGN AND IMPLEMENTATION
CHAPTER 3 CONVERTING THE LOGICAL DATA MODEL
CHAPTER 4 FORMAL DATA NORMAILIZATION
CHAPTER 5 DATA DENORMALIZATION
CHAPTER 6 OBJECTORIENTED DESIGN
CHAPTER 7 OBJECTREALTIONAL DESIGN
Other editions - View all
aggregate analysis application attributes block Blue Fred Cartesian product changes chapter clause column command conflict contain CREATE TABLE Customer object data cache data dictionary data flow Data marts data model data warehouse database design database management systems database system defined DELETE denormalization DEPARTMENT table diagrams disk documentation efficient EMPLOYEE SSN EMPLOYEE table entity class entity type example execution fact table Figure FirstName foreign key Fred Fred Fred function identify implement indexes inserted ISBN Jeff Blue join LastName Line-Item Listing load logical database Mary Mary Mary Red materialized view ment method MiddleName MOLAP multi-master replication multiple nested table Normal Form object model object-oriented database OLTP operations Oracle partition performance Pink pointers primary key query RDBMS record Red Jeff redundancy relation schema relational database relationship remote requirements resumés retrieve SDLC SELECT statement stored structure table EMPLOYEE TABLE_NAME Terry transaction unique updated values variables
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...