You are previewing Bitemporal Data.
O'Reilly logo
Bitemporal Data

Book Description

Bitemporal data is coming, and major database management systems are beginning to support it. You need to know what is going on "under the hood" and this book that will make you the expert on bitemporal data that every IT organization should have on its staff.

Table of Contents

  1. Cover image
  2. Title page
  3. Copyright
  4. Dedication
  5. Foreword
  6. Preface
    1. Perspectives on the Relational Paradigm of Data
    2. The Temporal SQL Standards: ISO 9075:2011 and TSQL2
    3. Audience
    4. A Companion Volume to <em xmlns="http://www.w3.org/1999/xhtml" xmlns:epub="http://www.idpf.org/2007/ops">Managing Time in Relational Databases</em>
    5. An Extensive Glossary
    6. A Note on Style
    7. Looking Forward
  7. Acknowledgments
  8. Chapter 1. Bitemporal Data: Preliminaries
    1. Nontemporal, Unitemporal and Bitemporal Data
    2. Semantics and its Implementations
    3. Glossary List
  9. Part 1: Theory
    1. Part 1. Theory
    2. Chapter 2. Time and Temporal Terminology
      1. Time
      2. Temporal Terminology
      3. Glossary List
    3. Chapter 3. The Relational Paradigm: Mathematics
      1. Tables and Columns
      2. Columns and Domains
      3. Cartesian Products
      4. Functions and Primary Keys
      5. Relations
      6. Glossary List
    4. Chapter 4. The Relational Paradigm: Logic
      1. Propositional Logic
      2. Predicate Logic
      3. Logic and the Relational Paradigm
      4. Glossary List
    5. Chapter 5. The Relational Paradigm: Ontology
      1. Types and Instances
      2. Instances and Identity
      3. The Relational Paradigm Ontology: Aristotelian Roots
      4. The Relational Paradigm Ontology
      5. On Using Ontologies
      6. Integrating the Mathematics and Ontology of the Relational Paradigm
      7. Glossary List
    6. Chapter 6. The Relational Paradigm: Semantics
      1. Rows, Statements, Assertions and Kindred Notions
      2. Rows, Inscriptions and Sentences
      3. Statements
      4. Speech Acts
      5. Glossary List
    7. Chapter 7. The Allen Relationships
      1. Why the Allen Relationships are Important
      2. A Taxonomy of the Allen Relationships
      3. A Binary Partitioning of the Allen Relationships Taxonomy
      4. An Allen Relationship Thought Experiment
      5. Glossary List
    8. Chapter 8. Temporal Integrity Concepts and Notations
      1. Cubes, Slices and Cells: Data in Three-Dimensional Temporal Space
      2. Semantically Anomalous Relational Tables
      3. Implicit Bitemporal Time
      4. Glossary List
    9. Chapter 9. Temporal Entity Integrity
      1. Entity Integrity
      2. Bitemporal Entity Integrity
      3. State-Time Entity Integrity
      4. Conventional Entity Integrity
      5. Glossary List
    10. Chapter 10. Temporal Referential Integrity
      1. Temporal Foreign Keys
      2. Episodes
      3. State-Time Referential Integrity
      4. Bitemporal Referential Integrity
      5. Conventional Referential Integrity
      6. Glossary List
  10. Part 2: Practice
    1. Part 2. Practice
    2. Chapter 11. Temporal Transactions
      1. An Overview of Temporal Transactions
      2. Basic Temporal Transactions on State-Time Tables
      3. Basic Temporal Transactions on Bitemporal Tables
      4. Whenever Temporal Transactions
      5. Temporal Merge Transactions
      6. Glossary List
    3. Chapter 12. Basic Temporal Queries
      1. Temporal Query Syntax
      2. Bitemporal Tables and Views
      3. Point-In-Time Range Queries
      4. Range Queries
      5. Glossary List
    4. Chapter 13. Advanced Temporal Queries
      1. A Basic Temporal Range Multi-Table Query
      2. A Complex Temporal Range Multi-Table Query
      3. Why Temporal Range Multi-Table Queries are Complex
      4. Glossary List
    5. Chapter 14. Future Assertion Time
      1. Future Assertion Time: Semantics
      2. Future Assertion Time: Implementation
      3. Glossary List
    6. Chapter 15. Temporal Requirements
      1. Updates and Corrections to Conventional Tables
      2. Timestamped Tables
      3. Double-Timestamped Tables
      4. Double-Timestamps and Corrections
      5. The Double-Timestamped Dilemma
      6. The Bitemporal Data Solution
      7. Glossary List
    7. Chapter 16. Bitemporal Data and the Inmon Data Warehouse
      1. A Brief History of the Data Warehouse
      2. What is an Inmon Data Warehouse?
      3. Why Unitemporal Tables Cannot Be Both Time-Variant and Nonvolatile
      4. The Enterprise Data Warehouse Redefined
      5. The Semantics of the EDW and the Question of its Physical Instantiation
      6. Glossary List
      7. Inmon Terms
    8. Chapter 17. Semantic Integration via Messaging
      1. The Objectives of an Enterprise Database
      2. Two Paths to Semantic Integration
      3. The Enterprise Data Model as a Canonical Message Model
      4. Glossary List
    9. Chapter 18. Bitemporal Data and the Kimball Data Warehouse
      1. Star Schemas and Relational Databases
      2. The Star Schema Data Warehouse Architecture
      3. The Star Schema Design Pattern
      4. Reconceptualizing Star Schemas: Fact Tables and Dimension Tables
      5. A Bitemporal Star Schema
      6. Bitemporal Dimensions Versus Slowly-Changing Dimensions
      7. Glossary List
      8. Kimball and Ross Terms
    10. Chapter 19. Time, Types and the Future of Relational Databases
      1. Tritemporal Data and Statement Provenance
      2. Ontologizing Relational Databases
      3. Atomic Statements and Binary Tables
      4. Looking Ahead
      5. Glossary List
    11. Chapter 20. Recommendations
      1. Recommendations for IT Professionals in End-User IT Organizations
      2. Recommendations for Standards Committees and Vendors
      3. Glossary List
  11. Afterword: Reflections on Mindfulness and Bitemporality
  12. Bibliography
    1. Philosophical Concepts
    2. The Computer Science Literature
  13. Index