Database Systems: A Practical Approach to Design, Implementation, and Management

by Connolly, Thomas M.; Begg, Carolyn E.

• ISBN13: 9780201708578
• ISBN10: 0201708574
• Edition: 3rd
• Format: Paperback
• Copyright: 2001-08-01
• Publisher: Prentice Hall

Summary

Database Systems has a practical, hands-on approach that 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 languages 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.

Table of Contents

Preface	xxxv
Part 1 Background	1	(66)
Introduction to Databases	3	(30)
Database Environment	33	(34)
Part 2 The Relational Model and Languages	67	(200)
The Relational Model	69	(19)
Relational Algebra and Relational Calculus	88	(22)
SQL: Data Manipulation	110	(46)
SQL: Data Definition	156	(41)
Query-By-Example	197	(26)
Commercial RDBMSs: Access and Oracle	223	(44)
Part 3 Database Analysis and Design Techniques	267	(148)
Database Planning, Design, and Administration	269	(33)
Fact-Finding Techniques	302	(28)
Entity-Relationship Modeling	330	(29)
Enhanced Entity-Relationship Modeling	359	(16)
Normalization	375	(40)
Part 4 Methodology	415	(104)
Methodology - Conceptual Database Design	417	(23)
Methodology - Logical Database Design for the Relational Model	440	(36)
Methodology - Physical Database Design for Relational Databases	476	(30)
Methodology - Monitoring and Tuning the Operational System	506	(13)
Part 5 Selected Database Issues	519	(164)
Security	521	(29)
Transaction Management	550	(54)
Query Processing	604	(47)
Programmatic SQL	651	(32)
Part 6 Current Trends	683	(258)
Distributed DBMSs - Concepts and Design	685	(46)
Distributed DBMSs - Advanced Concepts	731	(51)
Introduction to Object DBMSs	782	(29)
Object-Oriented DBMSs - Concepts and Design	811	(40)
Object-Oriented DBMSs - Standards and Systems	851	(40)
Object-Relational DBMSs	891	(50)
Part 7 Emerging Trends	941	(184)
Web Technology and DBMSs	943	(55)
Semistructured Data and XML	998	(47)
Data Warehousing Concepts	1045	(32)
Data Warehousing Design	1077	(23)
OLAP and Data Mining	1100	(25)
Appendices	1125	(73)
A Users' Requirements Specification for DreamHome Case Study	1127	(6)
B Other Case Studies	1133	(13)
C File Organization and Storage Structures	1146	(18)
D When is a DBMS Relational?	1164	(5)
E Alternative ER Modeling Notations	1169	(6)
F Summary of the Database Design Methodology for Relational Databases	1175	(6)
G Estimating Disk Space Requirements	1181	(3)
H Example Web Scripts	1184	(14)
References	1198	(11)
Further Reading	1209	(7)
Index	1216