Synopses & Reviews
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.
"An explicit presentation on Business Intelligence."
- P. Pichappan, Department of Information Science, Annamalai University, India
rch 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.
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.
sts include data warehousing, OLAP, data mining and machine learning.
mber 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.
This book is a 4th edition of the classic logical database design book, the first edition of which was the first book to focus on relational database design for the professional market--those database designers who are working on industrial-sized database applications. Logical database design is largely the domain of application designers who design the logical structure of a database to suit application requirements for data manipulation and structured query. This new edition features: integrated coverage of UML as well as the Entity-Relationship model, and updated and expanded coverage of business intelligence techniques for data warehousing, data mining, and OLAP.
About the Author
Toby J. Teorey
is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor. He received his B.S. and M.S. degrees in electrical engineering from the University of Arizona, Tucson, and a Ph.D. in computer sciences from the University of Wisconsin, Madison. He was general chair of the 1981 ACM SIGMOD Conference and program chair for the 1991 Entity-Relationship Conference. Professor Teorey’s current research focuses on database design and data warehousing, OLAP, advanced database systems, and performance of computer networks. He is a member of the ACM and the IEEE Computer Society.Sam Lightstone
is a Senior Technical Staff Member and Development Manager with IBM’s DB2 product development team. His work includes numerous topics in autonomic computing and relational database management systems. He is cofounder and leader of DB2’s autonomic computing R&D effort. He is Chair of the IEEE Data Engineering Workgroup on Self Managing Database Systems and a member of the IEEE Computer Society Task Force on Autonomous and Autonomic Computing. In 2003 he was elected to the Canadian Technical Excellence Council, the Canadian affiliate of the IBM Academy of Technology. He is an IBM Master Inventor with over 25 patents and patents pending; he has published widely on autonomic computing for relational database systems. He has been with IBM since 1991.Tom Nadeau is the founder of Aladdin Software (aladdinsoftware.com) and works in the area of data and text mining. He received his B.S. degree in computer science and M.S. and Ph.D. degrees in electrical engineering and computer science from the University of Michigan, Ann Arbor. His technical interests include data warehousing, OLAP, data mining and machine learning. He won the best paper award at the 2001 IBM CASCON Conference.H.V. Jagadish is a professor in EE and CS at the University of Michigan, Ann Arbor, where he is part of the database group affiliated with the bioinformatics program and the Center for Computational Medicine and Bioinformatics. Prior to joining the Michigan faculty, he spent over a decade at AT&T Bell Laboratories as a research scientist where he became head of the Database division.
Univ of Mich, Ann Arbor (EE/CS dept)
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