Database Modeling and Design: Logical Design / Edition 5
by Toby J. Teorey
Database systems and database design technology have seen significant changes in recent years. The relational data model and relational database systems dominate applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. Businesses are expanding and require well-constructed databases to track their new and various
… See more details belowOverview
Database systems and database design technology have seen significant changes in recent years. The relational data model and relational database systems dominate applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. Businesses are expanding and require well-constructed databases to track their new and various needs. How do you model and design your database application in the event of new technology or new business needs?
The answers are all in the fifth edition of Database Modeling and Design: Logical Design. This book shows you how to develop data modeling concepts and logical database design consistently over a wide scope in a way that will support the needs of your enterprise. Updated clear explanations, in-depth detail, real-world examples, and illustrative case studies provide you with practical advice that you can count on—with design rules that are applicable to any SQL-based system.
NEW to this edition:
• NEW- A whole chapter devoted to XML and web databases. What you need to know to utilize XML rather than relational tables.
• A whole chapter describing Object Relational Design. Learn how to make a choice between what is in the database as a BLOB and what is outside in a separate file.
Product Details
- ISBN-13:
- 9780123820204
- Publisher:
- Elsevier Science
- Publication date:
- 02/24/2011
- Series:
- Morgan Kaufmann Series in Data Management Systems Series
- Edition description:
- New Edition
- Pages:
- 352
- Sales rank:
- 877,319
- Product dimensions:
- 7.40(w) x 9.10(h) x 1.00(d)
Table of Contents
| Preface | ||
| Ch. 1 | Introduction | 1 |
| Ch. 2 | The ER Model: Basic Concepts | 13 |
| Ch. 3 | ER Modeling in Logical Database Design | 45 |
| Ch. 4 | Transformation of the ER Model to SQL | 79 |
| Ch. 5 | Normalization | 97 |
| Ch. 6 | Access Methods | 141 |
| Ch. 7 | An Example of Relational Database Design | 177 |
| Ch. 8 | Distributed Data Allocation | 187 |
| Ch. 9 | Data Warehousing, OLAP, And Data Mining | 211 |
| Ch. 10 | Advanced Database Technologies | 251 |
| App. A | Review of SQL | 281 |
| App. B | Database Performance Tuning | 301 |
| App. C | Dependability Estimation | 305 |
| App. D | Data Warehousing Technology Vendors | 315 |
| App. E | Connecting Databases to the World Wide Web | 319 |
| References | 323 | |
| Solutions to Selected Exercises | 347 | |
| Index | 355 | |
| About the Author | 366 |
Customer Reviews
Average Review: