Usage-Driven Database Design

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.

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