Introduction to Database Systems / Edition 8

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $21.49
Usually ships in 1-2 business days
(Save 89%)
Other sellers (Paperback)
  • All (21) from $21.49   
  • New (9) from $131.66   
  • Used (12) from $21.49   

Overview

For over 25 years, C. J. Date's An Introduction to Database Systems has been the authoritative resource for readers interested in gaining insight into and understanding of the principles of database systems. This revision continues to provide a solid grounding in the foundations of database technology and to provide some ideas as to how the field is likely to develop in the future.. "Readers of this book will gain a strong working knowledge of the overall structure, concepts, and objectives of database systems and will become familiar with the theoretical principles underlying the construction of such systems.

A classic book, revised--the best, most comprehensive, and most up-to-date treatment of database concepts and technology available. Contains greatly expanded treatment of object-oriented database system, including a proposal for rapprochement between OO and relational technologies. Includes important new chapters on functional dependencies, views, domains, and missing information.

Read More Show Less

Editorial Reviews

Booknews
Introduces the field of database systems, for students and professionals with a basic of knowledge of storage and file management capabilities of a modern computer system and features of one or more high-level programming language. Coverage includes general concepts, the relational model, theory and practice of database design, transaction management, how relational concepts are relevant to other aspects of database technology, and the impact of object technology on database systems. This seventh edition amplifies treatment of the relational model, relation-valued attributes, type inheritance, and temporal databases, and contains two new appendices of SQL and SQL3. The author is a lecturer, researcher, and independent consultant specializing in relational database systems. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780321197849
  • Publisher: Addison-Wesley
  • Publication date: 7/22/2003
  • Edition description: Eighth Edition
  • Edition number: 8
  • Pages: 983
  • Sales rank: 600,127
  • Product dimensions: 7.08 (w) x 9.05 (h) x 2.12 (d)

Table of Contents

(All chapters begin with an Introduction end with a Summary, Exercises, and Reference and Bibliography)

I. PRELIMINARIES.

1. An Overview of Database Management.

What is a database system?

What is a database?

Why database?

Data independence.

Relational systems and others.

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

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

4. An Introduction to SQL.

Overview.

The catalog.

Views.

Transactions.

Embedded SQL.

Dynamic SQL and SQL/CLI.

SQL is not perfect.

II. THE RELATIONAL MODEL.

5. Types.

Values v Variables.

Types v Representations.

Type Definition.

Operators.

Type generators.

SQL facilities.

6. Relations.

Tuples.

Relation types.

Relation values.

Relation variables.

SQL facilities.

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

8. Relational Calculus.

Tuple calculus.

Examples.

Calculus vs. algebra.

Computational capabilities.

SQL facilities.

Domain calculus.

Query-By-Example.

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

10. Views.

What are views for?

View retrievals.

View updates.

Snapshots (a digression).

SQL facilities.

III. DATABASE DESIGN.

11. Functional Dependencies.

Basic definitions.

Trivial and nontrivial dependencies.

Closure of a set of dependencies.

Closure of a set of attributes.

Irreducible sets of dependencies.

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

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

14. Semantic Modeling.

The overall approach.

The E/R model.

E/R diagrams.

Database design with the E/R model.

A brief analysis.

IV. TRANSACTION MANAGEMENT.

15. Recovery.

Transactions.

Transaction recovery.

System recovery.

Media recovery.

Two-phase commit.

Savepoints (a digression).

SQL facilities.

16. Concurrency.

Three concurrency problems.

Locking.

The three concurrency problems revisited.

Deadlock.

Serializability.

Recovery revisited.

Isolation levels.

Intent locking.

ACID dropping.

SQL facilities.

V. FURTHER TOPICS.

17. Security.

Discretionary access control.

Mandatory access control.

Statistical databases.

Data encryption.

SQL facilities.

18. Optimization.

A motivating example.

An overview of query processing.

Expression transformation.

Database statistics.

A divide-and-conquer strategy.

Implementing the relational operators.

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

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

21. Distributed Databases.

Some preliminaries.

The twelve objectives.

Problems of distributed systems.

Client/server systems.

DBMS independence.

SQL facilities.

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

23. Temporal Databases.

What is the problem?

Intervals.

Packing and unpacking relations.

Generalizing the relational operators.

Database work design.

Integrity constraints.

24. Logic-Based Databases.

Overview.

Propositional calculus.

Predicate calculus.

A proof-theoretic view of databases.

Deductive database systems.

Recursive query processing.

VI. OBJECTS, RELATIONS, AND XML.

25. Object Databases.

Objects, classes, methods, and messages.

A closer look.

A cradle-to-grave example.

Miscellaneous issues.

26. Object / Relational Databases.

The First Great Blunder.

The Second Great Blunder.

Implementation issues.

Benefits of true rapprochement.

SQL facilities.

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

Appendix A: The TransRelational™ Model.

Three levels of abstraction.

The basic idea.

Condensed columns.

Merged columns.

Implementing the relational operators.

Appendix B: SQL Expressions, Table Expressions, and Boolean Expressions.

Appendix C: Abbreviations, Acronyms, and Symbol.

Appendix D: Online storage structures and access methods, database access: an overview, page sets and files, indexing, hashing, pointer chains, and compression techniques.

Index.

Read More Show Less

Customer Reviews

Average Rating 4
( 3 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(1)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted August 10, 2004

    Foundations, or 'why smug relational weenies are smug'

    Extremely useful reference for the relational model; the foundations and principles which are essential to properly understanding _why_ I should care about reading 'SQL in a nutshell' or 'Oracle for dummies'. I would recommend reading several varying introductions to relational theory first, in order to learn what the vocabulary is, learn what the crack-pot explanations are, and generally get a vague sense of the theory. ** In particular, if one is already familiar with SQL, one -- as an absolute prerequisite -- must gain a basic understanding of all the relational algebra operations. ** Some of the contained criticisms of OO techniques, although valid, are not generally valid against OO in general, in exactly the same way that its criticisms of sql and common databases are not valid against relational theory in general.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 29, 2004

    A sound foundation

    People looking for a cookbook approach or trying to get answers for questions like 'How can I do X in the SQL of product Y?', look further, or better contemplate on your real needs and questions. This book forms a firm, solid foundation for thinking about and working with data. I personally don't regard it as a mere 'Introduction', but as a reference guide on the Relational Model. When you leave the paradigm of SQL behind you, it's easy to follow. You get an understanding of what Database Systems are about and the formal language that makes reasoning about it understandable and less prone to misundertandings. You don't a mere syntax for creating tables. The only nasty thing about it, is that it leaves you with the question 'Why did the industry fail to implement the Relational Model in the decades since its conception?'. Figuring out an answer on a rainy Sunday morning is depressing. In that sence, Ignorance is Bliss, and don't read the book.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 10, 2009

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)