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
Crystal Reports 9 on Oracle (Database Professionals)
Oracle Structures
Oracle Advanced SELECT Options
Optimizing: Reducing Parses
Other Tips
The Crystal Repository
Snort Cookbook
Capturing Without Putting the Interface into Promiscuous Mode
Not Logging
Obfuscating IP Addresses
Working with Honeypots and Honeynets
Snort as Legal Evidence in the U.S.
SQL Hacks
Hack 25. Keep a Running Total
Hack 32. Cope with Rounding Errors
Hack 35. Tally Results into a Chart
Hack 36. Calculate the Distance Between GPS Locations
Hack 79. Identify Updates Uniquely
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Summary
Prerequisites
Running PostgreSQL on a Windows Host
Backing Up and Copying Databases
Securing Tables
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 334 Nonmetallic-Sheathed Cable Types NM, NMC, and NMS
Article 422: Appliances
Article 440: Air Conditioning and Refrigerating Equipment
Annex C. Conduit and Tubing Fill Tables for Conductors and Fixture Wires of the Same Size
Example No. D1(b) One-Family Dwelling
DNS & BIND Cookbook
Registering a Domain Name
Creating a Zone Data File
Configuring a Backup Mail Server in DNS
Creating a Zone Programmatically
Rotating Log Files
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