Features
- Cover Type: Paperback with 366 pages
- Published by: Morgan Kaufmann
- Edition: 3rd Edition January 15, 1999
- Written in: English
- ISBN 10 Number: 1558605002
- ISBN 13 Number: 978-1558605008
-
Book Dimensions:
9.1 x 7.3 x 0.8 inches
- Weighs: 1.5 pounds
Product Description
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
Book Info
Focuses on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification & conceptual modeling. Paper. DLC: Relational databases.
Reader Reviews
I have no formal schooling in programming, but find myself having developed one major database application and about to embark on another larger project. I bought the book because I wasn't sure if my intuitions about database design were the right intuitions. Given what I was looking for, the book was excellent. It described (perhaps in dry language) the theoretical underpinnings of a well designed (or normalized) database. Also, the book gave me the proper smybolic and linguistic tools to tackle the task of DB design in a more organized and effecient process. In short, it turns out there are very strict rules about what makes a database a well designed database. Given that previously I was designing on intuition alone, I found this book an excellent developmental tool. There were a few things I was doing wrong that I won't do again! By the way, there are 2 chapters in the book that most people won't use. Or rather, if you need these chapters you probably don't need the other chapters. These are the chapters on geographically distributed database applications and the chapter on how the physical implementation of the database in memory can relate to query optimization.
Comment | |
(Report this)
Search for books at
