Database Systems / Edition 1

Database Systems / Edition 1

by Thomas Connolly
     
 

ISBN-10: 0201422778

ISBN-13: 9780201422771

Pub. Date: 01/28/1996

Publisher: Addison-Wesley

Database Systems' practical, hands-on approach makes it uniquely suited to providing a strong foundation in good database design practice. A clear introduction to design, implementation and management issues, as well as an extensive treatment of database language and standards, make this book an indispensable complete reference for database students and…  See more details below

Overview

Database Systems' practical, hands-on approach makes it uniquely suited to providing a strong foundation in good database design practice. A clear introduction to design, implementation and management issues, as well as an extensive treatment of database language and standards, make this book an indispensable complete reference for database students and professionals alike. The new edition of this bestseller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that contributed to the success of previous editions.

A realistic case study integrated throughout the book enables complex subjects to be explained in the context of one understandable example, while three additional case studies allow readers to work through examples by themselves. Clearly stated chapter objectives and summaries guide the reader, highlighted key definitions and numerous worked examples illustrate the concepts, and review questions and exercises reinforce the material covered in each chapter.

Features

  • Database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice.
  • Extensive treatment of SQL in three tutorial-style chapters.
  • Comprehensive treatment of distributed, object-oriented, and object-relational DBMSs.
  • Comprehensive introduction to data warehousing, OLAP, and data mining.
  • Extensive treatment of the Web as an emerging platform for database applications with many code samples for accessing databases from the Webincluding JDBC, SQLJ, ASP, JSP, and Oracle's PSP.

New! For the third edition

  • Use of UML notation for ER diagrams.
  • New chapter on the relational algebra and relational calculus.
  • New chapter on fact-finding techniques as a step prior to the start of the database design methodology.
  • New chapter on Access and Oracle DBMSs, illustrating the difference between the two systems.
  • New chapter on semistructured data, its relationship to XML, and query languages for XML.
  • New chapter of data warehouse design using dimensionality modeling.
  • Introduction of color to highlight the text and improve navigation through the book.

Read More

Product Details

ISBN-13:
9780201422771
Publisher:
Addison-Wesley
Publication date:
01/28/1996
Series:
International Computer Science Series
Edition description:
Older Edition
Pages:
832
Product dimensions:
7.47(w) x 9.23(h) x 1.67(d)

Table of Contents

Preface
Pt. 1Background1
Ch. 1Introduction to Databases3
Ch. 2Database Environment33
Pt. 2The Relational Model and Languages67
Ch. 3The Relational Model69
Ch. 4Relational Algebra and Relational Calculus88
Ch. 5SQL: Data Manipulation110
Ch. 6SQL: Data Definition156
Ch. 7Query-By-Example197
Ch. 8Commercial RDBMSs: Access and Oracle223
Pt. 3Database Analysis and Design Techniques267
Ch. 9Database Planning, Design, and Administration269
Ch. 10Fact-Finding Techniques302
Ch. 11Entity-Relationship Modeling330
Ch. 12Enhanced Entity-Relationship Modeling359
Ch. 13Normalization375
Pt. 4Methodology415
Ch. 14Methodology - Conceptual Database Design417
Ch. 15Methodology - Logical Database Design for the Relational Model440
Ch. 16Methodology - Physical Database Design for Relational Databases476
Ch. 17Methodology - Monitoring and Tuning the Operational System506
Pt. 5Selected Database Issues519
Ch. 18Security521
Ch. 19Transaction Management550
Ch. 20Query Processing604
Ch. 21Programmatic SQL651
Pt. 6Current Trends683
Ch. 22Distributed DBMSs - Concepts and Design685
Ch. 23Distributed DBMSs - Advanced Concepts731
Ch. 24Introduction to Object DBMSs782
Ch. 25Object-Oriented DBMSs - Concepts and Design811
Ch. 26Object-Oriented DBMSs - Standards and Systems851
Ch. 27Object-Relational DBMSs891
Pt. 7Emerging Trends941
Ch. 28Web Technology and DBMSs943
Ch. 29Semistructured Data and XML998
Ch. 30Data Warehousing Concepts1045
Ch. 31Data Warehousing Design1077
Ch. 32OLAP and Data Mining1100
App. AUsers' Requirements Specification for DreamHome Case Study1127
App. B: Other Case Studies1133
App. CFile Organization and Storage Structures1146
App. DWhen is a DBMS Relational?1164
App. EAlternative ER Modeling Notations1169
App. FSummary of the Database Design Methodology for Relational Databases1175
App. GEstimating Disk Space Requirements1181
App. HExample Web Scripts1184
References1198
Further Reading1209
Index1216

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >