Chart page generation method, system and equipment and computer readable storage medium

Abstract

The invention relates to the technical field of artificial intelligence, and particularly discloses a chart page generation method, system and device and a computer readable storage medium, the method comprises the following steps: analyzing a to-be-processed document by using a GPT big language model to obtain a data table structure; constructing a target DDL statement corresponding to the data table structure, and constructing a database table structure according to the target DDL statement; and generating a first chart page linking the database table structure and the identifier of the linking function module, and importing data in the to-be-processed document into the database table structure to obtain a target chart management page. According to the method, documents of different formats and layouts can be directly processed, the method has extremely high adaptability, the efficiency of chart page generation is improved, a user does not need to carry out additional development work, and the method can be widely applied to different business scenes.

Description

Background Art

[0002] Currently, documents such as Word, Excel, and PDF are widely used for data storage and processing. However, existing chart building and data management tools usually have the following major problems when processing documents:

[0003] 1) Limitations of format recognition: Existing tools have high requirements for document format and layout when processing various types of documents. Users often need to pre-process documents to meet the requirements of the tools, which not only increases the workload of users, but also reduces the efficiency of document processing.

[0004] 2) Additional development requirements: Many existing chart building tools require users to perform additional development work to adapt to different data structures and business needs. This places high demands on the user's technical capabilities, and the development cycle is long, making it difficult to quickly respond to changes in business needs.

[0005] 3) Lack of flexibility: Existing tools usually use fixed templates when generating add, delete, modify and query pages, which lacks flexibility. It is difficult for users to adjust according to actual needs, resulting in the generated pages not fully meeting user needs in terms of layout and functionality.

[0006] 4) Inconvenient user interaction: Most existing tools use manual operation to adjust page layout. Users need to drag and adjust on the interface, which is cumbersome and inefficient, especially when dealing with complex layouts.

[0007] In summary, the prior art has many deficiencies in processing documents, generating pages for adding, deleting, modifying and checking, and adjusting page layout, and it is urgent to provide a technical solution to solve the above problems. Summary of the invention

[0008] To solve the above technical problems, the present invention provides a chart page generation method, system, device and computer-readable storage medium.

[0009] In a first aspect, the present invention provides a method for generating a chart page, and the technical solution of the method is as follows:

[0010] Use the GPT large language model to parse the document to be processed and obtain the database table structure;

[0011] Constructing a target DDL statement corresponding to the data table structure, and constructing a database table structure according to the target DDL statement;

[0012] A first chart page linking the database table structure and the identifier of the link function module is generated, and the data in the document to be processed is imported into the database table structure to obtain a target chart management page.

[0013] The beneficial effects of a chart page generation method of the present invention are as follows:

[0014] The method of the present invention can directly process documents of different formats and layouts, has extremely high adaptability, and improves the efficiency of chart page generation, does not require users to perform additional development work, and can be widely used in different business scenarios.

[0015] Based on the above solution, the method for generating a chart page of the present invention can also be improved as follows.

[0016] In an optional manner, the database table structure includes: table field names and table data types.

[0017] In an optional manner, the functional module includes at least one of: adding a functional module, modifying a functional module, deleting a functional module, importing and exporting a functional module, and searching a functional module.

[0018] In an optional manner, the method further includes:

[0019] The natural language instruction input by the user for adjusting the page layout is parsed, and the page layout of the target chart management page is adjusted according to the parsing result to obtain an adjusted chart management page.

[0020] In a second aspect, the present invention provides a chart page generation system, the technical solution of which is as follows:

[0021] Includes: a processing unit, a building unit and a generating unit;

[0022] The processing unit is used to: use the GPT large language model to parse the document to be processed to obtain a database table structure;

[0023] The construction unit is used to: construct a target DDL statement corresponding to the data table structure, and construct a database table structure according to the target DDL statement;

[0024] The generating unit is used to generate a first chart page linking the database table structure and the identifier of the link function module, and import the data in the document to be processed into the database table structure to obtain a target chart management page.

[0025] The beneficial effects of a chart page generation system of the present invention are as follows:

[0026] The system of the present invention can directly process documents of different formats and layouts, has extremely high adaptability, and improves the efficiency of chart page generation, does not require users to perform additional development work, and can be widely used in different business scenarios.

[0027] Based on the above solution, the chart page generation system of the present invention can also be improved as follows.

