Systems and methods for avoiding database anomalies when maintaining constraints and indexes in presence of snapshot isolation
US7653665B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 13, 2004 |
| Grant date | Jan 26, 2010 |
| Priority date | — |
| Expiry date | Jul 2, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2365
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method avoids anomalies in presence of data manipulation language (DML) plans maintaining dependent objects and snapshot isolation. An anomaly due to using a snapshot isolation level within the transaction is detected within a database transaction and the transaction is aborted based upon that detection. Involved in making the anomaly detection is determining whether a view of particular data accessed during the transaction under a snapshot isolation view to ensure read consistency differs from a view of the data under another isolation level, such as the read committed isolation level. Then a detection is made that an anomaly may occur if it is determined that the view of the data accessed during the transaction under the snapshot isolation differs from the view of the data under the other isolation level. Such anomaly avoidance prevents an indexed view being maintained nor a referential integrity constraint validated based on incorrect data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.