|
Database Systems: A Practical Approach 4th Edition
Over 200,000 people have been grounded in good database design practice by readingDatabase Systems. 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 has contributed to the success of previous editions.
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
Features
* Complex subjects are clearly explained using running case studies throughout the book.
* Database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described with an example of how it works in practice.
* SQL is comprehensively covered in three tutorial-style chapters.
* Distributed, object-oriented, and object-relational DBMSs are fully discussed.
Check out the web site at www.booksites.net/connbegg, for full implementations of the case studies, lab guides for Access and Oracle, and additional student support.
New! For the fourth edition
* Extended treatment of XML, OLAP and data mining.
* Coverage of updated standards including SQL:2003, W3C (XPath and
XQuery), and OMG.
* Now covers Oracle9i and Microsoft Office Access 2003.
Both Thomas Connolly and Carolyn Begg have experience of database design in industry, and now apply this in their teaching and research at the University of Paisley in Scotland.
This book comes with a free six-month subscription to Database Place, an online tutorial that helps readers master the key concepts of database systems. Log on at www.aw.com/databaseplace.
CONTENTS:
Preface
Part 1 Background
1 Introduction to Databases
2 Database Environment
Part 2 The Relational Model and Languages
3 The Relational Model
4 Relational Algebra and Relational Calculus
5 SQL: Data Manipulation
6 SQL: Data Definition
7 Query-By-Example
8 Commercial RDBMSs: Office Access and Oracle
Part 3 Database Analysis and Design Techniques
9 Database Planning, Design, and Administration
10 Fact-Finding Techniques
11 Entity??Relationship Modeling
12 Enhanced Entity??Relationship Modeling
13 Normalization
14 Advanced Normalization
Part 4 Methodology
15 Methodology ?? Conceptual Database Design
16 Methodology ?? Logical Database Design for the Relational Model
17 Methodology ?? Physical Database Design for Relational Databases
18 Methodology ?? Monitoring and Tuning the Operational System
Part 5 Selected Database Issues
19 Security
20 Transaction Management
21 Query Processing
Part 6 Distributed DBMSs and Replication
22 Distributed DBMSs ?? Concepts and Design
23 Distributed DBMSs ?? Advanced Concepts
24 Replication and Mobile Databases
Part 7 Object DBMSs
25 Introduction to Object DBMSs
26 Object-Oriented DBMSs ?? Concepts
27 Object-Oriented DBMSs ?? Standards and Systems
28 Object-Relational DBMSs
Part 8 Web and DBMSs
29 Web Technology and DBMSs
30 Semistructured Data and XML
Part 9 Business Intelligence
31 Data Warehousing Concepts
32 Data Warehousing Design
33 OLAP
34 Data Mining
Appendices
A Users?? Requirements Specification for DreamHome Case Study
B Other Case Studies
C File Organizations and Indexes
D When is a DBMS Relational?
E Programmatic SQL
F Alternative ER Modeling Notations
G Summary of the Database Design Methodology for Relational Databases
H Estimating disk space requirements (web only)
I Example web scripts (web only)
References
Further Reading
Index
|