[0028] In an optional manner, the database table structure includes: table field names and table data types.

[0029] In an optional manner, the functional module includes at least one of: adding a functional module, modifying a functional module, deleting a functional module, importing and exporting a functional module, and searching a functional module.

[0030] In an optional manner, it further includes: an adjustment unit;

[0031] The adjustment unit is used to parse the natural language instruction input by the user for adjusting the page layout, and adjust the page layout of the target chart management page according to the parsing result to obtain the adjusted chart management page.

[0032] In a third aspect, a technical solution of an electronic device of the present invention is as follows:

[0033] The invention comprises a memory, a processor and a program stored in the memory and running on the processor. When the processor executes the program, the steps of the diagram page generation method of the present invention are realized.

[0034] In a fourth aspect, the present invention provides a computer-readable storage medium having the following technical solution:

[0035] Instructions are stored in the computer-readable storage medium. When the computer-readable storage medium reads the instructions, the computer-readable storage medium executes the steps of the diagram page generation method of the present invention.

[0036] The above description is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention, it can be implemented according to the contents of the specification. In order to make the above and other purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] The accompanying drawings are only used to illustrate the embodiments and are not to be considered as limiting the present invention. In addition, the same reference symbols are used to represent the same components throughout the accompanying drawings. In the accompanying drawings:

[0038] Figure 1 A schematic diagram of a flow chart of an embodiment of a method for generating a chart page according to the present invention;

[0039] Figure 2 A schematic diagram of the structure of an embodiment of a chart page generation system of the present invention;

[0040] Figure 3The figure is a schematic structural diagram of an embodiment of an electronic device of the present invention. DETAILED DESCRIPTION

[0041] Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present invention are shown in the drawings, it should be understood that the present invention can be implemented in various forms and should not be limited to the embodiments set forth herein.

[0042] Figure 1 A flow chart of an embodiment of a method for generating a chart page provided by the present invention is shown. The method for generating a chart page can be executed by an electronic device such as a terminal device or a server. The terminal device can be any fixed or mobile terminal such as a user equipment (UE), a mobile device, a user terminal, a terminal, a cellular phone, a cordless phone, a personal digital assistant (PDA), a handheld device, a computing device, a vehicle-mounted device, a wearable device, etc. The server can be a single server or a server cluster composed of multiple servers. Any electronic device can implement the method for generating a chart page by calling computer-readable instructions stored in a memory through a processor. Figure 1 As shown, the following steps are included:

[0043] S1. Use the GPT large language model to parse the document to be processed and obtain the database table structure.

[0044] Among them, the GPT large language model parses the database table structure in the document to be processed, including the table field names and table data types, etc. The GPT large language model can identify and classify different fields, and infer the data type of each field, such as string, value, date, etc., based on the content of the document to be processed.

[0045] The database table structure is automatically generated according to the parsing result, and the user does not need to perform any additional development work. This embodiment can flexibly adapt to documents of different formats.

[0046] It should be noted that the chart structure includes multi-row header tables, tree tables, line charts, bar charts, pie charts and donut charts.

[0047] S2. Construct a target DDL statement corresponding to the data table structure, and construct a database table structure according to the target DDL statement.

[0048] Among them, the GPT large language model generates English names, data types and table names that comply with data specifications and are highly readable according to the names in the data table structure, and constructs corresponding DDL statements. It executes the DDL statements through the database to create the database table structure in the database.

[0049] S3. Generate a first chart page that links the database table structure and the identifier of the link function module, and import the data in the document to be processed into the database table structure to obtain a target chart management page.

[0050] Among them, the function modules include: at least one of adding function modules, modifying function modules, deleting function modules, importing and exporting function modules and searching function modules, and can also be set according to actual conditions, for example: ① table configuration function module: at least one of data set configuration, table header configuration, alias configuration, data rule configuration, column width configuration, locking configuration, sorting configuration, merging configuration, alignment configuration, download configuration, and permission configuration function modules. ② chart configuration function module: at least one of XY axis configuration, category switching configuration, inclination configuration, legend configuration, prompt configuration, label configuration, and color configuration function modules. The number of function modules can be determined according to the database table structure. The page is associated with the database table structure and function module in the database respectively, so that the database table structure and the logo of the linked function module are displayed in the page. By clicking the response logo, the function of the corresponding function module can be realized, such as adding data, modifying data, deleting data, searching data, etc. The logo layout in the first chart page can be set according to actual conditions. The target chart management page includes: a chart page with the database table structure of the imported data and the logo of the linked function module.

