PEER TO PEER (P2P) FEDERATED CONCEPT QUERIES

• US 20080250006A1
• Filed: 06/25/2008
• Published: 10/09/2008
• Est. Priority Date: 02/26/2002
• Status: Active Grant

• Current Assignee: Workday Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Kulack, Frederick A.
• Granted Patent: US 9,043,365 B2
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/903 Querying for retrieval from the web G06F16/953

Abstract

Embodiments of the invention are generally related to data processing, and more specifically to retrieving results for a query from one or more devices coupled to a network. A first device may receive an abstract query including logical fields defined by a first data abstraction model and retrieve query results stored in the first device. The query may be sent to one or more other devices via the network. The one or more other devices may be configured to convert the abstract query to local abstract queries including logical fields defined in local data abstraction models. The local queries may be issued against local databases to retrieve additional results for the query.

Claims

1. A computer-implemented method for retrieving query results comprising:

receiving, from a requesting entity, a first abstract query comprising one or more logical fields defined by a first data abstraction model comprising a plurality of first logical field definitions mapped to physical fields of a first database in a first device, wherein one or more of the first logical fields definitions associate respective first logical fields to respective concepts of a predefined set of concepts, the concepts being standardized metadata;

converting the abstract query to a second abstract query comprising one or more logical fields defined by a second data abstraction model, the conversion comprising, for each logical field of the first abstract query, determining a corresponding logical field in the second data abstraction model, the corresponding logical field being associated with a same concept as the logical field of the first abstract query, wherein the second data abstraction model comprises a plurality of second logical field definitions mapping the second logical fields to physical fields of a second database in a second device, wherein one or more of the second logical fields definitions associate respective second logical fields to respective concepts of the predefined set of concepts;

issuing the second abstract query against the second database to retrieve results for the second abstract query; and

providing the results of the second abstract query to the requesting entity.

2. The method of claim 1, further comprising, transferring the first abstract query to at least one third device.

3. The method of claim 2, further comprising, receiving results for the first abstract query from the third device and transferring the results received from the third device to the first device.

4. The method of claim 1, wherein the network is a peer-to-peer network.

5. The method of claim 1, wherein the requesting entity is a client computer.

6. The method of claim 1, wherein the requesting entity is an application.

7. The method of claim 1, wherein the first device and second device are servers.

8. A computer readable medium containing a program which, when executed, performs an operation, comprising:

receiving, from a requesting entity, a first abstract query comprising one or more logical fields defined by a first data abstraction model comprising a plurality of first logical field definitions mapped to physical fields of a first database in a first device, wherein one or more of the first logical fields definitions associate respective first logical fields to respective concepts of a predefined set of concepts, the concepts being standardized metadata;

converting the abstract query to a second abstract query comprising one or more logical fields defined by a second data abstraction model, the conversion comprising, for each logical field of the first abstract query, determining a corresponding logical field in the second data abstraction model, the corresponding logical field being associated with a same concept as the logical field of the first abstract query, wherein the second data abstraction model comprises a plurality of second logical field definitions mapping the second logical fields to physical fields of a second database in a second device, wherein one or more of the second logical fields definitions associate respective second logical fields to respective concepts of the predefined set of concepts;

issuing the second abstract query against the second database to retrieve results for the second abstract query; and

providing the results of the second abstract query to the requesting entity.

9. The computer readable medium of claim 8, wherein the operation further comprises transferring the first abstract query to at least one third device.

10. The computer readable medium of claim 9, wherein the operation further comprises receiving results for the first abstract query from the third device and transferring the results received from the third device to the first device.

11. The computer readable medium of claim 8, wherein the network is a peer-to-peer network.

12. The computer readable medium of claim 8, wherein the requesting entity is one of a client computer and an application.

13. The computer readable medium of claim 8, wherein the first device and second device are servers.

14. A system, comprising a plurality of devices coupled via a network, wherein each device is configured to:

receive, from a requesting entity, a first abstract query comprising one or more logical fields defined by a first data abstraction model comprising a plurality of first logical field definitions mapped to physical fields of a first database in a first device, wherein one or more of the first logical fields definitions associate respective first logical fields to respective concepts of a predefined set of concepts, the concepts being standardized metadata;

convert the abstract query to a second abstract query comprising one or more logical fields defined by a second data abstraction model, the conversion comprising, for each logical field of the first abstract query, determining a corresponding logical field in the second data abstraction model, the corresponding logical field being associated with a same concept as the logical field of the first abstract query, wherein the second data abstraction model comprises a plurality of second logical field definitions mapping the second logical fields to physical fields of a second database in a second device, wherein one or more of the second logical fields definitions associate respective second logical fields to respective concepts of the predefined set of concepts;

issue the second abstract query against the second database to retrieve results for the second abstract query; and

provide the results of the second abstract query to the requesting entity.

15. The system of claim 14, wherein each device is further configured to transfer the first abstract query to at least one third device.

16. The system of claim 15, wherein each device is further configured to receive results for the first abstract query from the third device and transfer the results received from the third device to the first device.

17. The system of claim 14, wherein the network is a peer-to-peer network.

18. The system of claim 14, wherein the requesting entity is a client computer.

19. The system of claim 14, wherein the first device and second device are servers.

20. The system of claim 14, wherein the requesting entity is an application.