Physical Database Design Using Oracle
Published on 27. July 2004
264 pages
978-0-203-50623-3 (ISBN)
Description
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
More details
Language
English
Place of publication
Baton Rouge
United States
Publishing group
Taylor & Francis Inc
Target group
Professional and scholarly
Analysts, programmers, DBAs, undergraduate and graduate-level IS students
Illustrations
53 s/w Abbildungen, 26 s/w Tabellen
53 b/w images and 26 tables
File size
2,94 MB
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 Classification
Other editions
Additional editions
Donald K. Burleson
Physical Database Design Using Oracle
Book
07/2004
1st Edition
CRC Press
€171.50
Shipment within 15-20 days
Content
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
