A modeling storage method, device and medium for electronic spreadsheet

Abstract

The present application discloses a modeling storage method, device and medium for an electronic table, the method comprising: receiving a modeling storage request for an electronic table, the electronic table being a non-modeling table storing business data; determining a first number of dimensions of the business data, dimension business data corresponding to the first number of dimensions, a second number of indicators and indicator business data corresponding to the second number of indicators according to the business type of the business data; generating a database table of the business data according to the first number of dimensions, the dimension business data, the second number of indicators and the indicator business data; selecting any cell in the electronic table, and determining the specified indicator and the specified dimension of the cell in the database table, binding the cell with the specified indicator and the specified dimension to model the electronic table. The method proposed in the present application can model and store the report, and decouple the report format from the business logic.

Description

Technical Field

[0001] The present application relates to the field of database tables, and in particular to a modeling storage method, device and medium for electronic tables. Background Art

[0002] When enterprises use online spreadsheet systems to report data, the style of the table needs to change as the business evolves. Due to the flexibility of the spreadsheet style, its two-dimensional structure is not enough to truly describe the business data model. The two-dimensional structure can be considered as non-modeled storage. This means that when the format or content of the spreadsheet is changed, query analysis, calculation formulas and other functions based on the table data need to be adjusted at the same time, which greatly increases the maintenance cost of the spreadsheet and reduces office efficiency.

[0003] Therefore, a more efficient electronic spreadsheet modeling storage method is urgently needed. Summary of the invention

[0004] In order to solve the above problems, the present application proposes a modeling storage method, device and medium for electronic spreadsheets, wherein the method includes:

[0005] A method for modeling a spreadsheet is provided. The method comprises: receiving a request for modeled storage of a spreadsheet, wherein the spreadsheet is a non-modeled spreadsheet storing business data; determining, according to a business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators; generating a database table of the business data according to the first number of dimensions, the dimensional business data, the second number of indicators, and the indicator business data; selecting any cell in the spreadsheet, determining a specified indicator and a specified dimension of the cell in the database table, and binding the cell to the specified indicator and the specified dimension to perform modeled storage on the spreadsheet.

[0006] In one example, generating a database table of the business data based on the first number of dimensions, the dimensional business data, the second number of indicators and the indicator business data specifically includes: setting the first number of dimensions to character format and creating them in a dimension database table; the dimension database table is provided with a dimension primary key column; merging the first number of dimensions as a unique index of the database table; setting the second number of indicators to floating point format or character format according to the data type of the indicator business data, and creating them in an indicator database table; if the number of indicators exceeds the set value of the indicator database table, establishing a sub-table to arrange the indicators; generating a primary key column of the indicator database table, and associating the main table of the indicator database table and the sub-table through the primary key column; generating a database table of the business data by merging the dimension database table and the indicator database table.

[0007] In one example, after determining, based on the business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators, the method further includes: describing, according to a preset indicator dictionary, physical properties and business properties corresponding to the second number of indicators; the physical properties include at least the library table name, field name, field type, and field length corresponding to the second data; the business attributes include at least one of the business number, business name, unit of measurement, remarks, and standard value benchmark corresponding to the second data.

[0008] In one example, after describing the physical properties and business properties corresponding to the second number of indicators, the method also includes: determining that the dimensional business data are all definite values; determining the calculation formula corresponding to any indicator in the database table according to the business type of the business data; the calculation formula is defined by combining multiple dimensions in the database table.

[0009] In one example, determining the calculation formula corresponding to any indicator in the database table specifically includes: determining multiple dimensions associated with any indicator in the first number of dimensions based on the physical properties of any indicator; determining the numerical relationship between the dimensional business data corresponding to the indicator and the multiple indicator business data corresponding to the multiple dimensions based on the business logic and the business properties of any indicator; and determining the calculation formula corresponding to any indicator through the numerical relationship.

[0010] In one example, after determining, according to the business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators, the method further includes: dividing the first number of dimensions into a first dimension, a second dimension, and a third dimension according to the dimensional business data; wherein the business data corresponding to the first dimension is discrete and bounded data; the second dimensional data is unbounded data; the business data corresponding to the third dimension can only be determined when the business occurs; obtaining dimensional information corresponding to the first dimension, the second dimension, and the third dimension respectively; and using the dimensional information as a query term to generate a query term set for the database table.

