Usage-Driven Database Design From Logical Data Modeling through Physical Schema Definition

Design great databases—from logical data modeling through physical schema definition. You will learn a framework that finally cracks the problem of merging data and process models into a meaningful and unified design that accounts for how data is actually used in production systems. Key to the frame...

Descripción completa

Detalles Bibliográficos
Autor principal: Tillmann, George. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2017.
Edición:1st ed. 2017.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630073906719
Tabla de Contenidos:
  • Part I: Introduction
  • 1. Introduction to Usage-Driven Database Design
  • Part II: Logical Data Modeling
  • 2. The E-R Approach
  • 3. More About the E-R Approach
  • 4. Building the Logical Data Model
  • 5. LDM Best Practices
  • 6. LDM Pitfalls
  • 7. LDM Perils to Watch For
  • Part III: Physical Schema Definition
  • 8. Introduction to Physical Database Design
  • 9. Introduction to Physical Schema Definition
  • 10. Transformation: Creating the Physical Data Model.-11. Utilization: Merging Data and Process.-12. Formalization: Creating a Schema
  • 13. Customization: Enhancing Performance
  • 14. The Data Warehouse
  • 15. The Big Data Decision Support System
  • Part IV: Where From Here?
  • 16. A Look Ahead
  • Part V: Appendixes
  • 17: Appendix A: Glossary
  • 18: Appendix B: Logical Data Modeling Definitions
  • 19. Appendix C: Physical Schema Definition Object Definitions
  • 20. Appendix D: Formulas Used in the Book
  • 21. Appendix E: List of U3D Deliverables.