
Database Systems The Complete Book
by Garcia-Molina, Hector; Ullman, Jeffrey D.; Widom, Jennifer-
Complimentary 7-Day eTextbook Access - Read more
When you rent or buy this book, you will receive complimentary 7-day online access to the eTextbook version from your PC, Mac, tablet, or smartphone. Feature not included on Marketplace Items.
Buy New
Rent Textbook
Rent Digital
Used Textbook
We're Sorry
Sold Out
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Author Biography
Hector Garcia-Molina is the L. Bosack and S. Lerner Professor of Computer Science and Electrical Engineering at Stanford University. His research interests include digital libraries, information integration, and database applications on the Internet. He was a recipient of the SIGMOD Innovations Award and a member of PITAC (President's Information-Technology Advisory Council). He currently serves on the Board of Directors of Oracle Corp.
Jeffrey D. Ullman is the Stanford W. Ascherman Professor of Computer Science (emeritus) at Stanford University. He is the author or co-author of 16 books, including Elements of ML Programming (Prentice Hall 1998). His research interests include data mining, information integration, and electronic education. He is a member of the National Academy of Engineering, and recipient of a Guggenheim Fellowship, the Karl V. Karlstom Outstanding Educator Award, the SIGMOD Contributions and Edgar F. Codd Innovations Awards, and the Knuth Prize.
Jennifer Widom is Professor of Computer Science and Electrical Engineering at Stanford University. Her research interests span many aspects of nontraditional data management. She is an ACM Fellow and a member of the National Academy of Engineering, she received the ACM SIGMOD Edgar F. Codd Innovations award in 2007 and was a Guggenheim Fellow in 2000, and she has served on a variety of program committees, advisory boards, and editorial boards.
Table of Contents
The Worlds of Database Systems | |
The Evolution of Database Systems | |
Early Database Management Systems | |
Relational Database Systems | |
Smaller and Smaller Systems | |
Bigger and Bigger Systems | |
Information Integration1.2 Overview of a Database Management System | |
Data-Definition Language Commands | |
Overview of Query Processing | |
Storage and Buffer Management | |
Transaction Processing | |
The Query Processor1.3 Outline of Database-System Studies1.4 References for Chapter 1I Relational Database Modeling2 The Relational Model of Data2.1 An Overview of Data Models | |
What is a Data Model? | |
Important Data Models | |
The Relational Model in Brief | |
The Semistructured Model in Brief | |
Other Data Models | |
Comparison of Modeling Approaches2.2 Basics of the Relational Model | |
Attributes | |
Schemas | |
Tuples | |
Domains2 CONTENTS | |
Equivalent Representations of a Relation | |
Relation Instances | |
Keys of Relations | |
An Example Database Schema | |
Exercises for Section | |
De ning a Relation Schema in SQL | |
Relations in SQL | |
Data Types | |
Simple Table Declarations | |
Modifying Relation Schemas | |
Default Values | |
Declaring Keys | |
Exercises for Section | |
An Algebraic Query Language | |
Why Do We Need a Special Query Language? | |
What is an Algebra? | |
Overview of Relational Algebra | |
Set Operations on Relations | |
Projection | |
Selection | |
Cartesian Product | |
Natural Joins | |
Theta-Joins | |
Combining Operations to Form Queries | |
Naming and Renaming | |
Relationships Among Operations | |
A Linear Notation for Algebraic Expressions | |
Exercises for Section | |
Constraints on Relations | |
Relational Algebra as a Constraint Language | |
Referential Integrity Constraints | |
Key Constraints | |
Additional Constraint Examples | |
Exercises for Section | |
Summary of Chapter 22.7 References for Chapter | |
Design Theory for Relational Databases3.1 Functional Dependencies | |
De nition of Functional Dependency | |
Keys of Relations | |
Superkeys | |
Exercises for Section | |
Rules About Functional Dependencies | |
Reasoning About Functional Dependencies | |
The Splitting/Combining Rule | |
Trivial Functional Dependencies | |
Computing the Closure of Attributes | |
Why the Closure Algorithm Works | |
The Transitive Rule | |
Closing Sets of Functional Dependencies | |
Projecting Functional Dependencies | |
Exercises for Section | |
Design of Relational Database Schemas | |
Anomalies | |
Decomposing Relations | |
Boyce-Codd Normal Form | |
Decomposition into BCNF | |
Exercises for Section | |
Decomposition: The Good, Bad, and Ugly | |
Recovering Information from a Decomposition | |
The Chase Test for Lossless Join | |
Why the Chase Works | |
Dependency Preservation | |
Exercises for Section | |
Third Normal Form | |
Definition of Third Normal Form | |
The Synthesis Algorithm for 3NF Schemas | |
Why the 3NF Synthesis Algorithm Works | |
Exercises for Section | |
Multivalued Dependencies | |
Attribute Independence and Its ConsequentRedundancy | |
Definition of Multivalued Dependencies | |
Reas | |
Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.