[0011] In one example, after using the dimension information and the business attributes as query terms to generate a query term set for the database table, the method further includes: receiving a query request for business data and obtaining a query phrase group contained in the query request; determining a query term group closest to the query phrase group in the query term set; determining a corresponding query dimension in the database table according to the query term group; and determining corresponding query data in the business data according to the query dimension.

[0012] In one example, the calculation formula is composed of four arithmetic expressions between basic functions in the database table; the basic functions include at least an indicator number acquisition function, a dimension number acquisition function and a cross-dimensional number acquisition function; the indicator number acquisition function is used to obtain the data corresponding to the indicator in the database table, the dimension number acquisition function is used to obtain the data corresponding to the specified dimension in the database table, and the cross-dimensional number acquisition function is used to obtain the data corresponding to the indicator under the corresponding dimension according to the specified indicator business data.

[0013] An embodiment of the present application also provides a modeled storage device for an electronic table, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute: receiving a modeled storage request for an electronic table, wherein the electronic table is a non-modeled table storing business data; determining, according to a business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators; generating a database table of the business data according to the first number of dimensions, the dimensional business data, the second number of indicators, and the indicator business data; selecting any cell in the electronic table, and determining a specified indicator and a specified dimension of the cell in the database table, binding the cell to the specified indicator and the specified dimension, so as to perform modeled storage on the electronic table.

[0014] The present application also provides a non-volatile computer storage medium storing computer executable instructions, characterized in that the computer executable instructions are configured to: receive a modeled storage request for a spreadsheet, wherein the spreadsheet is a non-modeled spreadsheet storing business data; determine, according to a business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators; generate a database table of the business data according to the first number of dimensions, the dimensional business data, the second number of indicators, and the indicator business data; select any cell in the spreadsheet, determine a specified indicator and a specified dimension of the cell in the database table, bind the cell to the specified indicator and the specified dimension, and store the spreadsheet in a modeled manner.

[0015] The method proposed in this application can store reports in a modeled manner and decouple the report format from the business logic, so that when the format of the electronic form changes, there is no need to maintain and adjust the internal data of the form, thereby reducing the maintenance cost of the electronic form, thereby increasing office efficiency and realizing modeled relational database storage of electronic forms. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0017] Figure 1 A schematic diagram of a flow chart of a modeling storage method for an electronic table in an embodiment of the present application;

[0018] Figure 2 It is a structural schematic diagram of a modeling storage device of an electronic table in an embodiment of the present application. DETAILED DESCRIPTION

[0019] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in combination with the specific embodiments of the present application and the corresponding drawings. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present application.

[0020] The technical solutions provided by various embodiments of the present application are described in detail below in conjunction with the accompanying drawings.

[0021] Figure 1 A flowchart of a modeling storage method for an electronic spreadsheet provided for one or more embodiments of this specification. The method can be applied to different types of business reports, such as company annual financial reports, e-commerce business reports, etc. The process can be executed by a computing device in the corresponding field (such as a system server or smart mobile terminal corresponding to financial business, etc.), and some input parameters or intermediate results in the process allow manual intervention and adjustment to help improve accuracy.

[0022] For ease of understanding and description, the following embodiments are described in detail using a server as an example.

[0023] It should be noted that the server may be a single device or a system consisting of multiple devices, that is, a distributed server, and this application does not make any specific limitation on this.

[0024] Since storing data in the form of models can help us separate the implementation of underlying technologies from the presentation of upper-level businesses, and more clearly see the intrinsic relationships between data, we can establish a comprehensive data perspective, eliminate information islands and data differentiation problems, and ensure data consistency. Therefore, this application improves work efficiency by modeling spreadsheet data to decouple the report format from business logic.

[0025] like Figure 1 As shown, the embodiment of the present application provides a modeling storage method of an electronic table, including:

[0026] S101: receiving a modeled storage request for an electronic form, where the electronic form is a non-modeled form storing business data.

[0027] First, obtain a spreadsheet that needs to be stored in a modeled manner, in which business data is stored. The above-mentioned business data and spreadsheet can be pre-stored in a storage device of a computer device. When the business data and spreadsheet need to be stored in a modeled manner, the computer device can select the business data and spreadsheet from the storage device. Of course, the computer device can also obtain the business data and spreadsheet from other external devices. For example, the business data and spreadsheet are stored in the cloud. When the business data and spreadsheet need to be stored in a modeled manner, the computer device can obtain the business data and spreadsheet from the cloud. This embodiment does not limit the method for obtaining feature data. At the same time, it is also possible that there is only business data, in which case a corresponding spreadsheet needs to be generated based on the business data.

[0028] S102: Determine, according to the business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators.

