Skip Navigation

The Computer Journal 1990 33(1):11-18; doi:10.1093/comjnl/33.1.11
© 1990 by British Computer Society
This Article
Right arrow Full Text (PDF)
Right arrow Alert me when this article is cited
Right arrow Alert me if a correction is posted
Services
Right arrow Email this article to a friend
Right arrow Similar articles in this journal
Right arrow Similar articles in ISI Web of Science
Right arrow Alert me to new issues of the journal
Right arrow Add to My Personal Archive
Right arrow Download to citation manager
Right arrow Search for citing articles in:
ISI Web of Science (23)
Right arrowRequest Permissions
Google Scholar
Right arrow Articles by Sarda, N. L.
Right arrow Search for Related Content
Social Bookmarking
Add to CiteULike   Add to Connotea   Add to Del.icio.us  
What's this?

Algebra and Query Language for A Historical Data Model

N. L. Sarda *

Department of Computer Science & Engineering, Indian Institute of Technology, Bombay 400076, India

A ‘cubic’ view of database with representation by time-stamping of tuples has been largely favoured so far in the research on modelling of time in database systems. In this paper, we propose a ‘state’ oriented view of historical databases. The salient features of our proposal are its simplicity, closeness to the consistency with classical relational model, and efficient implementability. We propose an algebra for historical which contains classical as well as some new operators. The operators are simple to comprehend, unlike in other research proposals. We are also able to formulate a completeness criteria for the proposed model. Finally, we extend the popular SQL query language for use with historical databases. Again, the extensions are consistent with the simple basis of standard SQL. They are minimal in number, yet very powerful and expressive. We illustrate algebra operators and extended SQL with many examples.


* Current address: Department of Computer Science & Engineering, Indian Institute of Technology, Bombay 400076, India

§ Department of Computer Science & Engineering, Indian Institute of Technology, Bombay 400076, India


Add to CiteULike CiteULike   Add to Connotea Connotea   Add to Del.icio.us Del.icio.us    What's this?




Disclaimer:
Please note that abstracts for content published before 1996 were created through digital scanning and may therefore not exactly replicate the text of the original print issues. All efforts have been made to ensure accuracy, but the Publisher will not be held responsible for any remaining inaccuracies. If you require any further clarification, please contact our Customer Services Department.