Web service discovery via data abstraction model and condition creation

• US 8,667,011 B2
• Filed: 04/30/2012
• Issued: 03/04/2014
• Est. Priority Date: 04/30/2010
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard D., Kulack, Frederick A., Paterson, Kevin G., Wenzel, Shannon E.
• Primary Examiner(s): Chbouki, Tarek
• Application Number:
  US13/460,736
• Publication Number:
  US 20120221598A1
• Time in Patent Office: 673 Days
• Field of Search: None
• US Class Current: 707/769
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques

Abstract

A method includes receiving a selection of a logical field of a data abstraction model. The method includes determining model entries (e.g., concepts) associated with the selected logical field and examining the data abstraction model to determine other model entries that are equal to the model entries associated with the selected logical field. For each equal model entry, the method includes determining web services to be used in performing a search, where the web services are determined by querying a discovery registry associated with the data abstraction model to discover one or more web services that are resolvable based on the selected logical field. A first discovered web service is executed with user supplied criteria provided via a user interface to obtain a list of values. A condition is created that limits acceptable values associated with the selected logical field based on the user supplied criteria.

Claims

1. A computer-implemented method of generating a database query, the method comprising:

receiving a selection of a first field, the first field associated with a data abstraction model of a database;

identifying a second field that has a logical relationship with the first field;

examining the data abstraction model to identify a third field that is logically equivalent to the second field;

determining a web service that is executable to generate output results corresponding to the third field, wherein the web service is determined based at least in part on a stored association in a discovery registry between the web service and the third field;

receiving user supplied search criteria associated with the first field;

initiating execution of the web service to obtain a list of output results; and

generating the database query based on the user supplied search criteria associated with the first field and the list of output results obtained from the web service.

2. The computer-implemented method of claim 1, wherein the web service examines real-time data associated with a healthcare facility.

3. The computer-implemented method of claim 2, wherein the web service determines that a particular doctor is within the healthcare facility based on badge information.

4. The computer-implemented method of claim 2, wherein the web service determines that a particular doctor is within the healthcare facility based on schedule information.

5. The computer-implemented method of claim 1, wherein the web service is selected by a user from a plurality of web services, each of the plurality of web services having a corresponding stored association in the discovery registry with the third field.

6. The computer-implemented method of claim 5, further comprising:

receiving a selection of a second web service of the plurality of web services from the user; and

initiating execution of the second web service to obtain a second list of output results, wherein the database query is generated further based on the second list of output results.

7. The computer-implemented method of claim 1, further comprising executing the database query.

8. The computer-implemented method of claim 1, wherein the second field corresponds to a date concept.

9. The computer-implemented method of claim 1, wherein the second field corresponds to a doctor concept.

10. The computer-implemented method of claim 9, wherein the third field corresponds to an employee identifier concept.

11. The computer-implemented method of claim 9, wherein the third field corresponds to a doctor identifier concept.

19. The computer-implemented method of claim 1, wherein the first field corresponds to a hemoglobin test concept.

12. A system, comprising:

a processor;

a computer readable storage medium comprising instructions stored therein, that when executed by the processor, cause the processor to;

receive a selection of a first field, the first field associated with a data abstraction model of a database;

identify a second field that has a logical relationship with the first field;

examine the data abstraction model to identify a third field that is logically equivalent to the second field;

determine a web service that is executable to generate output results corresponding to the third field, wherein the web service is determined based at least in part on a stored association in a discovery registry between the web service and the third field;

receive user supplied search criteria associated with the first field;

initiate execution of the web service to obtain a list of output results; and

generate a database query based on the user supplied search criteria associated with the first field and the list of output results obtained from the web service.

13. The system of claim 12, wherein the computer readable storage medium further comprises instructions stored therein, that when executed by the processor, cause the processor to execute the database query.

14. The system of claim 12, wherein the computer readable storage medium further comprises instructions stored therein, that when executed by the processor, cause the processor to initiate execution of a second web service to obtain a second list of output results, wherein the database query is generated further based on the second list of output results.

15. The system of claim 12, wherein the web service is selected by a user from a plurality of web services, each having an association with the first field stored in the discovery registry, and wherein a user interface is provided to the user dynamically.

16. A computer readable storage medium comprising instructions stored therein, that when executed by a processor, cause the processor to:

receive a selection of a first field, the first field associated with a data abstraction model of a database;

identify a second field that has a logical relationship with the first field;

examine the data abstraction model to identify a third field that is logically equivalent to the second field;

determine a web service that is executable to generate output results corresponding to the third field, wherein the web service is determined based at least in part on a stored association in a discovery registry between the web service and the third field;

receive user supplied search criteria associated with the first field;

initiate execution of the web service to obtain a first list of output results; and

generate a database query based on the user supplied search criteria associated with the first field and the list of output results obtained from the web service.

17. The computer readable storage medium of claim 16, wherein a user selects the web service from a plurality of web services, each web service of the plurality having an association with the third field stored in the discovery registry via a user interface that is provided to user dynamically.

18. The computer readable storage medium of claim 16, wherein the computer readable storage medium further comprises instructions stored therein, that when executed by the processor, cause the processor to initiate execution of a second web service to obtain a second list of output results, wherein the database query is generated further based on the second list of output results.