Flylib.com
Database in Depth: Relational Theory for Practitioners
Database in Depth: Relational Theory for Practitioners
ISBN: 0596100124
EAN: 2147483647
Year: 2006
Pages: 127
Authors:
C.J. Date
BUY ON AMAZON
Database in Depth
Database in Depth
Dedicated to the memory of E.F.Codd
Copyright
Foreword
What Makes This Book Different?
Further Preliminaries
Conventions Used in This Book
Using Code Examples
Safari Enabled
Comments and Questions
Acknowledgments
Chapter One. Introduction
A Remark on Terminology
Principles, Not Products
A Review of the Original Model
Model Versus Implementation
Properties of Relations
Relations Versus Relvars
Values Versus Variables
Summary
Exercises
Chapter Two. Relations Versus Types
Domain-Constrained Comparisons
Data Value Atomicity
So What s a Type?
Scalar Versus Nonscalar Types
Summary
Exercises
Chapter Three. Tuples and Relations
What s a Tuple?
Some Important Consequences
What s a Relation?
Further Important Consequences
Why Duplicate Tuples Are Prohibited
Why Nulls Are Prohibited
TABLE_DUM and TABLE_DEE
Summary
Exercises
Chapter Four. Relation Variables
Updating Is Set-at-a-Time
More on Candidate Keys
More on Foreign Keys
More on Views
Relvars and Predicates
More on Relations Versus Types
Summary
Exercises
Chapter Five. Relational Algebra
More on Closure
The Original Operators
Evaluating SQL Expressions
Extend and Summarize
Group and Ungroup
Expression Transformation
Relational Comparisons
More on Relational Assignment
The ORDER BY Operator
Summary
Exercises
Chapter Six. Integrity Constraints
Type Constraints
Database Constraints
Transactions
Why Database Constraint Checking Must Be Immediate
But Doesn t Some Checking Have to Be Deferred?
Constraints and Predicates
Miscellaneous Issues
Summary
Exercises
Chapter Seven. Database Design Theory
The Place of Design Theory
Functional Dependencies and BoyceCodd Normal Form
Join Dependencies and Fifth Normal Form
Two Cheers for Normalization
Orthogonality
Some Remarks on Physical Design
Summary
Exercises
Chapter Eight. What Is the Relational Model?
The Relational Model Defined
Objectives of the Relational Model
Some Database Principles
The Relational Model Versus Others
What Remains to Be Done?
Summary
Exercises
Appendix A. A Little Bit of Logic
Propositions
Predicates
Quantification
Free and Bound Variables
More on Quantification
Database Constraints
Queries
Some Equivalences
Summary
Appendix. Suggestions for Further Reading
Colophon
ABOUT THE AUTHOR
COLOPHON
Index
index_SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
Database in Depth: Relational Theory for Practitioners
ISBN: 0596100124
EAN: 2147483647
Year: 2006
Pages: 127
Authors:
C.J. Date
BUY ON AMAZON
Similar book on Amazon
SQL Hacks
An Introduction to Database Systems (8th Edition)
SQL and Relational Theory: How to Write Accurate SQL Code
SQL and Relational Theory: How to Write Accurate SQL Code
The Art of SQL
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Writing Database-Independent Code
Exporting the Results of a Query as a String
Binding Simple Data to Web Forms Controls
Debugging a SQL Server Stored Procedure
A.6. Delegates
Java I/O
Closing Output Streams
Buffered Streams
File Viewer, Part 2
Inflaters and Deflaters
Selectors
Interprocess Communications in Linux: The Nooks and Crannies
Process ID
Key Terms and Concepts
Using fork and exec Together
Key Terms and Concepts
Debugging Multithreaded Programs
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Benefits of Cisco IPC Express
Cisco Zero Touch Deployment
Step 7: Configuring Cisco CME Call Processing Features
Step 8: Interconnecting Multiple Cisco IPC Express Systems
Integrating Cisco CME with Cisco Unity Voice Mail
Developing Tablet PC Applications (Charles River Media Programming)
Introduction to the VB .NET Language
Your First Windows Forms Application
Form Effects
Using Gestures to Control Tablet Media Player
WMI and Hardware
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
Creating a Struts-based MVC Application
Form Presentation and Validation with Struts
Managing Business Logic with Struts
Templates and Velocity
Creating a Search Engine with Lucene
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies