HSQL(ID:6830/)

for historical SQL
Related languages
SQL 92 => HSQL   Extension of
References:
  • Sarda N. L. "Algebra and query language for a historical data model" view details
          in The Computer Journal 33(1) February 1990 view details
  • Sarda, N. L. "Extensions to SQL for Historical Databases" IEEE Transactions on Knowledge and Data Engineering 2(2) June 1990 pp220-230 view details Abstract: 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.


          in The Computer Journal 33(1) February 1990 view details
  • Johnson, R. G.; Lorentzos, N. A. and Sarda, N. L. Comments on "Extensions to SQL for Historical Databases" IEEE Transactions on Knowledge and Data Engineering 4(4) August 1992 view details Abstract: The commenters point out that the author of the above-titled paper failed to acknowledge their contemporary publications of almost identical results and the subsequent, comprehensive refinement of this work. The author replies that he did not have access to their publications. He indicates some differences between their work and his.

          in The Computer Journal 33(1) February 1990 view details
  • Sarda, N. HSQL: A Historical Query Language. In A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R. Snodgrass, editors, Temporal Databases: Theory, Design, and Implementation, Benjamin/Cummings Publishing Company, 1993, pages 110{138. view details
          in The Computer Journal 33(1) February 1990 view details