- Cover image
- Title page
- Copyright
- Dedication
- About the Authors
- Preface
- Part I: A Review of Relational Concepts
- Part II: Laying the Foundations
- Part II Laying the Foundations
- Chapter 4. Time and the Database
- Chapter 5. What’s the Problem?
- Chapter 6. Intervals
- Chapter 7. Interval Operators
- Chapter 8. The EXPAND and COLLAPSE Operators
- Chapter 9. The PACK and UNPACK Operators I: The Single-Attribute Case
- Chapter 10. The PACK and UNPACK Operators II: The Multiattribute Case
- Chapter 11. Generalizing the Algebraic Operators
- Part III: Building on the Foundations
- Part III Building on the Foundations
- Chapter 12. Database Design I: Structure
- Chapter 13. Database Design II : Keys and Related Constraints
- Simplifying the Running Example
- The Redundancy Problem
- The Circumlocution Problem
- PACKED ON
- The Contradiction Problem
- WHEN / THEN
- Combining Specifications
- PACKED ON without WHEN / THEN
- WHEN / THEN without PACKED ON
- Neither PACKED ON nor WHEN / THEN
- Keys Revisited
- Putting it all Tgether
- Exercises
- Answers
- Chapter 14. Database Design III : General Constraints
- Chapter 15. Queries
- Chapter 16. Updates
- Chapter 17. Logged Time and Stated Time
- Chapter 18. Point and Interval Types Revisited
- Part IV: SQL Support
- Appendixes
Time and Relational Theory
Temporal Databases in the Relational Model and SQL
Second Edition
C. J. Date
Hugh Darwen
Nikos A. Lorentzos
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.