Books & Videos

Table of Contents

  1. Chapter 1 A Motivating Example

    1. The Principle of Interchangeability

    2. Base Tables Only: Constraints

    3. Base Tables Only: Compensatory Actions

    4. Views: Constraints and Compensatory Actions

    5. There’s No Magic

    6. Concluding Remarks

  2. Chapter 2 The Technical Context

    1. Relations and Relvars

    2. Relational Assignment

    3. Integrity Constraints

    4. Relvar Predicates

    5. Matching, not Matching, and Extend

    6. Databases and Dbvars

  3. Chapter 3 The View Concept: A Closer Look

    1. The View Update Problem

    2. Views are Pseudovariables

    3. Data Independence

    4. How Not to do it

    5. Constraints and Predicates

    6. Information Equivalence

    7. Concluding Remarks

  4. Chapter 4 Restriction Views

    1. The Motivating Example Revisited

    2. More on Compensatory Actions

    3. What About Triggers?

    4. What About Explicit Update Operations?

    5. Suppliers and Shipments

    6. The Motivating Example Continued

    7. Putting it All Together

    8. The Point at Last

    9. Overlapping Restrictions

    10. Concluding Remarks

  5. Chapter 5 Projection Views

    1. Example 1: A Nonloss Decomposition

    2. Example 1 Continued: The Projection Relvars

    3. Example 1 Continued: Views

    4. Example 2: Another Nonloss Decomposition

    5. Example 3: A Lossy Decomposition

    6. Concluding Remarks

  6. Chapter 6 Join Views I: One to One Joins

    1. Example 1: Information Equivalence

    2. Example 2: Information Hiding

    3. Concluding Remarks

  7. Chapter 7 Join Views II: Many to Many Joins

    1. Example 1: Information Equivalence

    2. Projection Views Revisited

    3. Example 2: Information Hiding

    4. Concluding Remarks

  8. Chapter 8 Join Views III: One to Many Joins

    1. Example 1: Information Equivalence

    2. Example 2: Information Hiding

    3. Concluding Remarks

  9. Chapter 9 Intersection Views

    1. Example 1: Explicit Overlap

    2. Example 2: Implicit Overlap

    3. Concluding Remarks

  10. Chapter 10 Union Views

    1. Example 1: Disjoint Union

    2. Example 2: Explicit Overlap

    3. Example 3: Implicit Overlap

    4. Concluding Remarks

  11. Chapter 11 Difference Views

    1. Example 1: Implicit Overlap

    2. Example 2: Explicit Overlap

    3. Concluding Remarks

  12. Chapter 12 Group and Ungroup Views

    1. The Group and Ungroup Operators

    2. A Group / Ungroup Example

    3. A Summarize Example

  13. Chapter 13 Extension and Summarization Views

    1. An Extend Example

    2. Another Summarize Example

  14. Chapter 14 Updating through Expressions

    1. Semantics not Syntax (?)

    2. Some well known Tautologies

    3. “Semantic Transformations”

    4. Information Equivalence Revisited

    5. Concluding Remarks

  15. Chapter 15 Ambiguity Revisited

    1. Predicates and Constraints Revisited

    2. An Intersection Example

    3. Union and Difference Examples

    4. More on Predicates

    5. Concluding Remarks

  1. Appendix Some Remarks on Relational Assignment

  2. Appendix Relational Operators