Patent ID: 7734618

Claim:
A method for creating an independent index associated with a database including data, said independent index being separate from the database and being created without user interaction, said method comprising: (a) receiving a query to the database, said database having independent indexes separate from the database and associated with the database, wherein the received query includes metadata related to the database data; (b) in response to the received query, formulating a query index for the database without user interaction, wherein the formulated query index is a function of the received query; (c) in response to the received metadata, identifying a subset of the database data based on received metadata without user interaction; (d) in response to the formulated query index, searching the independent indexes associated with the database for an independent index that matches the formulated query index without user interaction; (e) in the event that an independent index associated with the database that matches the formulated query index is not found: (i) saving the formulated query index and the identified subset of the database data without user interaction; (ii) executing the query without the formulated query index without user interaction; and (iii) creating an independent index associated with the database without user interaction from the saved formulated query index, wherein creating the independent index occurs independent from executing the query, and wherein the created independent index for the database is populated with the identified subset of the database data; (f) in the event that an independent index associated with the database that matches the formulated query index is found, updating the independent index without user interaction if the independent index is not current and executing the received query with the updated independent index without user interaction; (g) in the event that an independent index associated with the database is not accessed within a certain period of time, deleting the independent index associated with the database without user interaction.