Usage-Driven Database Design
From Logical Data Modeling through Physical Schema Definition
Published on 7. April 2017
XXIV, 374 pages
978-1-4842-2722-0 (ISBN)
Description
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.
More details
Series
Edition
1st ed.
Language
English
Place of publication
Berkeley
United States
Publishing group
APRESS
Target group
Professional and scholarly
Product notice
Reflowable
Illustrations
XXIV, 374 p. 143 illus., 16 illus. in color.
File size
7,94 MB
ISBN-13
978-1-4842-2722-0 (9781484227220)
DOI
10.1007/978-1-4842-2722-0
Schweitzer Classification
Other editions
Additional editions
George Tillmann
Usage-Driven Database Design
From Logical Data Modeling through Physical Schema Definition
Book
04/2017
APress
€80.24
Shipment within 15-20 days
Person
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.
Content
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.
