This is a blog describing some thoughts about issues related to event processing and thoughts related to my current role. It is written by Opher Etzion and reflects the author's own opinions
Showing posts with label SQL:2011. Show all posts
Showing posts with label SQL:2011. Show all posts
Sunday, April 15, 2012
On temporal extension to SQL:2011
I have written before about the recent return to the bi-temporal databases, in conjunction with DB2. In the 1990-ies was the first attempt to create bi-temporal extensions to SQL, at that time there was a language war, some of it is reflected in the book that I have co-edited, published in 1998. Now after some attempts, SQL:2011 does include support in bi-temporal databases. The terminology was changed from the original terms. What was called in the original version - "valid time" is called in the SQL version "application time', an what was called in the original version - "transaction time" is called in the SQL version "system time".
More details about the SQL extension can be found in the overview presentation that Craig Baumunk uploaded to slideshare. As I have written before, temporal database is vital for maintaining historical events, and thus the importance of this standard, and the supporting databases to event processing application is noticable
Subscribe to:
Posts (Atom)