Database Modeling and Design: Logical Design / Edition 5

Paperback (Print)
Buy New
Buy New from BN.com
$51.98
Used and New from Other Sellers
Used and New from Other Sellers
from $19.15
Usually ships in 1-2 business days
(Save 70%)
Other sellers (Paperback)
  • All (17) from $19.15   
  • New (8) from $29.55   
  • Used (9) from $19.15   

Overview

Database Modeling & Design is a comprehensive guide to DB design for commercial database products and their applications. Throughout, Toby Teorey offers practical and immediately usable techniques for transforming the ER model into SQL data structures. New to this Edition: A simple introduction to the terms and concepts of relational databases for those new to DB application programming; a complete description of SQL with 20 sample queries; object data modeling and its relationship to ER modeling for easy conversion when needed; figures and examples utilize standard Chen notation; new coverage of DB tuning; and a new case study: an intuitive employee database example that allows the reader to concentrate on concepts rather than on the specifics of the database. Also includes solutions to selected exercises for those who want a taste of practical experience in DB design.

"...completely revised and updated to provide the most comprehensive treatment of database design for commercial database products and their applications...covers basic foundations as well as more advanced techniques."

Read More Show Less

Editorial Reviews

From the Publisher
"An explicit presentation on Business Intelligence."
- P. Pichappan, Department of Information Science, Annamalai University, India
Read More Show Less

Product Details

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

Read More Show Less

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
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)