[0051] In an optional manner, the method further includes:

[0052] The natural language instruction input by the user for adjusting the page layout is parsed, and the page layout of the target chart management page is adjusted according to the parsing result to obtain an adjusted chart management page.

[0053] Among them, the GPT large language model is used to parse the natural language instructions to obtain specific adjustment instructions. For example, if the natural language instruction is "put the date first" or "put the sales after the profit", the GPT large language model is used to parse the natural language instruction, so as to dynamically adjust the layout of the page according to the adjustment instruction obtained by the analysis, and obtain the adjusted chart management page to improve the user interaction experience.

[0054] The technical solution of this embodiment has the following technical effects:

[0055] 1) Automatic processing of documents in various formats: This embodiment can flexibly identify and parse documents in various formats and layouts without requiring the user to perform any preprocessing or format conversion. This greatly improves the efficiency of document processing and eliminates the strict requirements on document format and layout in the prior art.

[0056] 2) No additional development is required: By combining the GPT large language model, this embodiment can automatically generate add, delete, modify and query pages suitable for different business needs without the need for users to perform additional development work.

[0057] 3) Flexible natural language layout adjustment: This embodiment allows users to directly adjust the layout of the generated page through natural language commands. This interaction method based on natural language processing greatly improves the user's operational flexibility and convenience. Users can dynamically adjust the layout of the page according to actual needs without having to deeply understand technical details or use complex interface operations.

[0058] 4) Improve the efficiency of online data: This embodiment greatly simplifies the online data process by automatically importing the data in the document into the database and generating the corresponding management page. This not only reduces the steps of manual intervention, but also ensures the accuracy and consistency of the data, thereby significantly improving the efficiency of data management.

[0059] 5) Not restricted by document formats: This embodiment can process documents of various formats and layouts, has extremely high adaptability, and can be widely used in different business scenarios.

[0060] 6) Enhanced user experience: This embodiment uses natural language processing technology to lower the technical threshold of operation, allowing non-technical users to easily complete complex data processing tasks. This innovative interaction method not only improves the intuitiveness of operation, but also enhances user satisfaction.

[0061] Figure 2 FIG. 2 is a schematic diagram showing a structure of an embodiment of a chart page generation system 200 provided by the present invention. Figure 2 As shown, the system 200 includes: a processing unit 210, a construction unit 220 and a generation unit 230;

[0062] The processing unit 210 is used to: parse the document to be processed using the GPT large language model to obtain a database table structure;

[0063] The construction unit 220 is used to: construct a target DDL statement corresponding to the data table structure, and construct a database table structure according to the target DDL statement;

[0064] The generating unit 230 is used to generate a first chart page linking the database table structure and the identifier of the link function module, and import the data in the document to be processed into the database table structure to obtain a target chart management page.

[0065] In an optional manner, the database table structure includes: table field names and table data types.

[0066] In an optional manner, the functional module includes at least one of: adding a functional module, modifying a functional module, deleting a functional module, importing and exporting a functional module, and searching a functional module.

[0067] In an optional manner, it further includes: an adjustment unit;

[0068] The adjustment unit is used to parse the natural language instruction input by the user for adjusting the page layout, and adjust the page layout of the target chart management page according to the parsing result to obtain the adjusted chart management page.

[0069] The technical solution of this embodiment can directly process documents of different formats and layouts, has extremely high adaptability, and improves the efficiency of chart page generation. It does not require users to perform additional development work and can be widely used in different business scenarios.

[0070] The parameters and steps of each unit implementing the corresponding functions in the chart page generation system 200 of the present embodiment may refer to the parameters and steps in the above embodiment of the chart page generation method, and will not be described in detail here.

[0071] like Figure 3 As shown, an electronic device 300 according to an embodiment of the present invention includes a processor 320, the processor 320 is coupled to a memory 310, and the memory 310 stores at least one computer program 330, and the at least one computer program 330 is loaded and executed by the processor 320, so that the electronic device 300 implements any of the above-mentioned chart page generation methods, specifically:

