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
SQL The Complete Reference, 3rd Edition
MySQL in a Nutshell (In a Nutshell (O'Reilly))
High Performance MySQL SECOND EDITION
Oracle SQL Tuning Pocket Reference
SQL Clearly Explained, Second Edition
MySQL (4th Edition) (Developer's Library)
Pro SQL Server Reporting Services
Wrox Professional SQL Server 2005 Reporting Services
SQL Hacks
Pro Access 2007
Fundamentals of Database Systems (4th Ed(9201)
Introduction to Database Systems(7705)
Oracle PL/SQL by Example, 4th Edition(7460)
Microsoft SQL Server 2005, The Complete (4859)
Microsoft Access 2007 Data Analysis(4849)
OCA Oracle Database 11g: Administration (4783)
SQL Server 2005 Management and Administr(4428)
Oracle Database 10g Performance Tuning T(4256)
Oracle SQL by Example(4115)
Database Design: Know It All(3882)
Sams Teach Yourself SQL in 24 Hours (4th(3683)
Access 2007 VBA Programmer's Reference(3413)
Professional Microsoft SQL Server 2008 I(2971)
SQL Clearly Explained, Second Edition(2526)
MySQL in a Nutshell (In a Nutshell (O'Re(10-28)
High Performance MySQL SECOND EDITION(10-28)
Oracle SQL Tuning Pocket Reference(10-28)
SQL Clearly Explained, Second Edition(07-14)
MySQL (4th Edition) (Developer's Library(07-09)
Pro SQL Server Reporting Services(05-28)
Wrox Professional SQL Server 2005 Report(05-28)
SQL Hacks(05-09)
Pro Access 2007(05-04)
Administering SQL Server 7(12-31)
Database Design: Know It All(12-15)
Professional Microsoft SQL Server 2008 I(12-06)
Fundamentals of Database Systems (4th Ed(11-18)
SQL Clearly Explained, Second Edition(10-31)
