CN112506940A - Data reconciliation method and device, electronic equipment and storage medium - Google Patents
Data reconciliation method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112506940A CN112506940A CN202011486785.XA CN202011486785A CN112506940A CN 112506940 A CN112506940 A CN 112506940A CN 202011486785 A CN202011486785 A CN 202011486785A CN 112506940 A CN112506940 A CN 112506940A
- Authority
- CN
- China
- Prior art keywords
- data
- reconciliation
- standard
- message middleware
- identifier
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/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; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/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
Abstract
The invention relates to the field of big data, and discloses a data reconciliation method, which comprises the following steps: acquiring reconciliation data, performing storage format unification processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data in a preset message middleware; preprocessing the standard reconciliation data in the message middleware by using a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data; and carrying out data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result, and sending the reconciliation result to a corresponding user. In addition, the invention also relates to a block chain technology, and the reconciliation result can be stored in the block chain. 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, an apparatus, an electronic device, and a computer-readable storage medium.
Background
The data reconciliation is a process for monitoring whether the data of the upstream and downstream service systems are consistent or not, and is used for ensuring that the data of the upstream and downstream service systems are correct. Data reconciliation is applied in many industrial fields, for example, in the financial industry. Because various business systems in the financial industry have strict requirements on data consistency, data reconciliation is an essential 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 ensuring data to be correct.
The traditional reconciliation method usually needs longer time for waiting for reconciliation data, and simultaneously, due to the complexity of daily final data logic, the timeliness of the data reconciliation is lower, so that the efficiency of the data reconciliation is influenced; in addition, the traditional reconciliation method is difficult to achieve unified access and checking processing of reconciliation data, and meanwhile, the configuration degree of the reconciliation data is poor, so that repeated development of a plurality of reconciliation programs is easily caused, and the time effectiveness of data reconciliation is influenced.
Disclosure of Invention
The invention provides a data reconciliation method, a data reconciliation device, electronic equipment and a computer-readable storage medium, and mainly aims to improve timeliness of data reconciliation.
In order to achieve the above object, the present invention provides a data reconciliation method, comprising:
acquiring reconciliation data, performing storage format unification processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data in a preset message middleware;
preprocessing the standard reconciliation data in the message middleware by using a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and carrying out data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
Optionally, the logging 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 using 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, instruction _ id represents a storage number of standard reconciliation data in the message middleware, hash _ str (instruction) represents an object quantization function of the standard reconciliation data, and instruction _ time (time) represents a time quantization function of the standard reconciliation data, b1 represents a dispersion degree of the object quantization function, b2 represents a dispersion degree 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 the 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;
and 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 acquired 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 filtered data.
Optionally, the performing identification normalization on the filtered data to obtain identification normalized data includes:
acquiring a first data identifier and a second data identifier existing in the filtering 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 according to the uniform identification index, performing identification standardization on the filtering data to obtain identification standardization data.
Optionally, the reconciliation algorithm includes:
where T (, y) represents the reconciliation result of the target reconciliation data, xiAnd yiRepresenting any two pieces of target reconciliation data.
In order to solve the above problem, the present invention further provides a data reconciliation apparatus, comprising:
the unification module is used for acquiring reconciliation data, performing storage format unification 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 reconciliation module is used for carrying out data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result and sending the reconciliation result to a corresponding user.
In order to solve the above problem, the present invention also provides an electronic device, including:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to implement the data reconciliation method described above.
In order to solve the above problem, the present invention also provides a computer-readable storage medium, in which at least one computer program is stored, and the at least one computer program is executed by a processor in an electronic device to implement the data reconciliation method described above.
According to the embodiment of the invention, firstly, the account checking data is collected, the storage format of the account checking data is subjected to unified processing to obtain the standard account checking data, and the standard account checking data is stored in the preset message middleware, so that the high-speed reading of the account checking data is realized, and the time for waiting for the account checking data is reduced; secondly, the embodiment of the invention preprocesses the standard reconciliation data in the message middleware according to the reconciliation engine component which is configured with the standard reconciliation data in advance to obtain the target reconciliation data, and can realize the filtering, identification standardization and grouping processing of the reconciliation data, thereby realizing the uniform access of the reconciliation data and the direct filtering of the data which does not need reconciliation, saving the system resources, and simultaneously finishing the uniform checking of the reconciliation data, thereby improving the timeliness of the reconciliation data; further, the invention utilizes the reconciliation algorithm in the reconciliation engine component to carry out data reconciliation on the target reconciliation data to obtain a reconciliation result, and sends the reconciliation result to a corresponding user. Therefore, the data reconciliation method, the data reconciliation device, the electronic equipment and the storage medium can improve the timeliness of the data reconciliation.
Drawings
Fig. 1 is a schematic flow chart of a data reconciliation method according to an embodiment of the present invention;
FIG. 2 is a detailed flowchart illustrating a step of the data reconciliation method provided in FIG. 1 according to a first embodiment of the present invention;
fig. 3 is a block diagram of a data reconciliation apparatus according to an embodiment of the present invention;
fig. 4 is a schematic internal structural diagram of an electronic device implementing a data reconciliation method according to an embodiment of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit 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 electronic devices such as a server and a terminal, which can be configured to execute the method provided by the embodiment of the application. In other words, the data reconciliation method can be performed by software or hardware installed in the terminal device or the server device, and the software can be a block chain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like.
Fig. 1 is a schematic flow chart of a data reconciliation method according to an embodiment of the present invention. In the embodiment of the present invention, the data reconciliation method includes:
s1, 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 in 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 an upstream business system and a downstream business system through a reconciliation collection component. And the reconciliation acquisition component is compiled through java and is used for acquiring reconciliation data of different channels.
In detail, the collecting reconciliation data comprises: and in response to the data reconciliation request, collecting reconciliation data from the corresponding business system by using the reconciliation collection component. For example, a company a and a company B need to perform a batch of goods data reconciliation, receive a goods data reconciliation request, and acquire goods data of the company a from a business system of the company a and goods data of the company B from a business system of the company B by using a reconciliation acquisition component; the order of the company C is completed by the cooperation of a plurality of subsystems, the problem that accounts of upstream and downstream business subsystems of the company C are uneven is caused due to objective factors (network jitter, server downtime, abnormal business systems and the like), a financial reconciliation request of the upstream and downstream business subsystems of the company C is received, and corresponding financial data is collected from the upstream and downstream business subsystems of the company C by using a reconciliation collection component.
Furthermore, due to the fact that the source channels of the account checking data are different, the storage modes of the account checking data are different, for example, some data are stored in oracle, some data are stored in mysql, some data are stored in rocktMQ and the like, and therefore the problem that the storage modes of the account checking data are inconsistent is solved by carrying out storage format unification processing on the account checking data, and timeliness of the account checking data is improved.
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. Wherein, the json format refers to a lightweight data exchange format, which is convenient for data reading and understanding.
Further, the standard account checking data are stored in the preset message middleware to realize efficient access of the account checking data. Specifically, the storing the standard reconciliation data in a preset message middleware includes:
and calculating the storage number of the standard reconciliation data in the message middleware, and storing the standard reconciliation data in the message middleware by using a precompiled storage statement according to the storage number.
In an optional embodiment, the preset message middleware may be: mq or kafka message middleware.
In an optional embodiment, calculating the storage number of the standard reconciliation data in the message middleware by using the following method comprises:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein, instruction _ id represents a storage number of standard reconciliation data in the message middleware, hash _ str (instruction) represents an object quantization function of the standard reconciliation data, and instruction _ time (time) represents a time quantization function of the standard reconciliation data, b1 represents a dispersion degree of the object quantization function, b2 represents a dispersion degree 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 storage statement may be an sql statement, the sql statement comprising: insert statement.
And S2, preprocessing the standard reconciliation data in the message middleware by using the 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 on the reconciliation data, and the reconciliation engine component is configured through a web page.
Further, referring to fig. 2, the preprocessing the standard reconciliation data in the message middleware by using the pre-configured reconciliation engine component of the standard reconciliation data to obtain the target reconciliation data includes:
s21, filtering the data to be checked to obtain filtered data;
s22, performing identification standardization on the filtering data to obtain identification standardization data;
and S23, grouping the identification standardized data to obtain target reconciliation data.
Wherein, the filtering is to directly filter the data which does not need to be checked out, so as to save system resources; the identification standardization is to convert the identification (field or data value) of the account checking data into an intermediate state; the grouping is to divide the account checking data of the same account checking task into a group, for example, the grouping and the account checking can be performed according to orderID, so that the account checking efficiency of the account checking data is improved.
In detail, the filtering the standard reconciliation data in the message middleware to obtain filtered data includes:
and calculating the hash value of the standard reconciliation data, determining a pointer of the hash value, inquiring the acquired main key of the standard reconciliation data according to the pointer, and executing the data reconciliation of the standard reconciliation data according to the main key and a preset filtering principle.
The embodiment of the invention utilizes the hash function in the reconciliation engine component to calculate the hash value of the standard reconciliation data. 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 the age data not to be checked, and then filters the corresponding data with the main key of the checked account data as the age.
In detail, the performing identification normalization on the filtering data to obtain identification normalized data includes:
acquiring a first data identifier and a second data identifier existing in the filtering 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 standardizing the first data identifier and the second data identifier according to the uniform identifier index to obtain identifier standardized data.
In an optional embodiment, the index of the first id and the second id is created by using a request function in the reconciliation engine component.
In an optional embodiment, the second data identifier and the unified identifier index of the second data identifier are created by using a Shift function in the reconciliation engine component.
Exemplarily, a first data identifier and a second data identifier existing in the filtering data are obtained as orderId and orderjd, a uniform identifier index of the first data identifier and the second data identifier is created as orderID by using a request function, and the filtering data is subjected to identifier standardization according to the uniform identifier index to obtain identifier standardized data.
And S3, performing data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
In the embodiment of the invention, the reconciliation algorithm in the reconciliation engine component is adopted to carry out data reconciliation on the target reconciliation data to obtain a reconciliation result, and the reconciliation result is sent to a corresponding user.
In an optional embodiment, the reconciliation algorithm includes:
where T (, y) represents the reconciliation result of the target reconciliation data, xiFirst data, y, representing target reconciliation dataiSecond data representing target reconciliation data.
In an optional embodiment, the sending of the reconciliation result is implemented by a preset message sending component, the message sending component is compiled by java, and a sending channel of the message sending component includes: the mails and the short messages also support telephone calls, voice broadcast and the like.
Further, in order to ensure the safety and reliability of the reconciliation result, the reconciliation result can also be stored in a block chain node.
Further, before sending the reconciliation result to the corresponding user, the embodiment of the present invention may further include: and summarizing the account checking results and monitoring whether the account checking is abnormal or not in the account checking process of executing the target account checking data so as to ensure the accuracy and reliability of the account checking data. The summary of the account checking results is realized through preset time, for example, the total amount of account checking data in one hour is summarized, so that whether data is omitted in the account checking results is conveniently detected, and the account checking accuracy is improved; the account checking abnormal condition monitoring is realized through an abnormal monitoring component, account checking personnel are informed to check for the first time in time, the reliability of an account checking result is guaranteed, and the abnormal monitoring component is compiled through a JavaScript script.
Further, another embodiment of the present invention may further include: the reconciliation monitoring management background is compiled through java language and is connected with the reconciliation acquisition component, the reconciliation engine component, the message middleware, the message sending component and the abnormity monitoring component so as to manage and control the reconciliation data from the whole reconciliation process of access, pretreatment, reconciliation, abnormity warning, reconciliation result sending and the like, and meanwhile, the permission of different users can be set based on the reconciliation monitoring management platform so as to realize that different services can be seen by users with different permissions of different roles (products, services, development, administrators and the like), thereby greatly improving the flexible configuration and management of system users and ensuring the safety of the reconciliation data.
According to the embodiment of the invention, firstly, the account checking data is collected, the storage format of the account checking data is subjected to unified processing to obtain the standard account checking data, and the standard account checking data is stored in the preset message middleware, so that the high-speed reading of the account checking data is realized, and the time for waiting for the account checking data is reduced; secondly, the embodiment of the invention preprocesses the standard reconciliation data in the message middleware according to the reconciliation engine component which is configured with the standard reconciliation data in advance to obtain the target reconciliation data, and realizes the filtering, identification standardization and grouping processing of the reconciliation data, thereby realizing the uniform access of the reconciliation data and the direct filtering of the data which does not need reconciliation, saving the system resources, and simultaneously finishing the uniform checking of the reconciliation data, thereby improving the timeliness of the reconciliation data; further, the invention utilizes the reconciliation algorithm in the reconciliation engine component to carry out data reconciliation on the target reconciliation data to obtain a reconciliation result, and sends the reconciliation result to a corresponding user. Therefore, the data reconciliation method provided by the invention can improve the timeliness of data reconciliation.
Fig. 3 is a functional block diagram of the data reconciliation device according to the present invention.
The data reconciliation device 100 can be installed in an electronic device. According to the realized functions, the data reconciliation device can comprise a unification module 101, a preprocessing module 102 and a reconciliation module 103. A module according to the present invention, which may also be referred to as a unit, refers to a series of computer program segments that can be executed by a processor of an electronic device and that can perform a fixed function, and that are stored in a memory of the electronic device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
the unification 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 in 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 an upstream business system and a downstream business system through a reconciliation collection component. And the reconciliation acquisition component is compiled through java and is used for acquiring reconciliation data of different channels.
In detail, the unification module 101 collects reconciliation data in the following manner: and in response to the data reconciliation request, collecting reconciliation data from the corresponding business system by using the reconciliation collection component. For example, a company a and a company B need to perform a batch of goods data reconciliation, receive a goods data reconciliation request, and acquire goods data of the company a from a business system of the company a and goods data of the company B from a business system of the company B by using a reconciliation acquisition component; the order of the company C is completed by the cooperation of a plurality of subsystems, the problem that accounts of upstream and downstream business subsystems of the company C are uneven is caused due to objective factors (network jitter, server downtime, abnormal business systems and the like), a financial reconciliation request of the upstream and downstream business subsystems of the company C is received, and corresponding financial data is collected from the upstream and downstream business subsystems of the company C by using a reconciliation collection component.
Furthermore, due to the fact that the source channels of the account checking data are different, the storage modes of the account checking data are different, for example, some data are stored in oracle, some data are stored in mysql, some data are stored in rocktMQ and the like, and therefore the problem that the storage modes of the account checking data are inconsistent is solved by carrying out storage format unification processing on the account checking data, and timeliness of the account checking data is improved.
In detail, the unification module 101 performs storage format unification on the reconciliation data by adopting the following method 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. Wherein, the json format refers to a lightweight data exchange format, which is convenient for data reading and understanding.
Further, the standard account checking data are stored in the preset message middleware to realize efficient access of the account checking data. Specifically, the unification module 101 stores the standard reconciliation data in a preset message middleware in the following manner:
and calculating the storage number of the standard reconciliation data in the message middleware, and storing the standard reconciliation data in the message middleware by using a precompiled storage statement according to the storage number.
In an optional embodiment, the preset message middleware may be: mq or kafka message middleware.
In an optional embodiment, calculating the storage number of the standard reconciliation data in the message middleware by using the following method comprises:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein, instruction _ id represents a storage number of standard reconciliation data in the message middleware, hash _ str (instruction) represents an object quantization function of the standard reconciliation data, and instruction _ time (time) represents a time quantization function of the standard reconciliation data, b1 represents a dispersion degree of the object quantization function, b2 represents a dispersion degree 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 storage statement may be an sql statement, the sql statement comprising: insert statement.
The preprocessing module 102 is configured to preprocess the standard reconciliation data in the message middleware by using a reconciliation engine component of the standard reconciliation data configured in advance, 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 on the reconciliation data, and the reconciliation engine component is configured through a web page.
Further, the preprocessing module 102 executes a reconciliation engine component using the preconfigured standard reconciliation data to preprocess the standard reconciliation data in the message middleware by using the following method:
step I, filtering the data to be checked to obtain filtered data;
II, performing identification standardization on the filtering data to obtain identification standardization data;
and III, grouping the identification standardized data to obtain target reconciliation data.
Wherein, the filtering is to directly filter the data which does not need to be checked out, so as to save system resources; the identification standardization is to convert the identification (field or data value) of the account checking data into an intermediate state; the grouping is to divide the account checking data of the same account checking task into a group, for example, the grouping and the account checking can be performed according to orderID, so that the account checking efficiency of the account checking data is improved.
In detail, the preprocessing module 102 performs filtering on the standard reconciliation data in the message middleware by using the following method to obtain filtered data:
and calculating the hash value of the standard reconciliation data, determining a pointer of the hash value, inquiring the acquired main key of the standard reconciliation data according to the pointer, and executing the data reconciliation of the standard reconciliation data according to the main key and a preset filtering principle.
The embodiment of the invention utilizes the hash function in the reconciliation engine component to calculate the hash value of the standard reconciliation data. 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 the age data not to be checked, and then filters the corresponding data with the main key of the checked account data as the age.
In detail, the preprocessing module 102 performs identifier normalization on the filtered data by using the following method, so as to obtain identifier normalized data:
acquiring a first data identifier and a second data identifier existing in the filtering 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 standardizing the first data identifier and the second data identifier according to the uniform identifier index to obtain identifier standardized data.
In an optional embodiment, the index of the first id and the second id is created by using a request function in the reconciliation engine component.
In an optional embodiment, the second data identifier and the unified identifier index of the second data identifier are created by using a Shift function in the reconciliation engine component.
Exemplarily, a first data identifier and a second data identifier existing in the filtering data are obtained as orderId and orderjd, a uniform identifier index of the first data identifier and the second data identifier is created as orderID by using a request function, and the filtering data is subjected to identifier standardization according to the uniform identifier index to obtain identifier standardized 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 to 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 to obtain a reconciliation result, and sends the reconciliation result to a corresponding user.
In an optional embodiment, the reconciliation algorithm includes:
where T (, y) represents the reconciliation result of the target reconciliation data, xiFirst data, y, representing target reconciliation dataiSecond data representing target reconciliation data.
In an optional embodiment, the sending of the reconciliation result is implemented by a preset message sending component, the message sending component is compiled by java, and a sending channel of the message sending component includes: the mails and the short messages also support telephone calls, voice broadcast and the like.
Further, in order to ensure the safety and reliability of the reconciliation result, the reconciliation result can also be stored in a block chain node.
Further, the reconciliation module 103, before sending the reconciliation result to the corresponding user, may further be configured to: and summarizing the account checking results and monitoring whether the account checking is abnormal or not in the account checking process of executing the target account checking data so as to ensure the accuracy and reliability of the account checking data. The summary of the account checking results is realized through preset time, for example, the total amount of account checking data in one hour is summarized, so that whether data is omitted in the account checking results is conveniently detected, and the account checking accuracy is improved; the account checking abnormal condition monitoring is realized through an abnormal monitoring component, account checking personnel are informed to check for the first time in time, the reliability of an account checking result is guaranteed, and the abnormal monitoring component is compiled through a JavaScript script.
Further, another embodiment of the present invention may further include: the reconciliation monitoring management background is compiled through java language and is connected with the reconciliation acquisition component, the reconciliation engine component, the message middleware, the message sending component and the abnormity monitoring component so as to manage and control the reconciliation data from the whole reconciliation process of access, pretreatment, reconciliation, abnormity warning, reconciliation result sending and the like, and meanwhile, the permission of different users can be set based on the reconciliation monitoring management platform so as to realize that different services can be seen by users with different permissions of different roles (products, services, development, administrators and the like), thereby greatly improving the flexible configuration and management of system users and ensuring the safety of the reconciliation data.
According to the embodiment of the invention, firstly, the account checking data is collected, the storage format of the account checking data is subjected to unified processing to obtain the standard account checking data, and the standard account checking data is stored in the preset message middleware, so that the high-speed reading of the account checking data is realized, and the time for waiting for the account checking data is reduced; secondly, the embodiment of the invention preprocesses the standard reconciliation data in the message middleware according to the reconciliation engine component which is configured with the standard reconciliation data in advance to obtain the target reconciliation data, and realizes the filtering, identification standardization and grouping processing of the reconciliation data, thereby realizing the uniform access of the reconciliation data and the direct filtering of the data which does not need reconciliation, saving the system resources, and simultaneously finishing the uniform checking of the reconciliation data, thereby improving the timeliness of the reconciliation data; further, the invention utilizes the reconciliation algorithm in the reconciliation engine component to carry out data reconciliation on the target reconciliation data to obtain a reconciliation result, and sends the reconciliation result to a corresponding user. Therefore, the data reconciliation device provided by the invention can improve the timeliness of data reconciliation.
Fig. 4 is a schematic structural diagram of an electronic device implementing the data reconciliation method according to 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 operable on the processor 10.
The memory 11 includes at least one type of readable storage medium, which includes flash memory, removable hard disk, multimedia card, card-type memory (e.g., SD or DX memory, etc.), magnetic memory, magnetic disk, 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 also be an external storage device of the electronic device 1 in other embodiments, such as a plug-in mobile hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and 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 to store application software installed in the electronic device 1 and various types of data, such as codes of a data reconciliation program, but also to temporarily store data that has been output or is to be output.
The processor 10 may be composed of an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged with the same or different functions, including one or more Central Processing Units (CPUs), microprocessors, digital Processing chips, graphics processors, and combinations of various control chips. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects various components of the electronic device by using various interfaces and lines, and executes various functions and processes data of the electronic device 1 by running or executing programs or modules (for example, executing a data reconciliation program, etc.) stored in the memory 11 and calling data stored in the memory 11.
The bus may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is arranged to enable connection communication between the memory 11 and at least one processor 10 or the like.
Fig. 4 only shows an electronic device with components, and it will be understood by those 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 those shown, or some components may be combined, or a different arrangement of components.
For example, although not shown, the electronic device 1 may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so as to implement functions of charge management, discharge management, power consumption management, and the like through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The electronic device 1 may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
Further, the electronic device 1 may further include a network interface, and optionally, the network interface may include a wired interface and/or a wireless interface (such as a WI-FI interface, a bluetooth interface, etc.), which are generally used for establishing a communication connection between the electronic device 1 and other electronic devices.
Optionally, the electronic device 1 may further comprise a user interface, which may be a Display (Display), an input unit (such as a Keyboard), and optionally 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 device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the electronic device 1 and for displaying a visualized user interface, among other things.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
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, can implement:
acquiring reconciliation data, performing storage format unification processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data in a preset message middleware;
preprocessing the standard reconciliation data in the message middleware by using a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and carrying out data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
Specifically, the specific implementation method of the processor 10 for the instruction may refer to the description of the relevant steps in the embodiment corresponding to fig. 1, which is not described herein again.
Further, the integrated modules/units of the electronic device 1, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. The computer readable storage medium may be volatile or non-volatile. For example, the computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, 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, may implement:
acquiring reconciliation data, performing storage format unification processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data in a preset message middleware;
preprocessing the standard reconciliation data in the message middleware by using a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and carrying out data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
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 attributes 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 block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the system claims may also be implemented by one unit or means in software or hardware. The terms second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.
Claims (10)
1. A method for reconciling data, the method comprising:
acquiring reconciliation data, performing storage format unification processing on the reconciliation data to obtain standard reconciliation data, and storing the standard reconciliation data in a preset message middleware;
preprocessing the standard reconciliation data in the message middleware by using a pre-configured reconciliation engine component of the standard reconciliation data to obtain target reconciliation data;
and carrying out data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result, and sending the reconciliation result to a corresponding user.
2. The data reconciliation method of claim 1 wherein the depositing the standard reconciliation data into a pre-defined message middleware comprises:
calculating the storage number of the standard reconciliation data in the message middleware;
and storing the standard reconciliation data to the message middleware by using a precompiled storage statement according to the storage number.
3. The data reconciliation method of claim 2 wherein 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, instruction _ id represents a storage number of standard reconciliation data in the message middleware, hash _ str (instruction) represents an object quantization function of the standard reconciliation data, and instruction _ time (time) represents a time quantization function of the standard reconciliation data, b1 represents a dispersion degree of the object quantization function, b2 represents a dispersion degree of the time quantization function, w1 represents coefficients of the object quantization function, and w2 represents coefficients of the time quantization function.
4. The data reconciliation method of claim 1, wherein the preprocessing the standard reconciliation data in the message middleware to obtain target reconciliation data comprises:
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;
and grouping the identification standardized data to obtain target reconciliation data.
5. The data reconciliation method of claim 4 wherein the 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 acquired 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 filtered data.
6. The data reconciliation method of claim 4 wherein the identifier normalizing the filtered data to obtain identifier normalized data comprises:
acquiring a first data identifier and a second data identifier existing in the filtering 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 according to the uniform identification index, performing identification standardization on the filtering data to obtain identification standardization data.
7. The data reconciliation method of any one of claims 1 to 6 wherein the reconciliation algorithm comprises:
wherein T (x, y) represents the reconciliation result of the target reconciliation data, and xiAnd yiRepresenting any two pieces of target reconciliation data.
8. A data reconciliation apparatus, the apparatus comprising:
the unification module is used for acquiring reconciliation data, performing storage format unification 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 reconciliation module is used for carrying out data reconciliation on the target reconciliation data by using a reconciliation algorithm in the reconciliation engine component to obtain a reconciliation result and sending the reconciliation result to a corresponding user.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
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 of claims 1 to 7.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out a data reconciliation method according to any one of claims 1 to 7.
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 true CN112506940A (en) | 2021-03-16 |
| CN112506940B 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) |
Cited By (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 |
| CN114331663A (en) * | 2022-03-15 | 2022-04-12 | 国网浙江省电力有限公司金华供电公司 | 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 |
Cited By (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 |
| CN114331663A (en) * | 2022-03-15 | 2022-04-12 | 国网浙江省电力有限公司金华供电公司 | Multidimensional path comparison type data processing method and device suitable for financial information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112506940B (en) | 2023-07-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112506940B (en) | Data checking method and device, electronic equipment and storage medium | |
| CN112052242A (en) | Data query method and device, electronic equipment and storage medium | |
| CN111787171B (en) | Automatic outbound method, device, electronic equipment and computer readable storage medium | |
| CN112417503A (en) | Method and device for authorizing post authority, electronic equipment and storage medium | |
| CN112256783A (en) | Data export method and device, electronic equipment and storage medium | |
| CN114881616A (en) | Business process execution method and device, electronic equipment and storage medium | |
| CN112506559A (en) | Gray scale publishing method and device based on gateway, electronic equipment and storage medium | |
| CN111985194A (en) | Data storage method and device, electronic equipment and storage medium | |
| CN112580079A (en) | Authority configuration method and device, electronic equipment and readable storage medium | |
| CN111210324A (en) | General invoice data processing method and system based on parallel computing | |
| CN115829307A (en) | Automatic production method and device of smart card and readable storage medium | |
| CN114490137A (en) | Service data real-time statistical method and device, electronic equipment and readable storage medium | |
| CN114840388A (en) | Data monitoring method and device, electronic equipment and storage medium | |
| CN113419718A (en) | Data transmission method, device, equipment and medium | |
| CN114897624A (en) | Policy data merging method, device, equipment and storage medium | |
| CN113377857A (en) | Data distribution method and device, electronic equipment and readable storage medium | |
| CN113469649A (en) | Project progress analysis method and device, electronic equipment and storage medium | |
| CN113254446A (en) | Data fusion method and device, electronic equipment and medium | |
| CN113421009B (en) | Accessory approval method and device, electronic equipment and readable storage medium | |
| CN113064797B (en) | Front-end monitoring method and device, electronic equipment and storage medium | |
| CN112686759A (en) | Account checking monitoring method, device, equipment and medium | |
| CN114598624A (en) | Cluster monitoring method and device, electronic equipment and readable storage medium | |
| CN112559295A (en) | Data monitoring method and device, electronic equipment and storage medium | |
| CN112199718A (en) | Data transfer monitoring method and device, electronic equipment and storage medium | |
| CN117237127A (en) | Insurance fee reconciliation method, apparatus, device 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 |