[0029] After clarifying the business data and spreadsheets that need to be modeled and stored, it is necessary to determine the first number of dimensions and the second number of indicators corresponding to the business data through the business type corresponding to the business data and the business logic corresponding to the business type or the header of the spreadsheet, as well as the dimension business data corresponding to the first number of dimensions and the indicator business data corresponding to the second number of indicators. Indicators are units and methods for measuring the development level of things. They usually require aggregation statistics such as summation and averaging to obtain them, and they are still under certain conditions. Dimensions refer to certain characteristics of things and phenomena, such as gender, region and time. To be more specific, dimension: that is, the angle of data observation. From what angle to analyze a problem (indicator) is called dimension. For example: the sales volume of brand A mobile phones in region A in 2019, sales volume is an indicator we want to look at, and dimensions are time dimension, regional dimension and product dimension. Indicators: are the specific objects and data we want to analyze, such as sales revenue, gross profit, procurement cost, per capita output and other numerical types are indicators.

[0030] S103: Generate a database table of the business data according to the first number of dimensions, the dimensional business data, the second number of indicators, and the indicator business data.

[0031] After obtaining the dimensions, indicators, dimensional business data, and indicator business data corresponding to the business data in the spreadsheet, a database table of the business data is generated. The database table here is a multidimensional data model in the physical sense, and in this multidimensional data model, the columns used as query conditions are dimensions, and the columns storing data are indicators. From a business perspective, all business data in the spreadsheet can be abstracted into two elements: dimensions and indicators for description.

[0032] S104: Select any cell in the electronic table, determine the designated index and the designated dimension of the cell in the database table, bind the cell with the designated index and the designated dimension, and store the electronic table in a modeled manner.

[0033] Since the electronic table is physically a two-dimensional structure with only row and column dimensions, the technical solution provided by the present invention allows the setting of a multidimensional data model, i.e., an indicator and multiple dimension information in a database table, on the cells of the electronic table, thereby realizing the description of the multidimensional data model for the cells in the two-dimensional table. The specific operation is: select any cell in the electronic table, determine the specified indicator and specified dimension corresponding to the cell in the database table, bind the cell to the determined specified indicator and specified dimension, and store the binding information of the cell and the database table in the cell information in a json structure.

[0034] In one embodiment, after obtaining a first number of dimensions, dimension business data, a second number of indicators, and indicator business data, when generating a database table, the specific operations are as follows: the dimension is created as a character type, and all dimensions are combined as a unique index, all dimension columns are created in the dimension database table, and the dimension database table has a primary key column. The indicator is converted into a floating point type or a character type according to the data type to form a column in the indicator database table. If the number of columns exceeds the set value of the database table, a second sub-table is established to continue to arrange the indicator columns, and a primary key column is formed by default. The main table and the sub-table of the indicator database table are associated using the primary key column. By merging the dimension database table and the indicator database table, a database table for business data is generated.

[0035] In one embodiment, when the number of indicators is too large, the staff is prone to confuse the meaning of the indicators, thereby increasing the probability of error. Based on this, after obtaining the second number of indicators and indicator business data, the physical properties and business properties can be described through the indicator dictionary according to the indicator dictionary. The physical properties include the library table name, field name, field type, and field length that carry the indicator data. Business attributes include business number, business name, unit of measurement, remarks, standard value benchmark, etc. By adding descriptions of physical properties and business attributes to the indicators, confusion of meaning can be prevented when the number of indicators is large, thereby increasing the accuracy of the work.

[0036] Furthermore, in a spreadsheet, a part of the data can be obtained by performing fixed operations on other data, that is, the spreadsheet includes the function of setting calculation formulas. However, since most of the functions of the calculation formula are to locate the data based on the position of the data in the table, when the format or content of the table changes, it is easy to cause disorder of functions such as the calculation formula, thereby increasing the maintenance cost of the spreadsheet. Based on this, the present application is provided with a database table to decouple the report format from the business logic. Each indicator in the database table is based on the business logic corresponding to the business type, so as to define the calculation formula according to different dimensional combinations. When determining the calculation formula corresponding to any indicator in the database table, the prerequisite for being able to perform the calculation is that each dimension of the multidimensional data model is given a definite value.

[0037] Furthermore, when determining the calculation formula corresponding to any indicator in the database table, it is first necessary to determine multiple dimensions associated with any indicator in the first number of dimensions based on the physical properties of any indicator; then, based on the business logic and the business properties of any indicator, determine the numerical relationship between the dimensional business data corresponding to the indicator and the multiple indicator business data corresponding to the multiple dimensions; and determine the calculation formula corresponding to any indicator through the numerical relationship.

