LEADER 05584nam 2200697 a 450 001 9910808935303321 005 20200520144314.0 010 $a1-281-04654-X 010 $a9786611046545 010 $a0-08-055231-5 035 $a(CKB)1000000000364178 035 $a(EBL)313887 035 $a(OCoLC)469635004 035 $a(SSID)ssj0000221417 035 $a(PQKBManifestationID)11219098 035 $a(PQKBTitleCode)TC0000221417 035 $a(PQKBWorkID)10158103 035 $a(PQKB)10055807 035 $a(Au-PeEL)EBL313887 035 $a(CaPaEBR)ebr10191527 035 $a(CaONFJC)MIL104654 035 $a(OCoLC)808500631 035 $a(CaSebORM)9780123693891 035 $a(MiAaPQ)EBC313887 035 $a(OCoLC)ocn808500631 035 $a(EXLCZ)991000000000364178 100 $a20061222d2007 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aPhysical database design $ethe database professional's guide to exploiting indexes, views, storage, and more /$fSam Lightstone, Toby Teorey, Tom Nadeau 205 $a1st edition 210 $aAmsterdam ;$aBoston $cMorgan Kaufmann/Elsevier$dc2007 215 $a1 online resource (449 p.) 225 1 $aThe Morgan Kaufmann series in data management systems 300 $aDescription based upon print version of record. 311 $a0-12-369389-6 320 $aIncludes bibliographical references (p. 391-409) and indexes. 327 $aFront 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 327 $a2.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 327 $aChapter 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 327 $a6.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 327 $aChapter 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 327 $aChapter 10. Counting and Data Sampling in Physical Design Exploration 330 $aThe 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 410 0$aMorgan Kaufmann series in data management systems. 606 $aDatabase design 615 0$aDatabase design. 676 $a005.74 700 $aLightstone$b Sam$0633720 701 $aTeorey$b Toby J$0633722 701 $aNadeau$b Tom$f1958-$0627537 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910808935303321 996 $aPhysical database design$94068891 997 $aUNINA