Patent ID: 8463781
Filing Date: 2013-06-11
Classification: G06F

Abstract:
1. A method for pre-fetching, from a database having a plurality of database records, each of which has a first field and a plurality of other fields, all those database records that have a specified value stored in said first field, said method comprising: providing a database index having a plurality of index records, each index record corresponding to an allowed value, wherein each index record includes index-record-identification keys that identify all database records that have a particular allowed value stored in said first field; identifying, within said database index, an index record in which said particular allowed value corresponding to said index record is the same as said specified value; retrieving, from said index record, database-record-identification keys that provide information identifying those database records in which said first field stores a value that is the same as said specified value; on the basis of said information provided by said database-record-identification keys retrieved from said index record, pre-fetching, from said database, database records in which said first field stores a value that is the same as said specified value; and wherein identifying an index record comprises executing a database application having an instruction that, when executed, causes said database application to report access to said index record.