Title: Database Management Systems Author(s): Raghu Ramakrishnan, Johannes Gehrke Pages: 740 Publisher: McGraw-Hill Companies; 2nd edition Publication date: 2000 Language: English Format: PDF ISBN-10: 0072465352 ISBN-13: Description: 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
Title: Database Management Systems