发明名称 |
Halloween protection in a multi-version database system |
摘要 |
Mitigating problems related to the Halloween problem including where update operations potentially allow the record to be visited more than once during the operation. A method includes accessing an instance of a data store operation statement. The instance of the data store operation statement is executed causing an update or delete to an old version of data store record or creation of a data store record resulting in a new version of the data store record in the case of an update or creation of a data store record and a deleted version of the data store record in the case of a delete in the data store. The instance of the data store operation statement is correlated with the new version of the data store record or the deleted version of the data store record. |
申请公布号 |
US9547685(B2) |
申请公布日期 |
2017.01.17 |
申请号 |
US201514829325 |
申请日期 |
2015.08.18 |
申请人 |
Microsoft Technology Licensing, LLC |
发明人 |
Freedman Craig Steven;Cunningham Conor John |
分类号 |
G06F17/00;G06F7/00;G06F17/30 |
主分类号 |
G06F17/00 |
代理机构 |
|
代理人 |
Mehta Aneesh;Drakos Kate;Minhas Micky |
主权项 |
1. In a computing environment, a method of mitigating update errors including where update operations potentially allow a record to be visited more than once during an operation, the method comprising:
accessing an instance of a data store operation statement; executing the instance of the data store operation statement causing an update or delete to an old version of a data store record or creation of a data store record resulting in a new version of the data store record in the case of an update or creation of a data store record or a deleted version of the data store record in the case of a delete in a data store; and correlating the instance of the data store operation statement with the new version of the data store record or the deleted version of the data store record, wherein correlating the instance of the data store operation statement with the new version of the data store record prevents the instance of the data store operation statement from reading the new version of the data store record so as to prevent the instance of a data store operation statement from accessing its own changes while not preventing the instance of the data store operation statement from accessing a state of the data store as it existed before the data store operation statement started executing, wherein the state of the data store as it existed before the data store operation statement started executing comprises at least one or more of a record created or a record deleted by a previous data store operation statement. |
地址 |
Redmond WA US |