Physical Database Design Using Oracle

by Donald K. Burleson

Overview

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

Product Details

ISBN-13:	9781135497156
Publisher:	CRC Press
Publication date:	07/27/2004
Sold by:	Barnes & Noble
Format:	eBook
Pages:	264
File size:	4 MB

About the Author

Donald K. Burleson

Table of Contents

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