Multidimensional table processing method, device, storage medium and electronic device

Abstract

The embodiment of the present application discloses a multidimensional table processing method, device, storage medium and electronic device, wherein the method includes: obtaining a multidimensional table generation prompt word input by a user, performing table data stream generation processing based on the multidimensional table generation prompt word through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data, creating an initial multidimensional table management system based on the multidimensional table system structure data, and using each of the table system field data to update the table of the initial multidimensional table management system to obtain the updated multidimensional table management system.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a multidimensional table processing method, device, storage medium and electronic device. Background Art

[0002] Multidimensional tables can also be called multidimensional table management systems. Unlike traditional spreadsheets, multidimensional tables are table databases in the form of tables (such as online table databases) that can store business information, visualize business data, and manage business, assisting users in business decision-making management.

[0003] Currently, multidimensional table management systems are usually built manually by users, and users need to manually perform table maintenance operations such as creating, editing, deleting, and modifying each dimension table under the multidimensional table management system. Summary of the invention

[0004] The embodiments of this specification provide a multidimensional table processing method, device, storage medium and electronic device, and the technical solution is as follows:

[0005] In a first aspect, an embodiment of the present specification provides a multidimensional table processing method, the method comprising:

[0006] Obtain the multidimensional table generation prompt words input by the user;

[0007] Based on the multidimensional table generation prompt word, a table data stream generation process is performed through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data;

[0008] An initial multidimensional table management system is created based on the multidimensional table system structure data, and each of the table system field data is used to perform table update on the initial multidimensional table management system to obtain an updated multidimensional table management system.

[0009] In a feasible implementation manner, the generating prompt words based on the multidimensional table are processed by a multidimensional table processing large model to obtain multidimensional table system structure data and a plurality of table system field data, an initial multidimensional table management system is created based on the multidimensional table system structure data, and the table of the initial multidimensional table management system is updated using each of the table system field data, including:

[0010] Inputting the multidimensional table generation prompt words into the multidimensional table processing macro model;

[0011] Performing table structure generation processing through the multidimensional table processing large model to obtain multidimensional table system structure data, and creating an initial multidimensional table management system based on the multidimensional table system structure data;

[0012] The table data stream generation process is performed through the multi-dimensional table processing large model to obtain a plurality of table system field data, and the table of the initial multi-dimensional table management system is updated based on each of the table system field data.

[0013] In a feasible implementation manner, the step of performing table structure generation processing through the multidimensional table processing large model to obtain multidimensional table system structure data includes:

[0014] Determine the multidimensional table name and multidimensional table association information of the multidimensional table through the multidimensional table processing large model, and determine the table row and column information corresponding to each table in the multidimensional table;

[0015] Generate original multidimensional table system structure data based on the multidimensional table name, multidimensional table association information and table row and column information;

[0016] The original multidimensional table system structure data is packaged using a preset table system tool format to obtain multidimensional table system structure data.

[0017] In a feasible implementation manner, the creating an initial multidimensional table management system based on the multidimensional table system structure data includes:

[0018] The multidimensional table system structure data is sent to a table system tool service, and an initial multidimensional table management system is created by using the multidimensional table system structure data through the table system tool service.

[0019] In a feasible implementation manner, the step of performing table data stream generation processing through the multidimensional table processing large model to obtain a plurality of table system field data, and performing table updating on the initial multidimensional table management system based on each of the table system field data, comprises:

[0020] Performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data;

[0021] Performing field association stream processing based on the multidimensional field data through the multidimensional table processing large model to obtain multidimensional field association information, and performing association key mapping processing on the initial multidimensional table management system based on the multidimensional field association information;

[0022] The form metadata is obtained by performing form metadata streaming generation processing through the multi-dimensional table processing large model.

[0023] In a feasible implementation manner, the step of performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data includes:

[0024] The multidimensional table processing big model performs table field stream generation processing based on the multidimensional table system structure data to obtain multiple newly added field tables, and determines the field name and field type corresponding to the newly added field table, and the table association information between the newly added field table and the original field table;

[0025] Multidimensional field data is generated based on the field name, field type and the table association information.

[0026] In a feasible implementation manner, updating the table of the initial multidimensional table management system based on each of the table system field data includes:

[0027] Packing the table system field data using a preset table system tool format to obtain the packaged table system field data;

[0028] The table system field data is sent to a table system tool service, and the table system field data is used by the table system tool service to update the table of the initial multidimensional table management system.

[0029] In a second aspect, an embodiment of the present specification provides a multidimensional table processing device, the device comprising:

[0030] An input module, used to obtain a prompt word for generating a multidimensional table input by a user;

[0031] A processing module, used for performing table data stream generation processing based on the multidimensional table generation prompt word through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data;

[0032] A building module is used to create an initial multidimensional table management system based on the multidimensional table system structure data, and use each of the table system field data to update the table of the initial multidimensional table management system to obtain the updated multidimensional table management system.

[0033] In a feasible implementation manner, the processing module is used to:

[0034] Inputting the multidimensional table generation prompt words into the multidimensional table processing macro model;

[0035] Performing table structure generation processing through the multidimensional table processing large model to obtain multidimensional table system structure data;

[0036] The building module is used to:

[0037] Creating an initial multidimensional table management system based on the multidimensional table system structure data;

[0038] The table data stream generation process is performed through the multi-dimensional table processing large model to obtain a plurality of table system field data, and the table of the initial multi-dimensional table management system is updated based on each of the table system field data.

[0039] In a feasible implementation manner, the processing module is used to:

[0040] Determine the multidimensional table name and multidimensional table association information of the multidimensional table through the multidimensional table processing large model, and determine the table row and column information corresponding to each table in the multidimensional table;

[0041] Generate original multidimensional table system structure data based on the multidimensional table name, multidimensional table association information and table row and column information;

[0042] The original multidimensional table system structure data is packaged using a preset table system tool format to obtain multidimensional table system structure data.

[0043] In a feasible implementation manner, the processing module is used to:

[0044] The multidimensional table system structure data is sent to a table system tool service, and an initial multidimensional table management system is created by using the multidimensional table system structure data through the table system tool service.

[0045] In a feasible implementation manner, the building module is used to:

[0046] Performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data;

[0047] Performing field association stream processing based on the multidimensional field data through the multidimensional table processing large model to obtain multidimensional field association information, and performing association key mapping processing on the initial multidimensional table management system based on the multidimensional field association information;

[0048] The form metadata is obtained by performing form metadata streaming generation processing through the multi-dimensional table processing large model.

[0049] In a feasible implementation manner, the building module is used to:

[0050] The multidimensional table processing big model performs table field stream generation processing based on the multidimensional table system structure data to obtain multiple newly added field tables, and determines the field name and field type corresponding to the newly added field table, and the table association information between the newly added field table and the original field table;

[0051] Multidimensional field data is generated based on the field name, field type and the table association information.

[0052] In a feasible implementation manner, the building module is used to:

[0053] Packing the table system field data using a preset table system tool format to obtain the packaged table system field data;

[0054] The table system field data is sent to a table system tool service, and the table system field data is used by the table system tool service to update the table of the initial multidimensional table management system.

[0055] In a third aspect, an embodiment of the present specification provides a computer storage medium, wherein the computer storage medium stores a plurality of instructions, wherein the instructions are suitable for being loaded by a processor and executing the above-mentioned method steps.

[0056] In a fourth aspect, an embodiment of the present specification provides an electronic device, which may include: a processor and a memory; wherein the memory stores a computer program, and the computer program is suitable for being loaded by the processor and executing the above-mentioned method steps.

[0057] The beneficial effects brought by the technical solutions provided by some embodiments of this specification include at least:

[0058] In one or more embodiments of the present specification, the electronic device generates prompt words for a multidimensional table based on a multidimensional table input, performs table data streaming generation processing through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data, first creates an initial multidimensional table management system based on the multidimensional table system structure data, and uses the system field data of each table to update the table of the initial multidimensional table management system, so that the updated multidimensional table management system can be obtained, which can effectively and automatically generate multidimensional tables, greatly reducing the user's manual design of tables and management of fields. It uses a large model to automatically generate table structures and field data, and creates, updates and associates tables through a real-time update mechanism, which improves the convenience and efficiency of system construction and reduces the error rate; at the same time, streaming data generation and automatic table updates ensure the dynamic response and real-time feedback of the system, providing users with more efficient business management and decision support tools. BRIEF DESCRIPTION OF THE DRAWINGS

