Usage-Driven Database Design

How do you design good databases? This book breaks new ground by presenting a way of developing databases, from start to finish, where the start is logical data modeling and the finish is a database schema that reflects not only the definition of the data uncovered in logical data modeling, but also how the database will be used by applications and end users. The usage-driven design framework in this book provides guidance on mapping from logical to physical designs while simultaneously incorporating knowledge of the target business processes. The framework is practical, pragmatic, and proven over the author's many years of experience.

Presents a complete framework for database design success Emphasizes the practical aspects of database design theory Provides tips and techniques from decades of experience

Autorentext

George Tillmann is a retired Booz, Allen Hamilton partner; a former programmer, analyst, management consultant; and CIO who managed Booz Allen's global IT organization. He brings more than 30 years experience as a database administrator, database consultant, and database product designer. He has written two books, was a Computerworld columnist, and has articles published in CIO, Infoworld, Techworld, Data Base, The Standard, Database Programming & Design and is a former member of the ANSI/X3/SPARC Data Base Systems Study Group.

Zusammenfassung
Tagline: Taming NoSQL and relational schemas

Inhalt
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.