The evolution of Oracle has led to a revolution in design practices. For Oracle 10g, database physical structures have become more complex than ever before and database designers face multiple ways to implement their logical models. IS students studying database design and administration need to be able to implement management systems in a way that
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für Beruf und Forschung
Analysts, programmers, DBAs, undergraduate and graduate-level IS students
Illustrationen
53 s/w Abbildungen, 26 s/w Tabellen
53 b/w images and 26 tables
Dateigröße
ISBN-13
978-0-203-50623-3 (9780203506233)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
INTRODUCTION TO ORACLE PHYSICAL DESIGN Preface Relational Databases and Physical Design Systems Analysis and Physical Database Design Introduction to Logical Database Design Entity/Relation Modeling Bridging between Logical and Physical Models Physical Design Requirements Validation PHYSICAL ENTITY DESIGN FOR ORACLE Data Relationships and Physical Design Massive De-Normalization: STAR Schema Design Designing Class Hierarchies Materialized Views and De-Normalization Referential Integrity Conclusion ORACLE HARDWARE DESIGN Planning the Server Environment Designing the Network Infrastructure for Oracle Oracle Network Design Oracle Disk Design Conclusion ORACLE INSTANCE DESIGN SGA Parameter Components Designing the Shared Pool Library Cache Usage Measurement Oracle Event Waits The Shared Pool Advisory Utility Designing the Data Buffers Design with the Data Buffer Hit Ration (DBHR) Pinning Packages in the SGA ORACLE TABLESPACE DESIGN Sizing Oracle Data Blocks The Evolution of Oracle File Structures Design for Oracle Segment Storage Automatic Segment Space Management Replication Design Conclusion ORACLE TABLE DESIGN Table Replication Design Oracle External Tables Design with Materialized Views Oracle Object Structures Design with VARRAY Tables Using Nested Tables Conclusion ORACLE INDEX DESIGN Index Design Basics Evaluating Oracle Index Access Methods Designing High-Speed Index Access Oracle Optimizer and Index Design Physical Row-Ordering and Index Design Using Multicolumn Indexes How Oracle Chooses Indexes Index Design for STAR Schemas Indexing Alternatives to B-Tree Indexes Design for Oracle Full-Index Scans Basics of Function-Based Indexes Invoking the Full-Index Scan with a Function-Based Index How to use Oracle9I Bitmap Join Indexes