[0059] In order to more clearly illustrate the embodiments of this specification or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this specification. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0060] Figure 1 It is a scenario diagram of a multidimensional table processing system provided by an embodiment of this specification;

[0061] Figure 2 It is a flowchart of a multidimensional table processing method provided in an embodiment of this specification;

[0062] Figure 3 It is an interpretation diagram of a prompt word input provided in an embodiment of this specification;

[0063] Figure 4 It is a schematic diagram of establishing a multidimensional table management system provided in an embodiment of this specification;

[0064] Figure 5 It is a flowchart of another embodiment of a multidimensional table processing method provided in an embodiment of this specification;

[0065] Figure 6 It is a schematic diagram of prompt words for indicating system structure prompts provided in an embodiment of this specification;

[0066] Figure 7 It is a schematic diagram of prompt words for indicating system structure prompts provided in an embodiment of this specification;

[0067] Figure 8 It is a flowchart of a table update process provided by an embodiment of this specification;

[0068] Fig. 9 It is a structural schematic diagram of a multidimensional table processing device provided in an embodiment of this specification;

[0069] Fig.10 It is a structural schematic diagram of an electronic device provided in an embodiment of this specification;

[0070] Fig.11 It is a schematic diagram of the structure of the operating system and user space provided in the embodiments of this specification;

[0071] Fig.12 yes Fig.11 The architecture diagram of the Android operating system;

[0072] Fig.13 yes Fig.11 Architecture diagram of the IOS operating system. DETAILED DESCRIPTION

[0073] The following will be combined with the drawings in the embodiments of this specification to clearly and completely describe the technical solutions in the embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of this specification, not all of the embodiments. Based on the embodiments in this specification, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this specification.

[0074] In the description of this specification, it should be understood that the terms "first", "second", etc. are only used for descriptive purposes and cannot be understood as indicating or implying relative importance. In the description of this specification, it should be noted that, unless otherwise clearly specified and limited, "including" and "having" and any of their variations are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not limited to the listed steps or units, but optionally also includes steps or units that are not listed, or optionally also includes other steps or units inherent to these processes, methods, products or devices. For those of ordinary skill in the art, the specific meanings of the above terms in this specification can be understood by specific circumstances. In addition, in the description of this specification, unless otherwise specified, "multiple" refers to two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships can exist, for example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. The character " / " generally indicates that the associated objects before and after are an "or" relationship.

[0075] In the related art, users manually build a multidimensional table management system. Users need to manually perform table maintenance operations such as creating, editing, deleting, and modifying each dimensional table under the multidimensional table management system. It can be seen that the multidimensional table processing method is inconvenient and inefficient.

[0076] The present specification is described in detail below with reference to specific embodiments.

[0077] The present specification is described in detail below with reference to specific embodiments.

[0078] See also Figure 1 , is a schematic diagram of a scenario of a multidimensional table processing system provided in an embodiment of the present application. Figure 1 As shown, the multidimensional table processing system may include at least a client cluster and a service platform 100 .

[0079] In some embodiments, a client cluster may include at least one client, such as Figure 1 As shown, it specifically includes client 1 corresponding to user 1, client 2 corresponding to user 2, ..., client n corresponding to user n, where n is an integer greater than 0.

[0080] Each client in the client cluster may be an electronic device with communication function, including but not limited to: wearable device, handheld device, personal computer, tablet computer, vehicle-mounted device, smart phone, computing device or other processing device connected to a wireless modem, etc. Electronic devices may be called different names in different networks, such as: user equipment, access terminal, user unit, user station, mobile station, mobile station, remote station, remote terminal, mobile device, user terminal, terminal, wireless communication device, user agent or user device, cellular phone, cordless phone, personal digital assistant (PDA), electronic device in 5G network or future evolution network, etc.

[0081] In some embodiments, the service platform 100 can be a separate server device, such as a rack-mounted, blade, tower, or cabinet-mounted server device, or a hardware device with strong computing power such as a workstation or a mainframe computer; it can also be a server cluster composed of multiple servers, and the servers in the service cluster can be composed in a symmetrical manner, wherein each server has equivalent functions and status in the transaction link, and each server can provide services to the outside independently, and the independent service can be understood as not requiring the assistance of other servers.

[0082] In one or more embodiments of the present specification, the service platform 100 may establish a communication connection with at least one client in the client cluster, and complete data interaction during multidimensional table processing based on the communication connection.

[0083] For example, a user can send a multidimensional table generation prompt word to the service platform 100 through the client; the service platform 100 can receive the multidimensional table generation prompt word input by the user, and based on the multidimensional table generation prompt word, perform table data streaming generation processing through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data, create an initial multidimensional table management system based on the multidimensional table system structure data, and use each of the table system field data to update the table of the initial multidimensional table management system to obtain the updated multidimensional table management system; for example, the server 100 synchronizes the multidimensional table management system to the client, so that the client can display the multidimensional table management system to the user.

[0084] It should be noted that the service platform 100 and at least one client in the client cluster establish a communication connection through a network for interactive communication, wherein the network can be a wireless network or a wired network, the wireless network includes but is not limited to a cellular network, a wireless local area network, an infrared network or a Bluetooth network, and the wired network includes but is not limited to Ethernet, a universal serial bus (USB) or a controller local area network. In one or more embodiments of the specification, technologies and / or formats including Hyper Text Mark-up Language (HTML), Extensible Markup Language (XML), etc. are used to represent data (such as a target compressed package) exchanged through the network. In addition, conventional encryption technologies such as Secure Socket Layer (SSL), Transport Layer Security (TLS), Virtual Private Network (VPN), Internet Protocol Security (IPsec), etc. can also be used to encrypt all or some links. In other embodiments, customized and / or dedicated data communication technologies can also be used to replace or supplement the above data communication technologies.

[0085] The multidimensional table processing system embodiment provided in this specification and the multidimensional table processing method described in one or more embodiments belong to the same concept. The execution subject corresponding to the multidimensional table processing method involved in one or more embodiments of the specification can be an electronic device, and the electronic device can be the above-mentioned service platform 100, or the electronic device can be the above-mentioned client, which is determined based on the actual application environment. The specific implementation process of the demonstration file generation system embodiment can be detailed in the following method embodiment, which will not be repeated here.

[0086] In one embodiment, Figure 1 As shown, a multidimensional table processing method is proposed, which can be implemented by a computer program and can be run on a multidimensional table processing device based on the von Neumann system. The computer program can be integrated into an application or run as an independent tool application. The multidimensional table processing device can be an electronic device.

[0087] Multidimensional tables can also be called multidimensional table management systems. Unlike traditional spreadsheets, multidimensional tables are table databases in the form of tables (such as online table databases) that can perform information storage, data visualization analysis, and business management, and assist users in decision-making management.

[0088] Multidimensional tables support users to build business management systems involving multiple table data dimensions, such as project management systems and order management systems. Multidimensional tables can support the processing of massive business data and business data analysis in business databases and form visual multidimensional table data, and can support multiple people editing documents at the same time.

[0089] Specifically, the multidimensional table processing method includes:

[0090] S102: Obtaining a multidimensional table generation prompt word input by a user;

[0091] Exemplarily, the target intelligent agent object is pre-developed or integrated into the multidimensional table application platform used by the user in daily life, and then a user interface is configured, through which it can be ensured that the user can conveniently input a multidimensional table generation prompt word for assisting in generating a multidimensional table management system into the target intelligent agent object, and the target intelligent agent object is a front-end service of the multidimensional table processing large model for users, and is used for the interaction between the multidimensional table processing large model and the user;

[0092] Furthermore, when the user inputs a multidimensional table generation request and inputs a multidimensional table generation prompt word for the target intelligent agent object, the multidimensional table generation prompt word input by the user is automatically obtained through the target intelligent agent object.

[0093] For example, Figure 3 As shown, Figure 3 It is an interpretation diagram for prompt word input. The user opens the multidimensional table application platform through the client, and then can enter the multidimensional table generation prompt word "project management system" in the dialogue interface of the target intelligent object-"Ai Generation Assistant". The electronic device obtains the multidimensional table generation prompt word "project management system" input by the user.

[0094] S104: Based on the multidimensional table generation prompt word, a table data stream generation process is performed through a multidimensional table processing large model to obtain multidimensional table system structure data and a plurality of table system field data;

[0095] In a feasible implementation, the large model processed by the multidimensional table can be obtained by training the model for the task ticket generation scenario based on the basic large model. The basic large model (Large Language Model, LLM) is an artificial intelligence content generation model designed to understand and generate human language. The basic large model is trained on a large amount of data and can perform a wide range of tasks, including text summarization, translation, sentiment analysis, etc.

[0096] Optionally, the basic big model may be the Tongyi Qianwen big model, the Bailing big model, the GPT system big model, etc.;

[0097] In some embodiments, a trained basic big model can be obtained, and the basic big model can be adapted to the multidimensional table processing scenario to obtain the multidimensional table processing big model. Usually, the basic big model is directly applied to perform multidimensional table processing in the multidimensional table processing scenario, which is difficult to adapt to the new scenario. Based on this, the basic big model is first obtained to create an initial multidimensional table processing to generate a big model, and sample data is obtained in the new multidimensional table processing scenario. Since the basic big model is usually a trained AIGC model with content generation capabilities, based on this, this specification only needs to adapt it to the multidimensional table processing scenario. Specifically, the sample data can be used to perform model fine-tuning training on the initial multidimensional table processing big model, and after the model fine-tuning training is completed, a multidimensional table processing big model adapted to the multidimensional table processing scenario is obtained.

[0098] Indicatively, the multidimensional table generation prompt words are input into the multidimensional table processing large model for table data stream generation processing to generate "multidimensional table system structure data" and multiple "table system field data";

[0099] Optionally, the multidimensional table processing model automatically generates table (system) structure data and table (system) field data of the multidimensional table according to the multidimensional table generation prompt words provided by the user. The multidimensional table processing model adopts a streaming generation method. The first round determines the table (system) structure data, and then each round outputs each "table system field data" separately to ensure the efficiency of data generation and transmission.

[0100] The multidimensional table system structure data includes the hierarchical relationship of each table, table name, field type in the table (such as table row / column data type) and the relationship between tables;

[0101] Table system field data refers to the field name and data type corresponding to the specific table unit in the table;

[0102] In this manual, a multidimensional table processing large model is used to automatically generate the structure and fields of the multidimensional table, reducing the workload of manual design by the user, and the user can make adjustments on this basis.

[0103] S106: creating an initial multidimensional table management system based on the multidimensional table system structure data, and updating the table of the initial multidimensional table management system using each of the table system field data to obtain an updated multidimensional table management system.

[0104] Specifically, an initial multidimensional table management system is created based on the multidimensional table system structure data, and then the table is updated using the table system field data generated by the multidimensional table processing large model. The update process includes adding fields to each dimension table, setting field types, and defining associations between tables. After this series of table update operations, the electronic device finally forms a complete multidimensional table management system.

[0105] Exemplarily, the electronic device creates an initial multidimensional table management system based on the generated multidimensional table system structure data, and the system automatically creates the basic framework of the multidimensional table. The basic framework contains basic information of the table, such as the name of the table, the hierarchical structure of the table, the relationship between tables (such as foreign keys), etc. In the initial multidimensional table management system stage, the table does not yet contain all table fields and specific form metadata. It mainly defines the overall structure of the system, which is similar to the framework building of a database. By initially creating a multidimensional table system that can carry the generated data, a basic framework is provided for subsequent operations and updates.

[0106] Furthermore, the table structure of the initial multidimensional table management system is updated according to the table system field data generated by the large model. During the update process, each field is added to the table one by one according to the definition of the system structure data. At the same time, the field type of the table will affect the data input and storage method of the field. The update operation includes but is not limited to:

[0107] 1) Add new fields: Add fields to the table (such as "Warehouse ID", "Warehouse Name", etc.).

[0108] 2) Set the field type: Assign a corresponding data type to each field (for example, "int", "varchar(255)", etc.).

[0109] 3) Define field associations: Establish foreign key relationships for different table fields to ensure data consistency and association.

[0110] Furthermore, after all fields and relationships are correctly added in the initial multidimensional table management system, the initial multidimensional table management system will be updated to the final version. The final version of the multidimensional table management system already has a complete structure, fields and associations, and can be used for actual data storage, analysis and business management. Users can see all tables and their fields in the multidimensional table application platform and perform further operations (such as inputting data, querying, etc.).

[0111] For example, Figure 4 As shown, Figure 4 It is a schematic diagram of a multidimensional table management system. Figure 4 The final multidimensional table system is shown in the figure. The multidimensional table system includes tables of multiple dimensions, namely, project table, task table, user table, team table, and log table. Each dimension table includes each table field and table data of each table unit under the table field. Figure 4 Taking the log table in as an example, the table fields include: log ID, log content, creation time, update time, user and other field information. Each table unit corresponds to the table data under the corresponding table field.

[0112] In an embodiment of the present specification, the electronic device generates prompt words for a multidimensional table based on a multidimensional table input, performs table data streaming generation processing through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data, first creates an initial multidimensional table management system based on the multidimensional table system structure data, and uses the field data of each table system to update the table of the initial multidimensional table management system, so that the updated multidimensional table management system can be obtained, which can effectively and automatically generate multidimensional tables, greatly reducing the user's manual design of tables and management of fields. It uses a large model to automatically generate table structures and field data, and creates, updates and associates tables through a real-time update mechanism, which improves the convenience and efficiency of system construction and reduces the error rate; at the same time, streaming data generation and automatic table updates ensure the dynamic response and real-time feedback of the system, providing users with more efficient business management and decision support tools.

[0113] See also Figure 5 , Figure 5 This is a flowchart of another embodiment of a multidimensional table processing method proposed in this specification. Specifically:

[0114] S202: inputting the multidimensional table generation prompt words into the multidimensional table processing macro model;

[0115] S204: performing table structure generation processing through the multidimensional table processing large model to obtain multidimensional table system structure data, and creating an initial multidimensional table management system based on the multidimensional table system structure data;

[0116] Exemplarily, the electronic device creates an initial multidimensional table management system based on the generated multidimensional table system structure data, and the system automatically creates the basic framework of the multidimensional table. The basic framework contains basic information of the table, such as the name of the table, the hierarchical structure of the table, the relationship between tables (such as foreign keys), etc. In the initial multidimensional table management system stage, the table does not yet contain all table fields and specific form metadata. It mainly defines the overall structure of the system, which is similar to the framework building of a database. By initially creating a multidimensional table system that can carry the generated data, a basic framework is provided for subsequent operations and updates.

[0117] Optionally, the table structure generation process is performed through the multidimensional table processing large model to obtain multidimensional table system structure data, and the following method may be referred to:

[0118] S302: Determine the multidimensional table name and multidimensional table association information of the multidimensional table through the multidimensional table processing large model, and determine the table row and column information corresponding to each table in the multidimensional table;

[0119] Multidimensional table name: refers to the table name and table field name of each dimension.

[0120] Multidimensional table association information: refers to the association relationship between various tables. For example, the "warehouse table" and the "goods table" can establish a foreign key relationship through the "warehouse ID" field. Multidimensional table association information defines the mutual mapping information between table data in different tables, which is similar to the foreign key and table relationship in the database.

[0121] Table row and column information: refers to the information of fields (columns) and data records (rows) in each table, including the name and type of the field (such as integer, string, date, etc.), as well as the layout of the table. Table row and column information indicates the specific structure and field definition of each table.

[0122] The multidimensional table name and multidimensional table association information of the multidimensional table are generated based on the multidimensional table generation prompt words through the multidimensional table processing large model, and the table row and column information corresponding to each table in the multidimensional table is determined.

[0123] In this specification, user demand information is extracted based on multidimensional table generation prompt words, and a preset table structure can be used to generate a prompt template using the user demand information to generate a table system structure prompt. Based on the table system structure prompt, the content generation capability of the multidimensional table processing of the multidimensional table processing large model is used to automatically generate multidimensional table generation prompt words to generate the multidimensional table name, multidimensional table association information, and table row and column information corresponding to each table.

