Database Modeling and Design: Logical Design

Přední strana obálky
Elsevier, 5. 8. 2010 - Počet stran: 296

Database Modeling and Design, Fourth Edition, the extensively revised edition of the classic logical database design reference, explains how you can model and design your database application in consideration of new technology or new business needs. It is an ideal text for a stand-alone data management course focused on logical database design, or a supplement to an introductory text for introductory database management.

This book features clear explanations, lots of terrific examples and an illustrative case, and practical advice, with design rules that are applicable to any SQL-based system. The common examples are based on real-life experiences and have been thoroughly class-tested. The text takes 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 - complemented with examples for both approaches. It also discusses the use of data modeling concepts in logical database design; the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; and the major issues in business intelligence such as data warehousing, OLAP for decision support systems, and data mining. There are examples for how to use the most popular CASE tools to handle complex data modeling problems, along with exercises that test understanding of all material, plus solutions for many exercises. Lecture notes and a solutions manual are also available.

This edition will appeal to professional data modelers and database design professionals, including database application designers, and database administrators (DBAs); new/novice data management professionals, such as those working on object oriented database design; and students in second courses in database focusing on design.

+ 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.
 

Vybrané stránky

Obsah

body
1
2 The EntityRelationship Model
13
3 The Unified Modeling Language UML
33
4 Requirements Analysis and Conceptual Data Modeling
53
5 Transforming the Conceptual Data Model to SQL
83
6 Normalization
107
7 An Example of Logical Database Design
139
8 Business Intelligence
147
back matter
213
Glossary
231
References
239
Exercises
249
Solutions to Selected Exercises
259
About the Authors
263
index
265
Autorská práva

9 CASE Tools for Logical Database Design
187

Další vydání - Zobrazit všechny

Database Modeling & Design: Logical Design
Toby J. Teorey,Sam Lightstone,Tom Nadeau
Náhled není k dispozici. - 2006

Běžně se vyskytující výrazy a sousloví

activity diagrams aggregation attributes author_id BCNF binary relationships candidate key cascade on update conceptual data model constraints create table cust_no cust_num data elements data mining data warehouse data warehousing database design database life cycle Database Systems decomposition defined delete cascade delete set Department dept_name dimension emp_id char(10 Employee engineer entity cluster ER model estimated example fact table foreign key functional dependencies id fk integrity item_num key dept_no loc_name logical database design logical design manager many-to-many mgr_id MVDs n-ary relationship node normal form notation notebook_no OLAP OLAP system one-to-many one-to-one operations optional PowerDesigner primary key primary key emp_id proj_no query Rational Data Architect references on delete relational database report_no rows salesperson semantics shown in Figure skill_type skill_used snowflake schema SQL tables star schema step subtype superkey Sybase Technician ternary relationship tion transformation update cascade values widget

Oblíbené pasáže

Strana iii - Database System Don Chamberlin Distributed Algorithms Nancy A. Lynch Active Database Systems: Triggers and Rules For Advanced Database Processing Edited by Jennifer Widom and Stefano Ceri Migrating Legacy Systems: Gateways, Interfaces, & the Incremental Approach Michael L. Brodie and Michael Stonebraker Atomic Transactions Nancy Lynch, Michael Merritt, William Weihl, and Alan Fekete Query Processing for Advanced Database Systems Edited by Johann Christoph Freytag, David Maier, and Gottfried Vossen...‎
Objevuje se u 72 knih od 1993-2006.
Strana ii - Relational Databases: From Conceptual Analysis to Logical Design Terry Halpin Component Database Systems Edited by Klaus R. Dittrich and Andreas Geppert Managing Reference Data in Enterprise Databases: Binding Corporate Data to the Wider World Malcolm Chisholm Data Mining: Concepts and Techniques Jiawei Han and Micheline Kamber Understanding SQL and Java Together: A Guide to SQL], JDBC, and Related Technologies Jim Melton and Andrew Eisenberg Database: Principles, Programming, and Performance, Second...‎
Objevuje se u 26 knih od 1988-2006.
Strana ii - Transactional Information Systems: Theory, Algorithms, and Practice of Concurrency Control and Recovery Gerhard Weikum and Gottfried Vossen Spatial Databases: With Application to GIS Philippe Rigaux, Michel Scholl, and Agnes Voisard Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design Terry Halpin Component Database Systems Edited by Klaus R. Dittrich and Andreas Geppert Managing Reference Data in Enterprise Databases: Binding Corporate...‎
Objevuje se u 18 knih od 1987-2006.
Strana ii - JDBC, and Related Technologies Jim Melton and Andrew Eisenberg Database: Principles, Programming, and Performance, Second Edition Patrick and Elizabeth O'Neil The Object Data Standard: ODMG 3.0 Edited by RGG Cattell and Douglas K. Barry Data on the Web: From Relations to Semistructured Data and XML Serge Abiteboul, Peter Buneman, and Dan Suciu Data Mining: Practical Machine Learning Tools and Techniques with Java Implementations Ian Witten and Eibe Frank Joe Celko's SQL for Smarties: Advanced SQL...‎
Objevuje se u 46 knih od 1995-2006.
Strana ii - Enterprise Architects Terry Halpin, Ken Evans, Patrick Hallock, Bill Maclean Designing Data-Intensive Web Applications Stephano Ceri, Piero Fraternali, Aldo Bongio, Marco Brambilla, Sara Comai, and Maristella Matera Mining the Web: Discovering Knowledge from Hypertext Data Soumen Chakrabarti Advanced SQL: 1999 — Understanding ObjectRelational and Other Advanced Features Jim Melton Database Tuning: Principles, Experiments...‎
Objevuje se u 11 knih od 2004-2006.
Strana iii - Models for Advanced Applications, Edited by Ahmed K. Elmagarmid A Guide to Developing Client/Server SQL Applications, Setrag Khoshafian, Arvola Chan, Anna Wong, and Harry KT Wong The Benchmark Handbook for Database and Transaction Processing Systems, Second Edition, Edited by Jim Gray Camelot and Avalon: A Distributed Transaction Facility, Edited by Jeffrey L. Eppinger, Lily B. Mummert, and Alfred Z. Spector Readings in Object-Oriented Database Systems, Edited by Stanley B. Zdonik and David Maier...‎
Objevuje se u 67 knih od 1990-2006.
Strana i - The Morgan Kaufmann Series in Data Management Systems Series Editor: Jim Gray, Microsoft Research...‎
Objevuje se u 54 knih od 1989-2006.

Odkazy na tuto knihu

O autorovi (2010)

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.

Bibliografické údaje

NázevDatabase Modeling and Design: Logical Design
The Morgan Kaufmann Series in Data Management Systems
AutořiToby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish
Vydání4
VydavatelElsevier, 2010
ISBN0080470777, 9780080470771
DélkaPočet stran: 296
  
Exportovat citaciBiBTeX EndNote RefMan