[0072] The electronic device 300 may have relatively large differences due to different configurations or performances, and may include one or more processors 320 (Central Processing Units, CPU) and one or more memories 310, wherein the one or more memories 310 store at least one computer program 330, and the at least one computer program 330 is loaded and executed by the one or more processors 320, so that the electronic device 300 implements any of the chart page generation methods provided in the above embodiments. Of course, the electronic device 300 may also have components such as a wired or wireless network interface, a keyboard, and an input and output interface for input and output, and the electronic device 300 may also include other components for implementing device functions, which will not be described in detail here.

[0073] A computer-readable storage medium according to an embodiment of the present invention stores at least one computer program, and the at least one computer program is loaded and executed by a processor to enable a computer to implement any of the above-mentioned chart page generation methods.

[0074] Optionally, the computer-readable storage medium may be a read-only memory (ROM), a random access memory (RAM), a compact disc (CD-ROM), a magnetic tape, a floppy disk, an optical data storage device, and the like.

[0075] In an exemplary embodiment, a computer program product or a computer program is also provided, the computer program product or the computer program comprising computer instructions, the computer instructions being stored in a computer-readable storage medium. A processor of an electronic device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the electronic device executes any of the above-mentioned chart page generation methods.

[0076] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application are used to distinguish similar objects and represent the definition of a specific order or sequence. The order of use of similar objects can be interchanged where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than the order shown or described.

[0077] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, namely: it can be complete hardware, it can be complete software (including firmware, resident software, microcode, etc.), or it can be a combination of hardware and software, which is generally referred to as "circuit", "module" or "system" herein. In addition, in some embodiments, the present invention can also be implemented in the form of a computer program product in one or more computer-readable media, and the computer-readable medium contains computer-readable program code.

[0078] Any combination of one or more computer-readable media can be used. Computer-readable media can be computer-readable signal media or computer-readable storage media. Computer-readable storage media can be, for example, but not limited to, electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or devices, or any combination of the above. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present application, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.

[0079] Although the embodiments of the present invention have been shown and described above, it is to be understood that the above embodiments are exemplary and are not to be construed as limitations of the present invention. A person skilled in the art may change, modify, replace and vary the above embodiments within the scope of the present invention.

Claims

1. A method for generating a chart page, characterized in that: include: Use the GPT large language model to parse the document to be processed and obtain the data table structure; Constructing a target DDL statement corresponding to the data table structure, and constructing a database table structure according to the target DDL statement; A first chart page linking the database table structure and the identifier of the link function module is generated, and the data in the document to be processed is imported into the database table structure to obtain a target chart management page.

2. The method for generating a chart page according to claim 1, characterized in that: The database table structure includes: table field names and table data types.

3. The method for generating a chart page according to claim 1, characterized in that: The functional modules include at least one of: adding a functional module, modifying a functional module, deleting a functional module, importing and exporting a functional module, and searching a functional module.

4. The method for generating a chart page according to any one of claims 1 to 3, characterized in that: Also includes: The natural language instruction input by the user for adjusting the page layout is parsed, and the page layout of the target chart management page is adjusted according to the parsing result to obtain an adjusted chart management page.

5. A chart page generation system, characterized in that: include: Processing units, building units, and generating units; The processing unit is used to: use the GPT large language model to parse the document to be processed to obtain a database table structure; The construction unit is used to: construct a target DDL statement corresponding to the data table structure, and construct a database table structure according to the target DDL statement; The generating unit is used to generate a first chart page linking the database table structure and the identifier of the link function module, and import the data in the document to be processed into the database table structure to obtain a target chart management page.

6. The chart page generation system according to claim 5, characterized in that: The database table structure includes: table field names and table data types.

7. The chart page generation system according to claim 5, characterized in that: The functional modules include at least one of: adding a functional module, modifying a functional module, deleting a functional module, importing and exporting a functional module, and searching a functional module.

8. The chart page generation system according to any one of claims 5 to 7, characterized in that: Also included: an adjustment unit; The adjustment unit is used to parse the natural language instruction input by the user for adjusting the page layout, and adjust the page layout of the target chart management page according to the parsing result to obtain the adjusted chart management page.

9. An electronic device, characterized in that: The electronic device includes a processor, the processor is coupled to a memory, the memory stores at least one computer program, and the at least one computer program is loaded and executed by the processor so that the electronic device implements the chart page generation method as described in any one of claims 1 to 4.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores at least one computer program, and the at least one computer program is loaded and executed by the processor, so that the computer-readable storage medium implements the chart page generation method according to any one of claims 1 to 4.

Images