Method and system for performing table question-answering tasks while preserving data security

A computing system for performing a question-answering task relating to a table while preserving data security and privacy with respect to underlying data included in the table, the computing system comprising:

• a first processor residing on a first network;
• a second processor residing on a second network that is outside of the first network;
• a memory;
• and
• a communication interface coupled to each of the first processor and the memory,
• wherein the first processor is configured to:
• receive, from a user via the communication interface, a user query that relates to the table;
• generate, based on the user query, a prompt that includes a role, at least one instruction, schema, and a question,
• wherein the prompt is structured to guide a second processor residing outside of a first network to generate an executable code that is applicable to the table, and
• wherein the prompt dictates a format of a response to the prompt;
• transmit, via the communication interface to the second processor of the second network that is external to the first network, the prompt;
• receive, from the external processor via the communication interface, a first set of executable code that is applicable to the table, the first set of executable code having been generated by the external processor in response to the prompt;
• wherein the second processor generates the first set of executable code without knowledge of tabular content of the table for preserving data security and privacy with respect to the underlying data included in the table, and
• wherein the second processor specifies a sequence of commands for the generating of the first set of executable code in response to the prompt;
• evaluate the first set of executable code;
• in response to the evaluation, generate a follow-up prompt for modification of the first set of executable code;
• transmit, to the second processor, the follow-up prompt;
• modify, by the second processor, the first set of executable code based on the follow-up prompt;
• generate an answer to the user query by executing the modified first set of executable code;
• and
• transmit, to the user via the communication interface, the answer to the user query.

A non-transitory computer readable storage medium storing instructions for performing a question-answering task relating to a table while preserving data security and privacy with respect to underlying data included in the table, the storage medium comprising a first set of executable code which, when executed by a first processor residing on a first network, causes the first processor to:

• receive, from a user, a user query that relates to the table;
• generate, based on the user query, a prompt that includes a role, at least one instruction, schema, and a question,
• wherein the prompt is structured to guide a second processor residing on a second network that is outside of the first network to generate an executable code that is applicable to the table, and
• wherein the prompt dictates a format of a response to the prompt;
• transmit, to the second processor of the second network that is external to the first network, the prompt;
• receive, from the second processor, a second set of executable code that is applicable to the table, the second set of executable code having been generated by the second processor in response to the prompt,
• wherein the second processor generates the first set of executable code without knowledge of tabular content of the table for preserving data security and privacy with respect to the underlying data included in the table, and
• wherein the second processor specifies a sequence of commands for the generating of the first set of executable code in response to the prompt;
• evaluate the first set of executable code;
• in response to the evaluation, generate a follow-up prompt for modification of the first set of executable code;
• transmit, to the second processor, the follow-up prompt;
• modify, by the second processor, the first set of executable code based on the follow-up prompt;
• generate an answer to the user query by executing the modified first set of executable code;
• and
• transmit, to the user, the answer to the user query.