CN112506940B - Data checking method and device, electronic equipment and storage medium - Google Patents
Data checking method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112506940B CN112506940B CN202011486785.XA CN202011486785A CN112506940B CN 112506940 B CN112506940 B CN 112506940B CN 202011486785 A CN202011486785 A CN 202011486785A CN 112506940 B CN112506940 B CN 112506940B
- Authority
- CN
- China
- Prior art keywords
- data
- reconciliation
- standard
- checking
- message middleware
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the field of big data, and discloses a data reconciliation method, which comprises the following steps: collecting account checking data, carrying out storage format unification processing on the account checking data to obtain standard account checking data, and storing the standard account checking data into a preset message middleware; preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data; and utilizing a reconciliation algorithm in the reconciliation engine assembly to perform data reconciliation on the target reconciliation data to obtain a reconciliation result, and sending the reconciliation result to a corresponding user. Furthermore, the present invention also relates to blockchain techniques, where the reconciliation results may be stored in the blockchain. The invention can realize timeliness of data reconciliation.
Description
Technical Field
The present invention relates to the field of big data, and in particular, to a data reconciliation method, apparatus, electronic device, and computer readable storage medium.
Background
The data reconciliation is a process for monitoring whether the data of the upstream and downstream business systems are consistent, and is used for ensuring that the data of the upstream and downstream business systems are correct. Data reconciliation is applied in many industries, such as in the financial industry. Because various business systems in the financial industry have more strict requirements on data consistency, data reconciliation is an indispensable business link in the business system flow of the financial industry, is a powerful tool for detecting data inconsistency of upstream and downstream business systems, and is a final means for guaranteeing data to be free of errors.
The traditional checking method often needs longer time for waiting for checking data, and meanwhile, the complexity of daily final data logic is added, so that the timeliness of data checking is lower, and the checking efficiency of the data is affected; in addition, the conventional reconciliation method is difficult to access and check the reconciliation data in a unified manner, and meanwhile, the reconciliation data is poor in collocation degree, so that repeated development of a plurality of reconciliation programs is easy to cause, and the timeliness of data reconciliation is also affected.
Disclosure of Invention
The invention provides a data checking method, a data checking device, electronic equipment and a computer readable storage medium, and mainly aims to improve timeliness of data checking.
In order to achieve the above object, the present invention provides a data reconciliation method, including:
collecting account checking data, carrying out storage format unification processing on the account checking data to obtain standard account checking data, and storing the standard account checking data into a preset message middleware;
preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and utilizing a reconciliation algorithm in the reconciliation engine assembly to perform data reconciliation on the target reconciliation data to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
Optionally, the storing the standard reconciliation data in a preset message middleware includes:
calculating the storage number of the standard reconciliation data in the message middleware;
and storing the standard reconciliation data to the message middleware by utilizing a precompiled storage statement according to the storage number.
Optionally, the calculating a storage number of the standard reconciliation data in the message middleware includes:
calculating the storage number of the standard reconciliation data in the message middleware by using the following method:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein instruct_id represents a storage number of standard reconciliation data in the message middleware, hash_ str (instruction) represents an object quantization function of standard reconciliation data, and instruct_time (time) represents a time quantization function of standard reconciliation data, b1 represents a degree of dispersion of the object quantization function, b2 represents a degree of dispersion of the time quantization function, w1 represents coefficients of the object quantization function, and w2 represents coefficients of the time quantization function.
Optionally, the preprocessing the standard reconciliation data in the message middleware to obtain target reconciliation data includes:
filtering the standard reconciliation data in the message middleware to obtain filtered data;
performing identification standardization on the filtering data to obtain identification standardization data;
grouping the identification standardized data to obtain target reconciliation data.
Optionally, the filtering the standard reconciliation data in the message middleware to obtain filtered data includes:
calculating a hash value of the standard reconciliation data, and determining a pointer of the hash value;
and inquiring the obtained main key of the standard reconciliation data according to the pointer, and executing data filtering of the standard reconciliation data according to the main key to obtain filtering data.
Optionally, the performing identification standardization on the filtering data to obtain identification standardization data includes:
acquiring a first data identifier and a second data identifier existing in the filtered data, and creating a unified identifier index of the second data identifier and the second data identifier according to the first data identifier and the second data identifier;
and carrying out identification standardization on the filtering data according to the unified identification index to obtain identification standardization data.
Optionally, the reconciliation algorithm includes:
wherein T (, y) represents the reconciliation result of the target reconciliation data, x i Y i Representing any two of the target reconciliation data.
In order to solve the above-mentioned problem, the present invention also provides a data reconciliation device, the device comprising:
the unified module is used for collecting the reconciliation data, carrying out storage format unified processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data into a preset message middleware;
the preprocessing module is used for preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and the checking module is used for performing data checking on the target checking data by using a checking algorithm in the checking engine assembly to obtain a checking result and sending the checking result to a corresponding user.
In order to solve the above-mentioned problems, the present invention also provides an electronic apparatus including:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to implement the data reconciliation method described above.
In order to solve the above-mentioned problems, the present invention also provides a computer-readable storage medium having stored therein at least one computer program that is executed by a processor in an electronic device to implement the above-mentioned data reconciliation method.
According to the embodiment of the invention, firstly, the reconciliation data is collected, the storage format of the reconciliation data is subjected to unified processing to obtain the standard reconciliation data, and the standard reconciliation data is stored in the preset message middleware, so that the high-speed reading of the reconciliation data is realized, and the time for waiting for the reconciliation data is reduced; secondly, according to the reconciliation engine component of the standard reconciliation data which is preconfigured, the standard reconciliation data in the message middleware is preprocessed to obtain the target reconciliation data, filtering, identification standardization and grouping processing of the reconciliation data can be achieved, unified access of the reconciliation data is achieved, data which do not need reconciliation are directly filtered, system resources are saved, unified check of the reconciliation data is completed, and accordingly timeliness of the reconciliation data is improved; further, the invention uses the reconciliation algorithm in the reconciliation engine assembly to perform data reconciliation on the target reconciliation data to obtain a reconciliation result, and sends the reconciliation result to a corresponding user. Therefore, the data checking method, the device, the electronic equipment and the storage medium can improve the timeliness of data checking.
Drawings
Fig. 1 is a flow chart of a data reconciliation method according to an embodiment of the invention;
FIG. 2 is a detailed flowchart illustrating one of the steps of the data reconciliation method of FIG. 1 in accordance with the first embodiment of the invention;
FIG. 3 is a schematic block diagram of a data reconciliation device according to an embodiment of the invention;
fig. 4 is a schematic diagram of an internal structure of an electronic device for implementing a data reconciliation method according to an embodiment of the invention;
the achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
The embodiment of the application provides a data reconciliation method. The execution subject of the data reconciliation method includes, but is not limited to, at least one of a server, a terminal, etc. capable of being configured to execute the method provided by the embodiments of the present application. In other words, the data reconciliation method may be performed by software or hardware installed on a terminal device or a server device, the software may be a blockchain platform. The service end includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like.
Referring to fig. 1, a flow chart of a data reconciliation method according to an embodiment of the invention is shown. In an embodiment of the present invention, the data reconciliation method includes:
s1, collecting reconciliation data, carrying out storage format unification processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data into a preset message middleware.
In the embodiment of the invention, the reconciliation data comprises business data of different systems, such as financial data, business data, financial data and the like, and the reconciliation data is collected from the upstream and downstream business systems through a reconciliation collection assembly. The account checking and collecting component is compiled through java and used for collecting account checking data of different channels.
In detail, the collecting reconciliation data includes: and responding to the data reconciliation request, and acquiring reconciliation data from the corresponding business system by utilizing the reconciliation acquisition component. For example, company a and company B need to perform a batch of goods data reconciliation, receive a goods data reconciliation request, and collect goods data of company a from a business system of company a and goods data of company B from a business system of company B by using a reconciliation collecting component; the order of the company C is cooperatively completed by a plurality of subsystems, and due to objective factors (network jitter, server downtime, abnormal business systems and the like), the problem of uneven accounts of the upstream and downstream business subsystems of the company C can be caused, the financial account checking request of the upstream and downstream business subsystems of the company C is received, and corresponding financial data is acquired from the upstream and downstream business subsystems of the company C by using an account checking acquisition component.
Further, due to the fact that the sources and channels of the reconciliation data are different, difference exists in the storage modes of the reconciliation data, if any data are stored in oracle, if any data are stored in mysql, if any data are stored in a dockmq, and the like, then the embodiment of the invention solves the problem that the storage modes of the reconciliation data are inconsistent by carrying out unified processing on the storage formats of the reconciliation data, and improves timeliness of the reconciliation data.
In detail, the unifying the storage format of the reconciliation data to obtain standard reconciliation data includes: and converting the storage format of the reconciliation data into json (JavaScript Object Notation) format to obtain the standard reconciliation data. The json format refers to a lightweight data exchange format, and data reading and understanding are facilitated.
Further, the invention stores the standard reconciliation data to a preset message middleware to realize efficient access of the reconciliation data. Specifically, the storing the standard reconciliation data in a preset message middleware includes:
and calculating a storage number of the standard reconciliation data in the message middleware, and storing the standard reconciliation data to the message middleware by utilizing a precompiled storage statement according to the storage number.
In an alternative embodiment, the preset message middleware may be: mq or kafka message middleware.
In an alternative embodiment, calculating the storage number of the standard reconciliation data in the message middleware using the method comprises:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein instruct_id represents a storage number of standard reconciliation data in the message middleware, hash_ str (instruction) represents an object quantization function of standard reconciliation data, and instruct_time (time) represents a time quantization function of standard reconciliation data, b1 represents a degree of dispersion of the object quantization function, b2 represents a degree of dispersion of the time quantization function, w1 represents coefficients of the object quantization function, and w2 represents coefficients of the time quantization function.
In an alternative embodiment, the precompiled store statement may be an sql statement, the sql statement comprising: insert statements.
S2, preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data.
In a preferred embodiment of the present invention, the reconciliation engine component is configured to perform a reconciliation operation of the reconciliation data, where the reconciliation engine component is configured via a web page.
Further, referring to fig. 2, the pre-processing the standard reconciliation data in the message middleware by the reconciliation engine component of the standard reconciliation data configured in advance, to obtain target reconciliation data includes:
s21, filtering the data to be reconciled to obtain filtered data;
s22, carrying out identification standardization on the filtered data to obtain identification standardization data;
s23, grouping the identification standardized data to obtain target reconciliation data.
The filtering is to directly filter out data which does not need checking, so as to save system resources; the identification standardization is to convert the identification (field or data value) of the reconciliation data into an intermediate state; the grouping is to divide the reconciliation data of the same reconciliation task into a group, for example, the grouping reconciliation can be performed according to orderID so as to improve the reconciliation efficiency of the reconciliation data.
In detail, the filtering the standard reconciliation data in the message middleware to obtain filtered data includes:
and calculating a hash value of the standard reconciliation data, determining a pointer of the hash value, inquiring a main key of the obtained standard reconciliation data according to the pointer, and executing data reconciliation of the standard reconciliation data according to the main key and a preset filtering principle.
The embodiment of the invention calculates the hash value of the standard reconciliation data by utilizing the hash function in the reconciliation engine component. The Hash function may be a Hash function.
Further, the preset filtering principle may be preset by the user, for example, the user a sets that the age data is not to be checked, and then filters the main key of the checked data as the corresponding data of the age.
In detail, the step of performing identification standardization on the filtering data to obtain identification standardization data includes:
acquiring a first data identifier and a second data identifier existing in the filtered data, and creating a unified identifier index of the second data identifier and the second data identifier according to the first data identifier and the second data identifier;
and normalizing the first data identifier and the second data identifier according to the unified identifier index to obtain identifier normalized data.
In an alternative embodiment, an index to the first id and the second id is created using a request function in the reconciliation engine component.
In an alternative embodiment, the second data identifier and the unified identifier index of the second data identifier are created using a Shift function in the reconciliation engine component.
Illustratively, if the first data identifier and the second data identifier existing in the filtered data are obtained as orderId and order_id, a unified identifier index of the first data identifier and the second data identifier is created as orderId by using a request function, and the filtered data is subjected to identifier standardization according to the unified identifier index to obtain identifier standardization data.
And S3, performing data reconciliation on the target reconciliation data by utilizing a reconciliation algorithm in the reconciliation engine assembly to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
In the embodiment of the invention, the target reconciliation data is subjected to data reconciliation by adopting a reconciliation algorithm in the reconciliation engine assembly to obtain a reconciliation result, and the reconciliation result is sent to a corresponding user.
In an alternative embodiment, the reconciliation algorithm comprises:
wherein T (, y) represents the reconciliation result of the target reconciliation data, x i First data, y, representing target reconciliation data i Second data representing target reconciliation data.
In an optional embodiment, the sending of the reconciliation result is achieved through a preset message sending component, the message sending component is compiled through java, and a sending channel of the message sending component includes: mail and short messages also support telephone calls, voice broadcasts, and the like.
Further, to ensure the security and reliability of the reconciliation result, the reconciliation result may also be stored in a blockchain node.
Further, before the reconciliation result is sent to the corresponding user, the embodiment of the present invention may further include: and summarizing the checking results and monitoring whether checking abnormality occurs in the checking process of the target checking data so as to ensure the checking accuracy and reliability of the checking data. The account checking results are summarized through preset time, for example, the total amount of the account checking data is summarized for one hour, so that whether the account checking results have data omission or not can be conveniently detected, and the account checking accuracy is improved; the checking abnormal condition monitoring is realized through an abnormal monitoring component, checking staff is timely informed of checking at the first time, reliability of checking results is guaranteed, and the abnormal monitoring component is compiled through a JavaScript script.
Further, another embodiment of the present invention may further include: the checking monitoring management background is compiled through java language and is connected with the checking acquisition component, the checking engine component, the message middleware, the message sending component and the anomaly monitoring component so as to manage and control the whole checking flow of checking data from access, preprocessing, checking, anomaly alarming, checking result sending and the like, and meanwhile, the authority of different users can be set on the basis of the checking monitoring management platform so as to realize that different users with different authorities of different roles (products, services, development, administrators and the like) can see different services, thereby greatly improving the flexible configuration and management of system users and ensuring the safety of checking data.
According to the embodiment of the invention, firstly, the reconciliation data is collected, the storage format of the reconciliation data is subjected to unified processing to obtain the standard reconciliation data, and the standard reconciliation data is stored in the preset message middleware, so that the high-speed reading of the reconciliation data is realized, and the time for waiting for the reconciliation data is reduced; secondly, according to the reconciliation engine component of the standard reconciliation data which is preconfigured, the standard reconciliation data in the message middleware is preprocessed to obtain the target reconciliation data, filtering, identification standardization and grouping processing of the reconciliation data are achieved, unified access of the reconciliation data is achieved, data which do not need reconciliation are directly filtered, system resources are saved, unified check of the reconciliation data is completed, and timeliness of the reconciliation data is improved; further, the invention uses the reconciliation algorithm in the reconciliation engine assembly to perform data reconciliation on the target reconciliation data to obtain a reconciliation result, and sends the reconciliation result to a corresponding user. Therefore, the data checking method provided by the invention can improve the timeliness of data checking.
As shown in fig. 3, a functional block diagram of the data reconciliation device of the present invention is illustrated.
The data reconciliation apparatus 100 of the present invention may be installed in an electronic device. The data reconciliation device may include a unification module 101, a preprocessing module 102, and a reconciliation module 103, depending on the functionality implemented. The module of the present invention may also be referred to as a unit, meaning a series of computer program segments capable of being executed by the processor of the electronic device and of performing fixed functions, stored in the memory of the electronic device.
In the present embodiment, the functions concerning the respective modules/units are as follows:
the unifying module 101 is configured to collect reconciliation data, perform storage format unification processing on the reconciliation data to obtain standard reconciliation data, and store the standard reconciliation data into a preset message middleware.
In the embodiment of the invention, the reconciliation data comprises business data of different systems, such as financial data, business data, financial data and the like, and the reconciliation data is collected from the upstream and downstream business systems through a reconciliation collection assembly. The account checking and collecting component is compiled through java and used for collecting account checking data of different channels.
In detail, the unifying module 101 collects reconciliation data in the following manner: and responding to the data reconciliation request, and acquiring reconciliation data from the corresponding business system by utilizing the reconciliation acquisition component. For example, company a and company B need to perform a batch of goods data reconciliation, receive a goods data reconciliation request, and collect goods data of company a from a business system of company a and goods data of company B from a business system of company B by using a reconciliation collecting component; the order of the company C is cooperatively completed by a plurality of subsystems, and due to objective factors (network jitter, server downtime, abnormal business systems and the like), the problem of uneven accounts of the upstream and downstream business subsystems of the company C can be caused, the financial account checking request of the upstream and downstream business subsystems of the company C is received, and corresponding financial data is acquired from the upstream and downstream business subsystems of the company C by using an account checking acquisition component.
Further, due to the fact that the sources and channels of the reconciliation data are different, difference exists in the storage modes of the reconciliation data, if any data are stored in oracle, if any data are stored in mysql, if any data are stored in a dockmq, and the like, then the embodiment of the invention solves the problem that the storage modes of the reconciliation data are inconsistent by carrying out unified processing on the storage formats of the reconciliation data, and improves timeliness of the reconciliation data.
In detail, the unifying module 101 performs unifying the storage format of the reconciliation data in the following manner to obtain standard reconciliation data: and converting the storage format of the reconciliation data into json (JavaScript Object Notation) format to obtain the standard reconciliation data. The json format refers to a lightweight data exchange format, and data reading and understanding are facilitated.
Further, the invention stores the standard reconciliation data to a preset message middleware to realize efficient access of the reconciliation data. Specifically, the unifying module 101 stores the standard reconciliation data to a preset message middleware in the following manner:
and calculating a storage number of the standard reconciliation data in the message middleware, and storing the standard reconciliation data to the message middleware by utilizing a precompiled storage statement according to the storage number.
In an alternative embodiment, the preset message middleware may be: mq or kafka message middleware.
In an alternative embodiment, calculating the storage number of the standard reconciliation data in the message middleware using the method comprises:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein instruct_id represents a storage number of standard reconciliation data in the message middleware, hash_ str (instruction) represents an object quantization function of standard reconciliation data, and instruct_time (time) represents a time quantization function of standard reconciliation data, b1 represents a degree of dispersion of the object quantization function, b2 represents a degree of dispersion of the time quantization function, w1 represents coefficients of the object quantization function, and w2 represents coefficients of the time quantization function.
In an alternative embodiment, the precompiled store statement may be an sql statement, the sql statement comprising: insert statements.
The preprocessing module 102 is configured to pre-process the standard reconciliation data in the message middleware by using a pre-configured reconciliation engine component of the standard reconciliation data, so as to obtain target reconciliation data.
In a preferred embodiment of the present invention, the reconciliation engine component is configured to perform a reconciliation operation of the reconciliation data, where the reconciliation engine component is configured via a web page.
Further, the preprocessing module 102 performs preprocessing of the standard reconciliation data in the message middleware using a reconciliation engine component of the standard reconciliation data that is preconfigured by:
step I, filtering the data to be reconciled to obtain filtered data;
step II, carrying out identification standardization on the filtered data to obtain identification standardization data;
and III, grouping the identification standardized data to obtain target reconciliation data.
The filtering is to directly filter out data which does not need checking, so as to save system resources; the identification standardization is to convert the identification (field or data value) of the reconciliation data into an intermediate state; the grouping is to divide the reconciliation data of the same reconciliation task into a group, for example, the grouping reconciliation can be performed according to orderID so as to improve the reconciliation efficiency of the reconciliation data.
In detail, the preprocessing module 102 performs filtering on the standard reconciliation data in the message middleware to obtain filtered data by adopting the following method:
and calculating a hash value of the standard reconciliation data, determining a pointer of the hash value, inquiring a main key of the obtained standard reconciliation data according to the pointer, and executing data reconciliation of the standard reconciliation data according to the main key and a preset filtering principle.
The embodiment of the invention calculates the hash value of the standard reconciliation data by utilizing the hash function in the reconciliation engine component. The Hash function may be a Hash function.
Further, the preset filtering principle may be preset by the user, for example, the user a sets that the age data is not to be checked, and then filters the main key of the checked data as the corresponding data of the age.
In detail, the preprocessing module 102 performs the identification normalization on the filtered data by using the following method to obtain identification normalized data:
acquiring a first data identifier and a second data identifier existing in the filtered data, and creating a unified identifier index of the second data identifier and the second data identifier according to the first data identifier and the second data identifier;
and normalizing the first data identifier and the second data identifier according to the unified identifier index to obtain identifier normalized data.
In an alternative embodiment, an index to the first id and the second id is created using a request function in the reconciliation engine component.
In an alternative embodiment, the second data identifier and the unified identifier index of the second data identifier are created using a Shift function in the reconciliation engine component.
Illustratively, if the first data identifier and the second data identifier existing in the filtered data are obtained as orderId and order_id, a unified identifier index of the first data identifier and the second data identifier is created as orderId by using a request function, and the filtered data is subjected to identifier standardization according to the unified identifier index to obtain identifier standardization data.
The reconciliation module 103 is configured to perform data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component, obtain a reconciliation result, and send the reconciliation result to a corresponding user.
In the embodiment of the present invention, the reconciliation module 103 performs data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component, so as to obtain a reconciliation result, and sends the reconciliation result to a corresponding user.
In an alternative embodiment, the reconciliation algorithm comprises:
wherein T (, y) represents the reconciliation result of the target reconciliation data, x i First data, y, representing target reconciliation data i Second data representing target reconciliation data.
In an optional embodiment, the sending of the reconciliation result is achieved through a preset message sending component, the message sending component is compiled through java, and a sending channel of the message sending component includes: mail and short messages also support telephone calls, voice broadcasts, and the like.
Further, to ensure the security and reliability of the reconciliation result, the reconciliation result may also be stored in a blockchain node.
Further, the reconciliation module 103 may be further configured to, prior to sending the reconciliation result to the corresponding user: and summarizing the checking results and monitoring whether checking abnormality occurs in the checking process of the target checking data so as to ensure the checking accuracy and reliability of the checking data. The account checking results are summarized through preset time, for example, the total amount of the account checking data is summarized for one hour, so that whether the account checking results have data omission or not can be conveniently detected, and the account checking accuracy is improved; the checking abnormal condition monitoring is realized through an abnormal monitoring component, checking staff is timely informed of checking at the first time, reliability of checking results is guaranteed, and the abnormal monitoring component is compiled through a JavaScript script.
Further, another embodiment of the present invention may further include: the checking monitoring management background is compiled through java language and is connected with the checking acquisition component, the checking engine component, the message middleware, the message sending component and the anomaly monitoring component so as to manage and control the whole checking flow of checking data from access, preprocessing, checking, anomaly alarming, checking result sending and the like, and meanwhile, the authority of different users can be set on the basis of the checking monitoring management platform so as to realize that different users with different authorities of different roles (products, services, development, administrators and the like) can see different services, thereby greatly improving the flexible configuration and management of system users and ensuring the safety of checking data.
According to the embodiment of the invention, firstly, the reconciliation data is collected, the storage format of the reconciliation data is subjected to unified processing to obtain the standard reconciliation data, and the standard reconciliation data is stored in the preset message middleware, so that the high-speed reading of the reconciliation data is realized, and the time for waiting for the reconciliation data is reduced; secondly, according to the reconciliation engine component of the standard reconciliation data which is preconfigured, the standard reconciliation data in the message middleware is preprocessed to obtain the target reconciliation data, filtering, identification standardization and grouping processing of the reconciliation data are achieved, unified access of the reconciliation data is achieved, data which do not need reconciliation are directly filtered, system resources are saved, unified check of the reconciliation data is completed, and timeliness of the reconciliation data is improved; further, the invention uses the reconciliation algorithm in the reconciliation engine assembly to perform data reconciliation on the target reconciliation data to obtain a reconciliation result, and sends the reconciliation result to a corresponding user. Therefore, the data checking device provided by the invention can improve the timeliness of data checking.
Fig. 4 is a schematic structural diagram of an electronic device for implementing the data reconciliation method of the present invention.
The electronic device 1 may comprise a processor 10, a memory 11 and a bus, and may further comprise a computer program, such as a data reconciliation program 12, stored in the memory 11 and executable on the processor 10.
The memory 11 includes at least one type of readable storage medium, including flash memory, a mobile hard disk, a multimedia card, a card memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the electronic device 1, such as a removable hard disk of the electronic device 1. The memory 11 may in other embodiments also be an external storage device of the electronic device 1, such as a plug-in mobile hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the electronic device 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic device 1. The memory 11 may be used not only for storing application software installed in the electronic device 1 and various types of data, such as codes of data reconciliation programs, but also for temporarily storing data that has been output or is to be output.
The processor 10 may be comprised of integrated circuits in some embodiments, for example, a single packaged integrated circuit, or may be comprised of multiple integrated circuits packaged with the same or different functions, including one or more central processing units (Central Processing unit, CPU), microprocessors, digital processing chips, graphics processors, combinations of various control chips, and the like. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects respective components of the entire electronic device using various interfaces and lines, and executes various functions of the electronic device 1 and processes data by running or executing programs or modules (for example, executing a data reconciliation program or the like) stored in the memory 11, and calling data stored in the memory 11.
The bus may be a peripheral component interconnect standard (peripheral component interconnect, PCI) bus or an extended industry standard architecture (extended industry standard architecture, EISA) bus, among others. The bus may be classified as an address bus, a data bus, a control bus, etc. The bus is arranged to enable a connection communication between the memory 11 and at least one processor 10 etc.
Fig. 4 shows only an electronic device with components, it being understood by a person skilled in the art that the structure shown in fig. 4 does not constitute a limitation of the electronic device 1, and may comprise fewer or more components than shown, or may combine certain components, or may be arranged in different components.
For example, although not shown, the electronic device 1 may further include a power source (such as a battery) for supplying power to each component, and preferably, the power source may be logically connected to the at least one processor 10 through a power management device, so that functions of charge management, discharge management, power consumption management, and the like are implemented through the power management device. The power supply may also include one or more of any of a direct current or alternating current power supply, recharging device, power failure detection circuit, power converter or inverter, power status indicator, etc. The electronic device 1 may further include various sensors, bluetooth modules, wi-Fi modules, etc., which will not be described herein.
Further, the electronic device 1 may also comprise a network interface, optionally the network interface may comprise a wired interface and/or a wireless interface (e.g. WI-FI interface, bluetooth interface, etc.), typically used for establishing a communication connection between the electronic device 1 and other electronic devices.
The electronic device 1 may optionally further comprise a user interface, which may be a Display, an input unit, such as a Keyboard (Keyboard), or a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch, or the like. The display may also be referred to as a display screen or display unit, as appropriate, for displaying information processed in the electronic device 1 and for displaying a visual user interface.
It should be understood that the embodiments described are for illustrative purposes only and are not limited to this configuration in the scope of the patent application.
The data reconciliation program 12 stored in the memory 11 of the electronic device 1 is a combination of instructions that, when executed in the processor 10, may implement:
collecting account checking data, carrying out storage format unification processing on the account checking data to obtain standard account checking data, and storing the standard account checking data into a preset message middleware;
preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and utilizing a reconciliation algorithm in the reconciliation engine assembly to perform data reconciliation on the target reconciliation data to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
Specifically, the specific implementation method of the above instructions by the processor 10 may refer to the description of the relevant steps in the corresponding embodiment of fig. 1, which is not repeated herein.
Further, the modules/units integrated in the electronic device 1 may be stored in a computer readable storage medium if implemented in the form of software functional units and sold or used as separate products. The computer readable storage medium may be volatile or nonvolatile. For example, the computer readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM).
The present invention also provides a computer readable storage medium storing a computer program which, when executed by a processor of an electronic device, can implement:
collecting account checking data, carrying out storage format unification processing on the account checking data to obtain standard account checking data, and storing the standard account checking data into a preset message middleware;
preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and utilizing a reconciliation algorithm in the reconciliation engine assembly to perform data reconciliation on the target reconciliation data to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
In the several embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is merely a logical function division, and there may be other manners of division when actually implemented.
The modules described as separate components may or may not be physically separate, and components shown as modules may or may not be physical units, may be located in one place, or may be distributed over multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional module in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units can be realized in a form of hardware or a form of hardware and a form of software functional modules.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential characteristics thereof.
The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
The blockchain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, encryption algorithm and the like. The Blockchain (Blockchain), which is essentially a decentralised database, is a string of data blocks that are generated by cryptographic means in association, each data block containing a batch of information of network transactions for verifying the validity of the information (anti-counterfeiting) and generating the next block. The blockchain may include a blockchain underlying platform, a platform product services layer, an application services layer, and the like.
Furthermore, it is evident that the word "comprising" does not exclude other elements or steps, and that the singular does not exclude a plurality. A plurality of units or means recited in the system claims can also be implemented by means of software or hardware by means of one unit or means. The terms second, etc. are used to denote a name, but not any particular order.
Finally, it should be noted that the above-mentioned embodiments are merely for illustrating the technical solution of the present invention and not for limiting the same, and although the present invention has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications and equivalents may be made to the technical solution of the present invention without departing from the spirit and scope of the technical solution of the present invention.
Claims (6)
1. A method of reconciliation of data, the method comprising:
collecting account checking data, carrying out storage format unification processing on the account checking data to obtain standard account checking data, and storing the standard account checking data into a preset message middleware, wherein the account checking data comprises business data of different systems;
preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
performing data reconciliation on the target reconciliation data by utilizing a reconciliation algorithm in the reconciliation engine assembly to obtain a reconciliation result, and sending the reconciliation result to a corresponding user;
the storing the standard reconciliation data into a preset message middleware comprises the following steps: calculating the storage number of the standard reconciliation data in the message middleware; storing the standard reconciliation data to the message middleware by utilizing a precompiled storage statement according to the storage number;
the calculating the storage number of the standard reconciliation data in the message middleware comprises: calculating the storage number of the standard reconciliation data in the message middleware by using the following method:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein instruct_id represents a storage number of standard reconciliation data in the message middleware, hash_ str (instruction) represents an object quantization function of standard reconciliation data, and instruct_time (time) represents a time quantization function of standard reconciliation data, b1 represents a degree of dispersion of the object quantization function, b2 represents a degree of dispersion of the time quantization function, w1 represents coefficients of the object quantization function, and w2 represents coefficients of the time quantization function;
preprocessing the standard reconciliation data in the message middleware to obtain target reconciliation data, wherein the preprocessing comprises the following steps: filtering the standard reconciliation data in the message middleware to obtain filtered data; performing identification standardization on the filtering data to obtain identification standardization data; grouping the identification standardized data to obtain target reconciliation data;
the reconciliation algorithm comprises:
wherein T (x, y) represents the reconciliation result of the target reconciliation data, x i Y i Representing any two of the target reconciliation data.
2. The data reconciliation method of claim 1, wherein filtering the standard reconciliation data in the message middleware to obtain filtered data comprises:
calculating a hash value of the standard reconciliation data, and determining a pointer of the hash value;
and inquiring the obtained main key of the standard reconciliation data according to the pointer, and executing data filtering of the standard reconciliation data according to the main key to obtain filtering data.
3. The data reconciliation method of claim 1, wherein the performing an identification normalization on the filtered data to obtain identification normalized data comprises:
acquiring a first data identifier and a second data identifier existing in the filtered data, and creating a unified identifier index of the second data identifier and the second data identifier according to the first data identifier and the second data identifier;
and carrying out identification standardization on the filtering data according to the unified identification index to obtain identification standardization data.
4. A data reconciliation apparatus for carrying out the data reconciliation method of any one of claims 1 to 3, the apparatus comprising:
the unified module is used for collecting the reconciliation data, carrying out storage format unified processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data into a preset message middleware;
the preprocessing module is used for preprocessing the standard reconciliation data in the message middleware by utilizing a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and the checking module is used for performing data checking on the target checking data by using a checking algorithm in the checking engine assembly to obtain a checking result and sending the checking result to a corresponding user.
5. An electronic device, the electronic device comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data reconciliation method of any one of claims 1-3.
6. A computer readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the data reconciliation method of any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011486785.XA CN112506940B (en) | 2020-12-16 | 2020-12-16 | Data checking method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011486785.XA CN112506940B (en) | 2020-12-16 | 2020-12-16 | Data checking method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112506940A CN112506940A (en) | 2021-03-16 |
| CN112506940B true CN112506940B (en) | 2023-07-21 |
Family
ID=74972665
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011486785.XA Active CN112506940B (en) | 2020-12-16 | 2020-12-16 | Data checking method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112506940B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113326333A (en) * | 2021-06-30 | 2021-08-31 | 平安消费金融有限公司 | Data processing method, system, computer device and computer storage medium |
| CN113793216A (en) * | 2021-09-02 | 2021-12-14 | 国网河北省电力有限公司石家庄供电分公司 | Big data-based financial data management system and account checking method for power enterprise |
| CN114331663B (en) * | 2022-03-15 | 2022-06-14 | 国网浙江省电力有限公司金华供电公司 | Multidimensional path comparison type data processing method and device suitable for financial information |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109684347A (en) * | 2018-11-27 | 2019-04-26 | 平安科技（深圳）有限公司 | Account checking method, device, computer equipment and storage medium |
| CN110298740A (en) * | 2019-06-24 | 2019-10-01 | 深圳乐信软件技术有限公司 | Data account checking method, device, equipment and storage medium |
| CN110555698A (en) * | 2019-07-25 | 2019-12-10 | 深圳壹账通智能科技有限公司 | data processing method, data processing device, computer equipment and storage medium |
| WO2020211569A1 (en) * | 2019-04-18 | 2020-10-22 | 创新先进技术有限公司 | Method for constructing index of data record |
| CN111861482A (en) * | 2020-09-22 | 2020-10-30 | 支付宝(杭州)信息技术有限公司 | Block chain account checking method and system |
-
2020
- 2020-12-16 CN CN202011486785.XA patent/CN112506940B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109684347A (en) * | 2018-11-27 | 2019-04-26 | 平安科技（深圳）有限公司 | Account checking method, device, computer equipment and storage medium |
| WO2020211569A1 (en) * | 2019-04-18 | 2020-10-22 | 创新先进技术有限公司 | Method for constructing index of data record |
| CN110298740A (en) * | 2019-06-24 | 2019-10-01 | 深圳乐信软件技术有限公司 | Data account checking method, device, equipment and storage medium |
| CN110555698A (en) * | 2019-07-25 | 2019-12-10 | 深圳壹账通智能科技有限公司 | data processing method, data processing device, computer equipment and storage medium |
| CN111861482A (en) * | 2020-09-22 | 2020-10-30 | 支付宝(杭州)信息技术有限公司 | Block chain account checking method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112506940A (en) | 2021-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112506940B (en) | Data checking method and device, electronic equipment and storage medium | |
| CN113269547B (en) | Data processing method, device, electronic equipment and storage medium | |
| CN102479113B (en) | Abnormal self-adapting processing method and system | |
| CN112052242A (en) | Data query method and device, electronic equipment and storage medium | |
| WO2019006654A1 (en) | Financial self-service equipment maintenance dispatch generation method, hand-held terminal and electronic device | |
| CN111787171B (en) | Automatic outbound method, device, electronic equipment and computer readable storage medium | |
| CN111399909B (en) | Service system data distribution processing method, device and storage medium | |
| CN110688828A (en) | File processing method and device, file processing system and computer equipment | |
| CN111897548A (en) | Front-end resource publishing method and device, electronic equipment and computer storage medium | |
| CN107133233B (en) | Processing method and device for configuration data query | |
| CN111814203B (en) | Method, device and equipment for processing environmental data and storage medium | |
| CN113821575A (en) | Data checking method, device and equipment and computer storage medium | |
| CN112506559A (en) | Gray scale publishing method and device based on gateway, electronic equipment and storage medium | |
| CN112085611A (en) | Asynchronous data verification method and device, electronic equipment and storage medium | |
| CN117193975A (en) | Task scheduling method, device, equipment and storage medium | |
| CN112949278A (en) | Data checking method and device, electronic equipment and readable storage medium | |
| CN112541688B (en) | Service data verification method and device, electronic equipment and computer storage medium | |
| CN113448788A (en) | Test-based service processing method and device, electronic equipment and storage medium | |
| CN112256783A (en) | Data export method and device, electronic equipment and storage medium | |
| CN115829307A (en) | Automatic production method and device of smart card and readable storage medium | |
| CN112686759B (en) | Account reconciliation monitoring method, device, equipment and medium | |
| CN115480748A (en) | Service arrangement method, device and storage medium | |
| CN113254446B (en) | Data fusion method, device, electronic equipment and medium | |
| CN113568904B (en) | Work delivery method and device, electronic equipment and readable storage medium | |
| CN114547696A (en) | File desensitization method and device, electronic 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 |