CN110955686A - Data multidimensional cross processing method and device, electronic equipment and storage medium - Google Patents
Data multidimensional cross processing method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN110955686A CN110955686A CN201911217700.5A CN201911217700A CN110955686A CN 110955686 A CN110955686 A CN 110955686A CN 201911217700 A CN201911217700 A CN 201911217700A CN 110955686 A CN110955686 A CN 110955686A
- Authority
- CN
- China
- Prior art keywords
- information
- data
- terminal
- query condition
- piece
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a data multidimensional cross processing method and device, electronic equipment and a storage medium. The data multidimensional cross processing method is applied to a server, and comprises the following steps: acquiring query condition information and at least one piece of calculation logic information of target data sent by a terminal; acquiring target data meeting conditions based on the query condition information; performing corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information to generate result data information; and sending the result data information to a terminal for displaying. Therefore, the complex multidimensional cross operation processing service is provided for the terminal, the memory occupation of the terminal can be reduced, and the data processing capability of the terminal is improved.
Description
Technical Field
The present application relates to the field of computer network technologies, and in particular, to a method and an apparatus for multidimensional cross processing of data, an electronic device, and a storage medium.
Background
The existing data analysis method and the existing execution method are based on the pivot table function of the excel table to perform data analysis, and the mode can support cross calculation of any dimension. However, this cross-computing method requires that the terminal device must store the original data and install the corresponding processing software, and if the terminal device does not store the original data and install the corresponding processing software, the analysis and calculation cannot be performed at the local terminal.
In view of the above problems, no effective technical solution exists at present.
Disclosure of Invention
An object of the embodiments of the present application is to provide a data multidimensional cross processing method, apparatus, electronic device, and storage medium, which can improve data processing capability of a terminal.
In a first aspect, an embodiment of the present application provides a data multidimensional cross processing method, which is applied in a server, and the method includes the following steps:
acquiring query condition information and at least one piece of calculation logic information of target data sent by a terminal;
acquiring target data meeting conditions based on the query condition information;
performing corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information to generate result data information;
and sending the result data information to a terminal for displaying.
Optionally, in the data multidimensional cross processing method according to the embodiment of the present application, before the step of obtaining query condition information of target data sent by a terminal and at least one piece of computation logic information, the method further includes:
and sending the original data field and the selectable item to a terminal for displaying so that a user can perform selection operation on the original data field and the selectable item to generate query condition information.
Optionally, in the data multidimensional cross processing method according to the embodiment of the present application, the step of obtaining query condition information of target data sent by a terminal and at least one piece of computation logic information includes:
acquiring query condition information of target data sent by a terminal, wherein the query condition information carries position information of a plurality of target data to be processed;
and acquiring calculation logic information sent by the terminal, wherein the calculation logic information carries operation logic used for processing the plurality of original data.
Optionally, in the data multidimensional intersection processing method according to the embodiment of the present application, the operation logic includes at least one of: sorting, summing, averaging, generating a statistical chart and screening.
Optionally, in the data multidimensional cross processing method in the embodiment of the present application, the result data information carries at least one result data and location information of the result data in the original data field and an optional item.
In a second aspect, an embodiment of the present application provides a data multidimensional cross processing method, which is applied to a terminal, and includes the following steps:
acquiring an original data field and a selectable item sent by a server, and generating query condition information and at least one piece of calculation logic information based on the selection operation of a user on the original data field and the selectable item;
sending the query condition information and the at least one piece of calculation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of calculation logic information to generate result data information;
acquiring result data information returned by a server, wherein the result data information comprises at least one result data obtained by calculation based on the calculation logic information and position information of each result data in the original data field and optional items;
and updating the original data field and the optional items according to the result data information.
In a third aspect, an embodiment of the present application provides a data multidimensional cross processing apparatus, which is applied in a server, and the apparatus includes:
the first acquisition module is used for acquiring query condition information of target data sent by a terminal and at least one piece of calculation logic information;
the second acquisition module is used for acquiring target data meeting the conditions based on the query condition information;
the first generation module is used for carrying out corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information so as to generate result data information;
and the first sending module is used for sending the result data information to a terminal for displaying.
In a fourth aspect, an embodiment of the present application provides a data multidimensional cross processing apparatus, which is applied in a terminal, and the apparatus includes:
the second generation module is used for acquiring an original data field and an optional item sent by the server, and generating query condition information and at least one piece of calculation logic information based on the selection operation of a user on the original data field and the optional item;
a second sending module, configured to send the query condition information and the at least one piece of computation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of computation logic information to generate result data information;
and the third acquisition module is used for acquiring result data information returned by the server, wherein the result data information comprises at least one result data obtained by calculation based on the calculation logic information and position information of each result data in the original data field and optional items.
In a fifth aspect, an embodiment of the present application provides an electronic device, including a processor and a memory, where the memory stores computer-readable instructions, and when the computer-readable instructions are executed by the processor, the electronic device executes the method as provided in the first aspect.
In a sixth aspect, an embodiment of the present application provides a storage medium, on which a computer program is stored, where the computer program runs the method provided in the above first aspect when being executed by a processor.
As can be seen from the above, in the embodiment of the present application, query condition information of target data sent by a terminal and at least one piece of computation logic information are obtained; acquiring target data meeting conditions based on the query condition information; performing corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information to generate result data information; sending the result data information to a terminal for displaying; therefore, the complex multidimensional cross operation processing service is provided for the terminal, the multidimensional cross operation processing service can be realized without storing original data and corresponding operation software in the terminal, the memory occupation of the terminal can be reduced, and the data processing capacity of the terminal is improved.
Additional features and advantages of the present application will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the embodiments of the present application. The objectives and other advantages of the application may be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
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 of the present application 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 that those skilled in the art can also obtain other related drawings based on the drawings without inventive efforts.
Fig. 1 is a flowchart of a multidimensional cross processing method for data according to an embodiment of the present application.
Fig. 2 is another flowchart of a multidimensional intersection processing method for data according to an embodiment of the present application.
Fig. 3 is a schematic structural diagram of a data multidimensional cross processing apparatus according to an embodiment of the present application.
Fig. 4 is a second schematic structural diagram of a data multidimensional cross processing apparatus according to an embodiment of the present application.
Fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
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 only a part of the embodiments of the present application, and not all of the 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 of the present application 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. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance.
Referring to fig. 1, fig. 1 is a flowchart of a multidimensional intersection processing method of data in some embodiments of the present application. The data multidimensional cross processing method is applied to a server. The data multidimensional cross processing method comprises the following steps:
s101, acquiring query condition information and at least one piece of calculation logic information of target data sent by a terminal; .
And S102, acquiring target data meeting the conditions based on the query condition information.
S103, performing corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information to generate result data information.
And S104, sending the result data information to a terminal for displaying.
The following describes each step of the data multidimensional interleaving processing method in detail.
In step S101, the terminal is an electronic device such as a mobile phone, an IPAD, or a computer. The mobile phone cannot be provided with the excel table, and often cannot perform automatic multidimensional cross operation on data in the table, such as sorting, summing, averaging, data screening, data statistical chart generation and other common functions of the excel table. Therefore, the user can operate on the original data field and the selectable item displayed on the page of the terminal to select the area to be subjected to the arithmetic processing, thereby generating the query condition information. The raw data fields and the alternative profiles are similar to excel tables, but do not have the calculation function of excel tables. Wherein, the original data field and the optional item can comprise a table, therefore, the position information is the row and column number of the target data in the original data field and the optional item. The original data field and the selectable item can comprise a plurality of tables, and therefore, the position information is the table identification number and the row and column numbers of the target data in the original data field and the selectable item.
The information of the original data field and the optional item can be a plurality of discrete target data information or can be directly transmitted by one original data field and optional item.
In some embodiments, this step S101 includes: s1011, acquiring query condition information of target data sent by a terminal, wherein the query condition information carries position information of a plurality of target data to be processed; and S1012, acquiring computation logic information sent by the terminal, wherein the computation logic information carries computation logic used for processing the plurality of original data. The operation expressions carried in the computation logic information may include operation expressions of excel tables such as sorting, summing, averaging, data screening, and generating data statistical diagrams.
It is understood that, in some embodiments, before performing step S101, the method further includes: and sending the original data field and the selectable item to a terminal for displaying so that a user can perform selection operation on the original data field and the selectable item to generate query condition information. Of course, it is understood that the original data table may be obtained by the terminal in other manners.
In step S102, target data to be calculated is acquired from a database according to the query condition corresponding to the query condition information.
In step S103, according to one or more operation expressions corresponding to the computation logic information, corresponding operations, such as common operations of sorting, summing, averaging, data screening, and generating an excel table such as a data statistical graph, may be performed on the corresponding target data, and then the server generates result data information based on the operation result. The result data information may include a result data, for example, for a summation, averaging, or other calculation operation, the corresponding result data information may include only a result data and the corresponding location information of the result data. For the calculation of screening, sorting and the like, the result data information includes a plurality of result data and corresponding position information. And the result data information of each time is associated and stored with the corresponding original data field and the information of the selectable item, so that the result data information is convenient for a user to look up.
In step S104, when the result data information is sent to the terminal, the server may directly complete the filling of the result data into the corresponding positions of the original data field and the optional items, and then send the updated original data field and the updated optional items to the terminal, so that the terminal replaces the original data field and the optional items before with the updated original data field and the updated optional items. Of course, it is also possible to send a plurality of result data and corresponding location information included in the result data information to the terminal, so that the terminal performs data update on the original data field and the corresponding location on the option according to each result data and corresponding location information.
As can be seen from the above, in the embodiment of the present application, query condition information of target data sent by a terminal and at least one piece of computation logic information are obtained; acquiring target data meeting conditions based on the query condition information; performing corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information to generate result data information; sending the result data information to a terminal for displaying; therefore, the complex multidimensional cross operation processing service is provided for the terminal, the multidimensional cross operation processing service can be realized without storing original data and corresponding operation software in the terminal, the memory occupation of the terminal can be reduced, and the data processing capacity of the terminal is improved.
Referring to fig. 2, fig. 2 is a diagram illustrating a data multidimensional cross processing method in some embodiments of the present application, which is applied to a terminal, where the terminal may be a mobile phone, an IPAD, a computer, or the like. The data multidimensional cross processing method comprises the following steps:
s201, acquiring an original data field and an optional item sent by a server, and generating query condition information and at least one piece of calculation logic information based on the selection operation of a user on the original data field and the optional item.
S202, sending the query condition information and the at least one piece of calculation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of calculation logic information to generate result data information.
S203, obtaining result data information returned by the server, wherein the result data information comprises at least one result data obtained by operation based on the calculation logic information and position information of each result data in the original data field and optional items.
In step S201, the mobile phone cannot install an excel table, and often cannot perform automatic multidimensional cross operation on data in the table, for example, sorting, summing, averaging, data screening, and generating common functions of the excel table such as a data statistical chart. Therefore, a user can fill in the original data field and the optional items on the terminal, and the appearance of the original data field and the optional items is similar to that of the excel form, but the operation function of the excel form is not provided.
In step S202, after generating the original data field and the optional item, the terminal selects a corresponding area of the original data field and the optional item to be operated and corresponding computation logic information, and then sends the query condition information and the computation logic information to the server. The query condition information corresponds to the location information of the target data in the original data field and the selectable item. Wherein, the original data field and the optional item can comprise a table, therefore, the position information is the row and column number of the target data in the original data field and the optional item. The original data field and the selectable item can comprise a plurality of tables, and therefore, the position information is the table identification number and the row and column numbers of the target data in the original data field and the selectable item.
The information of the original data field and the optional item can be a plurality of discrete target data information or can be directly transmitted by one original data field and optional item. The server may perform corresponding operations on the corresponding target data according to one or more operational expressions corresponding to the computation logic information, for example, perform common operations of sorting, summing, averaging, data screening, generating an excel table such as a data statistical graph, and then generate result data information based on the operation result. The result data information may include a result data, for example, for a summation, averaging, or other calculation operation, the corresponding result data information may include only a result data and the corresponding location information of the result data. For the calculation of screening, sorting and the like, the result data information includes a plurality of result data and corresponding position information. And the result data information of each time is associated and stored with the corresponding original data field and the information of the selectable item, so that the result data information is convenient for a user to look up.
In step S203, the server may perform corresponding operations on the corresponding target data according to one or more operation expressions corresponding to the computation logic information, for example, perform common operations of sorting, summing, averaging, data screening, and generating an excel table such as a data statistical graph, and then generate result data information based on the operation result. The result data information may include a result data, for example, for a summation, averaging, or other calculation operation, the corresponding result data information may include only a result data and the corresponding location information of the result data. For the calculation of screening, sorting and the like, the result data information includes a plurality of result data and corresponding position information. And the result data information of each time is associated and stored with the corresponding original data field and the information of the selectable item, so that the result data information is convenient for a user to look up.
When the server sends the result data information to the terminal, the server can directly fill the result data in the corresponding positions of the original data field and the selectable item on the server side, and then the updated original data field and the selectable item are sent to the terminal, so that the terminal adopts the updated original data field and the selectable item to replace the original data field and the selectable item. Of course, it is also possible to send a plurality of result data and corresponding location information included in the result data information to the terminal, so that the terminal performs data update on the original data field and the corresponding location on the option according to each result data and corresponding location information.
As can be seen from the above, in the embodiment of the present application, by acquiring the original data field and the selectable item sent by the server, query condition information and at least one piece of computation logic information are generated based on the selection operation of the user on the original data field and the selectable item; sending the query condition information and the at least one piece of calculation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of calculation logic information to generate result data information; acquiring result data information returned by a server, wherein the result data information comprises at least one result data obtained by calculation based on the calculation logic information and position information of each result data in the original data field and optional items; therefore, the complex multidimensional cross operation processing service is provided for the terminal, the memory occupation of the terminal can be reduced, and the data processing capability of the terminal is improved.
Referring to fig. 3, fig. 3 is a block diagram of a data multidimensional cross processing apparatus in some embodiments of the present application, where the apparatus is applied in a server, and the apparatus includes: a first acquisition module 301, a second acquisition module 302, a first generation module 303 and a first sending module 304.
The first obtaining module 201 is configured to obtain query condition information of target data sent by a terminal and at least one piece of computation logic information. The terminal is an electronic device such as a mobile phone or an IPAD. The mobile phone cannot be provided with the excel table, and often cannot perform automatic multidimensional cross operation on data in the table, such as sorting, summing, averaging, data screening, data statistical chart generation and other common functions of the excel table. Accordingly, the user can operate on the original data field and the selectable item displayed on the terminal to select an area to be subjected to arithmetic processing, thereby generating query condition information. The raw data fields and the alternative profiles are similar to excel tables, but do not have the calculation function of excel tables. Wherein, the original data field and the optional item can comprise a table, therefore, the position information is the row and column number of the target data in the original data field and the optional item. The original data field and the selectable item can comprise a plurality of tables, and therefore, the position information is the table identification number and the row and column numbers of the target data in the original data field and the selectable item.
The information of the original data field and the optional item can be a plurality of discrete target data information or can be directly transmitted by one original data field and optional item.
In some embodiments, the first obtaining module 301: the device comprises a first acquisition unit, a second acquisition unit and a processing unit, wherein the first acquisition unit is used for acquiring query condition information of target data sent by a terminal, and the query condition information carries position information of a plurality of target data to be processed; and the second obtaining unit is used for obtaining the calculation logic information sent by the terminal, and the calculation logic information carries the operation logic used for processing the plurality of original data. The operation expressions carried in the computation logic information may include operation expressions of excel tables such as sorting, summing, averaging, data screening, and generating data statistical diagrams.
The second obtaining module 302 is configured to obtain target data that satisfies a condition based on the query condition information.
The first generating module 303 is configured to perform corresponding operation processing on the plurality of target data according to the at least one piece of computation logic information to generate result data information; corresponding operations, such as common operations of sorting, summing, averaging, data screening, generating an excel table such as a data statistical graph, and the like, can be performed on the corresponding target data according to one or more operational expressions corresponding to the computation logic information, and then the server generates result data information based on the operation result. The result data information may include a result data, for example, for a summation, averaging, or other calculation operation, the corresponding result data information may include only a result data and the corresponding location information of the result data. For the calculation of screening, sorting and the like, the result data information includes a plurality of result data and corresponding position information. And the result data information of each time is associated and stored with the corresponding original data field and the information of the selectable item, so that the result data information is convenient for a user to look up.
The first sending module 304 is configured to send the result data information to a terminal for displaying. When the result data information is sent to the terminal, the result data can be directly filled in the corresponding positions of the original data field and the selectable item on the server side, and then the updated original data field and the selectable item are sent to the terminal, so that the terminal adopts the updated original data field and the selectable item to replace the original data field and the selectable item. Of course, it is also possible to send a plurality of result data and corresponding location information included in the result data information to the terminal, so that the terminal performs data update on the original data field and the corresponding location on the option according to each result data and corresponding location information.
As can be seen from the above, in the embodiment of the present application, query condition information of target data sent by a terminal and at least one piece of computation logic information are obtained; acquiring target data meeting conditions based on the query condition information; performing corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information to generate result data information; sending the result data information to a terminal for displaying; therefore, the complex multidimensional cross operation processing service is provided for the terminal, the memory occupation of the terminal can be reduced, and the data processing capability of the terminal is improved.
Referring to fig. 4, fig. 4 is a block diagram of a data multidimensional cross processing apparatus in some embodiments of the present application, where the apparatus is applied in a terminal, and the apparatus includes: a third obtaining module 401, a second sending module 402, and a fourth obtaining module 403.
The third obtaining module 401 is configured to obtain the original data field and the optional items sent by the server, and generate query condition information and at least one piece of computation logic information based on a selection operation of the user on the original data field and the optional items.
The second sending module 402 is configured to send the query condition information and the at least one piece of computation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of computation logic information to generate result data information.
The fourth obtaining module 403 is configured to obtain result data information returned by the server, where the result data information includes at least one result data obtained by operation based on the computation logic information and location information of each result data in the original data field and an optional item.
As can be seen from the above, in the embodiment of the present application, by acquiring the original data field and the selectable item sent by the server, query condition information and at least one piece of computation logic information are generated based on the selection operation of the user on the original data field and the selectable item; sending the query condition information and the at least one piece of calculation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of calculation logic information to generate result data information; acquiring result data information returned by a server, wherein the result data information comprises at least one result data obtained by calculation based on the calculation logic information and position information of each result data in the original data field and optional items; therefore, the complex multidimensional cross operation processing service is provided for the terminal, the memory occupation of the terminal can be reduced, and the data processing capability of the terminal is improved.
Referring to fig. 5, fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure, where the present disclosure provides an electronic device 5, including: the processor 501 and the memory 502, the processor 501 and the memory 502 being interconnected and communicating with each other via a communication bus 503 and/or other form of connection mechanism (not shown), the memory 502 storing a computer program executable by the processor 501, the computer program being executable by the processor 501 when the computing device is running, the processor 501 executing the computer program to perform the method of any of the alternative implementations of the embodiments described above.
The embodiment of the present application provides a storage medium, and when being executed by a processor, the computer program performs the method in any optional implementation manner of the above embodiment. The storage medium may be implemented by any type of volatile or nonvolatile storage device or combination thereof, such as a Static Random Access Memory (SRAM), an Electrically Erasable Programmable Read-Only Memory (EEPROM), an Erasable Programmable Read-Only Memory (EPROM), a Programmable Read-Only Memory (PROM), a Read-Only Memory (ROM), a magnetic Memory, a flash Memory, a magnetic disk, or an optical disk.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions when actually implemented, and for example, a plurality of units 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 units through some communication interfaces, and may be in an electrical, mechanical or other form.
In addition, units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
Furthermore, the functional modules in the embodiments of the present application may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.
In this document, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions.
The above description is only an example of the present application and is not intended to limit the scope of the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (10)
1. A data multidimensional cross processing method is applied to a server, and is characterized by comprising the following steps:
acquiring query condition information and at least one piece of calculation logic information of target data sent by a terminal;
acquiring target data meeting conditions based on the query condition information;
performing corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information to generate result data information;
and sending the result data information to a terminal for displaying.
2. The multidimensional data intersection processing method of claim 1, wherein before the step of obtaining query condition information of target data sent by a terminal and at least one piece of computation logic information, the method further comprises:
and sending the original data field and the selectable items to a terminal for displaying, so that a user can select and operate the original data field and the selectable items to generate query condition information.
3. The multidimensional data intersection processing method of claim 1, wherein the step of obtaining query condition information of target data sent by a terminal and at least one piece of computation logic information comprises:
acquiring query condition information of target data sent by a terminal, wherein the query condition information carries position information of a plurality of target data to be processed;
and acquiring calculation logic information sent by the terminal, wherein the calculation logic information carries operation logic used for processing the plurality of original data.
4. The method of claim 3, wherein the arithmetic logic comprises at least one of: sorting, summing, averaging, generating a statistical chart and screening.
5. The multidimensional data intersection processing method of claim 1, wherein the result data information carries at least one result data and position information of the result data in the original data field and optional items.
6. A data multidimensional cross processing method is applied to a terminal and is characterized by comprising the following steps:
acquiring an original data field and a selectable item sent by a server, and generating query condition information and at least one piece of calculation logic information based on the selection operation of a user on the original data field and the selectable item;
sending the query condition information and the at least one piece of calculation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of calculation logic information to generate result data information;
and acquiring result data information returned by the server, wherein the result data information comprises at least one result datum obtained by operation based on the calculation logic information.
7. A data multidimensional cross processing device is applied to a server, and is characterized by comprising:
the first acquisition module is used for acquiring query condition information of target data sent by a terminal and at least one piece of calculation logic information;
the second acquisition module is used for acquiring target data meeting the conditions based on the query condition information;
the first generation module is used for carrying out corresponding operation processing on the plurality of target data according to the at least one piece of calculation logic information so as to generate result data information;
and the first sending module is used for sending the result data information to a terminal for displaying.
8. A data multidimensional cross processing device is applied to a terminal, and is characterized by comprising:
the second generation module is used for acquiring an original data field and an optional item sent by the server, and generating query condition information and at least one piece of calculation logic information based on the selection operation of a user on the original data field and the optional item;
a second sending module, configured to send the query condition information and the at least one piece of computation logic information to a server, so that the server performs operation processing on original data corresponding to the query condition information according to the at least one piece of computation logic information to generate result data information;
and the third acquisition module is used for acquiring result data information returned by the server, wherein the result data information comprises at least one result datum obtained by calculation based on the calculation logic information.
9. An electronic device comprising a processor and a memory, the memory storing computer readable instructions that, when executed by the processor, perform the method of any of claims 1-7.
10. A storage medium on which a computer program is stored, which computer program, when being executed by a processor, is adapted to carry out the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911217700.5A CN110955686A (en) | 2019-12-02 | 2019-12-02 | Data multidimensional cross processing method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911217700.5A CN110955686A (en) | 2019-12-02 | 2019-12-02 | Data multidimensional cross processing method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110955686A true CN110955686A (en) | 2020-04-03 |
Family
ID=69979408
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911217700.5A Pending CN110955686A (en) | 2019-12-02 | 2019-12-02 | Data multidimensional cross processing method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110955686A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114004190A (en) * | 2022-01-05 | 2022-02-01 | 芯行纪科技有限公司 | Method for multi-level information acquisition and extensible operation based on physical layout |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070250472A1 (en) * | 2006-04-20 | 2007-10-25 | International Business Machines Corporation | Query condition building using predefined query objects |
| US20150370897A1 (en) * | 2014-06-18 | 2015-12-24 | Alibaba Group Holding Limited | Data query method and apparatus |
| CN106897280A (en) * | 2015-12-17 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN109189777A (en) * | 2018-06-28 | 2019-01-11 | 微梦创科网络科技（中国）有限公司 | A kind of method, device and equipment stored and inquire multidimensional information |
| CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo（重庆）智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
| CN110019332A (en) * | 2017-09-29 | 2019-07-16 | 北京国双科技有限公司 | A kind of data query method and device based on precomputation |
| CN110162537A (en) * | 2019-04-19 | 2019-08-23 | 平安普惠企业管理有限公司 | Data query method and device, storage medium and electronic equipment |
-
2019
- 2019-12-02 CN CN201911217700.5A patent/CN110955686A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070250472A1 (en) * | 2006-04-20 | 2007-10-25 | International Business Machines Corporation | Query condition building using predefined query objects |
| US20150370897A1 (en) * | 2014-06-18 | 2015-12-24 | Alibaba Group Holding Limited | Data query method and apparatus |
| CN106897280A (en) * | 2015-12-17 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN110019332A (en) * | 2017-09-29 | 2019-07-16 | 北京国双科技有限公司 | A kind of data query method and device based on precomputation |
| CN109189777A (en) * | 2018-06-28 | 2019-01-11 | 微梦创科网络科技（中国）有限公司 | A kind of method, device and equipment stored and inquire multidimensional information |
| CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo（重庆）智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
| CN110162537A (en) * | 2019-04-19 | 2019-08-23 | 平安普惠企业管理有限公司 | Data query method and device, storage medium and electronic equipment |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114004190A (en) * | 2022-01-05 | 2022-02-01 | 芯行纪科技有限公司 | Method for multi-level information acquisition and extensible operation based on physical layout |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108388598B (en) | Electronic device, data storage method, and storage medium | |
| CN110716951B (en) | Label configuration method, device and equipment convenient to configure and storage medium | |
| CN112650782A (en) | Big data geographic information visualization method, system and storage medium | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN112269830A (en) | Big data analysis method, system, computer equipment and storage medium thereof | |
| CN110955686A (en) | Data multidimensional cross processing method and device, electronic equipment and storage medium | |
| CN110413598A (en) | List data amending method, device, electronic equipment and storage medium | |
| CN111724098B (en) | Information display method and system, electronic equipment and storage medium | |
| CN111475468A (en) | Log access method, device, equipment and storage medium of newly added system | |
| CN108834064B (en) | Site matching method and device based on electronic fence map | |
| CN108052521B (en) | Coordinated data display method, application server and storage medium | |
| CN113377473A (en) | Task creation method and device, electronic equipment and computer readable storage medium | |
| CN110324845B (en) | Resource allocation method and device | |
| CN110188006B (en) | Data maintenance method, device and equipment | |
| CN109739876B (en) | Data query method and device for database based on Sqltoy-orm framework | |
| CN110874370B (en) | Data query method and device, computer equipment and readable storage medium | |
| CN108255629B (en) | Breakpoint data obtaining method and terminal equipment | |
| CN112785230A (en) | Warehouse entry list generation method and system, computer equipment and storage medium | |
| WO2019168677A1 (en) | Multi-dimensional organization of data for efficient analysis | |
| CN111597179B (en) | Method and device for automatically cleaning data, electronic equipment and storage medium | |
| CN115114900B (en) | Text comment association method and device, electronic equipment, storage medium and product | |
| CN116127342B (en) | Information clustering processing method, system and platform based on hotel | |
| CN113448972B (en) | Map display method, device, terminal and storage medium | |
| CN111768161B (en) | Cross-business-department dispatch statistical method, device and system | |
| CN110728584B (en) | Information processing method and device, readable storage medium and electronic equipment |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200403 |