Database Systems The Complete Book

ISBN-10: 0130319953

ISBN-13: 9780130319951

Edition: 2002

Authors: Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom

List price: $127.33
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


Written by well-known information management experts, this book provides in-depth coverage of databases from the perspective of the designer, user and application programmer. It covers the SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL and XML standards.
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought

Book details

List price: $127.33
Copyright year: 2002
Publisher: Prentice Hall PTR
Publication date: 10/2/2001
Binding: Hardcover
Pages: 1152
Size: 7.50" wide x 9.75" long x 1.75" tall
Weight: 3.894
Language: English

NOTE:Each chapter concludes with Summary and References sections
The Worlds of Database Systems
The Evolution of Database Systems
Overview of a Database Management System
Outline of Database-System Studies
The Entity-Relationship Data Model
Elements of the E/R Model
Design Principles
The Modeling of Constraints
Weak Entity Sets
The Relational Data Model
Basics of the Relational Model
From E R Diagrams to Relational Designs
Converting Subclass Structures to Relations
Functional Dependencies
Rules About Functional Dependencies
Design of Relational Database Schemas
Multivalued Dependencies
Other Data Models
Review of Object-Oriented Concepts
Introduction to ODL
Additional ODL Concepts
From ODL Designs to Relational Designs
The Object-Relational Model
Semistructured Data
XML and Its Data Model
Relational Algebra
An Example Database Schema
An Algebra of Relational Operations
Relational Operations on Bags
Extended Operators of Relational Algebra
Constraints on Relations
The Database Language SQL
Simple Queries in SQL
Queries Involving More Than One Relation
Full-Relation Operations
Database Modifications
Defining a Relation Schema in SQL
View Definitions
Constraints and Triggers
Keys and Foreign Keys
Constraints on Attributes and Tuples
Modification of Constraints
Schema-Level Constraints and Triggers
System Aspects of SQL
SQL in a Programming Environment
Procedures Stored in the Schema
The SQL Environment
Using a Call-Level Interface
Java Database Connectivity
Transactions in SQL
Security and User Authorization in SQL
Object-Orientation in Query Languages
Introduction to OQL
Additional Forms of OQL Expressions
Object Assignment and Creation in OQL
User-Defined Types in SQL
Operations on Object-Relational Data
Logical Query Languages
A Logic for Relations
From Relational Algebra to Datalog
Recursive Programming in Datalog
Recursion in SQL
Data Storage
The ldquo;Megatron 2002rdquo; Database System
The Memory Hierarchy
Using Secondary Storage Effectively
Accelerating Access to Secondary Storage
Disk Failures
Recovery from Disk Crashes
Representing Data Elements
Data Elements and Fields
Representing Block and Record Addresses
Variable-Length Data and Records
Record Modifications
Index Structures
Indexes on Sequential Files
Secondary Indexes
Hash Tables
Multidimensional Indexes
Applications Needing Multiple Dimensions
Hash-Like Structures for Multidimensional Data
Tree-Like Structures for Multidimensional Data
Bitmap Indexes
Query Execution
Introduction to Physical-Query-Plan Operators
One-Pass Algorithms for Database Operations
Nested-Loop Joins
Two-Pass Algorithms Based on Sorting
Two-Pass Algorithms Based on Hashing
Index-Based Algorithms
Buffer Management
Algorithms Using More Than Two Passes
Parallel Algorithms for Relational Operations
The Query Co
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.