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
password: books_for_all
http://rapidshare.com/files/32594545/CD12E281-52EE-421F-98A9-E3BF98808232.rar
MCITP Sql Server Database Developer
How to Access Your Hidden Brain Power & Learn Faster
Managing and Mining Multimedia Databases
Databases with Access: Learning Made Simple
Oracle and Java Development (Sams White Book)
Major Donors: Finding Big Gifts in Your Database and Online
MCITP Sql Server Database Developer Exam Guide
Database Management Systems
Sams Teach Yourself SQL in 24 Hours (4th Edition)
Accelerated SQL Server 2008 (Accelerated)
How to Access Your Hidden Brain Power & (07-20)
Managing and Mining Multimedia Databases(07-18)
Databases with Access: Learning Made Sim(07-18)
Oracle and Java Development (Sams White (07-18)
Major Donors: Finding Big Gifts in Your (07-18)
MCITP Sql Server Database Developer Exam(07-16)
Database Management Systems(07-09)
Sams Teach Yourself SQL in 24 Hours (4th(06-28)
Accelerated SQL Server 2008 (Accelerated(06-16)
Sams Teach Yourself PHP, MySQL and Apach(05-30)
Pro SQL Server 2008 XML(05-23)
Introduction to Database Systems(05-20)
Microsoft SQL Server 2005, The Complete (962)
Oracle Database 10g Performance Tuning T(662)
Sams Teach Yourself SQL in 24 Hours (4th(632)
Database Management Systems(560)
SQL Server 2005 Management and Administr(527)
Accelerated SQL Server 2008 (Accelerated(375)
Access 2007 VBA Programmer's Reference(352)
SQL Queries for Mere Mortals: A Hands-On(345)
Practical Business Intelligence with SQL(341)
Pro SQL Server 2008 XML(331)
Data Modeling Fundamentals Jul 2007 eBoo(281)
Beginning VB 2008 Databases: From Novice(275)
