Database Management Systems

图书介绍

• Author: Raghu Ramakrishnan, Johannes Gehrke

DATABASE MANAGEMENT SYSTEMS is designed for use in a course in databases. This book is distinctive in its emphasis on the practical side of databases. This means that it has unique coverage of database design, uses SQL throughout the book to demonstrate different concepts, and has an emphasis on query evaluation and optimization. In this revision the author has moved coverage of the ER model earlier in the book. Additionally, he has added chapters on Internet Databases, Decision Support, Data Mining, Object-Relational Databases, Spatial Databases and Deductive and Active Databases. DATABASE MANAGEMENT SYSTEMS is accompanied by a website that includes solutions, presentation materials, practical SQL assignments, the minibase software and helpful lecture tips.



Book Info

Provides a hands-on approach to relational database systems, with an emphasis on practical topics such as indexing methods, SQL, and database design. DLC: Database management.



CONTENTS



PREFACE



Part I BASICS

1 INTRODUCTION TO DATABASE SYSTEMS

2 THE ENTITY-RELATIONSHIP MODEL

3 THE RELATIONAL MODEL



Part II RELATIONAL QUERIES

4 RELATIONAL ALGEBRA AND CALCULUS

5 SQL: QUERIES, PROGRAMMING, TRIGGERS

6 QUERY-BY-EXAMPLE (QBE)



Part III DATA STORAGE AND INDEXING

7 STORING DATA: DISKS AND FILES

8 FILE ORGANIZATIONS AND INDEXES

9 TREE-STRUCTURED INDEXING

10 HASH-BASED INDEXING



Part IV QUERY EVALUATION

11 EXTERNAL SORTING

12 EVALUATION OF RELATIONAL OPERATORS

13 INTRODUCTION TO QUERY OPTIMIZATION

14 A TYPICAL RELATIONAL QUERY OPTIMIZER



Part V DATABASE DESIGN

15 SCHEMA REFINEMENT AND NORMAL FORMS

16 PHYSICAL DATABASE DESIGN AND TUNING

17 SECURITY



Part VI TRANSACTION MANAGEMENT

18 TRANSACTION MANAGEMENT OVERVIEW

19 CONCURRENCY CONTROL

20 CRASH RECOVERY



Part VII ADVANCED TOPICS

21 PARALLEL AND DISTRIBUTED DATABASES

22 INTERNET DATABASES

23 DECISION SUPPORT

24 DATA MINING

25 OBJECT-DATABASE SYSTEMS

26 SPATIAL DATAMANAGEMENT

27 DEDUCTIVE DATABASES

28 ADDITIONAL TOPICS



A DATABASE DESIGN CASE STUDY: THE INTERNET SHOP

B THE MINIBASE SOFTWARE

REFERENCES

SUBJECT INDEX

AUTHOR INDEX