Physical database design : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau

• Autore: Lightstone Sam
• Pubblicazione: Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (449 p.)
• Disciplina: 005.74
• Soggetto topico: Database design
• Altri autori: TeoreyToby J NadeauTom <1958->
• Note generali: Description based upon print version of record.
• Nota di bibliografia: Includes bibliographical references (p. 391-409) and indexes.
• 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
• Sommario/riassunto: The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form
• Titolo autorizzato: Physical database design
• ISBN: 1-281-04654-X; 9786611046545; 0-08-055231-5
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910808935303321
• Lo trovi qui: Univ. Federico II
• Serie: Morgan Kaufmann series in data management systems.