Relational Theory for Computer Professionals
O'Reilly Media, Inc, USA (Verlag)
978-1-4493-6943-9 (ISBN)
All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. This book shows you what a real relational product would be like, and how and why it would be so much better than what’s currently available.
With this unique book, you will:
Learn how to see database systems as programming systems
Get a careful, precise, and detailed definition of the relational model
Explore a detailed analysis of SQL from a relational point of view
There are literally hundreds of books on relational theory or the SQL language or both. But this one is different. First, nobody is more qualified than Chris Date to write such a book. He and Ted Codd, inventor of the relational model, were colleagues for many years, and Chris’s involvement with the technology goes back to the time of Codd’s first papers in 1969 and 1970. Second, most books try to use SQL as a vehicle for teaching relational theory, but this book deliberately takes the opposite approach. Its primary aim is to teach relational theory as such. Then it uses that theory as a vehicle for teaching SQL, showing in particular how that theory can help with the practical problem of using SQL correctly and productively.
Any computer professional who wants to understand what relational systems are all about can benefit from this book. No prior knowledge of databases is assumed.
C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: »An Introduction to Database Systems« (Addison Wesley). He lives in Healdsburg, CA.
Foundations
Chapter 1 Basic Database Concepts
What’s a database?
What’s a DBMS?
What’s a relational DBMS?
Database systems vs. programming systems
Exercises
Answers
Chapter 2 Relations and Relvars
Relations
Relvars
Exercises
Answers
Chapter 3 Keys, Foreign Keys, and Related Matters
Integrity constraints
Keys
Foreign keys
Relvar definitions
Loading the database
Database systems vs. programming systems bis
Exercises
Answers
Chapter 4 Relational Operators I
Codd’s original algebra
Restrict
Project
Exercises I
Answers I
Union, intersection, and difference
Rename
Exercises II
Answers II
Join
Relational comparisons
Update operator expansions
Exercises III
Answers III
Chapter 5 Relational Operators II
MATCHING and NOT MATCHING
EXTEND
Image relations
Aggregation and summarization
Exercises
Answers
Chapter 6 Constraints and Predicates
Database constraints
Relvar predicates
Predicates vs. constraints
Exercises
Answers
Chapter 7 The Relational Model
The relational model defined
Types
The RELATION type generator
Relation variables
Relational assignment
Relational operators
Concluding remarks
Transactions and Database Design
Chapter 8 Transactions
What’s a transaction?
Recovery
Concurrency
Locking
A remark on SQL
Exercises
Answers
Chapter 9 Database Design
Nonloss decomposition
Functional dependencies
Second normal form
Third normal form
Boyce/Codd normal form
Concluding remarks
Exercises
Answers
SQL
Chapter 10 SQL Tables
A little history
Basic concepts
Properties of tables
Table updates
Equality comparisons
Table definitions
SQL systems vs. programming systems
Exercises
Answers
Chapter 11 SQL Operators I
Restrict
Project
Union, intersection, and difference
Rename
Exercises I
Answers I
Join
Evaluating table expressions
Table comparisons
Displaying results
Exercises II
Answers II
Chapter 12 SQL Operators II
MATCHING and NOT MATCHING
EXTEND
Image relations
Aggregation and summarization
Exercises
Answers
Chapter 13 SQL Constraints
Database constraints
Type constraints
Exercises
Answers
Chapter 14 SQL vs. the Relational Model
Some generalities
Some SQL departures from the relational model
Exercises
Answers
Appendixes
Appendix A Tutorial D Grammar
Expressions
Assignments
Appendix TABLE_DUM and TABLE_DEE
Appendix Set Theory
What’s a set?
Subsets and supersets
Set operators
Some identities
The algebra of sets
Cartesian product
Concluding remarks
Appendix Relational Calculus
Sample queries
Sample constraints
A simplified grammar
Exercises
Answers
Appendix A Guide to Further Reading
Papers by E. F. Codd
Books by C. J. Date
Books by C. J. Date and Hugh Darwen
Other Publications Related to SQL
Miscellaneous
| Erscheint lt. Verlag | 2.7.2013 |
|---|---|
| Reihe/Serie | Theory in Practice |
| Verlagsort | Sebastopol |
| Sprache | englisch |
| Maße | 178 x 233 mm |
| Gewicht | 458 g |
| Einbandart | kartoniert |
| Themenwelt | Informatik ► Datenbanken ► SQL Language |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Mathematik / Informatik ► Informatik ► Theorie / Studium | |
| ISBN-10 | 1-4493-6943-X / 144936943X |
| ISBN-13 | 978-1-4493-6943-9 / 9781449369439 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
