Résumé
- Investigates the design of modern database management systems, enabling the efficient storage and retrieval of company data
- Provides an introduction to logical database design and the application of design principles toward specific functions
- Explores formal data normalization and data denormalization
- Covers the terminology and steps of object-oriented design
- Examines aspects of object-relational design, including advantages and object types
- Discusses the design of replicated, OLTP, data warehouse, and decision support system (DSS) databases
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.
L'auteur - John Garmany
John Garmany is a Senior Oracle DBA with Burleson Consulting. A graduate of West Point, an Airborne Ranger and a retired Lt. Colonel with 20+ years of IT experience. John is an OCP Certified Oracle DBA with a Master Degree in Information Systems, a Graduate Certificate in Software Engineering, and a BS degree (Electrical Engineering) from West Point. A respected Oracle expert and author, John serves as a writer for Oracle Internals, DBAZine and SearchOracle and SELECT Magazine. John is also the author of four bestselling Oracle books by Rampant TechPress, Oracle Press and CRC Press and hosts a popular Oracle Application Server Newsletter.
Sommaire
- INTRODUCTION TO LOGICAL DATABASE DESIGN
- Understanding a Database
- Database Architectures
- Relational Databases
- Creating the Database
- System Development Life Cycle (SDLC)
- Systems Planning: Assessment and Feasibility
- System Analysis: Requirements
- System Analysis: Requirements Checklist
- Models Tracking and Schedules
- Design Modeling
- Functional Decomposition Diagram
- Data Flow Diagrams
- Data Dictionary
- Logical Structures and Decision Trees
- System Design: Logical
- SYSTEM DESIGN AND IMPLEMENTATION
- The ER Approach
- Entities and Entity Types
- Attribute Domains
- Attributes
- Set-Valued Attributes
- Weak Entities
- Constraints
- Lookup Tables and Consistency
- Modeling Approaches
- Relationships
- Cardinality
- Schemas
- Implementation: Converting the ERD
- Specifications and Documentation
- CONVERTING THE LOGICAL DATA MODEL
- Database Architecture
- SQL
- DDL Commands
- Data Retrieval
- DML Statements and Implicit Cursors
- SELECT Statements
- Cartesian Product
- DML: INSERT Commands
- DML: UPDATE Command
- DML: DELETE Statements
- Transaction Commands
- DCL Commands
- FORMAL DATA NORMALIZATION
- Definitions of Normal Forms
- Introduction to Relational Algebra
- Comparison Operations and Logical Operators
- Summary
- DATA DENORMALIZATION
- Historical Perspective on Disk Costs
- The Importance of Database Performance to the Logical Model
- Introducing Data Redundancy: Size versus Volatility
- The Theory of Dr. Ralph Kimball
- Pre-Joining Entities Together
- Pre-Aggregating Summary Information
- Non-First Normal Form Entities
- Horizontal and Vertical Partitioning for Performance
- Summary
- OBJECT-ORIENTED DESIGN
- Object-Oriented Terminology
- Object-Oriented Design
- Creating the Object Model
- Methods and Database Objects
- Summary
- OBJECT-RELATIONAL DESIGN
- Advantages of Object-Relational Databases
- Object Types
- Object Views
- Using Logical Pointers
- Comparison of Object-Oriented and Object-Relational Databases
- Creating the Object-Relational Design
- Summary
- DESIGNING REPLICATED DATABASES
- Manual Replication Techniques
- Standby Database
- Replication Using Triggers
- Replication Using Views
- One-Way Replication
- Writeable Replication
- Updateable Replication
- What Are Conflicts?
- Which Form of Replication is Right for You?
- Planning Your Replication Schema
- Summary
- DESIGN OF THE OLTP DATABASE
- Designing for Online Transaction Processing
- Normalization
- Data Storage
- SQL Reuse
- Database Locking and Waiting
- Deadlocks
- Rollbacks
- Indexing
- Summary
- DESIGN OF DATA WAREHOUSES AND DECISION SUPPORT SYSTEM DATABASES
- What Is a Data Warehouse?
- Gathering Data
- Staging and Processing Data
- Loading and Unloading Data
- Data Marts
- Designing the Data Warehouse
- Summary
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Auerbach |
| Auteur(s) | John Garmany, Jeff Walker |
| Parution | 07/06/2005 |
| Nb. de pages | 180 |
| Format | 16 x 24 |
| Couverture | Relié |
| Poids | 405g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780849318535 |
| ISBN13 | 978-0-8493-1853-5 |
Avantages Eyrolles.com
Nos clients ont également acheté
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