[0124] For example, Figure 6 As shown, Figure 6 It is a schematic diagram of prompt words that indicate system structure prompts, such as Figure 6 Generate multidimensional table name table system structure prompts to indicate multidimensional table processing large model according to the following Figure 6 The requirement shown in returns the name of the multidimensional table;

[0125] For example, Figure 7 As shown, Figure 7 It is a schematic diagram of prompt words that indicate system structure prompts, such as Figure 7 The table system structure prompt part of the multidimensional table related information generated multidimensional table indicates that the multidimensional table processing large model is as follows Figure 7 The requirement shown in returns multidimensional table association information;

[0126] S304: Generate original multidimensional table system structure data based on the multidimensional table name, multidimensional table association information and the table row and column information;

[0127] Indicatively, the multidimensional table name, multidimensional table association information and table row and column information are combined to generate original multidimensional table system structure data;

[0128] S306: Using a preset table system tool format to package the original multidimensional table system structure data to obtain multidimensional table system structure data.

[0129] The preset table system tool format is to be compatible with the multidimensional table application platform and to support online collaborative processing. The preset table system tool format is to ensure that the table data can be smoothly imported and used. For example, some multidimensional table application platforms require the table to be represented in a specific format such as JSON, XML, etc., to facilitate subsequent table processing and interaction.

[0130] After the original multidimensional table system structure data is packaged using the preset table system tool format to obtain the multidimensional table system structure data, the table system tool service (multidimensional table application platform) can be used to correctly read, display and use the multidimensional table system structure data, thereby creating a multidimensional table in real time. This is similar to converting data into a standardized form to meet different system requirements.

[0131] In this manual, the above method is used to ensure the complete process of the multidimensional table system from initial generation, structure definition to formatting processing, providing a solid foundation for subsequent system construction and data operations. The multidimensional table system structure data will be organized into a format that conforms to the actual usage environment and become a formal data structure that can ultimately be applied to the table management system.

[0132] Further, the creation of the initial multidimensional table management system based on the multidimensional table system structure data may be performed in the following manner:

[0133] The multidimensional table system structure data is sent to a table system tool service, and an initial multidimensional table management system is created by using the multidimensional table system structure data through the table system tool service.

[0134] Schematically, first, based on the table system tool service of the multidimensional table application platform, a data communication connection (such as a websocket connection) is created between a multidimensional table processing large model and the multidimensional table application platform. After the data communication connection is established, the multidimensional table system structure data is sent to the table system tool service. The table system tool service parses the multidimensional table system structure data to further create an initial multidimensional table management system.

[0135] S206: Perform table data stream generation processing through the multidimensional table processing large model to obtain multiple table system field data, and update the initial multidimensional table management system based on each of the table system field data to obtain an updated multidimensional table management system.

[0136] According to some embodiments, the table structure of the initial multidimensional table management system is updated according to the table system field data generated by the large model. During the update process, each field is added to the table one by one according to the definition of the system structure data. At the same time, the field type of the table will affect the data input and storage method of the field. Further, when all fields and associations are correctly added to the initial multidimensional table management system, the initial multidimensional table management system will be updated to the final version. The final version of the multidimensional table management system already has a complete structure, fields and associations.

[0137] Optional, see Figure 8 , Figure 8 The present invention is a flowchart of table update processing, wherein the table system field data includes multidimensional field data, multidimensional field association information and form metadata, and the table data stream generation processing is performed through the multidimensional table processing large model to obtain multiple table system field data, and the initial multidimensional table management system is updated based on each of the table system field data. The following method can be referred to:

[0138] S4002: performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data;

[0139] Multidimensional field data: refers to each field in the table, including the field name, type, default value, and specific attributes (such as whether it is empty, whether it is unique, etc.). After these field data are gradually generated, the system will apply them one by one to the initial multidimensional table management system.

[0140] Schematically, the table field streaming generation processing can be understood as: the large model will not generate all fields at once, but will gradually output the field definition according to the streaming processing method. The table field streaming generation processing can reduce the delay caused by one-time large-scale generation, ensure that data generation and update are carried out step by step, and use the multidimensional table to process the multidimensional field data that the large model has generated, and gradually (streaming) generate the table fields. As each field data is generated, it is gradually updated, and the field information is dynamically added to the table, providing a smoother user experience.

[0141] In a feasible implementation manner, updating the table fields of the initial multidimensional table management system based on the multidimensional field data includes: packaging the multidimensional field data using a preset table system tool format to obtain the packaged multidimensional field data, sending the multidimensional field data to a table system tool service, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data through the table system tool service;

[0142] Schematically, the multidimensional field data includes the name, type, default value, whether it is empty and other attributes of the table field. Packaging the multidimensional field data using the preset table system tool format will organize and package the multidimensional field data in a standardized format according to the preset table tool format. The packaged data is represented by a specific structure to ensure that the format is standardized during transmission; further, the packaged multidimensional field data is sent to the table system tool service, which is responsible for receiving the multidimensional field data, parsing and applying it to the initial multidimensional table management system, and performing table field update operations on the initial multidimensional table management system. After the table field is updated, the structure of the table will change with the change of the field, new fields will be added to the table, and old fields can also be updated or adjusted.

[0143] Table field update: refers to adding or modifying fields in the table based on multi-dimensional field data. For example, adding new field names, modifying field types, setting field properties (whether to allow nulls, whether unique, etc.).

[0144] In a feasible implementation manner, the following method may be used to perform table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data:

[0145] A2: Using the multidimensional table processing large model to perform table field stream generation processing based on the multidimensional table system structure data to obtain multiple newly added field tables, determine the field name and field type corresponding to the newly added field table, and table association information between the newly added field table and the original field table;

[0146] Newly added field table: refers to the new table to be added in the multidimensional table management system, which contains new field definitions. The newly added field table can be a completely new table or an extension of an existing table.

[0147] Field Name: Determine the name of each field in the newly added field table, such as "Warehouse Address", "Goods Name", etc. These field names define the type of data stored in the table.

[0148] Field type: Assign a specific data type to each field, such as integer (int), string (varchar), date (datetime), etc. The field type determines the data storage format of each field.

[0149] Table association information: refers to the relationship between the newly added field table and the original field table. For example, a newly added "Order" table may be associated with the "Customer" table through the "Customer ID" field, similar to the foreign key relationship in the database. This information defines the connection method between the newly added table and the existing table.

[0150] Indicatively, these newly added field tables will be gradually generated, and the field name, field type, and association information between the newly added tables and the original tables will be determined for each table, laying the foundation for the table structure expansion and field association of the entire multidimensional table system, ensuring that the newly added tables and existing tables can be correctly associated and support complex data management.

[0151] A4: Generate multidimensional field data based on the field name, field type and the table association information.

[0152] Indicatively, the name and type of the newly added field table and its association information with the original field table have been determined. Next, based on this information, multidimensional field data is generated. The multidimensional field data will be used for subsequent table updates to ensure that the newly added fields can be accurately added to the table and maintain the correct association relationship with the original fields and tables.

[0153] In this specification, a large model is processed through a multidimensional table, and multiple newly added field tables are generated based on the system structure data stream, and the name, type and association information of each field with the original field table are determined. This step realizes the automatic generation of field data and the establishment of preliminary association relationships, providing a basis for the structural expansion of the system. On this basis, the field name, type and association information are integrated to generate detailed multidimensional field data. These multidimensional field data are structured and standardized to ensure the accuracy of field definitions and the maintainability of the system, providing a solid foundation for subsequent table field updates and data management. Electronic devices can efficiently and automatically generate and manage field data of multidimensional tables, reduce manual operations, improve the flexibility and reliability of the system, and support complex business needs and data management tasks.

[0154] S4004: performing field association stream processing based on the multidimensional field data through the multidimensional table processing large model to obtain multidimensional field association information, and performing association key mapping processing on the initial multidimensional table management system based on the multidimensional field association information;

[0155] Multidimensional field association information includes but is not limited to:

[0156] Foreign key relationship: The association between a field and a primary key or foreign key in another table.

[0157] Parent-child relationship: For example, the relationship between parent nodes and child nodes in hierarchical data.

[0158] Unique constraint or reference relationship: whether a field refers to a unique value in another table.

[0159] Schematically, the multidimensional table processing large model dynamically performs association processing between fields based on the multidimensional field data that has been generated. The multidimensional table processing large model will not process the association of all fields at one time, but will gradually generate and update the association relationship of each field, that is, the multidimensional field association information, thereby ensuring that the system's response speed and processing efficiency are maintained when processing a large number of fields, while allowing dynamic adjustment and optimization during the generation process.

[0160] Furthermore, the table system tool service parses the multi-dimensional field association information. The multi-dimensional field association information defines which fields are associated with fields in other tables (such as foreign key relationships) and how to establish these associations. Parsing the multi-dimensional field association information is crucial for data references between tables to ensure data consistency and accuracy. Then, based on the field association information generated in the previous step, the actual association key mapping operation is performed. Through association key mapping, the field association relationship is applied to the actual table to ensure that the fields in the table can correctly reference the data in other tables and maintain data consistency and integrity. The association key mapping operation includes but is not limited to:

[0161] 1) Foreign key mapping: Add foreign key constraints to fields to associate them with primary keys in other tables. This ensures that the referenced data is correct. For example, the "warehouse ID" field may be referenced by the "goods table" to form a foreign key association.

[0162] 2) Data consistency check: Ensure that all data meets the defined constraints when doing key mapping. For example, if a field is a foreign key, it must reference a primary key that already exists in the related table.

[0163] 3) Mapping operation: Apply the association information of the fields to the table, and generate corresponding table constraints, triggers or indexes based on the association information of the fields to ensure the association between the fields. Mapping operations involve SQL operations performed at the database level, such as "ALTER TABLE" to add foreign key constraints.

[0164] In a feasible implementation, the performing of the associated field key mapping processing on the initial multidimensional table management system based on the multidimensional field associated information includes: packaging the multidimensional field associated information using a preset table system tool format to obtain the packaged multidimensional field associated information, sending the multidimensional field associated information to a table system tool service, and performing the associated field key mapping processing on the initial multidimensional table management system based on the multidimensional field associated information through the table system tool service;

[0165] Indicatively, the preset table system tool format organizes the associated information into a format that can be recognized and processed by the table system tool, and the multidimensional field associated information is packaged using the preset table system tool format to obtain the packaged multidimensional field associated information, so as to facilitate subsequent transmission and processing, and ensure the standardization and compatibility of the data; the packaged multidimensional field associated information is sent to the table system tool service, and the table system tool service can accept external input data (such as multidimensional field associated information). The table system tool service transmits the packaged associated information to the table system tool service through communication protocols such as API and WebSocket, and the table system tool service can receive the multidimensional field associated information and correctly parse it, and perform associated field key mapping processing on the initial multidimensional table management system according to the parsed data. After the associated field key mapping processing, the initial multidimensional table management system will contain complete field associated information. In this way, the association relationship between tables is clearly defined, and the consistency and integrity of the data are guaranteed. .

[0166] The associated field key mapping process is to actually establish the associated relationship of the fields in the initial multidimensional table management system. The associated field key mapping process includes but is not limited to:

[0167] 1) Foreign key mapping operation: add foreign key constraints to fields in the table. For example, add a foreign key constraint to the "Warehouse ID" field in the "Cargo Table" to associate it with the "Warehouse ID" of the "Warehouse Table".

[0168] 2) Reference relationship operation: Create reference constraints between fields in the system, for example, a field references the unique value of another table.

[0169] 3) Hierarchical relationship processing operations: processing the relationship between parent and child tables, such as defining the association between parent fields and child fields for hierarchical data.

[0170] S4006: Performing form metadata streaming generation processing through the multidimensional table processing large model to obtain form metadata for associated field keys, and updating the form metadata to target table units of multiple associated field tables corresponding to the associated field keys in the initial multidimensional table management system.

[0171] The multidimensional table processing large model is used to perform form metadata streaming generation processing to add new table data. For table data, the table data is usually relatively large, and the large model has a slow output speed at one time. The large model streaming output can be used to generate a row or a preset number of rows of data for the table each time. After obtaining the preset number of rows of data, the preset number of rows of data are assembled into a preset table system tool format. A message carrying a preset number of rows of data is sent using a method such as websocket, and the multidimensional table on the interface will add a preset number of rows of data. This not only speeds up the generation speed but also improves the user experience.

[0172] After completing all the form metadata steps, a table is automatically generated using the multidimensional table processing model. After all the tables are generated, a multidimensional table management system is built.

[0173] In a feasible implementation manner, updating the form metadata to the target table units of the multiple associated field tables corresponding to the associated field keys in the initial multidimensional table management system includes: packaging the form metadata using a preset table system tool format to obtain the packaged form metadata, sending the form metadata to a table system tool service, and updating the form metadata to the target table units of the multiple associated field tables corresponding to the associated field keys in the initial multidimensional table management system through the table system tool service.

[0174] Form metadata: It is a specific data item in a table, which refers to the specific value of each field in a table cell (i.e. each field position in a single table record). For example, the cell data in a "warehouse" table may contain "warehouse ID: 1", "warehouse name: main warehouse", etc.

[0175] The associated field key in the multidimensional table management system can be understood as the update of the associated fields in the table. For example, the "Warehouse ID" field in the "Goods" table may be a foreign key, which is associated with the primary key in the "Warehouse" table. When updating the data in the "Warehouse Table", it may be necessary to update the field in the "Goods Table" that references the "Warehouse ID" at the same time to ensure data consistency.

[0176] Update of target table unit of associated field table: The table system tool service updates the specific value of the field in the corresponding table according to the parsed data. For example: in the "Warehouse" table, update the "Warehouse Name" corresponding to "Warehouse ID: 1" to "Primary Warehouse"; if a field is a foreign key that references the primary key of another table, the service will ensure that these associations are updated correctly. For example, when the "Warehouse ID" in the "Warehouse Table" is updated, the "Warehouse ID" field in the associated "Goods Table" will also be updated synchronously.

[0177] Indicatively, the form metadata is packaged in a preset table system tool format, the form metadata is organized and encapsulated in a predefined format (JSON, XML, CSV or a system-defined format), and the packaged form metadata is sent to the table system tool service. After receiving the packaged form metadata, the table system tool service will unpack and parse the form metadata, extract information such as table name, field name, field value, and prepare to apply the form metadata to the corresponding table unit. Through the table system tool service, the transmitted form metadata is automatically applied to the actual table unit to ensure that the data in the multidimensional table management system is updated and the reference relationship of the associated fields remains consistent.

[0178] In one or more embodiments of this specification, the above method is used to realize the automatic generation and update of table fields and their associated information, effectively reducing the complexity and error rate of manual configuration. This process generates, packages and transmits data in a streaming manner to ensure that the field association relationship can be accurately and timely mapped to the multidimensional table management system, improve the efficiency and consistency of data processing, and enhance the flexibility and reliability of the system in complex business scenarios.

[0179] The following will be combined Fig. 9 , the multidimensional table processing device provided in the embodiment of this specification is introduced in detail. It should be noted that, Fig. 9 The multidimensional table processing device shown is used to execute the instructions Figure 1 to Figure 8 For the convenience of explanation, only the part related to the embodiment of this specification is shown. For the specific technical details not disclosed, please refer to this specification. Figure 1 to Figure 6 The embodiment shown.

[0180] See also Fig. 9 , which shows a schematic diagram of the structure of a multidimensional table processing device according to an embodiment of the present specification. The multidimensional table processing device 1 can be implemented as all or part of a device through software, hardware, or a combination of both. According to some embodiments, the multidimensional table processing device 1 includes an input module 11, a multi-processing module 12, and a building module 13, which are specifically used to:

[0181] An input module 11 is used to obtain a prompt word for generating a multidimensional table input by a user;

[0182] A processing module 12 is used to generate table data stream-based processing through a multidimensional table processing large model based on the multidimensional table generation prompt word to obtain multidimensional table system structure data and multiple table system field data;

[0183] The building module 13 is used to create an initial multidimensional table management system based on the multidimensional table system structure data, and use each of the table system field data to update the table of the initial multidimensional table management system to obtain an updated multidimensional table management system.

