Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau
| Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau |
| Autore | Lightstone Sam |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 |
| Descrizione fisica | 1 online resource (449 p.) |
| Disciplina | 005.74 |
| Altri autori (Persone) |
TeoreyToby J
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico | Database design |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-281-04654-X
9786611046545 0-08-055231-5 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Physical Database Design; Copyright Page; Contents; Preface; Organization; Usage Examples; Literature Summaries and Bibliography; Feedback and Errata; Acknowledgments; Chapter 1. Introduction to Physical Database Design; 1.1 Motivation-The Growth of Data and Increasing Relevance of Physical Database Design; 1.2 Database Life Cycle; 1.3 Elements of Physical Design: Indexing, Partitioning, and Clustering; 1.4 Why Physical Design Is Hard; 1.5 Literature Summary; Chapter 2. Basic Indexing Methods; 2.1 B+tree Index; 2.2 Composite Index Search; 2.3 Bitmap Indexing
2.4 Record Identifiers 2.5 Summary; 2.6 Literature Summary; Chapter 3. Query Optimization and Plan Selection; 3.1 Query Processing and Optimization; 3.2 Useful Optimization Features in Database Systems; 3.3 Query Cost Evaluation-An Example; 3.4 Query Execution Plan Development; 3.5 Selectivity Factors, Table Size, and Query Cost Estimation; 3.6 Summary; 3.7 Literature Summary; Chapter 4. Selecting Indexes; 4.1 Indexing Concepts and Terminology; 4.2 Indexing Rules of Thumb; 4.3 Index Selection Decisions; 4.4 Join Index Selection; 4.5 Summary; 4.6 Literature Summary Chapter 5. Selecting Materialized Views 5.1 Simple View Materialization; 5.2 Exploiting Commonality; 5.3 Exploiting Grouping and Generalization; 5.4 Resource Considerations; 5.5 Examples: The Good, the Bad, and the Ugly; 5.6 Usage Syntax and Examples; 5.7 Summary; 5.8 Literature Review; Chapter 6. Shared-nothing Partitioning; 6.1 Understanding Shared-nothing Partitioning; 6.2 More Key Concepts and Terms; 6.3 Hash Partitioning; 6.4 Pros and Cons of Shared Nothing; 6.5 Use in OLTP Systems; 6.6 Design Challenges: Skew and Join Collocation 6.7 Database Design Tips for Reducing Cross-node Data Shipping 6.8 Topology Design; 6.9 Where the Money Goes; 6.10 Grid Computing; 6.11 Summary; 6.12 Literature Summary; Chapter 7. Range Partitioning; 7.1 Range Partitioning Basics; 7.2 List Partitioning; 7.3 Syntax Examples; 7.4 Administration and Fast Roll-in and Roll-out; 7.5 Increased Addressability; 7.6 Partition Elimination; 7.7 Indexing Range Partitioned Data; 7.8 Range Partitioning and Clustering Indexes; 7.9 The Full Gestalt: Composite Range and Hash Partitioning with Multidimensional Clustering; 7.10 Summary; 7.11 Literature Summary Chapter 8. Multidimensional Clustering 8.1 Understanding MDC; 8.2 Performance Benefits of MDC; 8.3 Not Just Query Performance: Designing for Roll-in and Roll-out; 8.4 Examples of Queries Benefiting from MDC; 8.5 Storage Considerations; 8.6 Designing MDC Tables; 8.7 Summary; 8.8 Literature Summary; Chapter 9. The Interdependence Problem; 9.1 Strong and Weak Dependency Analysis; 9.2 Pain-first Waterfall Strategy; 9.3 Impact-.rst Waterfall Strategy; 9.4 Greedy Algorithm for Change Management; 9.5 The Popular Strategy (the Chicken Soup Algorithm); 9.6 Summary; 9.7 Literature Summary Chapter 10. Counting and Data Sampling in Physical Design Exploration |
| Record Nr. | UNINA-9910458663703321 |
Lightstone Sam
|
||
| Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau
| Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau |
| Autore | Lightstone Sam |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 |
| Descrizione fisica | 1 online resource (449 p.) |
| Disciplina | 005.74 |
| Altri autori (Persone) |
TeoreyToby J
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico | Database design |
| ISBN |
1-281-04654-X
9786611046545 0-08-055231-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Physical Database Design; Copyright Page; Contents; Preface; Organization; Usage Examples; Literature Summaries and Bibliography; Feedback and Errata; Acknowledgments; Chapter 1. Introduction to Physical Database Design; 1.1 Motivation-The Growth of Data and Increasing Relevance of Physical Database Design; 1.2 Database Life Cycle; 1.3 Elements of Physical Design: Indexing, Partitioning, and Clustering; 1.4 Why Physical Design Is Hard; 1.5 Literature Summary; Chapter 2. Basic Indexing Methods; 2.1 B+tree Index; 2.2 Composite Index Search; 2.3 Bitmap Indexing
2.4 Record Identifiers 2.5 Summary; 2.6 Literature Summary; Chapter 3. Query Optimization and Plan Selection; 3.1 Query Processing and Optimization; 3.2 Useful Optimization Features in Database Systems; 3.3 Query Cost Evaluation-An Example; 3.4 Query Execution Plan Development; 3.5 Selectivity Factors, Table Size, and Query Cost Estimation; 3.6 Summary; 3.7 Literature Summary; Chapter 4. Selecting Indexes; 4.1 Indexing Concepts and Terminology; 4.2 Indexing Rules of Thumb; 4.3 Index Selection Decisions; 4.4 Join Index Selection; 4.5 Summary; 4.6 Literature Summary Chapter 5. Selecting Materialized Views 5.1 Simple View Materialization; 5.2 Exploiting Commonality; 5.3 Exploiting Grouping and Generalization; 5.4 Resource Considerations; 5.5 Examples: The Good, the Bad, and the Ugly; 5.6 Usage Syntax and Examples; 5.7 Summary; 5.8 Literature Review; Chapter 6. Shared-nothing Partitioning; 6.1 Understanding Shared-nothing Partitioning; 6.2 More Key Concepts and Terms; 6.3 Hash Partitioning; 6.4 Pros and Cons of Shared Nothing; 6.5 Use in OLTP Systems; 6.6 Design Challenges: Skew and Join Collocation 6.7 Database Design Tips for Reducing Cross-node Data Shipping 6.8 Topology Design; 6.9 Where the Money Goes; 6.10 Grid Computing; 6.11 Summary; 6.12 Literature Summary; Chapter 7. Range Partitioning; 7.1 Range Partitioning Basics; 7.2 List Partitioning; 7.3 Syntax Examples; 7.4 Administration and Fast Roll-in and Roll-out; 7.5 Increased Addressability; 7.6 Partition Elimination; 7.7 Indexing Range Partitioned Data; 7.8 Range Partitioning and Clustering Indexes; 7.9 The Full Gestalt: Composite Range and Hash Partitioning with Multidimensional Clustering; 7.10 Summary; 7.11 Literature Summary Chapter 8. Multidimensional Clustering 8.1 Understanding MDC; 8.2 Performance Benefits of MDC; 8.3 Not Just Query Performance: Designing for Roll-in and Roll-out; 8.4 Examples of Queries Benefiting from MDC; 8.5 Storage Considerations; 8.6 Designing MDC Tables; 8.7 Summary; 8.8 Literature Summary; Chapter 9. The Interdependence Problem; 9.1 Strong and Weak Dependency Analysis; 9.2 Pain-first Waterfall Strategy; 9.3 Impact-.rst Waterfall Strategy; 9.4 Greedy Algorithm for Change Management; 9.5 The Popular Strategy (the Chicken Soup Algorithm); 9.6 Summary; 9.7 Literature Summary Chapter 10. Counting and Data Sampling in Physical Design Exploration |
| Record Nr. | UNINA-9910784649703321 |
|
Lightstone Sam
|
||
| Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||