000 02169nam a2200337Ia 4500
005 20260803094046.0
008 251212s2007 xx 000 0 und d
245 1 _aPhysical database design :
_bthe database professional's guide to exploiting indexes, views, storage, and more /
_cSam Lightstone.
100 _aLightstone, Sam
700 _aTeorey, Toby; Nadeau, Tom
260 _aAmsterdam :
_bMorgan Kaufmann/Elsevier,
_c2007.
300 _axx, 427 p. : ill.:
300 _c24 cm.
500 _aIncludes bibliographic references and index
020 _a978-0-123-69389-1
650 _aDatabase design
050 _a005.74 L62p
943 _b0
_c0
_d0
_e1
_f0
_g2
_h0
_i0
_j0
944 _b1
_c1
_d0
953 _pHED2542
546 _aEnglish
953 _cCollLib
505 _a1: Introduction to physical database design 2: Basic indexing methods 3: Query optimization and plan selection 4: Selecting indexes 5: Selecting materialized views 6: Shared nothing partitioning 7: Range partitioning 8: Multidimensional clustering 9: The interdependence problem (i.e. design choices) 10: Data sampling in design exploration 11: Access plan selection and physical design 12: Automated physical database design 13: Down to the metal 14: Physical design for Decision Support, Warehousing and OLAP 15: Denormalization 16: Distributed Data Allocation Appendix A: A Simple Performance Model for Database
520 _a"Physical Database Design discusses the concept of how the 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 of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in this book."--Jacket.
591 _a1
336 _aText
337 _aUnmediated
338 _aVolume
942 _2lcc
_cBK
_arizal
_b2015-04-07 23:18:18
_drizal
_e2015-04-07 23:18:18
998 _a3387
999 _c3374
_d3374