Method and apparatus for implementing dynamic database traversal
AssigneeMcKesson Financial Holdings
InventorMarion Hoffman
Life of this patent
Estimating the term…
Abstract
A method, apparatus and computer program product are therefore provided for implementing requests for data using independent data objects. In this regard, the method, apparatus and computer program may receive a request for set of data. The request may include an identifier for the particular set of data. The method may further determine a structure of the set of data using an attribute table associated with one or more data objects, and generate a query using the determined structure of the set of data. The generated query may be executed to retrieve a set of data responsive to the request. The retrieved data may be used along with the determined structure to provide a response to the request.
Claims20
A method comprising:
- receiving a request for a set of data stored in a relational database;
- determining a first entry in at least one attribute table associated with the set of data;
- determining, using a processor, three or more attributes for the set of data using the entry, the three or more attributes providing at least a portion of a query for obtaining the set of data, wherein each attribute identifies at least one data object to be joined by the query to obtain the set of data, wherein a first attribute of the three or more attributes indicates a first data object, a second attribute of the three or more attributes indicates a second data object, and a third attribute of the three or more attributes indicates a third data object, wherein the first data object is not dependent upon any data objects, wherein the second data object references the first data object but does not depend on the first data object, and wherein the third data object references the first data object and depends on the first data object;
- generating the query using the one or more attributes;
- and
- executing the query to retrieve data responsive to the request.
An apparatus comprising at least one processor and a memory, the memory comprising instructions that, when executed by the processor, configure the apparatus to:
- receive a request for a set of data stored in a relational database;
- determine a first entry in at least one attribute table associated with the set of data;
- determine three or more attributes for the set of data using the entry, the three or more attributes providing at least a portion of a query for obtaining the set of data, wherein each attribute identifies at least one data object to be joined by the query to obtain the set of data, wherein a first attribute of the three or more attributes indicates a first data object, a second attribute of the three or more attributes indicates a second data object, and a third attribute of the three or more attributes indicates a third data object, wherein the first data object is not dependent upon any data objects, wherein the second data object references the first data object but does not depend upon the first data object, and wherein the third data object references the first data object and depends upon the first data object;
- generate the query using the one or more attributes;
- and
- execute the query to retrieve data responsive to the request.
A non-transitory computer readable storage medium comprising instructions that, when executed by a processor, cause the processor to configure an apparatus to:
- receive a request for a set of data stored in a relational database;
- determine a first entry in at least one attribute table associated with the set of data;
- determine three or more attributes for the set of data using the entry, the three or more attributes providing at least a portion of a query for obtaining the set of data, wherein each attribute identifies at least one data object to be joined by the query to obtain the set of data, wherein a first attribute of the three or more attributes indicates a first data object, a second attribute of the three or more attributes indicates a second data object, and a third attribute of the three or more attributes indicates a third data object, wherein the first data object is not dependent upon any data objects, wherein the second data object references the first data object but does not depend upon the first data object, and wherein the third data object references the first data object and depends upon the first data object;
- generate the query using the one or more attributes;
- and
- execute the query to retrieve data responsive to the request.
Dependencies are inferred from the claim text.