Time and relational theory : temporal databases in the relational model and SQL / C. J. Date, Hugh Darwen, Nikos A. Lorentozos.

Format:

Book

Author/Creator:

Date, C. J., author.

Darwen, Hugh, author.

Lorentzos, Nikos, author.

Series:

The Morgan Kaufmann Series in Data Management Systems

Language:

English

Subjects (All):

Database management.

Temporal databases.

Physical Description:

1 online resource (579 p.)

Edition:

2nd ed.

Place of Publication:

Waltham, Massachusetts : Morgan Kaufmann, 2014.

Language Note:

English

System Details:

text file

Summary:

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. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: Cheap storage enables retention of large volumes of historical data in data warehousesUsers are now faced with temporal data problems, and need solutions Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal su

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

Since Relvars Only

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

Description based on online resource; title from PDF title page (ebrary, viewed September 1, 2014).

ISBN:

9780128006757

0128006757

OCLC:

889675736