Developing Time-Oriented Database Applications in SQL

“Developing Time-Oriented Database Applications in SQL” by Richard T. Snodgrass is available for free in pdf format from the author.

Book Description

It offers incisive advice on recording temporal data using SQL data types, defining appropriate integrity constraints, updating temporal tables, and querying temporal tables with interactive and embedded SQL. Also it provides case studies detailing real-world problems and solutions in areas such as event data, state-based data, partitioned data, and audit logs.

What is everywhere but occupies no space; can be measured but not seen or touched; can be spent, wasted, or killed, but not destroyed or changed? The simple answer is time, and the relationship between the fourth dimension and data is the foundation for Developing Time-Oriented Database Applications in SQL, a fascinating book by Richard T. Snodgrass.

Table of Contents

• Introduction
• Fundamental Concepts
• Instants and Intervals
• Periods
• Defining State Tables
• Querying State Tables
• Modifying State Tables
• Retaining a Tracking Log
• Transaction-Time State Tables
• Bitemporal Tables
• Temporal Database Design
• Language Directions
• Prospects

Download Free PDF / Read Online