Introduction to Database Systems

ISBN-10: 0201385902
ISBN-13: 9780201385908
Edition: 7th 2000
Authors: C. J. Date
List price: $69.00
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

Description: The Seventh Edition continues to focus on the hallmark feature of its previous editions: providing a solid grounding in the foundations of database technology and shedding some light on how the field is likely to develop in the future. This  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

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
Calculus 1 Online content $4.95 $1.99
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

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $69.00
Edition: 7th
Copyright year: 2000
Publisher: Addison-Wesley Longman, Incorporated
Publication date: 8/12/1999
Binding: Hardcover
Pages: 938
Size: 10.00" wide x 8.25" long x 1.50" tall
Weight: 3.630

The Seventh Edition continues to focus on the hallmark feature of its previous editions: providing a solid grounding in the foundations of database technology and shedding some light on how the field is likely to develop in the future. This comprehensive introduction to databases has been thoroughly revised to reflect the latest developments and advances in the field of database systems. Emphasizing insight and understanding rather than formalism, Chris Date has divided the book into six parts: Basic Concepts, The Relational Model, Database Design, Transaction Management, Further Topics, and Object and Object/Relational Databases. Throughout the book, there are numerous worked examples and exercises for the readerwith selected answersas well as an extensive set of annotated references. The release of this new edition of An Introduction to Database Systems coincides with the 25th Anniversary of its initial publication.

(All chapters begin with an Introduction end with a Summary, Exercises, and Reference and Bibliography)
Preliminaries
An Overview of Database Management
What is a database system?
What is a database?
Why database?
Data independence
Relational systems and others
Database System Architecture
The three levels of the architecture
The external level
The conceptual level
The internal level
Mappings
The database administrator
The database management system
Data communications
Client/server architecture
Utilities
Distributed processing
An Introduction to Relational Databases
An informal look at the relational model
Relations and relvars
What relations mean
Optimization
The catalog
Base relvars and views
Transactions
The suppliers-and-parts database
An Introduction to SQL
Overview
The catalog
Views
Transactions
Embedded SQL
Dynamic SQL and SQL/CLI
SQL is not perfect
The Relational Model
Types
Values v Variables
Types v Representations
Type Definition
Operators
Type generators
SQL facilities
Relations
Tuples
Relation types
Relation values
Relation variables
SQL facilities
Relational Algebra
Closure revisited
The original algebra: Syntax
The original algebra: Semantics
Examples
What is the algebra for?
Further points
Additional operators
Grouping and ungrouping
Relational Calculus
Tuple calculus
Examples
Calculus vs. algebra
Computational capabilities
SQL facilities
Domain calculus
Query-By-Example
Integrity
A closer look
Predicates and propositions
Relvar predicates and database predicates
Checking the constraints
Internal v external constraints
Correctness v consistency
Integrity and views
A constraint classification scheme
Keys
Triggers (a digression)
SQL facilities
Views
What are views for?
View retrievals
View updates
Snapshots (a digression)
SQL facilities
Database Design
Functional Dependencies
Basic definitions
Trivial and nontrivial dependencies
Closure of a set of dependencies
Closure of a set of attributes
Irreducible sets of dependencies
Further Normalization I: 1NF, 2NF, 3NF, BCNF
Nonloss decomposition and functional dependencies
First, second, and third normal forms
Dependency preservation
Boyce/Codd normal form
A note on relation-valued attributes
Further Normalization II: Higher Normal Forms
Multi-valued dependencies and fourth normal form
Join dependencies and fifth normal form
The normalization procedure summarized
A note on denormalization
Orthogonal design (a digression)
Other normal forms
Semantic Modeling
The overall approach
The E/R model
E/R diagrams
Database design with the E/R model
A brief analysis
Transaction Management
Recovery
Transactions
Transaction recovery
System recovery
Media recovery
Two-phase commit
Savepoints (a digression)
SQL facilities
Concurrency
Three concurrency problems
Locking
The three concurrency problems revisited
Deadlock
Serializability
Recovery revisited
Isolation levels
Intent locking
ACID dropping
SQL facilities
Further Topics
Security
Discretionary access control
Mandatory access control
Statistical databases
Data encryption
SQL facilities
Optimization
A motivating example
An overview of query processing
Expression transformation
Database statistics
A divide-and-conquer strategy
Implementing the relational operators
Missing Information
An overview of the 3VL approach
Some consequences of the foregoing scheme
Nulls and keys
Outer join (a digression)
Special values
SQL facilities
Type Inheritance
Type hierarchies
Polymorphism and substitutability
Variables and assignments
Specialization by constraint
Comparisons
Operators, versions, and signatures
Is a circle an ellipse?
Specialization by constraint revisited
SQL facilities
Distributed Databases
Some preliminaries
The twelve objectives
Problems of distributed systems
Client/server systems
DBMS independence
SQL facilities
Decision Support
Aspects of decision support
Database design for decision support
Data preparation
Data warehouses and data marts
Online analytical processing
Data mining
SQL facilities
Temporal Databases
What is the problem?
Intervals
Packing and unpacking relations
Generalizing the relational operators
Database work design
Integrity constraints
Logic-Based Databases
Overview
Propositional calculus
Predicate calculus
A proof-theoretic view of databases
Deductive database systems
Recursive query processing
Objects, Relations, And Xml
Object Databases
Objects, classes, methods, and messages
A closer look
A cradle-to-grave example
Miscellaneous issues
Object / Relational Databases
The First Great Blunder
The Second Great Blunder
Implementation issues
Benefits of true rapprochement
SQL facilities
The World Wide Web and XML
The Web and the Internet
An overview of XML
XML data definition
XML data manipulation
XML and databases
SQL facilities
Appendixes
The TransRelational��� Model
Three levels of abstraction
The basic idea
Condensed columns
Merged columns
Implementing the relational operators
SQL Expressions, Table Expressions, and Boolean Expressions
Abbreviations, Acronyms, and Symbol
Online storage structures and access methods, database access: an overview, page sets and files, indexing, hashing, pointer chains, and compression techniques
Index

×
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.

×