| Description |
1 online resource (1 volume) : illustrations |
| Series |
The Morgan Kaufmann Series in Data Management Systems |
|
Morgan Kaufmann series in data management systems.
|
| Bibliography |
Includes bibliographical references and index. |
| Summary |
Annotation 'Time and Relational Theory' provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. |
| Contents |
Front Cover; Time and Relational Theory; Copyright; Dedication; About the Authors; Contents; Preface; Part I: A Review of Relational Concepts; Chapter 1: Types and Relations; The Running Example; Types; Relations; Exercises; Answers; Chapter 2: Relational Algebra; Rename; Restrict; Project; Union, Intersect, and Minus; Join; Matching and Not Matching; Extend; Image Relations; Group and Ungroup; Extend bis; Relational Comparisons; Formulating Expressions One Step at a Time; Relational Completeness; Exercises; Answers; Chapter 3: Relation Variables; Relations vs. Relvars; Relational Assignment. |
|
KeysForeign Keys; Database Constraints; Views; The Relational Model; Exercises; Answers; Part II: Laying the Foundations; Chapter 4: Time and the Database; Temporal Databases; Timestamped Propositions; Valid Time vs. Transaction Time; Some Fundamental Questions; Exercises; Answers; Chapter 5: What's the Problem?; Revising the Running Example; Sample Constraints and Queries; Semitemporalizing the Example; Fully Temporalizing the Example; Exercises; Answers; Chapter 6: Intervals; What's an Interval?; Applications of Intervals; Point and Interval Types; A More Searching Example; Exercises. |
|
AnswersChapter 7: Interval Operators; Notation; Interval Comparisons; "Set Operators"; Queries; Concluding Remarks; Exercises; Answers; Chapter 8: The EXPAND and COLLAPSE Operators; Preliminary Remarks; Expanded Form; Collapsed Form; Operator Definitions; Unary Relations; Nullary Relations; Exercises; Answers; Chapter 9: The PACK and UNPACK Operators I: The Single-Attribute Case; Preliminary Examples; Packed Form; Unpacked Form; Further Queries; Exercises; Answers; Chapter 10: The PACK and UNPACK Operators II: The Multiattribute Case; PACKING and UNPACKING ON no Attributes. |
|
UNPACKING ON Two or More AttributesPACKING ON Two or More Attributes; A Logical Difference; Equivalence of Relations; Expand and Collapse Revisited; Some Remarks On Redundancy; A More Complex Example; Exercises; Answers; Chapter 11: Generalizing the Algebraic Operators; A Motivating Example; Dyadic Operators; n-Adic Operators; Monadic Operators; Relational Comparisons; The Underlying Intuition; The Regular Operators Revisited; Exercises; Answers; Part III: Building on the Foundations; Chapter 12: Database Design I: Structure; The Running Example Revisited; Since Relvars Only. |
|
During Relvars OnlyA New Normal Form; "The Moving Point now"; Both Since and During Relvars; Concluding Remarks; Exercises; Answers; 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; The Nine Requirements. |
| Subject |
Database management.
|
|
Temporal databases.
|
|
Bases de données -- Gestion. |
|
Bases de données spatio-temporelles. |
|
Database management |
|
Temporal databases |
| Added Author |
Darwen, Hugh.
|
|
Lorentzos, Nikos A.
|
| Other Form: |
Print version: Date, C.J. Time and relational theory 0128006315 (OCoLC)879582386 |
| ISBN |
9780128006757 |
|
0128006757 |
|
0128006315 |
|
9780128006313 |
|
More Resources