Patent · US Active

System and method for an optimistic database access

US7774319B2 · kind B2 · utility

24Cited by

9References

30Claims

0Family size

Assignee

SAP AG · DE

Inventors

Rainer Schweigkoffer · Mannheim, DE
Guenther Drach · Bruchsal, DE
Tobias Wenner · Schallstadt, DE
Frank-Martin Haas · Wiesloch, DE
Torsten Ziegler · Dielheim, DE

Key dates

Filing date	Aug 11, 2004
Grant date	Aug 10, 2010
Priority date	—
Expiry date	Oct 30, 2026

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2329
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

In an embodiment, a database interface performs a three-step optimistic database access. The database interface initially performs an optimistic read of a database object. The database object is checked for consistency after the optimistic read. If the database object is inconsistent, a first pessimistic read is performed with an isolation level that does not guarantee consistency (e.g., with an isolation level of committed read). The database object is checked again for consistency after the first pessimistic read. If the database object is inconsistent, a second pessimistic read is performed with an isolation level that may guarantee consistency (e.g., with an isolation level of repeatable read).

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.