[0038] Furthermore, when determining the calculation formula corresponding to any indicator in the database table, the prerequisite for executing the calculation is that each dimension of the multidimensional data model is given a definite value. This set of definite values ​​is called the calculation context. The engine supports three basic functions, namely the indicator retrieval function, the syntax is IND (indicator number), this function can get the indicator specified in the calculation context; dimension retrieval function DIM (dimension attribute), get the value of the specified dimension attribute in the current calculation context. The cross-dimensional retrieval function INDF has the syntax of INDF (indicator number, dimension condition 1, dimension condition 2), which is used to retrieve the data of the indicator under the corresponding dimension according to the dimension value specified in the parameter. Nesting is allowed between multiple functions, and the syntax of dimension conditions is the same as the syntax of where conditions in SQL statements, which are converted into real SQL execution retrieval during calculation.

[0039] In one embodiment, since ordinary electronic forms are affected by changes in the table format when querying data of specified indicators, this application sets a database table so that cells are bound to a multidimensional data model, which can avoid the impact of changes in the format of electronic forms on query data. Therefore, after determining each dimension and indicator, the first number of dimensions must first be divided into a first dimension, a second dimension, and a third dimension according to the dimensional business data; wherein the business data corresponding to the first dimension is discrete and bounded data, that is, an enumerable dimension, such as all accounting units of a certain group, all products of a certain brand, etc., and its dimension member values ​​are discrete and bounded. The second dimension data is unbounded data, such as year, date, etc., whose dimension member values ​​have no upper or lower bounds but have certain rules. The business data corresponding to the third dimension can only be determined when the business occurs, that is, a dynamic dimension, such as a construction project, a contract number, and a dimension whose dimension member values ​​can only be determined when the business occurs. It should be noted that different dimensions are subject to different restrictions.

[0040] Among them, for the first dimension, when defining dimension attributes, the dimension management tool configures by specifying the enumeration dictionary in the system. The dimension member values ​​are stored in the enumeration dictionary, which is called standard coding in the system. For the second dimension, the system's date control, year control, etc. are used for restrictions, and the controls are converted to characters using a fixed format. For the third dimension, there is no restriction on dimension members, and all dimensions on the model can be entered at any time when filling in the report. This type of dimension cannot be bound to indicators after binding the report cell, and can only be bound to the header area of ​​the report.

[0041] Furthermore, after the dimensions are divided into three types, in order to query the business data in the spreadsheet through the database table, a query vocabulary set needs to be generated. At this time, the dimension information corresponding to the first dimension, the second dimension, and the third dimension, that is, the dimension name, needs to be obtained respectively; and the dimension information is used as the query vocabulary to generate the query vocabulary set of the database table.

[0042] Furthermore, after generating the query vocabulary set of the database table, when querying the business data, it is first necessary to receive a query request for the business data and obtain the query phrase group contained in the query request; determine the query vocabulary group closest to the query phrase group in the query vocabulary set; determine the corresponding query dimension in the database table according to the query vocabulary group; and finally determine the corresponding query data in the business data according to the query dimension.

[0043] like Figure 2 As shown, the embodiment of the present application also provides a model storage device for an electronic form, including: at least one processor; and a memory connected to the at least one processor in communication; wherein,

[0044] The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to:

[0045] A method for modeling a spreadsheet is provided. The method comprises: receiving a request for modeled storage of a spreadsheet, wherein the spreadsheet is a non-modeled spreadsheet storing business data; determining, according to a business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators; generating a database table of the business data according to the first number of dimensions, the dimensional business data, the second number of indicators, and the indicator business data; selecting any cell in the spreadsheet, determining a specified indicator and a specified dimension of the cell in the database table, and binding the cell to the specified indicator and the specified dimension to perform modeled storage on the spreadsheet.

[0046] The embodiment of the present application further provides a non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured as follows:

[0047] A method for modeling a spreadsheet is provided. The method comprises: receiving a request for modeled storage of a spreadsheet, wherein the spreadsheet is a non-modeled spreadsheet storing business data; determining, according to a business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators; generating a database table of the business data according to the first number of dimensions, the dimensional business data, the second number of indicators, and the indicator business data; selecting any cell in the spreadsheet, determining a specified indicator and a specified dimension of the cell in the database table, and binding the cell to the specified indicator and the specified dimension to perform modeled storage on the spreadsheet.

