CN113806504A - Multi-dimensional report data calculation method and device and computer equipment - Google Patents
Multi-dimensional report data calculation method and device and computer equipment Download PDFInfo
- Publication number
- CN113806504A CN113806504A CN202110995769.1A CN202110995769A CN113806504A CN 113806504 A CN113806504 A CN 113806504A CN 202110995769 A CN202110995769 A CN 202110995769A CN 113806504 A CN113806504 A CN 113806504A
- Authority
- CN
- China
- Prior art keywords
- information
- query
- field
- value
- calculation
- 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
- 238000004364 calculation method Methods 0.000 title claims abstract description 154
- 238000000034 method Methods 0.000 claims abstract description 42
- 238000004590 computer program Methods 0.000 claims description 20
- 230000008859 change Effects 0.000 description 15
- 230000008569 process Effects 0.000 description 11
- 238000004519 manufacturing process Methods 0.000 description 9
- 238000010586 diagram Methods 0.000 description 8
- 238000004422 calculation algorithm Methods 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 239000004099 Chlortetracycline Substances 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/332—Query formulation
- G06F16/3325—Reformulation based on results of preceding query
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/34—Browsing; Visualisation therefor
- G06F16/345—Summarisation for human users
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a method and a device for calculating multi-dimensional report data and computer equipment. The method comprises the following steps: acquiring first query information, and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value; acquiring second query information, and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value; when the second information abstract value is the same as the first information abstract value, obtaining a historical query result corresponding to the first query information, and taking the historical query result as a target query result corresponding to the second query information; and when the first information abstract value is different from the second information abstract value, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information. The method can save time and computing power and improve efficiency.
Description
Technical Field
The present application relates to the field of business management technologies, and in particular, to a method and an apparatus for calculating multidimensional report data, and a computer device.
Background
In a business system, the statistical fields of some complex reports are many, for example, the volume bengli report has up to 90 columns, each column needs to be calculated according to the query conditions passed by, and the result is returned. When reports involve incremental changes, i.e., documents change, the conventional solution is to query again from the beginning. The calculation amount of each query from the beginning is the calculation amount of the full report, so that the calculation amount is huge and time is consumed.
Disclosure of Invention
Therefore, it is necessary to provide a method, an apparatus, and a computer device for calculating multi-dimensional report data to save time and effort and improve efficiency.
A multi-dimensional report data calculation method comprises the following steps:
acquiring first query information, and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value.
And acquiring second query information, and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value.
And when the second information abstract value is the same as the first information abstract value, obtaining a historical query result corresponding to the first query information, and taking the historical query result as a target query result corresponding to the second query information.
And when the first information abstract value is different from the second information abstract value, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, the step of performing message digest calculation on the current message comprises:
and acquiring key fields in the current information, and performing information abstract calculation on the key fields.
In one embodiment, the obtaining the key field in the current information includes:
and customizing the key field in the current information by a user or obtaining the key field in the current information according to the report calculation historical record rule.
In one embodiment, the calculating the information summary of the key field includes:
and performing MD5 calculation on the key field to obtain an MD5 value of the key field value.
In one embodiment, before the obtaining the historical query result corresponding to the first query information, the method further includes:
and acquiring an information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information.
And acquiring an information abstract of second candidate data, wherein the second candidate data is the candidate data corresponding to the second query information.
And when the information abstract of the first candidate data is the same as the information abstract of the second candidate data, entering the step of acquiring the historical query result corresponding to the first query information.
And when the information abstract of the first candidate data is different from the information abstract of the second candidate data, performing overall query on the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, the method for calculating the multi-dimensional report data further comprises the following steps:
and acquiring an associated field value set corresponding to a target field in the target document.
And calculating the information abstract value of the character string formed by each field value in the associated field value set.
When the information abstract value of the character string changes, updating the field value corresponding to the target field according to each field value in the associated field value set.
In one embodiment, the method for calculating the multi-dimensional report data further comprises the following steps:
and acquiring a field value corresponding to a first field in the first document.
And acquiring a field value corresponding to a second field in a second document, wherein the business logic calculation rules corresponding to the first field and the field are the same.
And acquiring a third information summary value of the associated field value set corresponding to the first field.
And acquiring a fourth information summary value of the associated field value set corresponding to the second field.
And if the third information abstract value is the same as the fourth information abstract value, and the field value corresponding to the first field is different from the field value corresponding to the second field, generating alarm information, wherein the alarm information is used for prompting that errors exist in the first field and the second field.
A multidimensional reporting data computing apparatus, the apparatus comprising:
the first acquisition and calculation module is used for acquiring first query information and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value;
the second acquisition and calculation module is used for acquiring second query information and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value;
the first judgment processing module is used for acquiring a historical query result corresponding to the first query information when the second information abstract value is the same as the first information abstract value, and taking the historical query result as a target query result corresponding to the second query information;
and when the first information abstract value and the second information abstract value are different, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, a multidimensional report data calculation device performs information summary calculation on current information, and includes:
and the first acquisition module is used for acquiring the key fields in the current information and carrying out information abstract calculation on the key fields.
In one embodiment, before obtaining the historical query result corresponding to the first query information, a multidimensional report data calculation apparatus further includes:
a second obtaining module, configured to obtain an information summary of first candidate data, where the first candidate data is candidate data corresponding to the first query information;
and the information abstract of second candidate data is acquired, wherein the second candidate data is the candidate data corresponding to the second query information.
A second judgment processing module, configured to, when the information summary of the first candidate data is the same as the information summary of the second candidate data, perform the step of obtaining a historical query result corresponding to the first query information;
and when the information abstract of the first candidate data is different from the information abstract of the second candidate data, performing overall query on the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, the multidimensional report data calculation device further comprises:
and the third acquisition module is used for acquiring the associated field value set corresponding to the target field in the target document.
And the calculation module is used for calculating the information abstract value of the character string consisting of all field values in the associated field value set.
And the third judgment processing module is used for updating the field value corresponding to the target field according to each field value in the associated field value set when the information abstract value of the character string changes.
In one embodiment, the multidimensional report data calculation device further comprises:
the fourth obtaining module is used for obtaining a field value corresponding to the first field in the first document;
the method is also used for acquiring a field value corresponding to a second field in a second document, wherein the business logic calculation rules corresponding to the first field and the field are the same;
the third information summary value is also used for acquiring the associated field value set corresponding to the first field;
and the fourth information summary value is also used for acquiring the associated field value set corresponding to the second field.
And the early warning module is used for generating warning information if the third information abstract value is different from the fourth information abstract value and the field value corresponding to the first field is different from the field value corresponding to the second field, wherein the warning information is used for prompting that errors exist in the first field and the second field.
According to the multi-dimensional report data calculation method, the multi-dimensional report data calculation device and the computer equipment, the server receives the request sent from the terminal, then executes the first query information in the request, and performs information abstract calculation on the first query information to obtain the corresponding first information abstract value; and the server receives the request sent by the terminal again, then executes the second query information in the request, and performs information abstract calculation on the second query information to obtain a corresponding second information abstract value. When the server performs information abstract calculation on the second query information and obtains a corresponding information abstract calculation value, the server starts to obtain an information abstract value corresponding to the first query information obtained by calculation; then, the server compares the information abstract value corresponding to the second query information obtained by calculation at present with the information abstract value corresponding to the first query information obtained by calculation. Finally, when the information abstract value corresponding to the second query information is the same as the acquired information abstract value corresponding to the first query information, the server directly returns the historical query result corresponding to the first query information to the query result corresponding to the second query information as a target query result; otherwise, the server continues to execute the query command on the candidate data according to the second query information as a whole query, and obtains a query result corresponding to the second query information as a target query result. By the method, the necessary from-head query and the unnecessary from-head query can be judged in advance, so that the blind from-head query under the condition of the unnecessary from-head query is avoided, the time and the calculation force are saved, and the efficiency is improved.
Drawings
FIG. 1 is a diagram of an application environment of a method for computing multidimensional report data in an embodiment;
FIG. 2 is a flowchart illustrating a method for computing multidimensional report data according to an embodiment;
FIG. 3 is a flowchart illustrating the steps of querying key fields for information in one embodiment;
FIG. 4 is a flowchart illustrating the steps of conditional queries in a report in one embodiment;
FIG. 5 is a diagram illustrating a conditional query in a report in an exemplary embodiment;
FIG. 6 is a flowchart illustrating a step of merging field values in documents according to an embodiment;
FIG. 7 is a diagram illustrating field value merging in documents in an exemplary embodiment;
FIG. 8 is a flowchart illustrating the report error warning procedure in one embodiment;
FIG. 9 is a diagram illustrating an exemplary report error warning;
FIG. 10 is a block diagram of an embodiment of a multidimensional reporting data computing device;
fig. 11 is an internal configuration diagram of a server apparatus in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The multidimensional report data calculation method provided by the application can be applied to the application environment shown in FIG. 1. The application environment comprises a multi-dimensional report data computing system, which comprises: the server 104 receives a request sent from the terminal 102, then executes first query information in the request, and performs information summary calculation on the first query information to obtain a corresponding first information summary value; the server 104 receives the request from the terminal 102 again, then executes the second query information in the request, and performs information summary calculation on the second query information to obtain a corresponding second information summary value. After the server 104 performs information abstract calculation on the second query information and obtains a corresponding information abstract calculation value, the server 104 starts to obtain an information abstract value corresponding to the first query information obtained by the previous calculation; then, the server 104 compares the information digest value corresponding to the second query information obtained by the current calculation with the information digest value corresponding to the first query information obtained by the current calculation. Finally, when the information abstract value corresponding to the second query information is the same as the acquired information abstract value corresponding to the first query information, the server 104 directly returns the historical query result corresponding to the first query information to the query result corresponding to the second query information as the target query result; otherwise, the server 104 will continue to execute the query command on the candidate data according to the second query information as a whole query, and obtain a query result corresponding to the second query information as a target query result. The server 104 may be implemented as a stand-alone server or a server cluster composed of a plurality of servers for different requests of the terminal 102, and the terminal 102 may be, but is not limited to, a personal computer, a notebook computer, a smart phone, a tablet computer, and a portable wearable device.
In an embodiment, as shown in fig. 2, a multidimensional report data calculation method is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:
step 202, acquiring first query information, and performing information summary calculation on the first query information to obtain a corresponding first information summary value.
The first query information is a filtering condition for access in report calculation, and the filtering condition is also called a query condition. The message digest calculation is a value calculated according to a message digest algorithm, which extracts fingerprint information from all data to realize functions such as data signature and data integrity check, and is sometimes used for encrypting sensitive information due to irreversibility. The first message digest value is a value obtained by calculating the first query message using the message digest.
Specifically, after receiving a request from the terminal, the server performs information summary calculation on first query information in the request to obtain a corresponding information summary calculation value. For example, the terminal sends a request to the server, where the request includes first query information, and the first query information includes a plurality of query conditions. When the server receives the request, the server starts to calculate the information abstract of the inquiry condition, the first inquiry information containing various inquiry conditions is subjected to information abstract calculation one by one according to the inquiry condition, and each inquiry condition is subjected to corresponding information abstract value calculation.
Step 204, obtaining second query information, and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value.
The second query information is different from the first query information, only for distinguishing the same operation or object, and is not limited at all. The second query information is also the access filter condition for report calculation, and the filter condition is also called query condition. The second message digest value is also a value obtained by calculating the second query message using the message digest.
Specifically, after receiving the request from the terminal again, the server performs the message digest calculation on the second query message in the request to obtain the corresponding message digest calculation value. For example, the terminal sends a request to the server again, where the request includes second query information including a plurality of query conditions. When the server receives the request, the server starts to calculate the information abstract of the inquiry condition, the second inquiry information containing various inquiry conditions is subjected to information abstract calculation one by one according to the inquiry condition, and each inquiry condition is subjected to corresponding information abstract value calculation.
Step 206, when the second information summary value is the same as the first information summary value, obtaining a historical query result corresponding to the first query information, and taking the historical query result as a target query result corresponding to the second query information.
The historical query result refers to a query result obtained after the query of the first query information is performed, and the query result occurs already compared with a query result obtained after the query of the second query information is performed. The target query result refers to a query result obtained after the query of the second query information, and the query result is a desired result.
Specifically, after the server performs information summary calculation on the second query information and obtains a corresponding information summary calculation value, the server starts to obtain an information summary value corresponding to the first query information obtained by calculation. Then, the server compares the information abstract value corresponding to the second query information obtained by calculation at present with the information abstract value corresponding to the first query information obtained by calculation. And when the information abstract value corresponding to the second query information is the same as the acquired information abstract value corresponding to the first query information, the server directly returns the historical query result corresponding to the first query information to the query result corresponding to the second query information as the target query result.
And 208, when the first information abstract value and the second information abstract value are different, performing overall query on corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
The overall query is a complete query performed once according to query information included in a request sent from a terminal. For example, in report calculation, data is obtained by querying information, and the whole query refers to executing all SQL (structured query language) to obtain data. Here, the candidate data refers to data after being queried for the first information by the server.
Specifically, after the server performs information summary calculation on the second query information and obtains a corresponding information summary calculation value, the server starts to obtain an information summary value corresponding to the first query information obtained by calculation. Then, the server compares the information abstract value corresponding to the second query information obtained by calculation at present with the information abstract value corresponding to the first query information obtained by calculation. When the information abstract value corresponding to the second query information is different from the information abstract value corresponding to the acquired first query information, the server continues to execute a query command on the candidate data according to the second query information as a primary overall query, and obtains a query result corresponding to the second query information as a target query result.
In the multi-dimensional report data calculation method, a server receives a request sent from a terminal, then executes first query information in the request, and performs information summary calculation on the first query information to obtain a corresponding first information summary value; and the server receives the request sent by the terminal again, then executes the second query information in the request, and performs information abstract calculation on the second query information to obtain a corresponding second information abstract value. When the server performs information abstract calculation on the second query information and obtains a corresponding information abstract calculation value, the server starts to obtain an information abstract value corresponding to the first query information obtained by calculation; then, the server compares the information abstract value corresponding to the second query information obtained by calculation at present with the information abstract value corresponding to the first query information obtained by calculation. Finally, when the information abstract value corresponding to the second query information is the same as the acquired information abstract value corresponding to the first query information, the server directly returns the historical query result corresponding to the first query information to the query result corresponding to the second query information as a target query result; otherwise, the server continues to execute the query command on the candidate data according to the second query information as a whole query, and obtains a query result corresponding to the second query information as a target query result. By the method, the necessary from-head query and the unnecessary from-head query can be judged in advance, so that the blind from-head query under the condition of the unnecessary from-head query is avoided, the time and the calculation force are saved, and the efficiency is improved.
In one embodiment, as shown in fig. 3, the current information is the first query information or the second query information, and the step of performing the information summary calculation on the current information includes:
step 302, obtaining the key fields in the current information, and performing information summary calculation on the key fields.
The key field refers to a field participating in operation, the query information includes a plurality of fields, all the fields are changed, and the fields are definitely involved in the operation of the query as long as the fields are changed. Therefore, the essence of defining the fields participating in the operation as key fields is to define the fields that are subject to change as key fields.
Specifically, the server extracts key fields in the current information through a request sent by the terminal, and then performs information summarization on the key fields to obtain information summarization values corresponding to the key field values. For example, the current information contains 10 fields, of which 3 are key fields, one of the 3 key fields is user-defined, and the other two fields are rules obtained from the report calculation history. Then, the server executes the message digest processing command on the 3 fields to obtain the message digest values corresponding to the 3 field values.
In the embodiment, by means of carrying out information abstract calculation on key fields in the current information in advance, the aim of differential calculation can be achieved when any field changes.
In an embodiment, obtaining the key field in the current information includes:
and customizing the key field in the current information by a user or obtaining the key field in the current information according to the report calculation historical record rule.
The key fields in the user-defined current information refer to fields which are easy to change in the report and are known by the user, so that the key fields can be defined in advance. The key fields in the current information obtained according to the report calculation history rule refer to fields which are easy to change and can be obtained through the history of the report, and the fields are the key fields in the current information.
Specifically, when the user knows the fields which are easy to change in the report, the fields can be defined by the user as key fields in the current information; when the user does not know the fields which are easy to change in the report, the fields which are easy to change can be found through the report historical record rule, and the fields are the key fields in the current information; when the user does not determine the fields which are easy to change in the report, the corresponding fields which are easy to change can be found by combining the report historical record rules, and the fields are the key fields in the current information.
In one embodiment, the calculating the information summary of the key field comprises:
the information summarization calculation for the key field may be an MD5(MD5 Message-Digest Algorithm, MD5 information summarization Algorithm) calculation for the key field to obtain an MD5 value of the key field value.
The principle of MD5 is that MD5 codes process input information in 512-bit packets, each packet is divided into 16 32-bit sub-packets, and after a series of processing, the output of the algorithm is composed of four 32-bit packets, and a 128-bit hash value is generated by concatenating the four 32-bit packets.
Specifically, the server extracts key fields in the current information through a request sent by the terminal, and then the server performs MD5 calculation on the key fields to obtain MD5 values corresponding to the key field values.
In an embodiment, as shown in fig. 4, before obtaining the historical query result corresponding to the first query information, the method further includes:
step 402, obtaining an information summary of first candidate data, where the first candidate data is candidate data corresponding to the first query information.
The candidate data corresponding to the first query information is data before the server receives the request from the terminal and passes through the first query data. Data is generally stored in a database, and when specific data in the database is to be processed, a range is usually defined, and the data in the range is to be processed. Within the range of the data to be processed, the data which is easy to change may be defined as the candidate data here, or the data to be processed may be directly defined as the candidate data.
Specifically, the server performs information summarization on first candidate data through a request sent by the terminal, wherein the first candidate data is data before the server passes through the first query data. Then, the server obtains the information abstract value of the first candidate data, namely the information abstract value of the candidate data corresponding to the first query information.
Step 404, obtaining an information summary of second candidate data, where the second candidate data is candidate data corresponding to the second query information.
The candidate data corresponding to the second query information is data subjected to the first query after the server receives the request from the terminal again. The second candidate is different from the first candidate only for the purpose of distinguishing the same operation or object, and is not used for any limitation.
Specifically, the server performs information summarization on second candidate data through a request sent again by the terminal, wherein the second candidate data is data of the server after the first query. Then, the server obtains the information abstract value of the second candidate data, namely the information abstract value of the candidate data corresponding to the second query information.
Step 406, when the information summary of the first candidate data is the same as the information summary of the second candidate data, entering the step of obtaining the historical query result corresponding to the first query information.
The historical query result refers to a query result obtained after the query of the first query information is performed, and the query result occurs already compared with a query result obtained after the query of the second query information is performed.
Specifically, after the server performs the message digest calculation on the second candidate data and obtains the corresponding message digest calculation value, the server starts to obtain the message digest value corresponding to the first candidate data obtained by the previous calculation. And then, the server compares the information abstract value corresponding to the second candidate data obtained by calculation at present with the information abstract value corresponding to the first candidate data obtained by calculation. And when the information abstract value corresponding to the second candidate data is the same as the acquired information abstract value corresponding to the first candidate data, the server directly returns the historical query result corresponding to the first query information to the query result corresponding to the second candidate data.
Step 408, when the information abstract of the first candidate data is different from the information abstract of the second candidate data, performing the overall query in the corresponding candidate data based on the second query information to obtain the target query result corresponding to the second query information.
The overall query is a complete query performed once according to query information included in a request sent from a terminal.
Specifically, after the server performs the message digest calculation on the second candidate data and obtains the corresponding message digest calculation value, the server starts to obtain the message digest value corresponding to the first candidate data obtained by the previous calculation. And then, the server compares the information abstract value corresponding to the second candidate data obtained by calculation at present with the information abstract value corresponding to the first candidate data obtained by calculation. When the information abstract value corresponding to the second candidate data is different from the information abstract value corresponding to the acquired first candidate data, the server continues to execute the query command on the candidate data according to the second query information as a whole query, and obtains a query result corresponding to the second query information.
In this embodiment, the server performs information abstraction on the first candidate data through a request sent by the terminal, so as to obtain an information abstraction value of the candidate data corresponding to the first query information. Then, the server performs information abstraction on the second candidate data through a request sent again by the terminal, and an information abstraction value of the candidate data corresponding to the second query information is obtained. And when the server performs information abstract calculation on the second candidate data and obtains a corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first candidate data obtained by calculation. And finally, the server compares the information abstract value corresponding to the second candidate data obtained by calculation at present with the information abstract value corresponding to the first candidate data. And when the information abstract value corresponding to the second candidate data is the same as the acquired information abstract value corresponding to the first candidate data, the server directly returns the historical query result corresponding to the first query information to the query result corresponding to the second candidate data. Otherwise, the server continues to execute the query command on the candidate data according to the second query information as a whole query, and obtains a query result corresponding to the second query information. In this way, the report query condition is converted into the information abstract value, so that the query condition change can be compared quickly. Under the condition that the query condition is not changed, the information abstract value is not changed, and the server does not need to execute complete one-time query; instead, the server needs to perform a complete query.
In a specific embodiment, as shown in fig. 5, the query condition a 501 is composed of a1, a2, and A3, the query condition B502 is composed of B1, B2, and B3, and the server performs information summarization on the first candidate data through a request sent by the terminal to obtain an information summary value a 503 of the candidate data corresponding to the first query information. Then, the server performs information summarization on the second candidate data through a request sent again by the terminal, and an information summary value b 504 of the candidate data corresponding to the second query information is obtained. And when the server performs information abstract calculation on the second candidate data and obtains a corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first candidate data obtained by calculation. Finally, the server compares the information abstract value b 504 corresponding to the second candidate data obtained by calculation at present with the information abstract value a 503 corresponding to the first candidate data obtained by calculation. When a is equal to b, the server directly returns the historical query result corresponding to the first query information to the query result corresponding to the second candidate data. Otherwise, if a is not equal to b, the server will continue to execute the query command on the candidate data according to the second query information as a whole query, and obtain a query result corresponding to the second query information.
In one embodiment, as shown in fig. 6, a method for calculating multi-dimensional report data further includes:
step 602, obtaining an associated field value set corresponding to a target field in a target document.
The target document refers to a document to be subjected to data processing. The target field refers to the field in the target document where the change occurred. The target document can be the same document or different documents.
Specifically, the server obtains an associated field value set corresponding to a target field in the target document through a request sent by the terminal. For example, the terminal sends a request, and after the request includes target field values C1, C2, C3, …, cn (n represents a positive integer) in the target document C, and the server receives the request, the target fields are unified and integrated through the server to be the associated field value set corresponding to the target fields.
Step 604, calculating the information abstract value of the character string composed of each field value in the associated field value set.
Specifically, the server calculates the information summary value of the character string composed of each field value in the associated field value set through a request sent again by the terminal. For example, the terminal issues a request for extracting information of the information digest value of a character string composed of C1, C2, C3, …, and cn (n represents a positive integer) in the set of target field values C1, C2, C3, …, and cn (n represents a positive integer) in the target document C, and the server performs information digest processing on the request after receiving the request.
Step 606, when the information abstract value of the character string changes, updating the field value corresponding to the target field according to each field value in the associated field value set.
The change of the information abstract value of the character string indicates that the information of the character string is changed, and the change of the information abstract value of the character string indicates that at least one piece of character information is changed.
Specifically, when the server determines that the information summary value of the character string changes, the server updates the field value corresponding to the target field according to each field value in the associated field value set.
In this embodiment, the server obtains the associated field value set corresponding to the target field in the target document through a request sent by the terminal. Then, the server calculates the information summary value of the character string composed of each field value in the associated field value set through a request sent by the terminal again. And finally, when judging that the information abstract value of the character string changes, the server updates the field value corresponding to the target field according to each field value in the associated field value set. By the method, whether the field value in the document is changed or not can be rapidly positioned, and then the change of the calculation condition can be accurately judged.
In a specific embodiment, as shown in fig. 7, the terminal sends a request, where the request includes target field values D1 and D2 in the target document D701 and target fields E1 and E2 in the document E702, and information for summarizing the information is formed by combining D1, D2, E1, and E2 together. After receiving the request, the server unites d1, d2, e1 and e2 together to form a set. Then, the terminal sends a request which contains information for extracting the information abstract value of the character string consisting of the target field values D1 and D2 in the D701 and the target field values E1 and E2 in the document E702, and the D1, D2, E1 and E2 in the collection, and the server receives the request and then performs information abstract processing on the request to obtain the information abstract value. Finally, when the server judges that the information abstract value of the character string changes, the server updates the corresponding field value of the target field j3 for the document 703 according to the values d1, d2, e1 and e2 in the associated field value set.
In one embodiment, as shown in fig. 8, a method for calculating multi-dimensional report data further includes:
step 802, a field value corresponding to a first field in a first document is obtained.
Specifically, the server obtains a field value corresponding to a first field in the first document through a request sent by the terminal. For example, the terminal sends a request, the request includes a field value corresponding to the field F1 in the production document F, and the server processes the request after receiving the request.
Step 804, a field value corresponding to a second field in a second document is obtained, wherein the business logic calculation rules corresponding to the first field and the field are the same.
The second sheet is different from the first sheet only for distinguishing the same operation or object, and is not used for any limitation. The second field is distinct from the first field only for the purpose of distinguishing between the same operation or object and is not intended to be limiting in any way. The business logic calculation rule refers to specific or appointed objects in the calculation document according to business requirements. For example, the production document G and the production document H contain the object of the production quantity in the field 1 column, and the object is obtained through the same functional relationship via the business requirement.
Specifically, the server acquires a field value corresponding to a second field in the second document through a request sent again by the terminal. For example, the terminal sends a request, the request includes a field value corresponding to a field I1 in the production document I, and the server processes the request after receiving the request. Where f1 and i1 are the objects specified in the calculation according to business requirements.
Step 806, obtaining a third information digest value of the associated field value set corresponding to the first field.
Specifically, the server performs information digest processing on the associated field value set corresponding to the first field through a request sent by the terminal, and acquires a third information digest value of the associated field value set. For example, the terminal sends a request, the request includes information for acquiring a third information summary value of the associated field value set corresponding to the field F1 in the production document F, and the server processes the request after receiving the request.
Step 808, obtaining a fourth information digest value of the associated field value set corresponding to the second field.
The fourth message digest is different from the third message digest only for the purpose of distinguishing the same operation or object, and is not limited to any particular use.
Specifically, the server performs information digest processing on the associated field value set corresponding to the second field through a request sent again by the terminal, and acquires a fourth information digest value of the associated field value set. For example, the terminal sends a request, the request includes information for acquiring a fourth information summary value of an associated field value set corresponding to the field I1 in the production document I, and the server processes the request after receiving the request.
Step 810, if the third information abstract value is different from the fourth information abstract value, and the field value corresponding to the first field is different from the field value corresponding to the second field, generating an alarm message, where the alarm message is used to prompt that an error exists between the first field and the second field.
Specifically, the server determines that, if the third information digest value is different from the fourth information digest value and the field value corresponding to the first field is different from the field value corresponding to the second field, an alarm message is generated, where the alarm message is used to prompt that an error exists between the first field and the second field. For example, the server determines that the information of the third information summary value of the associated field value set corresponding to the field F1 in the production document F is different from the fourth information summary value of the associated field value set corresponding to the field I1 in the production document I, and F1 is not equal to I1, so that the server immediately generates the alarm information to prompt that F1 and I1 have a problem.
In this embodiment, the server obtains a field value corresponding to a first field in the first document through a request sent by the terminal, and obtains a field value corresponding to a second field in the second document through a request sent again by the terminal. Then, the server performs information abstraction processing on the associated field value set corresponding to the first field through a request sent by the terminal, acquires a third information abstraction value of the associated field value set, performs information abstraction processing on the associated field value set corresponding to the second field through a request sent again by the terminal, and acquires a fourth information abstraction value of the associated field value set. And finally, the server judges that if the third information abstract value is different from the fourth information abstract value and the field value corresponding to the first field is different from the field value corresponding to the second field, alarm information is generated and used for prompting that errors exist in the first field and the second field. By the method, the effect of quickly comparing different fields of a plurality of reports can be achieved.
In a specific embodiment, as shown in fig. 9, the terminal sends a request, where the request includes a field value corresponding to a field J2 in the acquired report J901, and the server processes the request after receiving the request. The terminal sends a request, the request comprises a field value corresponding to the field K2 in the report K902, and the server processes the request after receiving the request. Where j2 and k2 are the objects specified in the computation according to business requirements. The terminal sends a request, the request includes information for obtaining a third information summary value of the associated field value set corresponding to the field J2 in the report J901, and the server processes the request according to the request after receiving the request. The terminal sends a request, the request includes information for obtaining a fourth information summary value of the associated field value set corresponding to the field K2 in the report K902, and the server processes the request after receiving the request. The server judges that the information of the third information summary value of the associated field value set corresponding to the field J2 in the report J901 is different from the fourth information summary value of the associated field value set corresponding to the field K2 in the report K902, and J2 is not equal to K2, so that the server immediately generates the alarm information to prompt that J2 and K2 have problems.
It should be understood that although the various steps in the flowcharts of fig. 2-4, 6 and 8 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-4, 6 and 8 may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least some of the other steps.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculation apparatus, including: the device comprises a first acquisition calculation module, a second acquisition calculation module and a first judgment processing module, wherein:
the first acquisition and calculation module is used for acquiring first query information and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value;
the second acquisition and calculation module is used for acquiring second query information and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value;
the first judgment processing module is used for acquiring a historical query result corresponding to the first query information when the second information abstract value is the same as the first information abstract value, and taking the historical query result as a target query result corresponding to the second query information;
and when the first information abstract value and the second information abstract value are different, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculation apparatus, including:
and the first acquisition module is used for acquiring the key fields in the current information and carrying out information abstract calculation on the key fields.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculation apparatus, including:
a second obtaining module, configured to obtain an information summary of first candidate data, where the first candidate data is candidate data corresponding to the first query information;
and the information abstract of second candidate data is acquired, wherein the second candidate data is the candidate data corresponding to the second query information.
A second judgment processing module, configured to, when the information summary of the first candidate data is the same as the information summary of the second candidate data, perform the step of obtaining a historical query result corresponding to the first query information;
and when the information abstract of the first candidate data is different from the information abstract of the second candidate data, performing overall query on the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculation apparatus, including:
and the third acquisition module is used for acquiring the associated field value set corresponding to the target field in the target document.
And the calculation module is used for calculating the information abstract value of the character string consisting of all field values in the associated field value set.
And the third judgment processing module is used for updating the field value corresponding to the target field according to each field value in the associated field value set when the information abstract value of the character string changes.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculation apparatus, including:
the fourth obtaining module is used for obtaining a field value corresponding to the first field in the first document;
the method is also used for acquiring a field value corresponding to a second field in a second document, wherein the business logic calculation rules corresponding to the first field and the field are the same;
the third information summary value is also used for acquiring the associated field value set corresponding to the first field;
and the fourth information summary value is also used for acquiring the associated field value set corresponding to the second field.
And the early warning module is used for generating warning information if the third information abstract value is different from the fourth information abstract value and the field value corresponding to the first field is different from the field value corresponding to the second field, wherein the warning information is used for prompting that errors exist in the first field and the second field.
For the specific definition of the multidimensional report data calculation device, reference may be made to the above definition of the multidimensional report data calculation method, which is not described herein again. All modules in the multi-dimensional report data calculation device can be completely or partially realized through software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 11. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used for storing multi-dimensional report data calculation data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to realize a multi-dimensional report data calculation method.
Those skilled in the art will appreciate that the architecture shown in fig. 11 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program:
acquiring first query information, and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value.
And acquiring second query information, and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value.
And when the second information abstract value is the same as the first information abstract value, obtaining a historical query result corresponding to the first query information, and taking the historical query result as a target query result corresponding to the second query information.
And when the first information abstract value is different from the second information abstract value, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, the current information is the first query information or the second query information, and the processor executes the computer program to further implement the following steps:
and acquiring key fields in the current information, and performing information abstract calculation on the key fields.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
and customizing the key field in the current information by a user or obtaining the key field in the current information according to the report calculation historical record rule.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
and acquiring an information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information.
And acquiring an information abstract of second candidate data, wherein the second candidate data is the candidate data corresponding to the second query information.
And when the information abstract of the first candidate data is the same as the information abstract of the second candidate data, entering the step of acquiring the historical query result corresponding to the first query information.
And when the information abstract of the first candidate data is different from the information abstract of the second candidate data, performing overall query on the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
and acquiring an associated field value set corresponding to a target field in the target document.
And calculating the information abstract value of the character string formed by each field value in the associated field value set.
When the information abstract value of the character string changes, updating the field value corresponding to the target field according to each field value in the associated field value set.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
and acquiring a field value corresponding to a first field in the first document.
And acquiring a field value corresponding to a second field in a second document, wherein the business logic calculation rules corresponding to the first field and the field are the same.
And acquiring a third information summary value of the associated field value set corresponding to the first field.
And acquiring a fourth information summary value of the associated field value set corresponding to the second field.
And if the third information abstract value is different from the fourth information abstract value, and the field value corresponding to the first field is different from the field value corresponding to the second field, generating alarm information, wherein the alarm information is used for prompting that errors exist in the first field and the second field.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring first query information, and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value;
acquiring second query information, and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value;
when the second information abstract value is the same as the first information abstract value, obtaining a historical query result corresponding to the first query information, and taking the historical query result as a target query result corresponding to the second query information;
and when the first information abstract value is different from the second information abstract value, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, the computer program when executed by the processor further performs the steps of:
and acquiring key fields in the current information, and performing information abstract calculation on the key fields.
In one embodiment, the computer program when executed by the processor further performs the steps of:
and customizing the key field in the current information by a user or obtaining the key field in the current information according to the report calculation historical record rule.
In one embodiment, the computer program when executed by the processor further performs the steps of:
and acquiring an information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information.
And acquiring an information abstract of second candidate data, wherein the second candidate data is the candidate data corresponding to the second query information.
And when the information abstract of the first candidate data is the same as the information abstract of the second candidate data, entering the step of acquiring the historical query result corresponding to the first query information.
And when the information abstract of the first candidate data is different from the information abstract of the second candidate data, performing overall query on the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
In one embodiment, the computer program when executed by the processor further performs the steps of:
and acquiring an associated field value set corresponding to a target field in the target document.
And calculating the information abstract value of the character string formed by each field value in the associated field value set.
When the information abstract value of the character string changes, updating the field value corresponding to the target field according to each field value in the associated field value set.
In one embodiment, the computer program when executed by the processor further performs the steps of:
and acquiring a field value corresponding to a first field in the first document.
And acquiring a field value corresponding to a second field in a second document, wherein the business logic calculation rules corresponding to the first field and the field are the same.
And acquiring a third information summary value of the associated field value set corresponding to the first field.
And acquiring a fourth information summary value of the associated field value set corresponding to the second field.
And if the third information abstract value is different from the fourth information abstract value, and the field value corresponding to the first field is different from the field value corresponding to the second field, generating alarm information, wherein the alarm information is used for prompting that errors exist in the first field and the second field.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A multi-dimensional report data calculation method is characterized by comprising the following steps:
acquiring first query information, and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value;
acquiring second query information, and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value;
when the second information abstract value is the same as the first information abstract value, obtaining a historical query result corresponding to the first query information, and taking the historical query result as a target query result corresponding to the second query information;
and when the first information abstract value is different from the second information abstract value, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
2. The method of claim 1, wherein the current information is the first query information or the second query information, and the step of performing the information digest calculation on the current information comprises:
and acquiring key fields in the current information, and performing information abstract calculation on the key fields.
3. The method of claim 2, wherein the obtaining the key field in the current information comprises:
and customizing the key field in the current information by a user or obtaining the key field in the current information according to the report calculation historical record rule.
4. The method of claim 2, wherein performing the information digest computation on the key field comprises:
and performing MD5 calculation on the key field to obtain an MD5 value of the key field value.
5. The method according to claim 1, wherein before the obtaining the historical query result corresponding to the first query information, further comprising:
acquiring an information abstract of first candidate data, wherein the first candidate data are candidate data corresponding to the first query information;
acquiring an information abstract of second candidate data, wherein the second candidate data is candidate data corresponding to the second query information;
when the information abstract of the first candidate data is the same as the information abstract of the second candidate data, entering the step of acquiring the historical query result corresponding to the first query information;
and when the information abstract of the first candidate data is different from the information abstract of the second candidate data, performing overall query on the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
6. The method of claim 1, further comprising:
acquiring an associated field value set corresponding to a target field in a target document;
calculating the information abstract value of the character string formed by each field value in the associated field value set;
when the information abstract value of the character string changes, updating the field value corresponding to the target field according to each field value in the associated field value set.
7. The method of claim 1, further comprising:
acquiring a field value corresponding to a first field in a first document;
acquiring a field value corresponding to a second field in a second document, wherein the business logic calculation rules corresponding to the first field and the field are the same;
acquiring a third information summary value of the associated field value set corresponding to the first field;
acquiring a fourth information summary value of the associated field value set corresponding to the second field;
and if the third information abstract value is different from the fourth information abstract value, and the field value corresponding to the first field is different from the field value corresponding to the second field, generating alarm information, wherein the alarm information is used for prompting that errors exist in the first field and the second field.
8. A multidimensional reporting data computing apparatus, the apparatus comprising:
the first acquisition and calculation module is used for acquiring first query information and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value;
the second acquisition and calculation module is used for acquiring second query information and performing information abstract calculation on the second query information to obtain a corresponding second information abstract value;
the first judgment processing module is used for acquiring a historical query result corresponding to the first query information when the second information abstract value is the same as the first information abstract value, and taking the historical query result as a target query result corresponding to the second query information; and when the first information abstract value and the second information abstract value are different, performing overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110995769.1A CN113806504B (en) | 2021-08-27 | 2021-08-27 | Multi-dimensional report data calculation method and device and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110995769.1A CN113806504B (en) | 2021-08-27 | 2021-08-27 | Multi-dimensional report data calculation method and device and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113806504A true CN113806504A (en) | 2021-12-17 |
| CN113806504B CN113806504B (en) | 2024-04-02 |
Family
ID=78942095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110995769.1A Active CN113806504B (en) | 2021-08-27 | 2021-08-27 | Multi-dimensional report data calculation method and device and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113806504B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102375813A (en) * | 2010-08-09 | 2012-03-14 | 腾讯科技（深圳）有限公司 | Duplicate detection system and method for search engines |
| CN110019350A (en) * | 2017-07-28 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on configuration information |
| CN113220684A (en) * | 2021-05-12 | 2021-08-06 | 北京马赫谷科技有限公司 | Data packet storage and query method, device, system and storage medium |
-
2021
- 2021-08-27 CN CN202110995769.1A patent/CN113806504B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102375813A (en) * | 2010-08-09 | 2012-03-14 | 腾讯科技（深圳）有限公司 | Duplicate detection system and method for search engines |
| CN110019350A (en) * | 2017-07-28 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on configuration information |
| CN113220684A (en) * | 2021-05-12 | 2021-08-06 | 北京马赫谷科技有限公司 | Data packet storage and query method, device, system and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113806504B (en) | 2024-04-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Hompes et al. | Discovering deviating cases and process variants using trace clustering | |
| Zhang et al. | Ektelo: A framework for defining differentially-private computations | |
| US9817858B2 (en) | Generating hash values | |
| US9477974B2 (en) | Method and systems for flexible and scalable databases | |
| CN107729371B (en) | Data indexing and querying method, device, equipment and storage medium of block chain | |
| US8849837B2 (en) | Configurable dynamic matching system | |
| CN109815226B (en) | Block chain-based data storage method, device, equipment and storage medium | |
| CN111708771A (en) | Data duplicate checking method, device, equipment and computer storage medium | |
| CN117033424A (en) | Query optimization method and device for slow SQL (structured query language) statement and computer equipment | |
| CN117061254B (en) | Abnormal flow detection method, device and computer equipment | |
| CN113806504B (en) | Multi-dimensional report data calculation method and device and computer equipment | |
| CN109522915B (en) | Virus file clustering method and device and readable medium | |
| CN114745173B (en) | Login verification method, login verification device, computer equipment and storage medium | |
| US9916373B2 (en) | Dynamic data partitioning extension | |
| CN112416966A (en) | Ad hoc query method, apparatus, computer device and storage medium | |
| Zheng et al. | Compact, tamper-resistant archival of fine-grained provenance | |
| Sutton et al. | Timestamp-based integrity proofs for linked data | |
| CN112202822B (en) | Database injection detection method and device, electronic equipment and storage medium | |
| CN110874469A (en) | Database high-risk operation detection method and device, computer equipment and storage medium | |
| CN113672457B (en) | Method and device for identifying abnormal operation in database | |
| US12013830B2 (en) | System and method using bloom filters to improve system reliability | |
| CN113867975B (en) | Quick response method and device for command line and computer equipment | |
| CN117406967B (en) | Component identification method and device, electronic equipment and storage medium | |
| CN112860755B (en) | Service identifier generation method, device, computer equipment and medium | |
| CN115309770A (en) | Data analysis method, device, equipment and storage medium based on user-defined strategy |
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 |