Database Modeling and Design: Logical Design / Edition 4

Database Modeling and Design: Logical Design / Edition 4

by Toby J. Teorey, Tom Nadeau, Sam S. Lightstone
     
 

Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new

See more details below

Overview

Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?

In the extensively revised fourth edition, you’ll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on—with design rules that are applicable to any SQL-based system. But you’ll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems:

+ a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling—with examples throughout the book in both approaches!
+ the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax;
+ the fundamentals of database normalization through the fifth normal form;
+ practical coverage of the major issues in business intelligence—data warehousing, OLAP for decision support systems, and data mining;
+ examples for how to use the most popular CASE tools to handle complex data modeling problems.
+ Exercises that test understanding of all material, plus solutions for many exercises.

About the Authors

Toby J. Teorey is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor, and his current research focuses on database design and performance of computing systems. Sam S. Lightstone is the cofounder and leader of DB2's autonomic computing R&D effort, and has been with IBM since 1991. His current research includes automatic physical database design, adaptive self-tuning resources, automatic administration, benchmarking methodologies, and system control. Mr. Lightstone is an IBM Master Inventor. Thomas P. Nadeau is a senior technical staff member of Ubiquiti Inc. and works in the area of data and text mining. His technical interests include data warehousing, OLAP, data mining and machine learning.

Read More

Product Details

ISBN-13:
9780126853520
Publisher:
Elsevier Science
Publication date:
09/06/2005
Series:
Morgan Kaufmann Series in Data Management Systems Series
Edition description:
REV
Pages:
296
Product dimensions:
7.48(w) x 9.34(h) x 0.72(d)

Table of Contents

Chapter 1 Introduction
Chapter 2 The Entity-Relationship Model
Chapter 3 Unified Modeling Language
Chapter 4 Requirements Analysis and Conceptual Data Modeling
Chapter 5 Transforming the Conceptual Data Model to SQL
Chapter 6 Normalization
Chapter 7 An Example of Logical Database Design
Chapter 8 Business Intelligence
Chapter 9 CASE Tools for Logical Database Design
Appendix The Basics of SQL

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >