Physical database design : the database professional's guide to exploiting indexes, views, storage, and more /
I highly recommend Physical Database Design by Lightstone, Teorey, and Nadeau. The book covers fine aspects of physical design -- issues such as the effects of different approaches to indexes, tradeoffs in materializing views, and details of physical data layout. Unlike other books, it does not focu...
| Основен автор: | Lightstone, Sam. |
|---|---|
| Други автори: | Teorey, Toby J., Nadeau, Tom, 1958- |
| Формат: | Електронна книга |
| Език: | English |
| Публикувано: |
Amsterdam ; Boston :
Morgan Kaufmann/Elsevier,
℗♭2007.
|
| Серия: |
Morgan Kaufmann series in data management systems.
|
| Предмети: | |
| Онлайн достъп: |
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=207397 |
| Подобни документи: |
Print version::
Physical database design. |
Съдържание:
- 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 (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.