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,
c2007.
|
| Σειρά: |
Morgan Kaufmann series in data management systems.
|
| Θέματα: | |
| Διαθέσιμο Online: |
http://www.sciencedirect.com/science/book/9780123693891 |
| Ετικέτες: |
Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
|
Πίνακας περιεχομένων:
- 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.