[0184] In a feasible implementation manner, the processing module 12 is used to:

[0185] Inputting the multidimensional table generation prompt words into the multidimensional table processing macro model;

[0186] Performing table structure generation processing through the multidimensional table processing large model to obtain multidimensional table system structure data;

[0187] The building module 13 is used for:

[0188] Creating an initial multidimensional table management system based on the multidimensional table system structure data;

[0189] The table data stream generation process is performed through the multi-dimensional table processing large model to obtain a plurality of table system field data, and the table of the initial multi-dimensional table management system is updated based on each of the table system field data.

[0190] In a feasible implementation manner, the processing module 12 is used to:

[0191] Determine the multidimensional table name and multidimensional table association information of the multidimensional table through the multidimensional table processing large model, and determine the table row and column information corresponding to each table in the multidimensional table;

[0192] Generate original multidimensional table system structure data based on the multidimensional table name, multidimensional table association information and table row and column information;

[0193] The original multidimensional table system structure data is packaged using a preset table system tool format to obtain multidimensional table system structure data.

[0194] In a feasible implementation manner, the processing module 12 is used to:

[0195] The multidimensional table system structure data is sent to a table system tool service, and an initial multidimensional table management system is created by using the multidimensional table system structure data through the table system tool service.

[0196] In a feasible implementation manner, the building module 13 is used to:

[0197] Performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data;

[0198] Performing field association stream processing based on the multidimensional field data through the multidimensional table processing large model to obtain multidimensional field association information, and performing association key mapping processing on the initial multidimensional table management system based on the multidimensional field association information;

[0199] The form metadata is obtained by performing form metadata streaming generation processing through the multi-dimensional table processing large model.

[0200] In a feasible implementation manner, the building module 13 is used to:

[0201] The multidimensional table processing big model performs table field stream generation processing based on the multidimensional table system structure data to obtain multiple newly added field tables, and determines the field name and field type corresponding to the newly added field table, and the table association information between the newly added field table and the original field table;

[0202] Multidimensional field data is generated based on the field name, field type and the table association information.

[0203] In a feasible implementation manner, the building module 13 is used to:

[0204] Packing the table system field data using a preset table system tool format to obtain the packaged table system field data;

[0205] The table system field data is sent to a table system tool service, and the table system field data is used by the table system tool service to update the table of the initial multidimensional table management system.

[0206] It should be noted that the multidimensional table processing device provided in the above embodiment only uses the division of the above functional modules as an example when executing the multidimensional table processing method. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the device is divided into different functional modules to complete all or part of the functions described above. In addition, the multidimensional table processing device provided in the above embodiment and the multidimensional table processing method embodiment belong to the same concept, and the implementation process thereof is detailed in the method embodiment, which will not be repeated here.

[0207] The serial numbers of the embodiments of this specification are for description only and do not represent the advantages or disadvantages of the embodiments.

[0208] In an embodiment of the present specification, the electronic device generates prompt words for a multidimensional table based on a multidimensional table input, performs table data streaming generation processing through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data, first creates an initial multidimensional table management system based on the multidimensional table system structure data, and uses the field data of each table system to update the table of the initial multidimensional table management system, so that the updated multidimensional table management system can be obtained, which can effectively and automatically generate multidimensional tables, greatly reducing the user's manual design of tables and management of fields. It uses a large model to automatically generate table structures and field data, and creates, updates and associates tables through a real-time update mechanism, which improves the convenience and efficiency of system construction and reduces the error rate; at the same time, streaming data generation and automatic table updates ensure the dynamic response and real-time feedback of the system, providing users with more efficient business management and decision support tools.

[0209] The present specification also provides a computer storage medium, which can store multiple instructions, and the instructions are suitable for being loaded and executed by a processor as described above. Figure 1 to Figure 8 The multidimensional table processing method of the embodiment shown in the figure can be specifically executed by referring to Figure 1 to Figure 8 The specific description of the illustrated embodiment will not be repeated here.

[0210] The present specification also provides a computer program product, which stores at least one instruction, and the at least one instruction is loaded and executed by the processor as described above. Figure 1 to Figure 8 The multidimensional table processing method of the embodiment shown in the figure can be specifically executed by referring to Figure 1 to Figure 8 The specific description of the illustrated embodiment will not be repeated here.

[0211] Please refer to Fig.10 , which shows a block diagram of the structure of an electronic device provided by an exemplary embodiment of this specification. The electronic device in this specification may include one or more of the following components: a processor 110, a memory 120, an input device 130, an output device 140, and a bus 150. The processor 110, the memory 120, the input device 130, and the output device 140 may be connected via the bus 150.

[0212] The processor 110 may include one or more processing cores. The processor 110 uses various interfaces and lines to connect various parts of the entire electronic device, and executes various functions of the electronic device and processes data by running or executing instructions, programs, code sets or instruction sets stored in the memory 120, and calling data stored in the memory 120. Optionally, the processor 110 can be implemented in at least one hardware form of digital signal processing (DSP), field-programmable gate array (FPGA), and programmable logic array (PLA). The processor 110 can integrate one or a combination of a central processing unit (CPU), a graphics processing unit (GPU), and a modem. Among them, the CPU mainly processes the operating system, user interface, and application programs; the GPU is responsible for rendering and drawing display content; and the modem is used to process wireless communications. It can be understood that the above-mentioned modem may not be integrated into the processor 110, but may be implemented separately through a communication chip.

[0213] The memory 120 may include a random access memory (RAM) or a read-only memory (ROM). Optionally, the memory 120 includes a non-transitory computer-readable storage medium. The memory 120 may be used to store instructions, programs, codes, code sets or instruction sets. The memory 120 may include a program storage area and a data storage area, wherein the program storage area may store instructions for implementing an operating system, instructions for implementing at least one function (such as a touch function, a sound playback function, an image playback function, etc.), instructions for implementing the following various method embodiments, etc. The operating system may be an Android system, including a system deeply developed based on the Android system, an IOS system developed by Apple, including a system deeply developed based on the IOS system or other systems. The data storage area may also store data created by the electronic device during use, such as a phone book, audio and video data, chat record data, etc.

[0214] See also Fig.11As shown, the memory 120 can be divided into an operating system space and a user space. The operating system runs in the operating system space, and native and third-party applications run in the user space. In order to ensure that different third-party applications can achieve good operating results, the operating system allocates corresponding system resources to different third-party applications. However, different application scenarios in the same third-party application also have different requirements for system resources. For example, in the local resource loading scenario, the third-party application has higher requirements for disk reading speed; in the animation rendering scenario, the third-party application has higher requirements for GPU performance. The operating system and third-party applications are independent of each other, and the operating system often cannot perceive the current application scenario of the third-party application in a timely manner, resulting in the operating system being unable to perform targeted system resource adaptation according to the specific application scenario of the third-party application.

[0215] In order for the operating system to distinguish the specific application scenarios of third-party applications, it is necessary to open up data communication between third-party applications and the operating system so that the operating system can obtain the current scenario information of third-party applications at any time, and then perform targeted system resource adaptation based on the current scenario.

[0216] Taking the Android operating system as an example, the programs and data stored in the memory 120 are as follows: Fig.12As shown, the memory 120 may store a Linux kernel layer 320, a system runtime library layer 340, an application framework layer 360 and an application layer 380, wherein the Linux kernel layer 320, the system runtime library layer 340 and the application framework layer 360 belong to the operating system space, and the application layer 380 belongs to the user space. The Linux kernel layer 320 provides underlying drivers for various hardware of electronic devices, such as display drivers, audio drivers, camera drivers, Bluetooth drivers, Wi-Fi drivers, power management, etc. The system runtime library layer 340 provides major feature support for the Android system through some C / C++ libraries. For example, the SQLite library provides support for databases, the OpenGL / ES library provides support for 3D drawing, and the Webkit library provides support for browser kernels, etc. The system runtime library layer 340 also provides an Android runtime library (Android runtime), which mainly provides some core libraries, allowing developers to use Java language to write Android applications. The application framework layer 360 provides various APIs that may be used when building applications. Developers can also use these APIs to build their own applications, such as activity management, window management, view management, notification management, content provider, package management, call management, resource management, and location management. At least one application runs in the application layer 380. These applications can be native applications that come with the operating system, such as contact applications, text messaging applications, clock applications, camera applications, etc.; they can also be third-party applications developed by third-party developers, such as game applications, instant messaging applications, photo beautification applications, etc.

