| |
| |
| |
Theory Is Practical | |
| |
| |
Introduction | |
| |
| |
| |
Theory is Practical | |
| |
| |
| |
The Importance of Closure | |
| |
| |
| |
What's in a Name | |
| |
| |
| |
Why Three-Valued Logic is a Mistake | |
| |
| |
| |
Nothing in Excess | |
| |
| |
| |
Answers to Puzzle Corner Problems (Installments 1-5) | |
| |
| |
| |
Tables with No Columns | |
| |
| |
| |
Empty Bags and Identity Crises | |
| |
| |
| |
The Power of the Keys | |
| |
| |
| |
Expression Transformation (Part 1 of 3) | |
| |
| |
| |
A Matter of Integrity (Part 2 of 3) | |
| |
| |
| |
A Matter of Integrity (Part 3 of 3) | |
| |
| |
| |
Toil and Trouble | |
| |
| |
| |
Answers to Puzzle Corner Problems (Installments 13-17) | |
| |
| |
| |
More on DEE and DUM | |
| |
| |
| |
Divide---and Conquer | |
| |
| |
| |
Relational Comparison | |
| |
| |
| |
Domains, Relations, and Data Types ( | |
| |
| |
| |
of 2) | |
| |
| |
| |
Domains, Relations, and Data Types ( | |
| |
| |
| |
of 2) | |
| |
| |
| |
Answers to Puzzle Corner Problems (Installments 19-23) | |
| |
| |
| |
Many Happy Returns! | |
| |
| |
| |
Relational Database Management | |
| |
| |
An Overview Of INGRES and QUEL | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Background | |
| |
| |
| |
Data Definition | |
| |
| |
| |
Data Manipulation: Retrieval Operations | |
| |
| |
| |
Data Manipulations: Update Operations | |
| |
| |
| |
Views | |
| |
| |
| |
Embedded QUEL. The Primacy Of Primary Keys: An Investigation | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments of Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
Keys in Relational Model | |
| |
| |
| |
Arguments in Defense of the PK: AK Distinction | |
| |
| |
| |
Relations with Multiple Candidate Keys | |
| |
| |
| |
The Invoices-and-Shipments example | |
| |
| |
| |
One Primary Key Per Entry Type | |
| |
| |
| |
The Applicants-and-Employees Example | |
| |
| |
| |
Conclusion. A Normalization Problem | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Problem Statement | |
| |
| |
| |
Definitions of 3NF and BCNF | |
| |
| |
| |
Problem Solving | |
| |
| |
| |
The Five Proposed Solutions | |
| |
| |
| |
Declaring Integrity Constraints. A New Database Design Principle | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
The Loves-Hates Example | |
| |
| |
| |
The Employee Example | |
| |
| |
| |
Integrity Constraints | |
| |
| |
| |
The Question of Meaning | |
| |
| |
| |
Tables with Overlapping Meanings | |
| |
| |
| |
The Examples Revisited | |
| |
| |
| |
An Important Clarification | |
| |
| |
| |
Concluding Remarks. Updating Union, Intersection, And Difference Views | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
Integrity Constraints | |
| |
| |
| |
Table Predicates | |
| |
| |
| |
Further Principles | |
| |
| |
| |
Updating Unions | |
| |
| |
| |
Updating Intersections and Differences | |
| |
| |
| |
Concluding Remarks. Updating Joins And Other Views Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
Preliminaries | |
| |
| |
| |
The Supplier-and-Parts Database | |
| |
| |
| |
Updating Restrictions | |
| |
| |
| |
Updating Projections | |
| |
| |
| |
Updating Extensions | |
| |
| |
| |
Updating Joins | |
| |
| |
| |
Concluding Remarks. The Extended Relational Model RM/T Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
An Overview of RM/T | |
| |
| |
| |
Database Design with RM/T | |
| |
| |
| |
Comparison with E/R Model | |
| |
| |
| |
Summary. The Third Manifesto Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
Back to the Future | |
| |
| |
| |
RM Prescriptions | |
| |
| |
| |
RM Proscriptions | |
| |
| |
| |
OOPrescriptions | |
| |
| |
| |
OO Proscriptions | |
| |
| |
| |
Very Strong Suggestions | |
| |
| |
| |
OO Very Strong Suggestions | |
| |
| |
| |
Summary. Much Ado About Nothing | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
Codd's Commentary | |
| |
| |
| |
Date's Rebuttal I | |
| |
| |
| |
Date's Rebuttal II | |
| |
| |
| |
Date's Rebuttal III | |
| |
| |
| |
Date's Rebuttal IV | |
| |
| |
| |
Rebutting the Rebuttals. A Note On The Logical Operators Of SQL | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
Some Further Preliminaries | |
| |
| |
| |
Monadic Operators Supported "Directly" | |
| |
| |
| |
Monadic Operators Supported "Indirectly" | |
| |
| |
| |
Dynadic Operators | |
| |
| |
| |
Dynadic Operators Revisted | |
| |
| |
| |
Concluding Remarks | |
| |
| |
| |
Relational Vs. Nonrelational Systems | |
| |
| |
Essentiality | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
A Hierarchic Database | |
| |
| |
| |
Querying the Hierarchic Database | |
| |
| |
| |
Relational vs. Nonrelational Databases | |
| |
| |
| |
Essential vs. Inessential Ordering | |
| |
| |
| |
Concluding Remarks. An Inverted List System: Datacom/DB | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Background | |
| |
| |
| |
The Inverted List Model | |
| |
| |
| |
An Overview of DATACOM/DB | |
| |
| |
| |
Data Definition | |
| |
| |
| |
Data Manipulation | |
| |
| |
| |
The Compound Boolean Selection Feature. A Hierarchic System: IMS | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Background | |
| |
| |
| |
The Network Model | |
| |
| |
| |
An Overview of IDMS | |
| |
| |
| |
Data Definition | |
| |
| |
| |
Data Manipulation | |
| |
| |
| |
Storage Structure | |
| |
| |
| |
Logical Databases | |
| |
| |
| |
Secondary Indexes | |
| |
| |
| |
Concluding Remarks. A Network System: IDMS | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Background | |
| |
| |
| |
The Network Model | |
| |
| |
| |
An Overview of IDMS | |
| |
| |
| |
Data Definition | |
| |
| |
| |
Data Manipulation | |
| |
| |
| |
Storage Structure | |
| |
| |
| |
The Logical Record Facility | |
| |
| |
| |
The Automatic System Facility | |
| |
| |
| |
Concluding Remarks. Frontend Subsystems | |
| |
| |
| |
Abstract | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Introduction | |
| |
| |
| |
Data Access | |
| |
| |
| |
Data Presentation | |
| |
| |
| |
Application Generation. Afterword | |
| |
| |
| |
Comments on Republication | |
| |
| |
| |
Relational vs. OO Systems | |
| |
| |
| |
Mapping Object Classes to the Relational Model | |
| |
| |
| |
Tables within Tables | |
| |
| |
| |
Views and Object Classes | |
| |
| |
| |
Encapsulation | |
| |
| |
| |
Inheritance and Type Hierarchies | |
| |
| |
| |
Database Design | |
| |
| |
| |
Business Rules | |
| |
| |
| |
OO Systems | |
| |
| |
| |
Further Developments in Data Management | |