Invention Grant
- Patent Title: Managing record location lookup caching in a relational database
- Patent Title (中): 在关系数据库中管理记录位置查找缓存
-
Application No.: US13445144Application Date: 2012-04-12
-
Publication No.: US09251179B2Publication Date: 2016-02-02
- Inventor: Allan T. Chandler
- Applicant: Allan T. Chandler
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agent Parashos Kalaitzis; Amy J. Pattillo
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
In managing a relational database, a relational manager sets a foreign key lookup value to an unavailable state in a source table row containing each of a foreign key value and the foreign key lookup value in a source table in a relational database, wherein the foreign key value references a primary key value in a referenced row in a separate destination table in the relational database. The relational manager, responsive to looking up, for the foreign key value, in a data structure separate from the source table, a location of the referenced row in the relational database, when the foreign key lookup value is set to the unavailable state, updating the foreign key lookup value with the location, wherein the foreign key lookup value in the source table is looked up for identifying the location of the referenced row for subsequent retrievals of the referenced row for the foreign key value.
Public/Granted literature
- US20130275476A1 MANAGING RECORD LOCATION LOOKUP CACHING IN A RELATIONAL DATABASE Public/Granted day:2013-10-17
Information query