[0048] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device and medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.

[0049] The devices and media provided in the embodiments of the present application correspond one-to-one to the methods. Therefore, the devices and media also have similar beneficial technical effects as the corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be repeated here.

[0050] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0051] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0052] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0053] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0054] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0055] The memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0056] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0057] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0058] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A method for storing electronic forms in a modeled manner, characterized in that: include: receiving a modeled storage request for an electronic form, wherein the electronic form is a non-modeled form storing business data; Determine, according to the business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators; Generate a database table of the business data according to the first number of dimensions, the dimensional business data, the second number of indicators, and the indicator business data; Select any cell in the electronic table, determine a specified index and a specified dimension of the cell in the database table, bind the cell with the specified index and the specified dimension, and store the electronic table in a modeled manner; The generating a database table of the business data according to the first number of dimensions, the dimension business data, the second number of indicators, and the indicator business data specifically includes: The first number of dimensions are set to character format and created in a dimension database table; the dimension database table is provided with a dimension primary key column; Merging the first number of dimensions as a unique index of the database table; According to the data type of the indicator business data, the second number of indicators are set to a floating point format or a character format, and are created in an indicator database table; If the number of the indicators exceeds the set value of the indicator database table, a sub-table is created to arrange the indicators; Generate a primary key column of the indicator database table, and associate the main table of the indicator database table and the sub-table through the primary key column; The database table of the business data is generated by merging the dimension database table and the indicator database table.

2. The method according to claim 1, characterized in that After determining, according to the business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators, the method further includes: According to a preset indicator dictionary, the physical attributes and business attributes corresponding to the second number of indicators are described; the physical attributes include at least the library table name, field name, field type, and field length corresponding to the indicator business data; the business attributes include at least one of the business number, business name, unit of measurement, remarks, and standard value benchmark corresponding to the indicator business data.

3. The method according to claim 2, characterized in that After describing the physical attributes and business attributes respectively corresponding to the second number of indicators, the method further includes: Determine that the dimensional business data are all definite values; According to the business type of the business data, a calculation formula corresponding to any indicator in the database table is determined; the calculation formula is defined by combining multiple dimensions in the database table.

4. The method according to claim 3, characterized in that The determining of the calculation formula corresponding to any indicator in the database table specifically includes: According to the physical property of the any indicator, determining a plurality of dimensions associated with the any indicator in the first number of dimensions; Determine, according to the business logic and the business attribute of any one of the indicators, a numerical relationship between the dimension business data corresponding to the indicator and the plurality of indicator business data corresponding to the plurality of dimensions; The calculation formula corresponding to any one of the indicators is determined through the numerical relationship.

5. The method according to claim 2, characterized in that: After determining, according to the business type of the business data, a first number of dimensions of the business data, dimensional business data corresponding to the first number of dimensions, a second number of indicators, and indicator business data corresponding to the second number of indicators, the method further includes: According to the dimensional business data, the first number of dimensions are divided into a first dimension, a second dimension and a third dimension; wherein the business data corresponding to the first dimension is discrete and bounded data; the second dimensional data is unbounded data; and the business data corresponding to the third dimension can only be determined when the business occurs; Obtaining dimension information corresponding to the first dimension, the second dimension, and the third dimension respectively; The dimension information is used as a query term to generate a query term set for the database table.

6. The method according to claim 5, characterized in that After the dimension information and the business attributes are used as query terms to generate a query term set for the database table, the method further includes: Receiving a query request for business data, and obtaining a query phrase group contained in the query request; Determining a query word group closest to the query phrase group in the query word set; Determining a corresponding query dimension in the database table according to the query vocabulary group; According to the query dimension, corresponding query data is determined in the business data.

7. The method according to claim 3, characterized in that The calculation formula is composed of four arithmetic expressions between basic functions in the database table; The basic functions include at least an indicator retrieval function, a dimension retrieval function and a cross-dimensional retrieval function; the indicator retrieval function is used to obtain the data corresponding to the indicator in the database table, the dimension retrieval function is used to obtain the data corresponding to the specified dimension in the database table, and the cross-dimensional retrieval function is used to obtain the data corresponding to the indicator under the corresponding dimension according to the specified indicator business data.

8. A modeling storage device for an electronic table, characterized in that: include: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform: the steps of the method according to any one of claims 1 to 7.

9. A non-volatile computer storage medium storing computer executable instructions, characterized in that: The computer executable instructions are configured to execute the steps of the method according to any one of claims 1 to 7.

Images