High performanse relational database design
This book shows how to create high performances relations databases designs. It concentrates on making database designs work showing how to move away from the relational rules to achieve high performance and outlining practical ways of circumventing difficulties thrown up by the theory.
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
New York
Ellis Horwood
1992
|
| Series: | Ellis Horwood series in computer and their applications
|
| Subjects: | |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
Table of Contents:
- 1. Introduction
- 2. Relational model
- Historical perspective
- Three schema architecture
- Performance design strategy
- Relational model
- Structure component
- Manipulation component
- Integrity component
- 3. Physical design: general concepts
- Role of logical model
- Other logical models
- Performance objectives
- Macro design criteria
- System configuration
- Memory sizing
- 4. Mapping entities to tables
- Storage structures
- Heap storage
- Sequenced storage
- Row sizes
- Fillfactor
- Collocation in a page
- Segmentation
- Placement on disk
- Storage methods: summary of techniques
- 5. Mapping keys to indexes
- Hashing
- Hashing collisions
- Random distribution
- B-tree
- Linked pointers
- Summary of usage
- First cut physical design worked example
- 6. Recovery and locking
- Recovery
- Media failure
- System failure
- Dump and restore
- Concurrency control and locking
- Contention resolution
- Deadlock
- Demand locking
- Read consistency
- 7. Denormalisation and overnormalisation
- Denormalisation
- Duplicated data
- Derived data
- Surrogate keys
- Vector data
- Denormalisation summary
- Overnormalisation
- Table segmentation
- Database segmentation
- Overnormalisation summary
- 8. Optimiser and index selection
- Examples
- Search arguments
- Example
- OR strategy
- Join clauses
- Join strategy
- Nested iteration
- Reformatting
- Statistics
- t Density
- Optimiser assists
- 9. Sybase
- Architecture
- Storage structure and indexing
- Index structure
- Page/node splitting
- Fillfactor
- Index summary
- Optimiser
- Single table plans
- OR strategy
- Join strategy
- Statistics
- Locking.