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.

Download

Share

COinS