System and method for translating a software query in an automated integration process into natural language
A method of translating software queries into natural language may comprise receiving a user instruction to identify a data set through a database query defined by a received user-selected query object and user-selected query value in setting a portion of a currently modeled integration process, and to perform a user-selected action on the data set, and translating a suggested database query associated in memory with the user-selected query object to a natural language translation. The method may also comprise displaying the natural language translation of the suggested database query, receiving a user instruction to include the suggested database query in the currently modeled integration process, and automatically generating and transmitting to a remote location for later execution, code instructions for performing the user-selected action on data sets stored at the remote database meeting the selected, suggested database query.
1. An information handling system operating a system for translating software queries into natural language comprising:
a processor executing code instructions of an integration application management system to set a portion of a currently modeled integration process to identify a data set stored at a remote database through a database query and to perform a user-selected action on the data set;
a graphical user interface receiving a user-selected query object and user-selected query value defining parameters of the database query;
the processor retrieving a suggested database query drawn from previously executed database queries based on the received user selected query object;
the processor translating, via execution of code for a natural language generator system, the suggested database query associated with the user-selected query object to a natural language translation of the suggested database query;
the graphical user interface displaying the natural language translation of the suggested database query for selection by a user instruction to include the selected, suggested database query in the currently modeled integration process;
the processor automatically generating a connector code set of machine readable and executable code instructions for performing the user-selected action on data sets stored at the remote database meeting the selected, suggested database query and the user-selected query value; and
a network interface device transmitting the connector code set and a runtime engine for execution of the connector code set at a remote location in deployment of the currently modeled integration process.
2. The information handling system of claim 1 further comprising:
the graphical user interface presenting a natural language sentence describing performance of the user-selected action if a data set stored at the remote database meets the suggested database query; and
the graphical user interface receiving a user selection of the natural language sentence indicating the selected, suggested database query.
3. The information handling system of claim 1 , wherein the suggested database query comprises a concatenated query object and a concatenated query operator, further comprising:
the processor translating the suggested database query by parsing the suggested database query into one or more phrases that each comprise a concatenated query object and a concatenated query operator; and
the processor parsing the one or more phrases into a plurality of parsed clauses that each comprise a parsed query object and a natural language query operator.
4. The information handling system of claim 3 , wherein a first of the plurality of parsed clauses comprises a first parsed query object beginning with a capital letter, a second of the plurality of parsed clauses comprises a second parsed query object beginning with a capital letter, and one of the one or more phrases comprises a concatenation of the first parsed query object and the second parsed query object.
5. The information handling system of claim 3 , wherein the concatenated query object comprises a plurality of concatenated query objects separated by a slash.
6. The information handling system of claim 3 further comprising:
the processor determining a plurality of suggested database queries is selected and that each of the parsed query objects of the plurality of suggested database queries matches;
the processor generating a combined parsed query object clause by adding the conjunction “and” to the natural language query operators of the plurality of suggested database queries; and
wherein the combined clause forms the natural language translation of the multiple selected, suggested database queries.
7. The information handling system of claim 1 , wherein the suggested database query is identified as relevant to the database query of the currently modeled integration process based on crowd-sourced histories of previously executed integration processes involving the user-defined query object.
8. A method of translating software queries into natural language comprising:
setting, via a processor executing code instructions of an integration application management system, a portion of a currently modeled integration process to identify a data set stored at a remote database through a database query and to perform a user-selected action on the data set
receiving, via a graphical user interface, a user-selected query object and user-selected query value defining parameters of the database query;
retrieving a plurality of suggested database queries drawn from previously executed database queries based on the received user selected query object;
translating the plurality of suggested database queries associated in memory with the user-selected query object to a natural language translation of the plurality of suggested database queries for display via the graphical user interface;
receiving a user instruction selecting at least one suggested database query for inclusion in the currently modeled integration process;
automatically generating, via the processor, a connector code set of machine readable and executable code instructions for performing the user-selected action on data sets stored at the remote database meeting the selected, at least one suggested database query and the user-selected query value; and
transmitting the connector code set and a runtime engine for execution of the connector code set at a remote location via a network interface device upon deployment of the currently modeled integration process.
9. The method of claim 8 further comprising:
presenting a natural language sentence, via the graphical user interface, describing performance of the user-selected action on the user-selected query object if a data set stored at the remote database meets the selected, at least one suggested database query; and
receiving a user selection of the natural language sentence.
10. The method of claim 8 , wherein the previously executed, suggested database query comprises a concatenated query object and a concatenated query operator, further comprising:
translating the plurality of suggested database queries by parsing, via the processor, each suggested database query into one or more phrases that each comprise a concatenated query object and a concatenated query operator; and
parsing the one or more phrases into a plurality of parsed clauses that each comprise a parsed query object and a natural language query operator.
11. The method of claim 10 further comprising:
determining, via the processor, that more than one of the plurality of suggested database queries is selected and determining if plurality of parsed clauses for the parsed query object matches;
generating a combined clause by adding the natural language query operators separated by the conjunction “and” for the more than one of the plurality of selected, suggested database queries for a natural language translation of the more than one selected, suggested database queries.
12. The method of claim 10 , wherein the concatenated query object comprises a plurality of concatenated query objects separated by a period.
13. The method of claim 10 , wherein the concatenated query object comprises a plurality of concatenated query objects separated by an underscore.
14. The method of claim 8 , wherein the plurality of suggested database queries are identified as potentially relevant to the database query and retrieved based on crowd-sourced histories of previously executed integration processes involving the user-defined query object.
15. An information handling system operating a system for translating software queries into natural language comprising:
a processor executing code instructions of an integration application management system to set a portion of a currently modeled integration process to identify a data set stored at a remote database through a database query and to perform a user-selected action on the data set;
a graphical user interface receiving a user-selected query object and user-selected query value defining parameters of the database query;
the processor retrieving a plurality of suggested database queries identified as relevant to the database query of the currently modeled integration process based on crowd-sourced histories of previously executed integration processes involving the user-defined query object;
the processor translating, via execution of code for a natural language generator system, the plurality of suggested database queries associated with the user-selected query object to a natural language translation of the plurality of suggested database queries for display via the graphical user interface;
selection by a user instruction to include at least one suggested database query as a selected, suggest database query in the currently modeled integration process;
the processor automatically generating a connector code set of machine readable and executable code instructions for performing the user-selected action on data sets stored at the remote database meeting the selected, suggested database query and the user-selected query value; and
a network interface device transmitting the connector code set and a runtime engine for execution of the connector code set at a remote location in deployment of the currently modeled integration process.
16. The information handling system of claim 15 , wherein the suggested database queries comprise a concatenated query object and a concatenated query operator, further comprising:
the processor translating the plurality of suggested database queries by parsing the suggested database queries into one or more phrases that each comprise a concatenated query object and a concatenated query operator.
17. The information handling system of claim 16 , wherein the concatenated query object is separated from the concatenated query operator by a space.
18. The information handling system of claim 16 , wherein the concatenated query object comprises a plurality of concatenated query objects separated by a dash.
19. The information handling system of claim 16 , further comprising:
parsing the one or more phrases into one or more parsed clauses that each comprise a parsed query object and a natural language query operator, where the one or more parsed clauses form the natural language translation of the selected, suggested database query.
20. The information handling system of claim 15 , further comprising:
selection to include more than one suggested database query as selected, suggest database queries in the currently modeled integration process; and
translating, via execution of code for the natural language generator system, the more than one selected, suggested database queries associated with the user-selected query object to a combined natural language translation of the more than one selected, suggested database queries by matching parsed query objects for display via the graphical user interface.