Physical Database Design Using Oracle 1st Edition by Donald Burleson 0203506235 9780849318177

Physical Database Design Using Oracle 1st Edition by Donald Burleson – Ebook PDF Instant Download/Delivery: 0203506235, 9780849318177

Full download Physical Database Design Using Oracle 1st Edition after payment

Product details:

ISBN 10: 0203506235 

ISBN 13: 9780849318177

Author: Donald K. Burleson

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

Table of contents:

1 INTRODUCTION TO ORACLE PHYSICAL DESIGN
PREFACE
RELATIONAL DATABASES AND PHYSICAL DESIGN
SYSTEMS DEVELOPMENT AND PHYSICAL DESIGN
SYSTEMS ANALYSIS AND PHYSICAL DATABASE DESIGN
THE ROLE OF FUNCTIONAL DECOMPOSITION IN PHYSICAL DATABASE DESIGN
INTRODUCTION TO LOGICAL DATABASE DESIGN
NESTED TABLES
E/R MODELING
BRIDGING BETWEEN LOGICAL AND PHYSICAL MODELS
PHYSICAL DESIGN REQUIREMENTS VALIDATION
LOCATING ORACLE PHYSICAL DESIGN FLAWS

2 PHYSICAL ENTITY DESIGN FOR ORACLE
INTRODUCTION
DATA RELATIONSHIPS AND PHYSICAL DESIGN
MASSIVE DENORMALIZATION: STAR SCHEMA DESIGN
OBJECT-ORIENTED DATABASE DESIGN
DESIGNING CLASS HIERARCHIES
MATERIALIZED VIEWS AND DENORMALIZATION
REFERENTIAL INTEGRITY
CONCLUSION

3 ORACLE HARDWARE DESIGN
INTRODUCTION
PLANNING THE SERVER ENVIRONMENT
DESIGNING THE NETWORK INFRASTRUCTURE FOR ORACLE
ORACLE NETWORK DESIGN
ORACLE DISK DESIGN
CONCLUSION

4 ORACLE INSTANCE DESIGN
INTRODUCTION
SGA PARAMETER COMPONENTS
DESIGNING THE SHARED POOL
ORACLE EVENT WAITS
THE SHARED POOL ADVISORY UTILITY
DESIGNING THE DATA BUFFERS
DESIGN WITH THE DBHR
PINNING PACKAGES IN THE SGA
DESIGNING LOGON TRIGGERS TO TRACK USER ACTIVITY
DESIGNING ORACLE FAILOVER OPTIONS
CONCLUSION

5 ORACLE TABLESPACE DESIGN
INTRODUCTION
SIZING ORACLE DATA BLOCKS
THE EVOLUTION OF ORACLE FILE STRUCTURES
DESIGN FOR ORACLE SEGMENT STORAGE
AUTOMATIC SEGMENT SPACE MANAGEMENT
REPLICATION DESIGN
CONCLUSION

6 ORACLE TABLE DESIGN
INTRODUCTION
TABLE REPLICATION DESIGN
ORACLE EXTERNAL TABLES
DESIGN WITH MATERIALIZED VIEWS
DESIGN FOR PARTITIONED STRUCTURES
ORACLE OBJECT STRUCTURES
DESIGN WITH VARRAY TABLES
USING NESTED TABLES
CONCLUSION

7 ORACLE INDEX DESIGN
INTRODUCTION
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 FBIs
INDEXING ON A COLUMN WITH NULL VALUES
INVOKING THE FULL-INDEX SCAN WITH A FBI
HOW TO USE ORACLE 9I BITMAP JOIN INDEXES
HOW BITMAP JOIN INDEXES WORK
DESIGN FOR AUTOMATIC HISTOGRAM CREATION
CONCLUSION

People also search:

physical database design example

physical design database

physical database design using oracle pdf

oracle physical database design

oracle database table design best practices

Tags: Donald Burleson, Physical, Database, Design