CN113806504B - 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
- CN113806504B CN113806504B CN202110995769.1A CN202110995769A CN113806504B CN 113806504 B CN113806504 B CN 113806504B CN 202110995769 A CN202110995769 A CN 202110995769A CN 113806504 B CN113806504 B CN 113806504B
- Authority
- CN
- China
- Prior art keywords
- information
- query
- field
- value
- abstract
- 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.)
- Active
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 124
- 238000000034 method Methods 0.000 claims abstract description 53
- 238000004590 computer program Methods 0.000 claims description 21
- 238000012545 processing Methods 0.000 claims description 21
- 230000008859 change Effects 0.000 description 15
- 238000004519 manufacturing process Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 7
- 238000004422 calculation algorithm Methods 0.000 description 4
- 238000001914 filtration Methods 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 239000004099 Chlortetracycline Substances 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000013496 data integrity verification Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000007726 management method Methods 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
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
Abstract
The application relates to a multi-dimensional report data calculation method, a multi-dimensional report data calculation device 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, acquiring 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 and the second information abstract value are different, carrying out overall query in the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information. By adopting the method, time and calculation force can be saved, and the efficiency is improved.
Description
Technical Field
The present invention relates to the field of business management technologies, and in particular, to a method, an apparatus, and a computer device for calculating multidimensional report data.
Background
In a business system, some complex reports have a large number of statistical fields, for example, as many as 90 columns of volume benefit reports, each column needs to be calculated according to past query conditions, and the result is returned. When a report involves incremental changes, i.e., a document changes, the conventional approach is to query again from scratch. 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 the time is very long.
Disclosure of Invention
Based on the above, it is necessary to provide a method, a device and a computer device for calculating multidimensional report data, so as to save time and calculation force and improve efficiency.
A method of multi-dimensional report data calculation, the method comprising:
and 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, acquiring 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 and the second information abstract value are different, carrying out overall query in 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 step of performing a message digest calculation on the current message includes:
and acquiring a key field in the current information, and performing information abstract calculation on the key field.
In one embodiment, the obtaining the key field in the current information includes:
and the key fields in the current information are obtained by user definition or according to report calculation history rules.
In one embodiment, the performing the information summary calculation on the key field includes:
and carrying out MD5 calculation on the key field to obtain an MD5 value of the key field value.
In one embodiment, before obtaining the historical query result corresponding to the first query information, the method further includes:
and acquiring the information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information.
And acquiring the 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, entering a step of carrying out overall query in 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 multidimensional report data further comprises:
and acquiring an associated field value set corresponding to the 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.
And when the information abstract value of the character string is changed, 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 multidimensional report data further comprises:
and acquiring a field value corresponding to a first field in the first bill.
And acquiring a field value corresponding to a second field in the second bill, wherein the service logic calculation rules corresponding to the first field and the second field are the same.
And acquiring a third information abstract value of the associated field value set corresponding to the first field.
And acquiring a fourth information abstract 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 the first field and the second field have errors.
A multi-dimensional report data computing device, the device comprising:
the first acquisition and calculation module acquires first query information, and performs 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 carrying out information abstract calculation on the second query information to obtain a corresponding second information abstract value;
the first judging and 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 the method is also used for carrying out overall query in the corresponding candidate data based on the second query information when the first information abstract value and the second information abstract value are different, so as to obtain a target query result corresponding to the second query information.
In one embodiment, a multi-dimensional report data computing device, the step of performing information summary computation on current information includes:
the first acquisition module is used for acquiring key fields in the current information and carrying out information abstract calculation on the key fields.
In one embodiment, the multi-dimensional report data calculating device further includes:
the second acquisition module is used for acquiring the information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information;
and the method is also used for acquiring the information abstract of the second candidate data, wherein the second candidate data is the candidate data corresponding to the second query information.
The second judging and processing module is used for entering the step of acquiring the historical query result corresponding to the first query information when the information abstract of the first candidate data is the same as the information abstract of the second candidate data;
And the step of entering the step of carrying out overall query in the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information when the information abstract of the first candidate data is different from the information abstract of the second candidate data.
In one embodiment, a multi-dimensional report data calculating apparatus further includes:
and the third acquisition module is used for acquiring the associated field value set corresponding to the target field in the target bill.
And the calculation module is used for calculating the information abstract value of the character string formed by each field value in the associated field value set.
And a third judging and processing module, configured to update, when the information abstract value of the character string changes, a field value corresponding to the target field according to each field value in the associated field value set.
In one embodiment, a multi-dimensional report data calculating apparatus further includes:
the fourth acquisition module is used for acquiring a field value corresponding to the first field in the first bill;
the method is also used for acquiring a field value corresponding to a second field in the second bill, wherein the service logic calculation rules corresponding to the first field and the second field are the same;
The method is also used for obtaining a third information abstract value of the associated field value set corresponding to the first field;
and the method is also used for acquiring a fourth information abstract value of 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, and the warning information is used for prompting that the first field and the second field have errors.
The server receives a request sent by 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; the server receives the request from the terminal again, then executes the second inquiry information in the request, and carries out information abstract calculation on the second inquiry information to obtain a corresponding second information abstract value. After the server performs information abstract calculation on the second query information and obtains a corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first query information obtained by calculation before; and then, the server compares the information abstract value corresponding to the second query information calculated at present with the information abstract value corresponding to the first query information. Finally, when the information abstract value corresponding to the second query information is the same as the information abstract value corresponding to the acquired 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 head-from inquiry and the unnecessary head-from inquiry can be judged in advance, so that blind head-from inquiry under the condition of unnecessary head-from inquiry is avoided, time and calculation force are saved, and efficiency is improved.
Drawings
FIG. 1 is an application environment diagram of a multi-dimensional report data computing method in one embodiment;
FIG. 2 is a flowchart of a method for computing multidimensional report data in one embodiment;
FIG. 3 is a flowchart illustrating steps for querying key fields for information in one embodiment;
FIG. 4 is a flowchart illustrating steps for conditional queries in a report in one embodiment;
FIG. 5 is a diagram of conditional queries in a report in one embodiment;
FIG. 6 is a flow chart illustrating a field value merging step in a document in one embodiment;
FIG. 7 is a diagram illustrating field value merging in a document in one embodiment;
FIG. 8 is a flowchart illustrating a report error warning step in one embodiment;
FIG. 9 is a schematic diagram of a report error warning in one embodiment;
FIG. 10 is a block diagram of a multi-dimensional report data computing device in one embodiment;
fig. 11 is an internal structural diagram of a server device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The multi-dimensional report data calculation method provided by the application can be applied to an application environment shown in fig. 1. The application environment includes a multi-dimensional report data computing system, the system comprising: the server 104 receives the request from the terminal 102, then executes the first query information in the request, and performs information abstract calculation on the first query information to obtain a corresponding first information abstract value; the server 104 receives the request from the terminal 102 again, then executes the second query information in the request, and performs the information summary calculation on the second query information to obtain the corresponding second information summary value. After the server 104 performs the information abstract calculation on the second query information and obtains the corresponding information abstract calculation value, the server 104 starts to obtain the information abstract value corresponding to the first query information obtained by previous calculation; then, the server 104 compares the currently calculated information abstract value corresponding to the second query information with the obtained information abstract value corresponding to the first query information. Finally, when the information abstract value corresponding to the second query information is the same as the information abstract value corresponding to the obtained 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 a target query result; otherwise, the server 104 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. For different requests that occur at the terminal 102, the server 104 may be implemented as a stand-alone server or a cluster of servers, and the terminal 102 may be, but is not limited to, a personal computer, a notebook, a smart phone, a tablet, and a portable wearable device.
In one embodiment, as shown in fig. 2, a multi-dimensional report data calculating method is provided, and the method is applied to the server in fig. 1 for illustration, and includes the following steps:
step 202, obtaining first query information, and performing information abstract calculation on the first query information to obtain a corresponding first information abstract value.
The first query information is a filtering condition of access number in report calculation, and the filtering condition is also called a query condition. The information digest calculation is a value calculated according to an information digest algorithm, and the information digest algorithm extracts fingerprint information from all data to realize functions of data signature, data integrity verification and the like, and is sometimes used for encrypting sensitive information due to the irreversibility of the information digest. The first message digest value is a numerical value obtained by calculating the first query information using the message digest.
Specifically, after receiving a request from a terminal, the server performs information abstract calculation on first query information in the request and obtains a corresponding information abstract 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 information abstract calculation is started to be carried out on the query conditions, the first query information containing a plurality of query conditions is carried out one by one according to the query conditions, and each query condition is calculated to be a corresponding information abstract value.
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, and is only for distinguishing the same kind of operation or object, and is not used for limiting. The second query information is also the filtering condition of the fetch number in report calculation, and the filtering condition is also called as a 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 information abstract calculation on the second query information in the request and obtains a corresponding information abstract calculation value. For example, the terminal sends a request to the server again, where the request includes second query information, and the second query information includes a plurality of query conditions. When the server receives the request, the information abstract calculation is started to be carried out on the query conditions, the second query information containing a plurality of query conditions is carried out one by one according to the query conditions, and each query condition is calculated to be a corresponding information abstract value.
And step 206, when the second information abstract value is the same as the first information abstract value, acquiring 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, and the query result happens relatively to a query result obtained after the query of the second query information. 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 the information abstract calculation on the second query information and obtains the corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first query information obtained by previous calculation. And then, the server compares the information abstract value corresponding to the second query information calculated at present with the information abstract value corresponding to the first query information. When the information abstract value corresponding to the second query information is the same as the information abstract value corresponding to the acquired 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.
And step 208, when the first information abstract value and the second information abstract value are different, carrying out overall query in the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
The whole inquiry refers to one complete inquiry according to inquiry information contained in a request sent by a terminal. For example, in report calculation, the query information is used to perform the fetching, and the whole query refers to executing all SQL (structured query language) to acquire data. Here, the candidate data refers to data after being queried by the first information of the server.
Specifically, after the server performs the information abstract calculation on the second query information and obtains the corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first query information obtained by previous calculation. And then, the server compares the information abstract value corresponding to the second query information calculated at present with the information abstract value corresponding to the first query information. 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 the query command to 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.
In the multi-dimensional report data calculation method, a server receives a request sent by a terminal, then executes first query information in the request, and performs information abstract calculation on the first query information to obtain a corresponding first information abstract value; the server receives the request from the terminal again, then executes the second inquiry information in the request, and carries out information abstract calculation on the second inquiry information to obtain a corresponding second information abstract value. After the server performs information abstract calculation on the second query information and obtains a corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first query information obtained by calculation before; and then, the server compares the information abstract value corresponding to the second query information calculated at present with the information abstract value corresponding to the first query information. Finally, when the information abstract value corresponding to the second query information is the same as the information abstract value corresponding to the acquired 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 head-from inquiry and the unnecessary head-from inquiry can be judged in advance, so that blind head-from inquiry under the condition of unnecessary head-from inquiry is avoided, time and calculation force are saved, and 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 information summary calculation on the current information includes:
step 302, obtaining a key field in the current information, and performing information abstract calculation on the key field.
The key field refers to a field participating in operation, and the query information contains a plurality of field information, and all the fields change, but the operation of the query is certainly participated as long as the fields change. Thus, the essence of defining the fields involved in the operation as key fields is that the fields that are easy to change are defined as key fields.
Specifically, the server extracts key fields in the current information through a request sent by the terminal, and then the server performs information summarization on the key fields to obtain information summarization values corresponding to the key field values. For example, the current information includes 10 fields, wherein 3 fields are key fields, one of the 3 key fields is user-defined, and the other two fields are rules obtained by report calculation history. Then, the server executes the message digest processing command on these 3 fields, resulting in message digest values corresponding to these 3 field values.
In this embodiment, the key fields in the current information are advanced and information abstract calculation is performed on the key fields, so that the purpose of differential calculation when any field changes can be solved.
In an embodiment, obtaining the key field in the current information includes:
and the key fields in the current information are obtained by user definition or according to report calculation history rules.
The key fields in the user-defined current information refer to fields which are easy to change in the report, so that the key fields can be defined in advance. The key fields in the current information are obtained according to the report calculation history rules, namely the fields which are easy to change 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 customized to be 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 report history rules, and the fields are 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 history rules, and the fields are key fields in the current information.
In one embodiment, performing a message digest calculation on the key field includes:
the information Digest calculation of the key field may be that MD5 (MD 5 Message-Digest Algorithm) is performed on the key field to obtain an MD5 value of the key field value.
The principle of MD5 is that the MD5 code processes the input information in 512-bit packets, each packet is divided into 16 32-bit sub-packets, after a series of processing, the output of the algorithm is composed of four 32-bit packets, and after the four 32-bit packets are concatenated, a 128-bit hash value is generated.
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 one 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 a message digest 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 refers to data before the server receives the request from the terminal and passes through the first query data. The data is generally stored in a database, and when specific data in the database is to be processed, a range is generally defined, and the data in the range, that is, the data to be processed, is defined. The data which is easy to change in the range of the data to be processed can be defined as candidate data here, or the data to be processed can be directly defined as candidate data.
Specifically, the server performs information abstraction 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. And 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 a message digest of second candidate data, where the second candidate data is the candidate data corresponding to the second query information.
The candidate data corresponding to the second query information is data after the server receives the request from the terminal again and then performs the first query. The second candidate data is different from the first candidate data only for distinguishing the same kind of operation or object, and is not used for any limitation.
Specifically, the server performs information summary 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. And 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 abstract of the first candidate data is the same as the information abstract 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, and the query result happens relatively to a query result obtained after the query of the second query information.
Specifically, after the server performs the information abstract calculation on the second candidate data and obtains the corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first candidate data obtained by previous calculation. And then, the server compares the information abstract value corresponding to the second candidate data calculated at present with the information abstract value corresponding to the first candidate data. When the information abstract value corresponding to the second candidate data is the same as the information abstract value corresponding to the acquired 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.
And step 408, when the information abstract of the first candidate data is different from the information abstract of the second candidate data, entering a step of carrying out overall query in the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information.
The whole inquiry refers to one complete inquiry according to inquiry information contained in a request sent by a terminal.
Specifically, after the server performs the information abstract calculation on the second candidate data and obtains the corresponding information abstract calculation value, the server starts to obtain the information abstract value corresponding to the first candidate data obtained by previous calculation. And then, the server compares the information abstract value corresponding to the second candidate data calculated at present with the information abstract value corresponding to the first candidate data. 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 to the candidate data as a whole query according to the second query information, and obtains a query result corresponding to the second query information.
In this embodiment, the server performs the information summary on the first candidate data through the request sent by the terminal, to obtain the information summary value of the candidate data corresponding to the first query information. And then, the server performs information abstraction on the second candidate data through the request sent again by the terminal, and the information abstraction value of the candidate data corresponding to the second query information is obtained. After 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 obtained. When the information abstract value corresponding to the second candidate data is the same as the information abstract value corresponding to the acquired 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 conditions are converted into information summary values to facilitate rapid comparison of query condition changes. Under the condition that the query condition is unchanged, the information abstract value is unchanged, and the server does not need to execute complete one-time query; instead, the server needs to perform a complete query once.
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 the information summary on the first candidate data through the request sent by the terminal, to obtain the 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 the request sent again by the terminal, and obtains the information summarization value b 504 of the candidate data corresponding to the second query information. After 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 calculated at present with the information abstract value a 503 corresponding to the first candidate data obtained. When a is equal to b, then the server directly returns the historical query results corresponding to the first query information to the query results corresponding to the second candidate data. Otherwise, if a is not equal to b, 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 one embodiment, as shown in fig. 6, a multi-dimensional report data calculating method further includes:
step 602, obtaining an associated field value set corresponding to a target field in a target document.
The target bill refers to a bill to be subjected to data processing. The target field refers to a field in the target document where a change occurs. The target bill can be the same bill or different bills.
Specifically, the server acquires an associated field value set corresponding to a target field in a target document through a request sent by the terminal. For example, the terminal sends a request, and the request includes target field values C1, C2, C3, …, cn (n represents a certain positive integer) in the target document C, and after the server receives the request, the target fields are unified and integrated by the server to obtain an associated field value set corresponding to the target field.
Step 604, calculating the information abstract value of the character string formed by each field value in the associated field value set.
Specifically, the server calculates the information abstract value of the character string formed by each field value in the associated field value set through the request sent again by the terminal. For example, the terminal sends a request, the request includes information for extracting information summary values of a character string composed of C1, C2, C3, …, cn (n represents a certain positive integer) in a set of target field values C1, C2, C3, …, cn (n represents a certain positive integer) in the target document C, and the server performs information summary 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.
Wherein, 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 character information is changed.
Specifically, when the server determines 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.
In this embodiment, the server obtains, through a request sent by the terminal, a set of associated field values corresponding to a target field in a target document. Then, the server calculates the information abstract value of the character string composed of each field value in the associated field value set through the request sent again by the terminal. 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 bill is changed or not can be rapidly positioned, and further the change of the calculation conditions can be accurately judged.
In a specific embodiment, as shown in fig. 7, the terminal sends a request, where the request includes the target field values D1 and D2 in the target document D701 and the target fields E1 and E2 in the document E702, and the information that forms a set together from D1, D2 and E1 and E2 is subjected to information summarization. After receiving the request, the server unifies d1 and d2 and e1 and e2 to form a set. Then, the terminal sends a request, the request includes information for extracting the information summary value of the character string formed by the target field values D1 and D2 in the D701 and the target field E1 and E2 in the set of the target fields E1 and E2 in the document E702, and the server receives the request, performs information summary processing on the request and obtains the information summary value. Finally, when the server determines that the information abstract value of the character string changes, the field value corresponding to the target field j3 is updated for the document 703 according to the d1, d2, e1 and e2 values in the associated field value set.
In one embodiment, as shown in fig. 8, a multi-dimensional report data calculating method further includes:
step 802, obtaining a field value corresponding to a first field in a first bill.
Specifically, the server acquires a field value corresponding to a first field in the first bill through a request sent by the terminal. For example, the terminal sends a request, the request includes a field value corresponding to a field F1 in the production document F, and the server processes according to the request after receiving the request.
Step 804, obtaining a field value corresponding to a second field in the second document, where the service logic calculation rules corresponding to the first field and the second field are the same.
Wherein the second document is different from the first document, only for distinguishing the same operation or object, and not for any limitation. The second field is different from the first field only for distinguishing the same operation or object, and is not used for any limitation. The business logic calculation rule refers to calculating a specific or appointed object in the bill according to business requirements. For example, the production document G and the production document H simultaneously include an object of the production quantity in the field 1 column, and the object is obtained through the same functional relationship by the business requirement.
Specifically, the server acquires a field value corresponding to the second field in the second bill 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 according to the request after receiving the request. Where f1 and i1 are objects specified in the calculation according to business requirements.
Step 806, obtaining a third information abstract value of the associated field value set corresponding to the first field.
Specifically, the server performs information abstract processing on the associated field value set corresponding to the first field through a request sent by the terminal, and obtains a third information abstract value of the information abstract processing. For example, the terminal sends a request, the request includes information for obtaining a third information abstract value of the associated field value set corresponding to the field F1 in the production document F, and the server processes according to the request after receiving the request.
Step 808, obtaining a fourth information abstract value of the associated field value set corresponding to the second field.
The fourth message digest value is different from the third message digest value, which is only for distinguishing the same operation or object, and is not used for limiting.
Specifically, the server performs information abstract processing on the associated field value set corresponding to the second field through the request sent again by the terminal, and obtains the fourth information abstract value of the information abstract processing. For example, the terminal sends a request, the request includes information for obtaining a fourth information abstract value of the associated field value set corresponding to the field I1 in the production document I, and the server processes according to the request after receiving the request.
Step 810, if the third message digest value is different from the fourth message digest value, and the field value corresponding to the first field is different from the field value corresponding to the second field, generating alarm information, where the alarm information is used to prompt that an error exists in the first field and the second field.
Specifically, the server determines that if the third information abstract value is different from the fourth information abstract value, the field value corresponding to the first field is different from the field value corresponding to the second field, and alarm information is generated, where the alarm information is used for prompting that an error exists in the first field and the second field. For example, the server determines that the information of the third information abstract value of the associated field value set corresponding to the field F1 in the production document F is different from the fourth information abstract value of the associated field value set corresponding to the field I1 in the production document I, F1 is not equal to I1, and the server immediately generates the alarm information prompt F1 and I1 to have a problem.
In this embodiment, the server obtains the field value corresponding to the first field in the first document through the request sent by the terminal, and obtains the field value corresponding to the second field in the second document through the request sent again by the terminal. And then, the server performs information abstraction processing on the associated field value set corresponding to the first field through the request sent by the terminal, acquires the third information abstraction value of the information abstraction processing, performs information abstraction processing on the associated field value set corresponding to the second field through the request sent again by the terminal, and acquires the fourth information abstraction value of the information abstraction processing. And finally, the server judges that if the third information abstract value is different from the fourth information abstract value, the field value corresponding to the first field is different from the field value corresponding to the second field, and alarm information is generated and used for prompting that the first field and the second field have errors. By the method, the effect of rapid comparison of 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 according to the request after receiving the request. The terminal sends a request, the request includes a field value corresponding to a field K2 in the acquired report K902, and the server processes according to the request after receiving the request. Where j2 and k2 are objects specified in the calculation according to business requirements. The terminal sends a request, the request includes information for obtaining a third information abstract value of the associated field value set corresponding to the field J2 in the report J901, and the server processes according to the request after receiving the request. The terminal sends a request, the request includes information for obtaining a fourth information abstract value of the associated field value set corresponding to the field K2 in the report K902, and the server processes according to the request after receiving the request. The server judges that the information of the third information abstract value of the associated field value set corresponding to the field J2 in the report J901 is different from the fourth information abstract value of the associated field value set corresponding to the field K2 in the report K902, J2 is not equal to K2, and the server immediately generates an alarm information prompt J2 and K2 that a problem exists.
It should be understood that, although the steps in the flowcharts of fig. 2-4, 6, and 8 are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps of FIGS. 2-4, 6, and 8 may include steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor does the order in which the steps or stages are performed necessarily occur sequentially, but may be performed alternately or alternately with other steps or at least a portion of the steps or stages in other steps.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculating apparatus including: the device comprises a first acquisition computing module, a second acquisition computing module and a first judgment processing module, wherein:
the first acquisition and calculation module acquires first query information, and performs 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 carrying out information abstract calculation on the second query information to obtain a corresponding second information abstract value;
the first judging and 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 the method is also used for carrying out overall query in the corresponding candidate data based on the second query information when the first information abstract value and the second information abstract value are different, so as 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 calculating apparatus including:
the first acquisition module is used for acquiring 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 calculating apparatus including:
the second acquisition module is used for acquiring the information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information;
And the method is also used for acquiring the information abstract of the second candidate data, wherein the second candidate data is the candidate data corresponding to the second query information.
The second judging and processing module is used for entering the step of acquiring the historical query result corresponding to the first query information when the information abstract of the first candidate data is the same as the information abstract of the second candidate data;
and the step of entering the step of carrying out overall query in the corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information when the information abstract of the first candidate data is different from the information abstract of the second candidate data.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculating apparatus including:
and the third acquisition module is used for acquiring the associated field value set corresponding to the target field in the target bill.
And the calculation module is used for calculating the information abstract value of the character string formed by each field value in the associated field value set.
And a third judging and processing module, configured to update, when the information abstract value of the character string changes, a field value corresponding to the target field according to each field value in the associated field value set.
In one embodiment, as shown in fig. 10, there is provided a multi-dimensional report data calculating apparatus including:
the fourth acquisition module is used for acquiring a field value corresponding to the first field in the first bill;
the method is also used for acquiring a field value corresponding to a second field in the second bill, wherein the service logic calculation rules corresponding to the first field and the second field are the same;
the method is also used for obtaining a third information abstract value of the associated field value set corresponding to the first field;
and the method is also used for acquiring a fourth information abstract value of 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, and the warning information is used for prompting that the first field and the second field have errors.
For a specific limitation of the multi-dimensional report data calculating apparatus, reference may be made to the limitation of the multi-dimensional report data calculating method hereinabove, and the description thereof will not be repeated here. Each module in the multi-dimensional report data calculating device can be implemented in whole or in part by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which 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 includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device 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, when executed by the processor, implements a multi-dimensional report data computing method.
It will be appreciated by those skilled in the art that the structure shown in fig. 11 is merely a block diagram of a portion of the structure associated with the present application and is not limiting of the computer device to which the present application applies, and that a particular computer device may include more or fewer components than shown, or may combine some of the 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 stored therein a computer program, the processor when executing the computer program performing the steps of:
and 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, acquiring 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 and the second information abstract value are different, carrying out overall query in 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 current information is the first query information or the second query information, and the processor when executing the computer program further performs the steps of:
and acquiring a key field in the current information, and performing information abstract calculation on the key field.
In one embodiment, the processor when executing the computer program further performs the steps of:
and the key fields in the current information are obtained by user definition or according to report calculation history rules.
In one embodiment, the processor when executing the computer program further performs the steps of:
and acquiring the information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information.
And acquiring the 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, entering a step of carrying out overall query in 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 the 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.
And when the information abstract value of the character string is changed, 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 bill.
And acquiring a field value corresponding to a second field in the second bill, wherein the service logic calculation rules corresponding to the first field and the second field are the same.
And acquiring a third information abstract value of the associated field value set corresponding to the first field.
And acquiring a fourth information abstract value of the associated field value set corresponding to the second field.
If the third information abstract value is different from the fourth information abstract value, the field value corresponding to the first field is different from the field value corresponding to the second field, and alarm information is generated, 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, acquiring 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 and the second information abstract value are different, carrying out overall query in 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 a key field in the current information, and performing information abstract calculation on the key field.
In one embodiment, the computer program when executed by the processor further performs the steps of:
And the key fields in the current information are obtained by user definition or according to report calculation history rules.
In one embodiment, the computer program when executed by the processor further performs the steps of:
and acquiring the information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information.
And acquiring the 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, entering a step of carrying out overall query in 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 the 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.
And when the information abstract value of the character string is changed, 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 bill.
And acquiring a field value corresponding to a second field in the second bill, wherein the service logic calculation rules corresponding to the first field and the second field are the same.
And acquiring a third information abstract value of the associated field value set corresponding to the first field.
And acquiring a fourth information abstract value of the associated field value set corresponding to the second field.
If the third information abstract value is different from the fourth information abstract value, the field value corresponding to the first field is different from the field value corresponding to the second field, and alarm information is generated, wherein the alarm information is used for prompting that errors exist in the first field and the second field.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, or the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples merely represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the invention. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application is to be determined by the claims appended hereto.
Claims (10)
1. A method for calculating multidimensional report data, the method comprising:
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, acquiring 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;
when the first information abstract value and the second information abstract value are different, carrying out overall query in corresponding candidate data based on the second query information to obtain a target query result corresponding to the second query information;
acquiring an associated field value set corresponding to a target field in a target document;
calculating the information abstract value of a character string formed by each field value in the associated field value set;
and when the information abstract value of the character string is changed, updating the field value corresponding to the target field according to each field value in the associated field value set.
2. The method of claim 1, wherein the current information is the first query information or the second query information, and wherein the step of performing the information digest calculation on the current information comprises:
and acquiring a key field in the current information, and performing information abstract calculation on the key field.
3. The method of claim 2, wherein the obtaining key fields in the current information comprises:
And the key fields in the current information are obtained by user definition or according to report calculation history rules.
4. The method of claim 2, wherein performing a message digest calculation on the key field comprises:
and carrying out MD5 calculation on the key field to obtain an MD5 value of the key field value.
5. The method of claim 1, wherein before obtaining the historical query result corresponding to the first query information further comprises:
acquiring an information abstract of first candidate data, wherein the first candidate data is the candidate data corresponding to the first query information;
acquiring an information abstract of second candidate data, wherein the second candidate data is the 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 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, entering a step of carrying out overall query in 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, wherein the target field is a field in the target document that changes.
7. The method according to claim 1, wherein the method further comprises:
acquiring a field value corresponding to a first field in a first bill;
acquiring a field value corresponding to a second field in a second bill, wherein the service logic calculation rules corresponding to the first field and the second field are the same;
acquiring a third information abstract value of an associated field value set corresponding to the first field;
acquiring a fourth information abstract value of the associated field value set corresponding to the second field;
if the third information abstract value is different from the fourth information abstract value, the field value corresponding to the first field is different from the field value corresponding to the second field, and alarm information is generated, wherein the alarm information is used for prompting that errors exist in the first field and the second field.
8. A multi-dimensional report data computing device, the device comprising:
the first acquisition and calculation module acquires first query information, and performs 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 carrying out information abstract calculation on the second query information to obtain a corresponding second information abstract value;
the first judging and 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; the method is also used for carrying out overall query in the corresponding candidate data based on the second query information when the first information abstract value and the second information abstract value are different, so as to obtain a target query result corresponding to the second query information; acquiring an associated field value set corresponding to a target field in a target document; calculating the information abstract value of a character string formed by each field value in the associated field value set; and when the information abstract value of the character string is changed, updating the field value corresponding to the target field according to each field value in the associated field value set.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any 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 CN113806504A (en) | 2021-12-17 |
| CN113806504B true 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 |
|---|---|
| CN113806504A (en) | 2021-12-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Hompes et al. | Discovering deviating cases and process variants using trace clustering | |
| KR102361153B1 (en) | Managing data profiling operations related to data type | |
| US9477974B2 (en) | Method and systems for flexible and scalable databases | |
| US20140019454A1 (en) | Systems and Methods for Caching Data Object Identifiers | |
| CN117061254B (en) | Abnormal flow detection method, device and computer equipment | |
| US11182375B2 (en) | Metadata validation tool | |
| CN113806504B (en) | Multi-dimensional report data calculation method and device and computer equipment | |
| CN117033424A (en) | Query optimization method and device for slow SQL (structured query language) statement and computer equipment | |
| CN112579705A (en) | Metadata acquisition method and device, computer equipment and storage medium | |
| CN112202822B (en) | Database injection detection method and device, electronic equipment and storage medium | |
| CN115168409B (en) | Data query method and device for database sub-tables and computer equipment | |
| CN113867975B (en) | Quick response method and device for command line and computer equipment | |
| CN114036170A (en) | Associated case acquisition method, associated case acquisition device, associated case acquisition apparatus, storage medium, and program product | |
| CN115309770A (en) | Data analysis method, device, equipment and storage medium based on user-defined strategy | |
| CN116880927A (en) | Rule management method, device, computer equipment and storage medium | |
| CN116991662A (en) | Time sequence alarm rule processing method and device and computer equipment | |
| CN117874082A (en) | Method for searching associated dictionary data and related components | |
| CN116910069A (en) | Database updating method, device, computer equipment and storage medium | |
| CN117076721A (en) | Data query method, device, equipment, medium and product | |
| CN116451199A (en) | Access request processing method, device, equipment, storage medium and computer product | |
| CN116860798A (en) | Data query method, electronic device and computer readable storage medium | |
| CN117349131A (en) | System error information display method and device and computer equipment | |
| CN117370339A (en) | Report blood edge relationship processing method and device, computer equipment and storage medium | |
| CN117194729A (en) | Power data storage method, apparatus, device, storage medium, and program product | |
| CN116366724A (en) | Business process processing method, device, computer equipment and storage medium |
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 |