# US 2021/0240750 A1 · System and method for translating a software query in an automated integration process into natural language > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2021/0240750 A1 - Document ID: US20210240750A1 - Status: Published application - Kind: A1 - Application number: 16/778,998 - Filed: 2020-01-31 - Published: 2021-08-05 - Earliest claimed: 2020-01-31 - Assignees: Dell Products L.P. - Applicants: Dell Products, LP - Inventors: Daniel Schwartz; Michael J. Morton - Web page: https://patentgrep.com/patent/US20210240750A1 ## CPC - G06F 16/3329: Natural language query formulation - G06F 40/56: Natural language generation - G06F 16/168: {Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs (query results presentation G06F16/156)} - G06F 16/182: Distributed file systems - G06F 16/3322: {using system suggestions (G06F16/3325 takes precedence)} - G06F 40/205: Parsing - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract 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. ## Claims ### Claim 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. ### Claim 2 (depends on 1) 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. ### Claim 3 (depends on 1) 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. ### Claim 4 (depends on 3) 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. ### Claim 5 (depends on 3) The information handling system of claim 3, wherein the concatenated query object comprises a plurality of concatenated query objects separated by a slash. ### Claim 6 (depends on 3) 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. ### Claim 7 (depends on 1) 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. ### Claim 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. ### Claim 9 (depends on 8) 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. ### Claim 10 (depends on 8) 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. ### Claim 11 (depends on 10) 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. ### Claim 12 (depends on 10) The method of claim 10, wherein the concatenated query object comprises a plurality of concatenated query objects separated by a period. ### Claim 13 (depends on 10) The method of claim 10, wherein the concatenated query object comprises a plurality of concatenated query objects separated by an underscore. ### Claim 14 (depends on 8) 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. ### Claim 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. ### Claim 16 (depends on 15) 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. ### Claim 17 (depends on 16) The information handling system of claim 16, wherein the concatenated query object is separated from the concatenated query operator by a space. ### Claim 18 (depends on 16) The information handling system of claim 16, wherein the concatenated query object comprises a plurality of concatenated query objects separated by a dash. ### Claim 19 (depends on 16) 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. ### Claim 20 (depends on 15) 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.