DESIGN OF AN INFORMATION SYSTEM USING A HISTORICAL DATABASE MANAGEMENT SYSTEM
Generate an AI Snapshot to get a quick, structured summary of this paper.
A concise AI-generated summary of the paper will appear here once you click Generate AI Snapshot.
TL;DR
The salient features of the approach include schema design with only "current state" perspective, same schema for accessing current and history data, efficient storage structures for history data, and simple extensions to the popular query language SQL.
Abstract
A historical database management system (HDBMS) provides facilities for modelling of time and storage and retrieval of history data (i.e., past status). Past research on HDBMS has considered various but individual aspects of the problem and suggested many alternatives. In this paper, we first outline our approach, identifying facilities that are both adequate and practical, and then consider design of a realistic application using those facilities. The application design consists of design of the database schema, storage structures and processing tasks (both query and database maintenance types). The salient features of our approach include schema design with only "current state" perspective, same schema for accessing current and history data, efficient storage structures for history data, and simple extensions to the popular query language SQL.