Record Details

Extensions to SQL for historical databases

DSpace at IIT Bombay

View Archive Info
 
 
Field Value
 
Title Extensions to SQL for historical databases
 
Creator SARDA, NL
 
Subject data models
database management systems
mathematical techniques
algebra
 
Description A historical management system (HDBMS) is described which uses an extended relational data model with state-oriented, instead of `cubic', conceptualization. Two types of historical relations, called state and event relations, are provided for modeling real-world objects. The query language SQL has been extended for definition, retrieval, and update of historical relations. The extended SQL, called HSQL, is a superset of SQL. The author defines a few primitive algebra operations for historical relations, and uses them as a basis for extensions to SQL. In this way, HSQL retains the elegant structural and algebraic framework of SQL. HSQL contains a few new clauses, many operations and built-in functions on time domain, and facilities for retrospective updates and time-rollback.
 
Publisher IEEE
 
Date 2009-05-08T02:34:23Z
2011-12-08T06:54:32Z
2011-12-26T13:01:51Z
2011-12-27T05:47:23Z
2009-05-08T02:34:23Z
2011-12-08T06:54:32Z
2011-12-26T13:01:51Z
2011-12-27T05:47:23Z
1990
 
Type Article
 
Identifier IEEE Transactions on Knowledge and Data Engineering 2(2), 220-230
1041-4347
10.1109/69.54721
http://hdl.handle.net/10054/1297
http://dspace.library.iitb.ac.in/xmlui/handle/10054/1297
 
Language en