Database Design for Smarties: Using UML for Data Modeling by Robert J. MullerBest-selling author and database expert with more than 25 years of experience modeling application and enterprise data, Dr. Michael Blaha provides tried and tested data model patterns, to help readers avoid common modeling mistakes and unnecessary frustration on their way to building effective data models. Unlike the typical methodology book, Patterns of Data Modeling provides advanced techniques for those who have mastered the basics. Recognizing that database representation sets the path for software, determines its flexibility, affects its quality, and influences whether it succeeds or fails, the text focuses on databases rather than programming. It is one of the first books to apply the popular patterns perspective to database systems and data models.
Usage-Driven Database Design
Data modelling is the first step in the process of database design. In the second step, the data items, the relationships and the constraints are all expressed using the concepts provided by the high-level data model. Because these concmepts do not include the implementation details, the result of the data modelling process is a semi formal representation of the database structure. The third step is database design. In the database design phases, data are represented using a certain data model. The data model is a collection of concepts or notations for describing data, data relationships, data semantics and data constraints.
Data Abstraction Layer
I recently realized that our database modeling library could use a few more advanced titles. So I headed over to Amazon to see what they had on offer. There are plenty of introductory books for beginners that tell you how to normalize data , and introduce you to indexes , but what about something for the professional, grown-up database modeler? Here are 5 of the best database modeling books I found listed in no particular order that go beyond the basics and come highly recommended by Amazon reviewers. Go ahead and add them to your wishlists! The primary complaints about these books revolve around the lack of complete SQL scripts for the models provided. Which of these books would you recommend?
It seems that you're in Germany. We have a dedicated site for Germany. 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 framework is a method for taking the logical data model that is a static look at the definition of the data, and merging that static look with the process models describing how the data will be used in actual practice once a given system is implemented.