This new edition of Database Modeling & Design continues to focus on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey then looks ahead to the common properties in data modeling and operations shared among the relational model and advanced database technologies such as the object-oriented, temporal, and multimedia models. A full chapter is devoted to database design techniques for data warehousing and online analytical processing (OLAP).
Teorey covers the database life cycle from requirements analysis and logical design to physical design for local, distributed, and multidatabases. The discussion of basic principles is supplemented with a common, running example: a company personnel and project database based on real-life experiences and classroom testing.
Written for both the novice and the professional database designer, this book is the essential resource for database modeling, including the building of standard SQL data definitions. The design rules set forth in this book are applicable to any SQL-based system, including IBM DB2, Oracle V8.0, Informix IDS-UDO, Microsoft Access, Microsoft SQL Server, and Sybase Adaptive Server Enterprise.
* Continued focus on relational model
* Integration of information about data warehouse and OLAP, plus other advanced database technologies, including object oriented, multimedia, and temporal database
* Discussion of basic principles is supplemented by examples based on real life cases
This book is for database developers and administrators.As the author of "Database Modeling and Design" I am pleased to make some comments on the practical use of the book. Relational databases have made a big impact on information technology, and it looks like they will be doing so for at least another decade as the dominant technology, especially for corporate and personal databases. This is a book for the database developer or database administrator with at least some background in programming and the basics of relational databases. In fact, 80% of its sales has been to professionals and managers of IT. It has also been successfully used to supplement textbooks for courses in relational databases.
The reader should be aware that this book is not an introductory text for relational databases and is not for the novice as a first exposure to databases. However, if you want to be able to take a database concept from inception to implementation, this is the right book. It's fun to use and it gets you to your goal with minimum hassles.