Patent ID: 9703810
Date: 2017-07-11
CPC Classifications: G06F

Claim:
1. A method for managing a relational database, comprising the steps of: a computer, setting 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, wherein the foreign key lookup value when set to a value other than the unavailable state refers to a location of the referenced row of the primary key value in the separate destination table; and the computer, responsive to looking up, for the foreign key value, in a data structure separate from the source table, the 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, wherein the computer, responsive to looking UP, for the foreign key value, in a data structure separate from the source table, the 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, further comprises: the computer, accessing the data structure separate from the source table comprising an index for the separate destination table, wherein the index comprises each separate primary key value in the separate destination table indexed to each separate location of each separate row referenced by each separate primary key value; and the computer, searching the index with the foreign key value to identify a particular location in the index indexed to the primary key value matching the foreign key value, wherein the index is created based on traffic levels across one or more sharing databases in a peer-to-peer network.