Notice bibliographique
- Notice
Type(s) de contenu et mode(s) de consultation : Texte noté : électronique
Auteur(s) : Lightstone, Sam
Titre(s) : Physical database design [Texte électronique] : the database professional's guide to exploiting indexes, views, storage, and more / Sam Lightstone, Toby Teorey, Tom Nadeau
Publication : Amsterdam ; Boston : Morgan Kaufmann/Elsevier, cop. 2007
Description matérielle : 1 ressource dématérialisée
Collection : The Morgan Kaufmann series in data management systems
Note(s) : Includes bibliographical references (pages 391-409) and indexes
"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
Autre(s) auteur(s) : Teorey, Toby J.. Fonction indéterminée
Nadeau, Tom (1958-....). Fonction indéterminée
Sujet(s) : Bases de données -- Conception
Indice(s) Dewey :
006.74 (23e éd.) = Langages de balisage [XML]
Identifiants, prix et caractéristiques : ISBN 9780123693891
Identifiant de la notice : ark:/12148/cb446333603
Notice n° :
FRBNF44633360
(notice reprise d'un réservoir extérieur)
Table des matières : 1. 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 ; 10. Counting and data sampling in
physical design exploration ; 11. Query execution plans and physical design ; 12.
Automated physical database design ; 13. Down to the metal : server resources and
topology ; 14. Physical design for decision support, warehousing, and OLAP ; 15.
Denormalization ; 16. Distributed data allocation ; App A.A simple performance model
for databases ; App B. Technical comparison of DB2 HADR with Oracle Data Guard for
database disaster recovery.