CN114356965A - Dynamic form generation method, system, server and storage medium - Google Patents
Dynamic form generation method, system, server and storage medium Download PDFInfo
- Publication number
- CN114356965A CN114356965A CN202210266677.4A CN202210266677A CN114356965A CN 114356965 A CN114356965 A CN 114356965A CN 202210266677 A CN202210266677 A CN 202210266677A CN 114356965 A CN114356965 A CN 114356965A
- Authority
- CN
- China
- Prior art keywords
- target
- dynamic form
- preselected
- table set
- generating
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a method, a system, a server and a storage medium for generating a dynamic form, and relates to the technical field of computers. The method comprises the steps of receiving a dynamic form query request initiated by terminal equipment; screening the preselected dimensions according to the incidence relation of the preselected dimensions in the dynamic form query request to obtain target dimensions; determining a target table set according to the target dimension, the preselected index, the aggregation algorithm and the filtering condition; generating a target data query instruction according to the target table set; and generating a dynamic form according to the target data query instruction, and sending the dynamic form to the terminal equipment. The method and the device can automatically screen and optimize the dynamic form query request initiated by a user and generate a target data query instruction, thereby avoiding errors caused by manually writing codes and improving the efficiency of data query.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, a system, a server, and a storage medium for generating a dynamic form.
Background
A Data Warehouse (DW or DWH for short) is a structured Data environment for decision support systems and online analysis of application Data sources. Compared with a transaction-oriented database, the data warehouse focuses more on data analysis, can support enterprise-level complex analysis operation and data decision, and can provide intuitive and understandable query results for users. Since various physical tables with huge data size and complicated relationships are generally stored in a data warehouse, how to improve the efficiency of data query and storage in data analysis becomes a problem that developers of the data warehouse must pay attention to.
At present, when a user performs custom query on a data warehouse, in order to improve the efficiency of performing custom analysis on data stored in the data warehouse, a developer usually designates a certain physical table in the data warehouse as a query main table, designs a plurality of large-width tables containing a plurality of fields at the same time, and determines a query result by performing query association on the fields in other large-width tables and the main table. Therefore, excessive associated operations in query normal mode operation can be reduced, and parallelization of processing is realized, so that the query efficiency of data is improved.
However, as the amount of information stored in the data warehouse increases, the number of large-width tables accumulated in the data warehouse also increases, and the large-width tables have large data volume and complex business logic, so that the occupation of storage and computing resources increases. In this case, the query result may be obtained by a developer through a query instruction written in a wide table, and the query result may be incorrect due to logic complexity. In addition, because a large number of dependencies exist among fields of the large-width tables, instability among the large-width tables is transmitted progressively, and the stability of the data warehouse is further reduced.
Disclosure of Invention
The object of the present application includes, for example, providing a method, a system, a server and a storage medium for generating a dynamic form, which can automatically screen and optimize a dynamic form query request initiated by a user, and generate a target data query instruction, thereby avoiding an error caused by manually writing a code, and improving the efficiency of data query.
The embodiment of the application can be realized as follows:
in a first aspect, the present application provides a method for generating a dynamic form, where the method includes:
receiving a dynamic form query request initiated by a terminal device, wherein the dynamic form query request comprises: a plurality of preselected dimensions, a plurality of preselected indicators, an aggregation algorithm for the plurality of preselected indicators, and a filtering condition;
screening the preselected dimensions according to the incidence relation of the preselected dimensions in the dynamic form query request to obtain target dimensions;
determining a target table set according to the target dimension, the preselected indicator, the aggregation algorithm, and the filtering condition, the target table set comprising: at least one physical table including fields having direct associations with the target dimension, the aggregation algorithm, the filter condition, and the preselected metric;
generating a target data query instruction according to the target table set;
and generating a dynamic form according to the target data query instruction, and sending the dynamic form to the terminal equipment.
In an alternative embodiment, the determining a target table set according to the target dimension, the preselected metric, the aggregation algorithm, and the filtering condition includes:
determining a plurality of physical tables in which the target dimension, the preselected index, the aggregation algorithm and the filtering condition are located according to the target dimension, the preselected index, the aggregation algorithm and the filtering condition;
determining a plurality of table sets to be selected according to a plurality of physical tables, wherein each table set to be selected comprises at least one physical table, and each physical table comprises fields which have association relations with the target dimension, the preselected index, the aggregation algorithm and the filtering condition;
and selecting one table set to be selected from the plurality of table sets to be selected as a target table set according to a preset evaluation strategy.
In an optional implementation manner, the determining, according to a plurality of physical tables, a plurality of sets of tables to be selected includes:
and carrying out permutation and combination on the plurality of physical tables to determine a plurality of table sets to be selected.
In an optional implementation manner, the selecting, according to a preset evaluation policy, one table set to be selected from the multiple table sets to be selected as a target table set includes:
according to the feature information of each table set to be selected, scoring the plurality of table sets to be selected respectively to obtain scores corresponding to the plurality of table sets to be selected, wherein the feature information comprises at least one of the following items: the number, the depth and the aggregation complexity of the physical tables in the table set to be selected;
and using a Monte Carlo algorithm to cooperate the table set to be selected corresponding to the highest score in all the scores as a target table set.
In an optional implementation, the association relationship includes: containment relationships and/or dependency relationships.
In an optional implementation manner, the generating a target data query instruction according to the target table set includes:
generating an initial data query instruction according to the target table set, wherein the initial data query instruction comprises: query statement and calculation formula of the target dimension and the preselected index;
and optimizing the initial data query instruction to obtain the target data query instruction.
In an optional implementation manner, the optimizing the initial data query instruction to obtain the target data query instruction includes:
simplifying the connection path of the query statement in the initial data query instruction to obtain the simplified query statement, and taking the simplified query statement as the query statement in the target data query instruction;
determining a plurality of pre-calculated indexes according to the pre-selected indexes;
according to the pre-calculation index, optimizing the target dimension and the calculation formula of the pre-selection index to obtain a processed calculation formula;
and selecting a target formula from the processed calculation formulas according to the characteristic information of the target dimension, and taking the target formula as the calculation formula in the target data query instruction.
In a second aspect, the present application provides an apparatus for generating a dynamic form, including:
a receiving module, configured to receive a dynamic form query request initiated by a terminal device, where the dynamic form query request includes: a plurality of preselected dimensions, a plurality of preselected indicators, an aggregation algorithm for the plurality of preselected indicators, and a filtering condition.
And the processing module is used for screening the preselected dimensions according to the incidence relation of the preselected dimensions in the dynamic form query request to obtain target dimensions.
A determining module, configured to determine a target table set according to the target dimension, the preselected indicator, the aggregation algorithm, and the filtering condition, where the target table set includes: at least one physical table including fields having direct associations with the target dimension, the aggregation algorithm, the filter condition, and the preselected metric.
And the generating module is used for generating a target data query instruction according to the target table set.
The generating module is further used for generating a dynamic form according to the target data query instruction and sending the dynamic form to the terminal equipment.
The determining module is further specifically configured to determine, according to the target dimension, the preselected indicator, the aggregation algorithm, and the filtering condition, a plurality of physical tables in which the target dimension, the preselected indicator, the aggregation algorithm, and the filtering condition are located; determining a plurality of table sets to be selected according to a plurality of physical tables, wherein each table set to be selected comprises at least one physical table, and each physical table comprises fields which have association relations with the target dimension, the preselected index, the aggregation algorithm and the filtering condition; and selecting one table set to be selected from the plurality of table sets to be selected as a target table set according to a preset evaluation strategy.
The determining module is further specifically configured to perform permutation and combination on the plurality of physical tables to determine a plurality of table sets to be selected.
The determining module is further specifically configured to score the multiple to-be-selected table sets according to feature information of each to-be-selected table set, so as to obtain scores corresponding to the multiple to-be-selected table sets, where the feature information includes at least one of the following items: the number, the depth and the aggregation complexity of the physical tables in the table set to be selected; and using a Monte Carlo algorithm to cooperate the table set to be selected corresponding to the highest score in all the scores as a target table set.
The processing module is further specifically configured to, the association relationship includes: containment relationships and/or dependency relationships.
The generating module is further specifically configured to generate an initial data query instruction according to the target table set, where the initial data query instruction includes: query statement and calculation formula of the target dimension and the preselected index; and optimizing the initial data query instruction to obtain the target data query instruction.
The generating module is further specifically configured to simplify a connection path of the query statement in the initial data query instruction to obtain the simplified query statement, and use the simplified query statement as the query statement in the target data query instruction; determining a plurality of pre-calculated indexes according to the pre-selected indexes; according to the pre-calculation index, optimizing the target dimension and the calculation formula of the pre-selection index to obtain a processed calculation formula; and selecting a target formula from the processed calculation formulas according to the characteristic information of the target dimension, and taking the target formula as the calculation formula in the target data query instruction.
In a third aspect, the present application provides a system for generating a dynamic form, the system comprising: the system comprises a plurality of terminal devices and a server, wherein the terminal devices are respectively in communication connection with the server;
the terminal equipment is used for initiating a dynamic form query request to the server and receiving a dynamic form sent by the server;
the server is configured to store data in a metadata manner and execute the steps of the method for generating a dynamic form according to any one of the preceding embodiments.
In a fourth aspect, the present application provides a server, comprising: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory communicating via the bus when the server is running, the processor executing the machine-readable instructions to perform the steps of the method of generating a dynamic form according to any of the preceding embodiments.
In a fifth aspect, the present application provides a computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, implements the steps of the method for generating a dynamic form according to any one of the preceding embodiments.
The beneficial effects of the embodiment of the application include:
by adopting the method, the system, the server and the storage medium for generating the dynamic form, firstly, the method optimizes a plurality of pre-dimensionalities according to the dynamic form request of a user, and then automatically generates a target data query instruction according to a determined target table set to obtain a dynamic form result. Compared with a large-width table, the data volume in the target table set is less, the calculation logic is clear, and the server can quickly obtain the dynamic form. Moreover, the target data query instruction is automatically generated by the server, and errors caused by manually writing codes are avoided. Secondly, each physical table is not in the form of a large-width table during design and storage, and negative effects of instability transfer among the physical tables on the system are avoided.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.
Fig. 1 is a schematic structural diagram of a dynamic form generation system provided in an embodiment of the present application;
fig. 2 is a schematic flowchart illustrating steps of a method for generating a dynamic form according to an embodiment of the present application;
fig. 3 is a flowchart illustrating another step of a method for generating a dynamic form according to an embodiment of the present application;
fig. 4 is a flowchart illustrating another step of a method for generating a dynamic form according to an embodiment of the present application;
fig. 5 is a flowchart illustrating another step of a method for generating a dynamic form according to an embodiment of the present application;
fig. 6 is a flowchart illustrating another step of a method for generating a dynamic form according to an embodiment of the present application;
fig. 7 is a schematic structural diagram of a dynamic form generation apparatus according to an embodiment of the present application;
fig. 8 is a schematic structural diagram of a server according to an embodiment of the present application.
Icon: 1011-a first terminal device; 1012-a second terminal device; 1013-nth terminal device; 10-a dynamic form generating device; 1001-receiving module; 1002-a processing module; 1003-determination module; 1004-a generation module; 102-a server; 2001-a processor; 2002-memory.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.
Furthermore, the appearances of the terms "first," "second," and the like, if any, are used solely to distinguish one from another and are not to be construed as indicating or implying relative importance.
It should be noted that the features of the embodiments of the present application may be combined with each other without conflict.
The large-width table is a database table containing many fields, and is usually a database table formed by associating many fields related to a certain index. In order to improve the query performance, different fields are put into the same table for storage in the large-width table, and with the increase of the data volume, the problem of data redundancy is caused, so that a large burden is brought to query and storage of a data warehouse. In addition, because the business logic in the data warehouse stored in the form of the large broad table is complex, developers who need to write query instructions have clear and overall understanding of the dependency relationship among the large broad tables. Moreover, even with such knowledge, because too much information and elements need to be paid attention to each time the index is extracted, it is inevitable that an instruction is written by a person in a wrong manner, resulting in an error in the result of the finally generated dynamic form.
Based on the above problems, the applicant has developed a method, a system, a server, and a storage medium for generating a dynamic form, which can optimize a plurality of preselected dimensions in a dynamic form query request, and automatically generate a target data query instruction according to a determined target table set, thereby obtaining a dynamic form result. Compared with a large-width table, the data volume in the target table set is less, the calculation logic is clear, and the server can quickly obtain the dynamic form. Moreover, the target data query instruction is automatically generated by the server, and errors caused by manually writing codes are avoided.
The following explains a method, a system, a server and a storage medium for generating a dynamic form according to an embodiment of the present application with reference to a plurality of specific application examples.
Fig. 1 is a schematic structural diagram of a dynamic form generation system provided in an embodiment of the present application, and as shown in fig. 1, the dynamic form generation system includes: a plurality of terminal devices, and a server 102, wherein the plurality of terminal devices are respectively connected with the server 102 in a communication way.
Alternatively, the plurality of terminal devices may include a plurality of terminal devices such as a first terminal device 1011, a second terminal device 1012 …, an nth terminal device 1013, and the like, each terminal device may be an entity device interacting with a user, and the user may log in a dynamic form generation system through a certain terminal device, initiate a dynamic form query request to the server 102 through the terminal device, and receive a dynamic form sent by the server 102. The terminal device may be a mobile phone, a tablet computer, a desktop computer, a notebook computer, or other devices in various forms, which is not limited in this application.
The server 102 may be a remote device with computing processing capabilities, such as a cloud server. Specifically, the server 102 is configured to store data in a metadata manner and execute the steps of the method for generating a dynamic form in the following embodiments.
The metadata may be an electronic catalog, which is data for describing data, or structural data for providing certain resource-related information, and describes information such as all dimensions and indexes supported by the data warehouse, dimensions and indexes contained in each physical table, a blood relationship between the dimensions and the indexes, and a polymerization algorithm supportable by each index. The server 102 may read the physical addresses of the dimensions and the index by reading the configuration information, and further obtain the data.
It should be noted that a dimension is a point of view for describing something, and depends on an index for describing attributes or features of data, for example, a year is a time dimension, and a place is a geographic dimension. The index is a value or a ratio, and is obtained through some calculation to measure the service. Such as order volume, goodness, revenue growth, etc.
Next, the operation of the dynamic form generation system will be described by taking the interaction between the first terminal device 1011 and the server 102 as an example.
The user inputs information such as a plurality of preselected dimensions and preselected indexes through the first terminal device 1011, and the first terminal device 1011 generates a corresponding dynamic form query request according to the information input by the user and sends the request to the server 102.
After receiving the dynamic form query request sent by the first terminal device 1011, the server 102 first performs preliminary screening on the preselected dimensions contained therein, and removes the columns containing the relationship or the dependency relationship among the dynamic form requests, so as to obtain the target dimensions.
Then, the server 102 may determine the plurality of physical tables in which it is located by using the target dimension and the preselected index in the dynamic form query request. Since the data of the index is obtained by performing data calculation through the same physical table, for example, the monthly total order quantity may be from the accumulation of the order quantities of different users in the user information table, and may also be from the accumulation of the sold order quantities of different sales in the sales performance table, so that there may be a plurality of combinations of the physical tables corresponding to each index. By arranging and combining the obtained multiple physical tables, the server 102 determines multiple table sets to be selected, and data contained in each table set to be selected can be calculated according to target dimensions on corresponding data in the physical tables to obtain preselected indexes.
And then, scoring the table sets to be selected respectively according to the characteristic information by using a Monte Carlo algorithm for the plurality of table sets to be selected, and determining corresponding scores for each table set to be selected. Wherein, the characteristic information may include: the number, depth and aggregation complexity of the physical tables in the table set to be selected. And then, after the scores of all the table sets to be selected are obtained, the table sets to be selected with the highest scores are combined into the target table.
Then, the server 102 may generate an initial data query instruction according to the obtained target table set, where the initial data query instruction includes a query statement, for example, a lookup, a connection, and the like for each physical table, and the initial data query instruction further includes: the target dimension and the calculation formula of the preselected index, for example, when the target dimension is year and the preselected index is number of users, the total number of users in year can be obtained by performing cumulative calculation on fields related to the number of users in year in the physical table through the calculation formula prestored in the server 102.
Further, the server 102 may optimize the query statement in the initial data query instruction and the calculation formulas of the target dimension and the preselected index, respectively. For the query statement, whether the connection path can be shortened or not can be determined by searching for the redundant fields to be obtained in the connected physical tables between the connected physical tables and in the main connected physical table, so that the query statement is optimized. For the calculation formula, the calculation speed of the server 102 can be increased by reading the pre-calculated index and reading the data in the physical table according to the data granularity of the dimension. After the optimization process, the server 102 obtains the target data query instruction.
Finally, the server 102 may read data from the physical table through the target data query instruction, perform calculation to obtain a dynamic form, and send the dynamic form to the first terminal device 1011.
Fig. 2 is a flowchart of steps of a method for generating a dynamic form according to an embodiment of the present application, where an execution subject of the method may be a server in a system for generating a dynamic form according to the foregoing embodiment, and the server may be a cloud server with computing processing capability. As shown in fig. 2, the method includes the following steps.
S201, receiving a dynamic form inquiry request initiated by a terminal device.
Wherein, the dynamic form inquiry request comprises: a plurality of preselected dimensions, a plurality of preselected indicators aggregation algorithm and a filtering condition.
For example, for an order system, the dimension may be a geographic dimension or a time dimension corresponding to a region where the user is located, and the index information may be a rating rate, an order growth rate, a total amount, and the like of the user.
Optionally, the user may also add more data analysis conditions to the dynamic form query request, for example, an aggregation algorithm of each index, a filtering condition, and the like. The index aggregation algorithm is a calculation method for a certain index, and may be a method such as an average value, a maximum value, and a minimum value. For example, when calculating the revenue amount of nearly 3 months, if the aggregation algorithm of the index is an average value, a single-month average value may be obtained for the total revenue amount of the 3 months as the calculation result of the index. The filtering condition may refer to an item that needs to be removed or retained when a certain index is calculated, for example, only the total amount of orders of a certain user is calculated, or the amount of performance of a certain department is removed when the total amount of performance is calculated.
Of course, the user may also add other data analysis conditions to the dynamic form query request, which is not limited herein.
After the user completes the selection of the data analysis conditions, the terminal device can pack the data analysis conditions into a dynamic form query request and send the dynamic form query request to the server.
S202, screening the preselected dimensions according to the incidence relation of the preselected dimensions in the dynamic form query request to obtain the target dimensions.
After receiving the dynamic form inquiry request, the server can analyze the dynamic form inquiry request and extract the preselected dimension and the preselected index. Since the association relationship between the dimensions may not be clear when the user selects the dimensions, the preselected dimensions may include the dimensions having the association relationship. For example, the preselected dimensions include two dimensions of a commodity name and a commodity brand, but the commodity brand is a sub-category of the commodity name, and the server can directly perform aggregation operation according to the commodity brand to obtain the commodity name. At this point, the name of the item can be removed from the preselected dimension.
After the screening process, the server can obtain the target dimension.
S203, determining a target table set according to the target dimension, the preselected index, the aggregation algorithm and the filtering condition.
Wherein the target table set comprises: at least one physical table including fields directly associated with the target dimension, the aggregation algorithm, the filter condition, and the preselected metric.
And according to the dynamic form query request, pre-screening a plurality of physical tables in the data warehouse, and determining a physical table set as a target table set. It should be noted that, through the calculation of the target dimension, the preselected index, the aggregation algorithm, and the filtering condition, the fields directly associated with the target dimension, the preselected index, the aggregation algorithm, and the filtering condition may be determined, and then the physical tables directly associated with the fields are found to form the target table set. Specifically, the target table set may include one or more physical tables, which are directly associated with fields corresponding to the aggregation algorithm, the filtering condition, and the preselected metric, and the result of the preselected metric can be obtained directly from the physical tables of the target table set under the data analysis conditions of the filtering condition, the aggregation algorithm, and the target dimension. That is, the target table set includes the physical table in which the field corresponding to the most resource-saving calculation and storage method for calculating the preselected index is located.
And S204, generating a target data query instruction according to the target table set.
And after determining the target table set, the server automatically generates a corresponding target data query instruction according to the target table set. It can be understood that, when databases where physical tables in the data warehouse are located are different, the generated target data query instructions are different, the server may generate corresponding target data query instructions according to the corresponding languages according to the databases where the physical tables are located, and the same target data query instruction may include query instructions in different languages to respectively execute the query instructions to obtain query results.
And S205, generating a dynamic form according to the target data query instruction, and sending the dynamic form to the terminal equipment.
Through the target data query instruction, the server can obtain a physical table required by the calculation of the corresponding preselected indexes under the condition of a plurality of target dimensions, a plurality of aggregation algorithms of the preselected indexes and filtering conditions required by the user.
And the server executes the target data query instruction, generates a dynamic form and sends the dynamic form to the terminal equipment to be displayed to the user. The dynamic form may be a result display page generated according to a dynamic form query request initiated by a user, and data in the dynamic form query request may be displayed on the dynamic form in a manner of numbers, curves, tables, statistical graphs, and the like, which is not limited to this.
In this embodiment, the dynamic form request of the user can be automatically optimized, and the target data query instruction is automatically generated according to the optimized dynamic form request, so as to obtain a dynamic form result. The optimized dynamic form requests have the advantages that the data quantity required to be acquired is reduced, the calculation logic is clearer, and the calculation efficiency of the server is improved. Moreover, the target data query instruction is automatically generated by the server, and errors caused by manually writing codes are avoided.
Alternatively, as shown in fig. 3, in the step S203, the target table set is determined according to the target dimension, the preselected index, the aggregation algorithm and the filtering condition, which may be implemented by the following steps S301 to S303.
S301, determining a plurality of physical tables of the target dimension, the preselected index, the aggregation algorithm and the filtering condition according to the target dimension, the preselected index, the aggregation algorithm and the filtering condition.
Firstly, the server analyzes the target dimension, the preselected index, the aggregation algorithm and the filtering condition to determine the fields required for obtaining the information, and further determines the physical table where the information is located. Further, each preselected metric may be calculated from a plurality of different fields, or a field may be located in a different physical table. Therefore, for a certain preselected index, the number of corresponding physical tables may be multiple.
S302, determining a plurality of table sets to be selected according to the plurality of physical tables.
Each table set to be selected comprises at least one physical table, and each physical table comprises fields which have correlation relations with the target dimension, the preselected index, the aggregation algorithm and the filtering condition.
And dividing the physical tables to obtain a plurality of table sets to be selected, wherein each table set to be selected comprises one or more physical tables. The division standard may be that a corresponding preselected index result is obtained by calculation through data included in each physical table in each table set to be selected under the data analysis condition of the target dimension, the aggregation algorithm and the filtering condition. The association relationship may be a direct association relationship or an indirect association relationship.
For example, for a preselected index of total sales amount of commodities of a company, under the condition that the target dimension is year, the aggregation algorithm is null, and the filtering condition is to filter out the sales amount of the last half year, the determined table set to be selected can be a customer order table, and the accumulated calculation is carried out through the order amount field of each customer. The table set to be selected can also be a department performance table, and the sales performance fields of all departments are used for carrying out accumulation calculation. Or the combination of the commodity selling price table and the customer order table, and the total commodity selling amount in the next half year is calculated according to the commodity unit price in the commodity selling price table and the customer order amount in the customer order table.
And S303, selecting one table set to be selected from the plurality of table sets to be selected as a target table set according to a preset evaluation strategy.
Optionally, for the multiple candidate table sets, the server may evaluate the multiple candidate table sets respectively according to a preset evaluation policy, and select one of the multiple candidate table sets as the target table set. The preset evaluation strategy can be a method which is stored in the server in advance and used for evaluating a plurality of table sets to be selected and calculating the efficiency of the result according to data such as target dimensions, preselected indexes, aggregation algorithms, filtering conditions and the like.
In this embodiment, a plurality of table sets to be selected are determined by analyzing data required by the target dimension, the preselected index, the aggregation algorithm, and the filtering condition. The multiple tables to be selected obtained by enumeration can contain possible modes of calculating final results as much as possible, and selectable items are provided for finding the optimal calculation path.
Optionally, in step S302, determining a plurality of table sets to be selected according to a plurality of physical tables may include: and carrying out permutation and combination on the plurality of physical tables to determine a plurality of table sets to be selected.
It is understood that, in the above embodiment, the plurality of physical tables may be divided in a manner of permutation and combination, for example, three different physical table combinations may be determined for the pre-selected index of the total sales amount of the commodity in the annual target dimension, and two different physical table combinations may be determined for the pre-selected index of the customer number growth rate in the annual target dimension. One of the three physical table combinations for calculating the total sales amount of the annual commodities and one of the two physical table combinations for calculating the number increase rate of the annual customers can be combined pairwise to obtain query results, so that the five physical tables are arranged and combined to obtain six table sets to be selected.
It can be understood that the physical tables in each candidate table set can obtain the query result through calculation, but the calculation efficiency and the occupation of storage resources may be different.
In this embodiment, the table set to be selected is obtained by permutation and combination of the physical tables, so that all possible situations of the physical tables of the dynamic form can be enumerated as much as possible, and a possibility is provided for seeking an optimal path.
Alternatively, as shown in fig. 4, in the step S303, one table set to be selected is selected from a plurality of table sets to be selected as the target table set according to a preset evaluation policy, which may be implemented by the following steps S401 to S402.
S401, scoring the multiple to-be-selected table sets respectively according to the characteristic information of each to-be-selected table set to obtain scores corresponding to the multiple to-be-selected table sets.
Wherein the characteristic information includes at least one of: the number, depth and aggregation complexity of the physical tables in the table set to be selected.
It can be understood that, in the candidate table set, the smaller the number of physical tables, the higher the parallelization degree is, the higher the efficiency of data query is, and the higher the score is obtained more easily.
The depth of the physical tables in the table set to be selected can be understood as that the physical tables in the data warehouse have dependency relationship, and a certain preselected index can be obtained according to the required physical tables after being connected with a plurality of physical tables in a hierarchical drilling or non-hierarchical drilling mode through connection of the plurality of physical tables. In the process, the layer number of the connected physical tables is the depth corresponding to the preselected index, and the sum of the depths required by the computation of all the preselected indexes is the depth of the table set to be selected. It will be appreciated that the greater the depth, the greater the number of connections, the less computationally efficient and the lower the score obtained.
The aggregation complexity of the candidate list set may be understood as that, when calculating the average value for the target dimension of annual order total amount, aggregation operation is performed from the physical list where monthly order total amount is located, and aggregation operation is performed from the physical list where daily order total amount is located, where the complexity of dimension aggregation is different, and it may be understood that the larger the data granularity is, the higher the aggregation complexity score is.
Optionally, the server may prestore the correspondence between different values and scores of the characteristic information for the above characteristic information. Therefore, each table set to be selected can be scored according to the characteristic information, and the score corresponding to each table set to be selected is obtained.
S402, using a Monte Carlo algorithm, and combining the table sets to be selected corresponding to the highest scores in the scores into a target table set.
The Monte Carlo algorithm is a summary of the characteristics of a random algorithm, and has the core idea that all possible solutions are enumerated as much as possible, and then a local optimal solution is selected from the possible solutions to serve as a global optimal solution for the problem. It can be understood that, because the monte carlo algorithm adopts a limited sampling mode, the obtained solution can only be an optimal solution within a sampling range, but as the sampling range is expanded, the probability that the obtained local optimal solution is a global optimal solution is gradually increased.
In the application, one of enumerated table sets to be selected is selected to serve as a target table set in a scoring process, and the table set to be selected with the highest score is obtained. The calculation efficiency and the occupied storage space of the target table set are the optimal ones in all the table sets to be selected.
In this embodiment, each table set to be selected is scored according to the feature information of each table set to be selected, so that the table sets to be selected can be comprehensively and completely evaluated at multiple angles. Then, the idea of the Monte Carlo algorithm is used, and a target table set is determined, so that the target table set is the optimal solution in the table set to be selected.
Optionally, the association relationship in the foregoing embodiment includes: containment relationships and/or dependency relationships.
The inclusion relationship refers to a relationship that one preselected dimension and another preselected dimension are all included parent-child dimensions in each preselected dimension, for example, two time dimensions, namely month and year, are dependency relationships.
The dependency relationship means that one preselected dimension among the preselected dimensions can be derived from other preselected dimensions, and then the preselected dimension is said to exist depending on other preselected dimensions. Generally, when a dimension is established, a data warehouse is established through normalization processing in a snowflake mode, but the situation that domains corresponding to the dimension are overlapped is inevitable. For example, for a company that includes two regions, the geographic dimension of the first region is summed with the physical dimension of the second region to obtain the overall geographic dimension of the company.
For the preselected dimension with the association relationship, the preselected dimension can be eliminated, and the target dimension is obtained.
In this embodiment, the specific situation of the association relationship is defined, and a basis is provided for the screening of the target dimension.
Alternatively, as shown in fig. 5, in the step S204, the target data query command is generated according to the target table set, and may be obtained through the following steps S501 to S502.
S501, generating an initial data query instruction according to the target table set.
Wherein, the initial data query instruction comprises: query statement, and calculation formula of target dimension and preselected index.
It can be understood that the query statement in the initial data query instruction is a database query statement that is automatically generated by the server according to the database in which each physical table in the target table set is located, and is used for acquiring data that can be used for generating a dynamic form by calculation from each physical table in the database.
In the initial data query statement, the calculation formula of the target dimension and the preselected index is a calculation formula of the process of acquiring data in the physical table, summarizing, calculating and generating the dynamic form.
And S502, optimizing the initial data query instruction to obtain a target data query instruction.
In the initial data query instruction, the data query and calculation mode with the highest efficiency may not be available, and the server may optimize the data acquisition path, the calculation path of the calculation mode, and the like in the query instruction, so as to accelerate the efficiency of data acquisition and the calculation efficiency.
In the embodiment, the initial data query instruction is automatically generated through the target table set, so that tedious manual development is avoided, and the situation that errors may occur in manual writing of the instruction is reduced.
Alternatively, as shown in fig. 6, in the step S502, the initial data query instruction is optimized to obtain the target data query instruction, which can be implemented by the following steps S601 to S604.
S601, simplifying a connection path of the query statement in the initial data query instruction to obtain a simplified query statement, and taking the simplified query statement as the query statement in the target data query instruction.
The connection path of the query statement may be understood as a query statement in which an upper physical table and a lower physical table are connected to each other by a common field in order to acquire data in a plurality of physical tables. Sometimes, in order to obtain data in a certain lowest physical table, multiple physical tables may be required to be connected for obtaining.
In order to reduce excessive association operations, fields frequently used in a lower physical table can be simultaneously stored in an upper physical table as shortcut redundancy fields in the upper physical table during the design of the physical table of the data warehouse. Therefore, after the server sequentially searches the upper-layer physical table and reads the shortcut redundancy field, the longer connection path connected to the lower-layer physical table is changed into the shorter connection path connected to the upper-layer physical table, and the length of the query statement in the initial data query instruction is shortened.
S602, determining a plurality of pre-calculated indexes according to the pre-selected indexes.
In order to simplify the calculation process, for the acquired data of some fields, the server may pre-calculate the data according to the pre-selected indexes which often correspond to the fields in the past, and then, generate a temporary view together with some fields by using the result obtained by the pre-calculation as a temporary field. Therefore, the calculation formula can calculate each part of field respectively, and the calculation efficiency is improved.
For example, for both the number of pieces and the unit price, the corresponding indicator may be the total amount in most cases. The server may pre-calculate the total amount and store it in the temporary view.
And S603, optimizing the target dimension and the calculation formula of the preselected index according to the pre-calculation index to obtain the processed calculation formula.
The server searches the temporary view according to the calculation formula, and if a certain field in the temporary view is a result which needs to be calculated and obtained by the calculation formula, the field in which the result is located can be directly replaced by the calculation of the part in the calculation formula, so that the complexity of the calculation formula is reduced, and the calculation efficiency is improved.
S604, selecting a target formula from the processed calculation formulas according to the characteristic information of the target dimension, and taking the target formula as the calculation formula in the target data query instruction.
Next, the calculation formula may be further optimized by using an angle of a certain dimension in the target dimension, so as to obtain the target formula. For example, annual revenue may be obtained by accumulation of monthly revenue or daily revenue, and obviously, the efficiency of annual revenue obtained from monthly revenue accumulation is higher than that obtained from daily revenue accumulation. Therefore, when both daily revenue and monthly revenue data are present, monthly revenue data can be preferentially used.
The method improves the generation efficiency of the dynamic form from the algorithm level, and optionally, the server can also improve the query efficiency of the query statement from the physical equipment level in a table partitioning mode when designing a data warehouse. Specifically, a physical table with a large data size can be divided and stored in a plurality of partitions, so that the plurality of partitions of the physical table can be searched at the same time, and the searching speed is improved.
The server can also store the data with different heat degrees in databases with different efficiencies and storage spaces according to the time dimension of the data. It will be appreciated that the closer the time dimension of the data, the higher the heat. Therefore, hot data can be stored in a MySQL database with a faster retrieval speed, warm data in a Holo database, and cold data in a MaxCompute database. When retrieving data with different heat degrees, the server can generate different query statements according to the corresponding databases, and respectively acquire and summarize the analysis data.
In the embodiment, the initial data query instruction is optimized from the two aspects of the query instruction and the calculation formula to obtain the target data query instruction, and the automatically generated initial data query instruction is further optimized, so that the generation efficiency of the dynamic form is improved.
An embodiment of the present application further provides an apparatus 10 for generating a dynamic form, as shown in fig. 7, the apparatus includes:
a receiving module 1001, configured to receive a dynamic form query request initiated by a terminal device, where the dynamic form query request includes: a plurality of preselected dimensions, a plurality of preselected indicators aggregation algorithm and a filtering condition.
The processing module 1002 is configured to screen the preselected dimensions according to the association relationship of each preselected dimension in the dynamic form query request, so as to obtain target dimensions.
A determining module 1003, configured to determine a target table set according to the target dimension, the preselected indicator, the aggregation algorithm, and the filtering condition, where the target table set includes: at least one physical table, the physical table including fields having direct associations with the target dimensions, the aggregation algorithm, the filter condition, and the preselected metric.
The generating module 1004 is configured to generate a target data query instruction according to the target table set.
The generating module 1004 is further configured to generate a dynamic form according to the target data query instruction, and send the dynamic form to the terminal device.
The determining module 1003 is further specifically configured to determine, according to the target dimension, the preselected index, the aggregation algorithm, and the filtering condition, a plurality of physical tables in which the target dimension, the preselected index, the aggregation algorithm, and the filtering condition are located. And determining a plurality of table sets to be selected according to the plurality of physical tables, wherein each table set to be selected comprises at least one physical table, and each physical table comprises fields which have association relations with the target dimension, the preselected index, the aggregation algorithm and the filtering condition. And selecting one table set to be selected from a plurality of table sets to be selected as a target table set according to a preset evaluation strategy.
The determining module 1003 is further specifically configured to perform permutation and combination on the multiple physical tables to determine multiple table sets to be selected.
The determining module 1003 is further specifically configured to score the multiple to-be-selected table sets according to the feature information of each to-be-selected table set, to obtain scores corresponding to the multiple to-be-selected table sets, where the feature information includes at least one of the following items: the number, depth and aggregation complexity of the physical tables in the table set to be selected. And using a Monte Carlo algorithm to cooperate the table set to be selected corresponding to the highest score in all the scores as a target table set.
The processing module 1002 is further specifically configured to associate relationships including: containment relationships and/or dependency relationships.
The generating module 1004 is further specifically configured to generate an initial data query instruction according to the target table set, where the initial data query instruction includes: query statement, and calculation formula of target dimension and preselected index. And optimizing the initial data query instruction to obtain a target data query instruction.
The generating module 1004 is further specifically configured to simplify a connection path of the query statement in the initial data query instruction, obtain a simplified query statement, and use the simplified query statement as the query statement in the target data query instruction. A plurality of pre-calculated indicators are determined based on the pre-selected indicators. And according to the pre-calculation index, optimizing the calculation formula of the target dimension and the pre-selection index to obtain a processed calculation formula. And selecting a target formula from the processed calculation formulas according to the characteristic information of the target dimension, and taking the target formula as the calculation formula in the target data query instruction.
Referring to fig. 8, the present embodiment further provides a server, including: a processor 2001, a memory 2002 and a bus, wherein the memory 2002 stores machine-readable instructions executable by the processor 2001, and when the server runs, the machine-readable instructions are executed, the processor 2001 and the memory 2002 are communicated through the bus, and the processor 2001 is used for executing the steps of the dynamic form generation method in the above embodiments.
The memory 2002, processor 2001, and bus elements are electrically coupled to each other, directly or indirectly, to enable data transfer or interaction. For example, the components may be electrically connected to each other via one or more communication buses or signal lines. The data processing device of the dynamic form generation system includes at least one software functional module which can be stored in the memory 2002 in the form of software or firmware (firmware) or solidified in an Operating System (OS) of the computer device. The processor 2001 is used to execute executable modules stored in the memory 2002, such as software functional modules and computer programs included in a data processing apparatus of a system for generating a dynamic form of an object.
The Memory 2002 may be, but is not limited to, a Random Access Memory (RAM), a Read Only Memory (ROM), a Programmable Read-Only Memory (PROM), an Erasable Read-Only Memory (EPROM), an electrically Erasable Read-Only Memory (EEPROM), and the like.
Optionally, the present application further provides a storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the computer program performs the steps of the above method embodiments. The specific implementation and technical effects are similar, and are not described herein again.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the system and the apparatus described above may refer to corresponding processes in the method embodiments, and are not described in detail in this application. In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. The above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is merely a logical division, and there may be other divisions in actual implementation, and for example, a plurality of modules or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or modules through some communication interfaces, and may be in an electrical, mechanical or other form.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a U disk, a removable hard disk, a ROM, a RAM, a magnetic disk, or an optical disk.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present application should be covered within the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. A method for generating a dynamic form, the method comprising:
receiving a dynamic form query request initiated by a terminal device, wherein the dynamic form query request comprises: a plurality of preselected dimensions, a plurality of preselected indicators, an aggregation algorithm for the plurality of preselected indicators, and a filtering condition;
screening the preselected dimensions according to the incidence relation of the preselected dimensions in the dynamic form query request to obtain target dimensions;
determining a target table set according to the target dimension, the preselected indicator, the aggregation algorithm, and the filtering condition, the target table set comprising: at least one physical table including fields having direct associations with the target dimension, the aggregation algorithm, the filter condition, and the preselected metric;
generating a target data query instruction according to the target table set;
and generating a dynamic form according to the target data query instruction, and sending the dynamic form to the terminal equipment.
2. The method of generating a dynamic form of claim 1, wherein said determining a set of target tables based on said target dimensions, said preselected metric, said aggregation algorithm, and said filtering criteria comprises:
determining a plurality of physical tables in which the target dimension, the preselected index, the aggregation algorithm and the filtering condition are located according to the target dimension, the preselected index, the aggregation algorithm and the filtering condition;
determining a plurality of table sets to be selected according to a plurality of physical tables, wherein each table set to be selected comprises at least one physical table, and each physical table comprises fields which have association relations with the target dimension, the preselected index, the aggregation algorithm and the filtering condition;
and selecting one table set to be selected from the plurality of table sets to be selected as a target table set according to a preset evaluation strategy.
3. The method for generating a dynamic form according to claim 2, wherein the determining a plurality of sets of tables to be selected according to a plurality of physical tables comprises:
and carrying out permutation and combination on the plurality of physical tables to determine a plurality of table sets to be selected.
4. The method for generating a dynamic form according to claim 2, wherein the selecting one table set to be selected from the plurality of table sets to be selected as a target table set according to a preset evaluation policy includes:
according to the feature information of each table set to be selected, scoring the plurality of table sets to be selected respectively to obtain scores corresponding to the plurality of table sets to be selected, wherein the feature information comprises at least one of the following items: the number, the depth and the aggregation complexity of the physical tables in the table set to be selected;
and using a Monte Carlo algorithm to cooperate the table set to be selected corresponding to the highest score in all the scores as a target table set.
5. The method of generating a dynamic form according to claim 1, wherein the association relationship comprises: containment relationships and/or dependency relationships.
6. The method of generating a dynamic form of claim 1, wherein generating a target data query instruction according to the target table set comprises:
generating an initial data query instruction according to the target table set, wherein the initial data query instruction comprises: query statement and calculation formula of the target dimension and the preselected index;
and optimizing the initial data query instruction to obtain the target data query instruction.
7. The method of claim 6, wherein the optimizing the initial data query to obtain the target data query comprises:
simplifying the connection path of the query statement in the initial data query instruction to obtain a simplified query statement, and taking the simplified query statement as the query statement in the target data query instruction;
determining a plurality of pre-calculated indexes according to the pre-selected indexes;
according to the pre-calculation index, optimizing the target dimension and the calculation formula of the pre-selection index to obtain a processed calculation formula;
and selecting a target formula from the processed calculation formulas according to the characteristic information of the target dimension, and taking the target formula as the calculation formula in the target data query instruction.
8. A system for generating a dynamic form, the system comprising: the system comprises a plurality of terminal devices and a server, wherein the terminal devices are respectively in communication connection with the server;
the terminal equipment is used for initiating a dynamic form query request to the server and receiving a dynamic form sent by the server;
the server is configured to store data in the form of metadata and to perform the steps of the method for generating a dynamic form according to any one of claims 1 to 7.
9. A server, characterized in that the server comprises: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory communicating via the bus when the server is running, the processor executing the machine-readable instructions to perform the steps of the method of generating a dynamic form according to any one of claims 1 to 7.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a computer program which, when being executed by a processor, carries out the steps of the method for generating a dynamic form according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210266677.4A CN114356965B (en) | 2022-03-18 | 2022-03-18 | Method, system, server and storage medium for generating dynamic form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210266677.4A CN114356965B (en) | 2022-03-18 | 2022-03-18 | Method, system, server and storage medium for generating dynamic form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114356965A true CN114356965A (en) | 2022-04-15 |
| CN114356965B CN114356965B (en) | 2022-06-14 |
Family
ID=81094792
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210266677.4A Active CN114356965B (en) | 2022-03-18 | 2022-03-18 | Method, system, server and storage medium for generating dynamic form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114356965B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050076045A1 (en) * | 2001-03-19 | 2005-04-07 | Pal Stenslet | Method and system for handling multiple dimensions in relational databases |
| US20140236884A1 (en) * | 2013-02-15 | 2014-08-21 | Sap Ag | Analysis of datasets without predefined dimensions |
| US8990212B1 (en) * | 2014-03-27 | 2015-03-24 | Visier Solutions, Inc. | Systems and methods of mapping multidimensional data and executing queries |
| US20160179921A1 (en) * | 2014-12-22 | 2016-06-23 | Amazon Technologies, Inc. | Identifying join relationships based on transactional access patterns |
| CN111462845A (en) * | 2020-03-17 | 2020-07-28 | 平安国际智慧城市科技股份有限公司 | Dynamic form generation method and device, computer equipment and storage medium |
| CN111813804A (en) * | 2019-04-11 | 2020-10-23 | 百度在线网络技术（北京）有限公司 | Data query method and device, electronic equipment and storage medium |
| CN112256745A (en) * | 2020-10-27 | 2021-01-22 | 武汉市钱鲸科技有限公司 | Retail data analysis method |
| CN112269792A (en) * | 2020-12-11 | 2021-01-26 | 腾讯科技（深圳）有限公司 | Data query method, device, equipment and computer readable storage medium |
| CN112860709A (en) * | 2021-03-17 | 2021-05-28 | 网易（杭州）网络有限公司 | Service index query method, device, equipment and storage medium |
| CN112965991A (en) * | 2021-03-08 | 2021-06-15 | 咪咕文化科技有限公司 | Pre-calculation result generation method and device, electronic equipment and storage medium |
| CN113468208A (en) * | 2021-07-19 | 2021-10-01 | 网易（杭州）网络有限公司 | Method and device for generating data query statement, server and storage medium |
-
2022
- 2022-03-18 CN CN202210266677.4A patent/CN114356965B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050076045A1 (en) * | 2001-03-19 | 2005-04-07 | Pal Stenslet | Method and system for handling multiple dimensions in relational databases |
| US20140236884A1 (en) * | 2013-02-15 | 2014-08-21 | Sap Ag | Analysis of datasets without predefined dimensions |
| US8990212B1 (en) * | 2014-03-27 | 2015-03-24 | Visier Solutions, Inc. | Systems and methods of mapping multidimensional data and executing queries |
| US20160179921A1 (en) * | 2014-12-22 | 2016-06-23 | Amazon Technologies, Inc. | Identifying join relationships based on transactional access patterns |
| CN111813804A (en) * | 2019-04-11 | 2020-10-23 | 百度在线网络技术（北京）有限公司 | Data query method and device, electronic equipment and storage medium |
| CN111462845A (en) * | 2020-03-17 | 2020-07-28 | 平安国际智慧城市科技股份有限公司 | Dynamic form generation method and device, computer equipment and storage medium |
| CN112256745A (en) * | 2020-10-27 | 2021-01-22 | 武汉市钱鲸科技有限公司 | Retail data analysis method |
| CN112269792A (en) * | 2020-12-11 | 2021-01-26 | 腾讯科技（深圳）有限公司 | Data query method, device, equipment and computer readable storage medium |
| CN112965991A (en) * | 2021-03-08 | 2021-06-15 | 咪咕文化科技有限公司 | Pre-calculation result generation method and device, electronic equipment and storage medium |
| CN112860709A (en) * | 2021-03-17 | 2021-05-28 | 网易（杭州）网络有限公司 | Service index query method, device, equipment and storage medium |
| CN113468208A (en) * | 2021-07-19 | 2021-10-01 | 网易（杭州）网络有限公司 | Method and device for generating data query statement, server and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 李润洲等: "基于异构集成的元数据及其多表动态查询算法", 《计算机工程》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114356965B (en) | 2022-06-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109766497B (en) | Ranking list generation method and device, storage medium and electronic equipment | |
| US10725981B1 (en) | Analyzing big data | |
| EP3365810B1 (en) | System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment | |
| JP4358475B2 (en) | Credit evaluation system | |
| US8838490B2 (en) | Associate memory learning for analyzing financial transactions | |
| US9031967B2 (en) | Natural language processing system, method and computer program product useful for automotive data mapping | |
| CN112527827A (en) | Automatic insights for multidimensional data | |
| US20080021850A1 (en) | Adapting to inexact user input | |
| US20140074731A1 (en) | System and method for automated data discrepancy analysis | |
| CN111125266A (en) | Data processing method, device, equipment and storage medium | |
| JP2016038658A (en) | Supplier search device and search method | |
| CN113032420A (en) | Data query method and device and server | |
| US9098550B2 (en) | Systems and methods for performing data analysis for model proposals | |
| CN111241123A (en) | View data query method, device, server and storage medium | |
| CN110795478A (en) | Data warehouse updating method and device applied to financial business and electronic equipment | |
| US9164978B2 (en) | Identifying objects within a multidimensional array | |
| CN114238308A (en) | Cross perspective table generation method and device, electronic equipment and readable storage medium | |
| CN114356965B (en) | Method, system, server and storage medium for generating dynamic form | |
| CN110544118B (en) | Sales prediction method, sales prediction device, medium and computing equipment | |
| US20230153286A1 (en) | Method and system for hybrid query based on cloud analysis scene, and storage medium | |
| US20170039289A1 (en) | Disambiguation of online social mentions | |
| CN113625967B (en) | Data storage method, data query method and server | |
| JP5310196B2 (en) | Classification system revision support program, classification system revision support device, and classification system revision support method | |
| CN113761102A (en) | Data processing method, device, server, system and storage medium | |
| US9785660B2 (en) | Detection and quantifying of data redundancy in column-oriented in-memory databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |