Patent · US Active

Managing overflow access records in a database

US9043294B2 · kind B2 · utility

6Cited by

6References

17Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Sebastian Nelke · Schenefeld, DE
Martin Oberhofer · Nagold, DE
Yannick Saillet · Stuttgart, DE
Jens Seifert · Schrobenhausen, DE
Knut Stolze · Jena, DE

Key dates

Filing date	Mar 2, 2012
Grant date	May 26, 2015
Priority date	—
Expiry date	Aug 24, 2033

Classification

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

Abstract

Overflow access records (OARs) are managed in a database system. An OAR is created in response to receiving an update command for a data record and to the updated data record generated by the update command not fitting onto the page in the table where the data record was stored. The OAR that is created includes an index counter that indicates a number of indexes associated with the table. When an OAR is accessed in response to a query command, an identifier of the accessed OAR is replaced in the index by an identifier of a data record pointed to by the OAR, and the index counter in the accessed OAR is changed by a predefined amount. When the index counter reaches a predefined value, the accessed OAR is removed from the table.

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