Generating a knowledge base
A method to automatically generate a new knowledge base includes receiving a signal that defines content that is to be included in the new knowledge base. Tables within an existing database are searched to identify at least one candidate table that is associated with data that may be relevant to the defined content that is to be included in the new knowledge base. At least one candidate application programming interface (API) is determined for each candidate table. Combinations of the identified at least one candidate table and the determined at least one candidate API are assessed to select from those combinations a master table and a master API for the new knowledge base. The new knowledge base is accessible by more than one application program within an integrated system. A non-expert user may automatically generate a new knowledge base and associated API with a single mouse click.
1. A method for generating a new knowledge base, the method comprising:
receiving a signal that defines content to be included in the new knowledge base;
searching for tables within an existing database and identifying at least one candidate table that is associated with data that may be relevant to the defined content to be included in the new knowledge base;
determining at least one candidate application programming interface (API) for each candidate table;
scoring combinations of the identified at least one candidate table and the determined at least one candidate API;
generating a master table and a master API for the new knowledge base, the master table and master API being generated automatically and based upon scores of the scored combinations; and
generating the new knowledge base that is accessible by more than one application program within an integrated system.
2. The method of claim 1 , wherein the received signal is generated by an application program within the integrated system.
3. The method of claim 1 , wherein the new knowledge base is generated in response to the received signal.
4. The method of claim 1 , wherein searching for tables within an existing database and identifying at least one candidate table that is associated with data that may be relevant to content to be included in the new knowledge base comprises: applying one or more heuristic rules to determine a score for each table and selecting candidate tables from among tables that score above a threshold score.
5. The method of claim 4 , further comprising adapting the heuristic rules based on experience to optimize performance of subsequently generated new knowledge bases.
6. The method of claim 1 , wherein determining at least one candidate API for each candidate table comprises: assessing APIs and applying one or more heuristic rules to determine a score for each API and selecting candidate APIs from among APIs that score above a threshold score.
7. The method of claim 6 , further comprising adapting the heuristic rules based on experience to optimize performance of subsequently generated new knowledge bases.
8. The method of claim 1 , wherein determining at least one candidate application programming interface (API) for each candidate table comprises: selecting at least one existing API to be one of the candidate APIs.
9. The method of claim 1 , wherein determining at least one candidate application programming interface (API) for each candidate table comprises: generating code to create one of the candidate APIs.
10. The method of claim 1 , further comprising testing the new knowledge base to verify that the new knowledge base is accessible by more than one application program within the integrated system.
11. The method of claim 1 , wherein the method runs as a background process relative to the application program.
12. The method of claim 1 , further comprising generating the new knowledge base with a single click from within the application program.
13. The method of claim 1 , further comprising selecting an icon on a display to trigger the received signal.
14. The method of claim 1 , wherein the integrated system comprises an enterprise system.
15. A computer program product tangibly embodied in an information carrier and containing therein instructions that, when executed, cause a processor to:
receive a signal that defines content to be included in a new knowledge base that is to be generated;
search for tables within an existing database and identify at least one candidate table that is associated with data that may be relevant to the defined content to be included in the new knowledge base;
determine at least one candidate application programming interface (API) for each candidate table;
score combinations of the identified at least one candidate table and the determined at least one candidate API;
generate a master table and a master API for the new knowledge base, the master table and master API being generated automatically and based upon scores of the scored combinations; and
generate the new knowledge base that is accessible by more than one application program within an integrated system.