[0217] Taking the operating system as an IOS system as an example, the programs and data stored in the memory 120 are as follows: Fig.13As shown, the IOS system includes: a core operating system layer 420 (Core OS layer), a core service layer 440 (Core Services layer), a media layer 460 (Media layer), and a touchable layer 480 (Cocoa Touch Layer). The core operating system layer 420 includes the operating system kernel, drivers, and underlying program frameworks. These underlying program frameworks provide functions closer to the hardware for use by the program frameworks located in the core service layer 440. The core service layer 440 provides system services and / or program frameworks required by applications, such as the foundation framework, account framework, advertising framework, data storage framework, network connection framework, geographic location framework, motion framework, etc. The media layer 460 provides audio-visual interfaces for applications, such as graphics and image-related interfaces, audio technology-related interfaces, video technology-related interfaces, and wireless playback (AirPlay) interfaces for audio and video transmission technologies. The touchable layer 480 provides various commonly used interface-related frameworks for application development, and the touchable layer 480 is responsible for the user's touch interaction operations on electronic devices. For example, local notification service, remote push service, advertising framework, game tool framework, message user interface (UI) framework, user interface UIKit framework, map framework, etc.

[0218] exist Fig.13 Among the frameworks shown, the frameworks related to most applications include but are not limited to: the basic framework in the core service layer 440 and the UIKit framework in the touchable layer 480. The basic framework provides many basic object classes and data types, provides the most basic system services for all applications, and has nothing to do with UI. The classes provided by the UIKit framework are basic UI class libraries for creating touch-based user interfaces. iOS applications can provide UIs based on the UIKit framework, so it provides the basic architecture of applications for building user interfaces, drawing, processing and user interaction events, responding to gestures, etc.

[0219] Among them, the method and principle of implementing data communication between third-party applications and the operating system in the IOS system can be referred to the Android system, and this manual will not go into details here.

[0220] Among them, the input device 130 is used to receive input instructions or data, and the input device 130 includes but is not limited to a keyboard, a mouse, a camera, a microphone or a touch device. The output device 140 is used to output instructions or data, and the output device 140 includes but is not limited to a display device and a speaker. In one example, the input device 130 and the output device 140 can be combined, and the input device 130 and the output device 140 are touch screen displays, which are used to receive touch operations on or near the user using any suitable object such as a finger or a touch pen, and to display the user interface of each application. The touch screen display is usually set on the front panel of the electronic device. The touch screen display can be designed as a full screen, a curved screen or a special-shaped screen. The touch screen display can also be designed as a combination of a full screen and a curved screen, or a combination of a special-shaped screen and a curved screen, which is not limited in the embodiments of this specification.

[0221] In addition, those skilled in the art will understand that the structure of the electronic device shown in the above drawings does not constitute a limitation on the electronic device, and the electronic device may include more or fewer components than shown, or combine certain components, or arrange the components differently. For example, the electronic device also includes radio frequency circuits, input units, sensors, audio circuits, wireless fidelity (WiFi) modules, power supplies, Bluetooth modules and other components, which will not be described in detail here.

[0222] In the embodiments of this specification, the execution subject of each step may be the electronic device described above. Optionally, the execution subject of each step is the operating system of the electronic device. The operating system may be an Android system, an IOS system, or other operating systems, which is not limited in the embodiments of this specification.

[0223] The electronic device of the embodiment of this specification may also be equipped with a display device, which may be various devices capable of realizing display functions, such as cathode ray tube display (CR), light-emitting diode display (LED), electronic ink screen, liquid crystal display (LCD), plasma display panel (PDP), etc. The user may use the display device on the electronic device to view displayed text, images, videos and other information. The electronic device may be a smart phone, a tablet computer, a gaming device, an AR (Augmented Reality) device, a car, a data storage device, an audio playback device, a video playback device, a notebook, a desktop computing device, a wearable device such as an electronic watch, an electronic glasses, an electronic helmet, an electronic bracelet, an electronic necklace, electronic clothing and other devices.

[0224] exist Fig.10 In the electronic device shown, the processor 110 may be used to call an application stored in the memory 120 and specifically perform the following operations:

[0225] Obtain the multidimensional table generation prompt words input by the user;

[0226] Based on the multidimensional table generation prompt word, a table data stream generation process is performed through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data;

[0227] An initial multidimensional table management system is created based on the multidimensional table system structure data, and each of the table system field data is used to perform table update on the initial multidimensional table management system to obtain an updated multidimensional table management system.

[0228] In one embodiment, the processor 110 performs table data stream generation processing based on the multidimensional table generation prompt word through the multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data, creates an initial multidimensional table management system based on the multidimensional table system structure data, and uses each of the table system field data to perform table update on the initial multidimensional table management system, including:

[0229] Inputting the multidimensional table generation prompt words into the multidimensional table processing macro model;

[0230] Performing table structure generation processing through the multidimensional table processing large model to obtain multidimensional table system structure data, and creating an initial multidimensional table management system based on the multidimensional table system structure data;

[0231] The table data stream generation process is performed through the multi-dimensional table processing large model to obtain a plurality of table system field data, and the table of the initial multi-dimensional table management system is updated based on each of the table system field data.

[0232] In one embodiment, the processor 110 performs the table structure generation process by the multidimensional table processing large model to obtain the multidimensional table system structure data, including:

[0233] Determine the multidimensional table name and multidimensional table association information of the multidimensional table through the multidimensional table processing large model, and determine the table row and column information corresponding to each table in the multidimensional table;

[0234] Generate original multidimensional table system structure data based on the multidimensional table name, multidimensional table association information and table row and column information;

[0235] The original multidimensional table system structure data is packaged using a preset table system tool format to obtain multidimensional table system structure data.

[0236] In one embodiment, the processor 110 executes the step of creating an initial multidimensional table management system based on the multidimensional table system structure data, including:

[0237] The multidimensional table system structure data is sent to a table system tool service, and an initial multidimensional table management system is created by using the multidimensional table system structure data through the table system tool service.

[0238] In one embodiment, the processor 110 performs the table data stream generation process through the multidimensional table processing large model to obtain a plurality of table system field data, and updates the table of the initial multidimensional table management system based on each of the table system field data, including:

[0239] Performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data;

[0240] Performing field association stream processing based on the multidimensional field data through the multidimensional table processing large model to obtain multidimensional field association information, and performing association key mapping processing on the initial multidimensional table management system based on the multidimensional field association information;

[0241] The form metadata is obtained by performing form metadata streaming generation processing through the multi-dimensional table processing large model.

[0242] In one embodiment, the processor 110 performs the table field stream generation process based on the multidimensional table system structure data through the multidimensional table processing large model to obtain the multidimensional field data, including:

[0243] The multidimensional table processing big model performs table field stream generation processing based on the multidimensional table system structure data to obtain multiple newly added field tables, and determines the field name and field type corresponding to the newly added field table, and the table association information between the newly added field table and the original field table;

[0244] Multidimensional field data is generated based on the field name, field type and the table association information.

[0245] In one embodiment, the processor 110 performs the following operations when updating the initial multidimensional table management system based on each of the table system field data:

[0246] Packing the table system field data using a preset table system tool format to obtain the packaged table system field data;

[0247] The table system field data is sent to a table system tool service, and the table system field data is used by the table system tool service to update the table of the initial multidimensional table management system.

[0248] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing related hardware through a computer program, and the program can be stored in a computer-readable storage medium, and when the program is executed, it can include the processes of the embodiments of the above-mentioned methods. The storage medium can be a disk, an optical disk, a read-only storage memory, or a random access memory, etc.

[0249] The above disclosure is only the preferred embodiment of this specification, which certainly cannot be used to limit the scope of rights of this specification. Therefore, equivalent changes made according to the claims of this specification are still within the scope covered by this specification.

Claims

