TY - JOUR
T1 - Immortal DB
T2 - SIGMOD 2005: ACM SIGMOD International Conference on Management of Data
AU - Lomet, David
AU - Barga, Roger
AU - Mokbel, Mohamed F.
AU - Shegalov, German
AU - Wang, Rui
AU - Zhu, Yunyue
PY - 2005
Y1 - 2005
N2 - Immortal DB builds transaction time database support into the SQL Server engine, not in middleware. Transaction time databases retain and provide access to prior states of a database, An update "inserts" a new record while preserving the old version, The system supports as of queries returning records current at the specified time. It also supports snapshot isolation concurrency control. Versions are stamped with the times of their updating transactions. The timestamp order agrees with transaction serialization order. Lazy timestamping propagates timestamps to all updates of a transaction after commit, All versions are kept in an integrated storage structure, with historical versions initially stored with current data. Time-splits of pages permit large histories to be maintained, and enable time based indexing. We demonstrate Immortal DB with a moving objects application that tracks cars in the Seattle area.
AB - Immortal DB builds transaction time database support into the SQL Server engine, not in middleware. Transaction time databases retain and provide access to prior states of a database, An update "inserts" a new record while preserving the old version, The system supports as of queries returning records current at the specified time. It also supports snapshot isolation concurrency control. Versions are stamped with the times of their updating transactions. The timestamp order agrees with transaction serialization order. Lazy timestamping propagates timestamps to all updates of a transaction after commit, All versions are kept in an integrated storage structure, with historical versions initially stored with current data. Time-splits of pages permit large histories to be maintained, and enable time based indexing. We demonstrate Immortal DB with a moving objects application that tracks cars in the Seattle area.
UR - http://www.scopus.com/inward/record.url?scp=29844433455&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=29844433455&partnerID=8YFLogxK
U2 - 10.1145/1066157.1066295
DO - 10.1145/1066157.1066295
M3 - Conference article
AN - SCOPUS:29844433455
SN - 0730-8078
SP - 939
EP - 941
JO - Proceedings of the ACM SIGMOD International Conference on Management of Data
JF - Proceedings of the ACM SIGMOD International Conference on Management of Data
Y2 - 14 June 2005 through 16 June 2005
ER -