Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

The plummeting cost of storage and the widespread adoption of data warehouse technology have led to an increasing interest in temporal databases. As a consequence, the ability to deal properly with the time dimension in databases has become an increasingly important practical problem. This video seminar describes and explains the theoretical ideal behind temporal databases in depth, and why it's 100% consistent with the classical relational model.

Subscriber Reviews

Average Rating: 3 out of 5 rating Based on 2 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

Preamble

Preview

00:10:13

Relational Model Part 1

Play Video

00:26:45

Relational Model Part 2

Preview

00:42:52

Relational Model Part 3

Preview

00:25:37

Time and the Database

Preview

00:28:14

What's the Problem

Preview

00:20:50

Intervals

Preview

00:19:01

Interval Operators

Preview

00:12:12

Set Operators

Preview

00:18:41

Pack and Unpack Part 1

Preview

00:09:38

Pack and Unpack Part 2

Preview

00:16:10

Pack and Unpack Part 3

Preview

00:14:59

Relational Operators

Preview

00:22:27

Database Design Part 1

Preview

00:18:10

Database Design Part 2

Preview

00:25:39

Integrity Constraints Part 1

Preview

00:31:15

Integrity Constraints Part 2

Preview

00:21:09

Queries

Preview

00:13:48

Updates Part 1

Preview

00:17:13

Updates Part 2

Preview

00:16:56

Stated Times and Logged Times

Preview

00:26:04

Point and Interval Types Revisited

Preview

00:27:25

Cyclic Point Types

Preview

00:10:33

SQL Features Part 1

Preview

00:28:13

SQL Features Part 2

Preview

00:25:57

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the errata page for Temporal Data and Relational Theory

  • Errata

Visit the catalog page for Temporal Data and Relational Theory

  • Catalog Page