1. A multidimensional table processing method, characterized in that: The method comprises: Obtain the multidimensional table generation prompt words input by the user; Based on the multidimensional table generation prompt word, a table data stream generation process is performed through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data; Creating an initial multidimensional table management system based on the multidimensional table system structure data, and updating the table of the initial multidimensional table management system using each of the table system field data to obtain an updated multidimensional table management system; The method of generating prompt words based on the multidimensional table by using a multidimensional table processing large model to perform table data stream generation processing to obtain multidimensional table system structure data and multiple table system field data, creating an initial multidimensional table management system based on the multidimensional table system structure data, and using each of the table system field data to perform table update on the initial multidimensional table management system includes: Inputting the multidimensional table generation prompt words into the multidimensional table processing macro model; First round: the multidimensional table processing large model is used to generate the table structure to obtain the multidimensional table system structure data, and an initial multidimensional table management system is created based on the multidimensional table system structure data. The initial multidimensional table management system includes the basic framework of the multidimensional table, and the multidimensional table system structure data includes the multidimensional table name, multidimensional table association information, and table row and column information corresponding to each table in the multidimensional table. The initial multidimensional table management system defines the overall structure of the multidimensional table system at the corresponding stage for carrying the table system field data generated subsequently, and each of the multidimensional tables does not contain all the table system field data and form metadata. The multidimensional table name is the table name of each dimensional table, and the multidimensional table association information is the association relationship between each dimensional table. In each round after the first round: the multidimensional table processing large model is used to perform table data stream generation processing to obtain multiple table system field data, and the initial multidimensional table management system is updated based on each of the table system field data, wherein the multiple table system field data are the data outputted in each round after the output of the first round; The table system field data includes multidimensional field data, multidimensional field association information and form metadata, the table data stream generation processing is performed by the multidimensional table processing large model to obtain a plurality of table system field data, and the initial multidimensional table management system is updated based on each of the table system field data, including: Performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data; Performing field association stream processing based on the multidimensional field data through the multidimensional table processing large model to obtain multidimensional field association information, and performing association field key mapping processing on the initial multidimensional table management system based on the multidimensional field association information; The form metadata is stream-generated and processed by the multidimensional table processing large model to obtain the form metadata for the associated field key, and the form metadata is updated to the target table units of the multiple associated field tables corresponding to the associated field key in the initial multidimensional table management system.

2. The method according to claim 1, characterized in that The process of generating a table structure by using the multidimensional table processing large model to obtain multidimensional table system structure data includes: Determine the multidimensional table name and multidimensional table association information of the multidimensional table through the multidimensional table processing large model, and determine the table row and column information corresponding to each table in the multidimensional table; Generate original multidimensional table system structure data based on the multidimensional table name, multidimensional table association information and table row and column information; The original multidimensional table system structure data is packaged using a preset table system tool format to obtain multidimensional table system structure data.

3. The method according to claim 2, characterized in that The step of creating an initial multidimensional table management system based on the multidimensional table system structure data includes: The multidimensional table system structure data is sent to a table system tool service, and an initial multidimensional table management system is created by using the multidimensional table system structure data through the table system tool service.

4. The method according to claim 1, characterized in that: The multidimensional field association information defines the association relationship between the fields in the table and the fields in other tables and indicates how to establish the association relationship. The multidimensional field association information includes at least one of a foreign key relationship, a parent-child relationship and a reference relationship. The foreign key relationship includes the association relationship between the fields in the table and the primary key or foreign key in other tables. The parent-child relationship includes the relationship between the parent node and the child node in the hierarchical data. The reference relationship is whether the field in the table refers to a unique value in other tables. The associated field key mapping processing corresponding to the associated field key mapping processing includes at least one of a foreign key mapping operation, a reference relationship operation and a hierarchical relationship processing operation. The foreign key mapping operation includes adding a foreign key constraint to a field in a table to associate it with a primary key in another table. The reference relationship operation includes creating a reference constraint between fields in a multidimensional table management system. The hierarchical relationship processing operation is an operation for processing the relationship between parent and child tables.

5. The method according to claim 4, characterized in that The step of performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data includes: The multidimensional table processing big model performs table field stream generation processing based on the multidimensional table system structure data to obtain multiple newly added field tables, and determines the field name and field type corresponding to the newly added field table, and the table association information between the newly added field table and the original field table; Multidimensional field data is generated based on the field name, field type and the table association information.

6. The method according to claim 4, characterized in that The updating of table fields of the initial multidimensional table management system based on the multidimensional field data comprises: packaging the multidimensional field data in a preset table system tool format to obtain the packaged multidimensional field data, sending the multidimensional field data to a table system tool service, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data through the table system tool service; The performing of the associated field key mapping process on the initial multidimensional table management system based on the multidimensional field associated information comprises: packaging the multidimensional field associated information in a preset table system tool format to obtain the packaged multidimensional field associated information, sending the multidimensional field associated information to a table system tool service, and performing the associated field key mapping process on the initial multidimensional table management system based on the multidimensional field associated information through the table system tool service; The updating of the form metadata to the target table units of the multiple associated field tables corresponding to the associated field keys in the initial multidimensional table management system includes: packaging the form metadata in a preset table system tool format to obtain the packaged form metadata, sending the form metadata to a table system tool service, and updating the form metadata to the target table units of the multiple associated field tables corresponding to the associated field keys in the initial multidimensional table management system through the table system tool service.

7. A multidimensional table processing device, characterized in that: The device comprises: An input module, used to obtain a prompt word for generating a multidimensional table input by a user; A processing module, for performing table data stream generation processing based on the multidimensional table generation prompt word through a multidimensional table processing large model to obtain multidimensional table system structure data and multiple table system field data; A building module is used to create an initial multidimensional table management system based on the multidimensional table system structure data, and use each of the table system field data to update the table of the initial multidimensional table management system to obtain an updated multidimensional table management system; The method of generating prompt words based on the multidimensional table by using a multidimensional table processing large model to perform table data stream generation processing to obtain multidimensional table system structure data and multiple table system field data, creating an initial multidimensional table management system based on the multidimensional table system structure data, and using each of the table system field data to perform table update on the initial multidimensional table management system includes: Inputting the multidimensional table generation prompt words into the multidimensional table processing macro model; First round: the multidimensional table system structure data is obtained by performing table structure generation processing through the multidimensional table processing big model, and an initial multidimensional table management system is created based on the multidimensional table system structure data. The multidimensional table system structure data is the first round output of the multidimensional table processing big model. The initial multidimensional table management system includes the basic framework of the multidimensional table. The multidimensional table system structure data includes the multidimensional table name, multidimensional table association information, and table row and column information corresponding to each table in the multidimensional table. The initial multidimensional table management system defines the overall structure of the multidimensional table system at the corresponding stage for carrying the table system field data generated subsequently, and each of the multidimensional tables does not contain all the table system field data and form metadata. The multidimensional table name is the table name of each dimensional table, and the multidimensional table association information is the association relationship between each dimensional table. In each round after the first round: the multidimensional table processing large model is used to perform table data stream generation processing to obtain multiple table system field data, and the initial multidimensional table management system is updated based on each of the table system field data, wherein the multiple table system field data are the data outputted in each round after the output of the first round; The table system field data includes multidimensional field data, multidimensional field association information and form metadata, the table data stream generation processing is performed by the multidimensional table processing large model to obtain a plurality of table system field data, and the initial multidimensional table management system is updated based on each of the table system field data, including: Performing table field stream generation processing based on the multidimensional table system structure data through the multidimensional table processing large model to obtain multidimensional field data, and updating the table fields of the initial multidimensional table management system based on the multidimensional field data; Performing field association stream processing based on the multidimensional field data through the multidimensional table processing large model to obtain multidimensional field association information, and performing association field key mapping processing on the initial multidimensional table management system based on the multidimensional field association information; The form metadata is stream-generated and processed by the multidimensional table processing large model to obtain the form metadata for the associated field key, and the form metadata is updated to the target table units of the multiple associated field tables corresponding to the associated field key in the initial multidimensional table management system.

8. A computer storage medium, characterized in that: The computer storage medium stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the method steps as claimed in any one of claims 1 to 6.

9. An electronic device, characterized in that: include: A processor and a memory; wherein the memory stores a computer program, and the computer program is suitable for being loaded by the processor and executing the method steps as claimed in any one of claims 1 to 6.

Images