| |
| |
| |
| 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 | |