Electronic device and method for database management

Abstract

An electronic device and method for database management are provided. The method includes: receiving a user request and a data form; enhancing the data form based on a knowledge base to generate an enhanced data form; generating a knowledge summary and a target script based on the user request and the enhanced data form; inferring the target script based on the knowledge summary from an initial script, thereby generating or updating the inferred script; and accessing a database based on the inferred script to output database information.

Claims

1. An electronic device for database management, comprising: transceiver; Storage media that stores multiple modules, knowledge bases, and databases; and a processor, coupled to the storage medium and the transceiver, and accessing and executing the plurality of modules, wherein the plurality of modules includes: a dialog interface for receiving user requests and data forms via the transceiver; A knowledge enhancement module enhances the data table based on the knowledge base to generate an enhanced data table; an intent determination module generates a knowledge summary and a target script based on the user request and the enhanced data table, wherein the intent determination module is a large language model; a reverse reasoning module infers the target script based on the knowledge summary and an initial script, thereby generating or updating the inferred script; and a forward data processing module accesses the database based on the inferred script to output database information through the transceiver.

2. The electronic device as claimed in claim 1, wherein the reverse inference module determines whether the data table includes all variables in the inference script; and in response to the data table including all variables in the inference script, the reverse inference module stops updating the inference script.

3. The electronic device as claimed in claim 2, wherein in response to the data table not including all variables of the inference script, the reverse inference module replaces the target script with the inference script and infers the target script based on the initial script to update the inference script.

4. The electronic device of claim 1, wherein the forward data processing module accesses instructions in the inference script and determines whether the instructions are valid; and in response to the valid instructions, the forward data processing module accesses the database according to the instructions to generate the database information.

5. The electronic device as claimed in claim 4, wherein in response to the instruction being invalid, the forward data processing module adjusts the configuration of the database or updates the instruction, and determines again whether the instruction is valid.

6. The electronic device as claimed in claim 4, wherein in response to the invalidation of the instruction, the forward data processing module outputs a warning message.

7. The electronic device of claim 1, wherein the knowledge augmentation module obtains multiple parameters from the data table and calculates statistical values ​​of the multiple parameters to enhance the data table.

8. The electronic device of claim 1, wherein the knowledge expansion module queries parameters from the knowledge base and adds the parameters to the data table to enhance the data table.

9. The electronic device as claimed in claim 1, wherein the inference script includes Structured Query Language instructions.

10. The electronic device as claimed in claim 1, wherein the reverse reasoning module or the forward data processing module is a large language model.

11. A method for database management, comprising: The processor receives user requests and data forms. The processor enhances the data table based on a knowledge base to generate an enhanced data table; The processor uses a large language model to generate a knowledge summary and a target script based on the user request and the enhanced data table; the processor infers the target script based on the knowledge summary and the initial script, thereby generating or updating the inferred script; and the processor accesses a database based on the inferred script to output database information.

Images