CN111061718A - Data checking method and device - Google Patents
Data checking method and device Download PDFInfo
- Publication number
- CN111061718A CN111061718A CN201911314854.6A CN201911314854A CN111061718A CN 111061718 A CN111061718 A CN 111061718A CN 201911314854 A CN201911314854 A CN 201911314854A CN 111061718 A CN111061718 A CN 111061718A
- Authority
- CN
- China
- Prior art keywords
- data
- checking
- audited
- account
- preset
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a data checking method and a device, wherein the method comprises the following steps: acquiring data to be audited; performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule; and if the data to be audited passes record number checking, null value checking, correlation checking and index value checking, determining that the data to be audited is qualified. The device is used for executing the method. The data checking method and the data checking device provided by the embodiment of the invention improve the accuracy of checking the data to be audited.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a data checking method and device.
Background
The gold audit platform is an audit data analysis system deployed by an audit organization in each large bank and a stock system bank, has the functions of overall analysis, query analysis, early warning analysis, clue checking and the like, and can realize digital audit of commercial banks.
At present, the bank system has the problems that general account is not smooth and wrong account due to lack of flow details due to historical data storage, internal data summary is inconsistent with external report data, data is lost in the data transmission process between the bank systems, and dirty data exists in data processing. Therefore, the audit data submitted by the bank needs to be checked, and the correlation of the service data of the internal system of the bank, the integrity of the whole service chain and the validity of the submitted audit data in the audit range are guaranteed. In the prior art, the check of the to-be-checked data is read and processed, the source file is read to carry out table level check and basic check, then the records which do not conform to the convention are removed, and the audit data which passes the check is stored. In the prior art, checking is carried out according to an agreed table format, field types and a main key relation, only order of magnitude checking can be carried out, business relevance checking cannot be carried out on a data content value, auditing factors cannot be checked, and data quality cannot be guaranteed.
Therefore, how to provide a data checking method, which can effectively check the data to be audited so as to improve the accuracy of checking the audited data in the banking industry becomes an important subject to be solved in the field.
Disclosure of Invention
To solve the problems in the prior art, embodiments of the present invention provide a data checking method and apparatus.
In one aspect, the present invention provides a data checking method, including:
acquiring data to be audited;
performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule;
and if the data to be audited passes record number checking, null value checking, correlation checking and index value checking, determining that the data to be audited is qualified.
In another aspect, the present invention provides a data checking apparatus, including:
the acquiring unit is used for acquiring data to be audited;
the checking unit is used for performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule;
and the judging unit is used for determining that the to-be-audited data is qualified after judging and knowing that the to-be-audited data passes through record number checking, null value checking, association checking and index value checking.
In another aspect, the present invention provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the steps of the data checking method according to any of the above embodiments are implemented.
In yet another aspect, the present invention provides a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the steps of the data checking method according to any one of the above embodiments.
The data checking method and the device provided by the embodiment of the invention can acquire the data to be audited, then record number checking is carried out on the data to be audited according to the first checking rule, null value checking is carried out on the data to be audited according to the second checking rule, correlation checking is carried out on the data to be audited according to the third checking rule, index value checking is carried out on the data to be audited according to the fourth checking rule, and after the data to be audited is judged and known to pass through the record number checking, the null value checking, the correlation checking and the index value checking, the data to be audited is determined to be qualified, the data to be audited can be checked comprehensively, and the accuracy of the data to be audited is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
fig. 1 is a schematic flow chart of a data checking method according to a first embodiment of the present invention.
Fig. 2 is a schematic structural diagram of a data checking apparatus according to an embodiment of the present invention.
Fig. 3 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
Fig. 1 is a schematic flow chart of a data checking method according to a first embodiment of the present invention, and as shown in fig. 1, the data checking method according to the embodiment of the present invention includes:
s101, acquiring data to be audited;
specifically, the server may obtain data to be audited from the database, where the data to be audited may be data submitted by each bank for auditing. The data to be audited can be stored in a preset model table, and the model table is set according to actual needs. The execution subject of the data checking method provided by the embodiment of the invention includes but is not limited to a server.
S102, performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing associated checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule;
specifically, after the server obtains the data to be audited, performing record number checking on the data to be audited according to a first checking rule to obtain a record number checking result; performing null value check on the data to be audited according to a second check rule to obtain a null value check result; performing correlation check on the data to be audited according to a third check rule to obtain a correlation check result; and performing index value checking on the to-be-checked data according to a fourth checking rule to obtain an index value checking result.
S103, if the data to be audited passes through record number checking, null value checking, association checking and index value checking, the data to be audited is determined to be qualified.
Specifically, after obtaining the record number checking result, the server may count an error rate of the record number checking result, and if the error rate of the record number checking result is smaller than a first threshold, the record number checking result meets a requirement, and the data to be audited passes the record number checking. After the server obtains the null value check result, the server may count the error rate of the null value check result, and if the error rate of the null value check result is smaller than a second threshold, the recorded number check result meets the requirement, and the data to be audited passes the null value check. After obtaining the correlation check result, the server may count an error rate of the correlation check result, and if the error rate of the correlation check result is smaller than a third threshold, the correlation check result meets a requirement, and the data to be audited passes the correlation check. After obtaining the index value check result, the server may determine whether the index value check result meets a requirement, and if the index value check result meets the requirement, the data to be audited passes through index check. And after judging that the data to be audited passes record number checking, null value checking, association checking and index value checking, the server determines that the data to be audited is qualified, namely the data quality of the data to be audited meets the requirement of auditing. The first threshold, the second threshold, and the third threshold are set according to actual needs, for example, all are set to one in ten thousand, and the embodiment of the present invention is not limited.
The data checking method provided by the embodiment of the invention can acquire the data to be audited, then record number checking is carried out on the data to be audited according to the first checking rule, null value checking is carried out on the data to be audited according to the second checking rule, correlation checking is carried out on the data to be audited according to the third checking rule, index value checking is carried out on the data to be audited according to the fourth checking rule, and after the data to be audited is judged to pass through the record number checking, the null value checking, the correlation checking and the index value checking, the data to be audited is determined to be qualified, the data to be audited can be checked comprehensively, and the accuracy of checking the data to be audited is improved.
On the basis of the foregoing embodiments, further, the performing record number checking on the data to be audited according to the first checking rule includes:
comparing the time point record number of the first time with the time point record number of the second time of the upstream source table corresponding to the to-be-examined data; the first time is the time when the upstream source table corresponding to the data to be audited is transmitted from an upstream system, and the second time is the time when the upstream source table corresponding to the data to be audited is received.
Specifically, the upstream source table corresponding to the data to be audited is the upstream source table of the data source to be audited. The upstream source table corresponding to the data to be audited is transmitted by an upstream system and can be received by a financial auditing data analysis platform, the time point record number of each upstream source table is counted when the upstream source table corresponding to the data to be audited is transmitted, and the time point record number of each upstream source table is counted when the upstream source table corresponding to the data to be audited is received. In order to prevent the upstream source table corresponding to the pending data from being missing in the transmission process, the time point record number of the first time and the time point record number of the second time of the upstream source table corresponding to the pending data may be compared to obtain a record number check result. The first time is the time when the upstream source table corresponding to the data to be audited is transmitted from an upstream system, and the second time is the time when the upstream source table corresponding to the data to be audited is received. The upstream source table refers to a data table provided by an upstream system for a financial audit data analysis platform. The upstream system refers to a system for providing data for a financial audit data analysis platform, such as a deposit system, a loan system and the like of a bank. The time point record number refers to the number of all records in the data table at the time point of providing data. The data table may be an upstream source table.
For example, the source table related to the data to be audited includes a legal life deposit account table, the corresponding upstream source table includes a detail table of the public periodic deposit contract account, and the time point record number of the server counting the legal life deposit account table is S1Counting the time point record number of obtaining the account detail table of the public periodic deposit contract as S2If the result h of checking the number of records corresponding to the legal deposit account table is equal to (S)1-S2)/S1. If the legal person deposits on the account in the current periodIf the record number checking result h corresponding to the account table is smaller than the first threshold value, checking the to-be-checked count data in the legal life deposit account table through the record number; if the record number checking result h corresponding to the legal person's current deposit account table is greater than or equal to the first threshold value, the to-be-checked count data in the legal person's current deposit account table cannot pass through the record number checking, and the to-be-checked count data cannot pass through the record number checking, namely, the record number checking result corresponding to any source table in the source table related to the to-be-checked data is greater than or equal to the first threshold value, and the to-be-checked data cannot pass through the record number checking.
On the basis of the foregoing embodiments, further, the performing null value checking on the data to be audited according to a second checking rule includes:
counting the null value rate of preset index items in the model table of the data to be audited; wherein the model table is preset.
Specifically, the data to be audited may be stored in a preset model table, the server may count a null value rate of a preset index item of each model table of the model table in which the data to be audited is stored, and the null value rate of the preset index item of each model table is used as a null value check result corresponding to each model table. And the preset index item is an index item which is not allowed to be a null value in each model table. And the model table of the data to be audited is the model table storing the data to be audited. And the purpose of checking the null value of the to-be-audited data is to ensure the integrity of the to-be-audited data. Index items in the model table are set according to actual needs, and the embodiment of the invention is not limited.
For example, in the model table a, each index entry has a corresponding null identifier, if the null identifier is Y, it indicates that the index entry may be null, and if the null identifier is N, it indicates that the index entry cannot be null. The server can count the number of the preset index items in the model table A as null values, namely count the number of the index items with the null value identification N as null values, and obtain the number K of the preset index items in the model table A as null values1The number of preset index items in the model table A is KThen, the null check result corresponding to the model table a is K ═ K1and/K. If the null value checking result k corresponding to the model table A is smaller than the second threshold value, the data to be checked in the model table A passes the null value checking; and if the null value check result k corresponding to the model table A is greater than or equal to the second threshold value, the to-be-audited data in the model table A cannot pass the null value check, and the to-be-audited data cannot pass the null value check, namely, the null value check result corresponding to any model table in all the model tables of the to-be-audited data is greater than or equal to the second threshold value, and the to-be-audited data cannot pass the null value check.
On the basis of the foregoing embodiments, further, the performing, according to a third checking rule, the associated checking on the data to be audited includes:
counting error rates of the same index items of different model tables of the data to be audited; wherein the model table is preset.
Specifically, the data to be audited may be stored in a preset model table, and for different model tables in which the same index item is stored, the server may count error rates of the same index item in the different model tables of the data to be audited, and use the error rate of the same index item in the different model tables as a correlation check result of the same index item. It will be appreciated that each model table may include a plurality of different index entries. And performing correlation check on the to-be-checked data to verify the consistency of the service data.
For example, the preset model table includes a legal loan lending information table and a legal loan contract standing book table, and the legal loan lending information table and the legal loan contract standing book table include the same index items: the loan contract number. The server carries out correlation check on the loan contract number in the legal person loan borrowing data information table and the loan contract number in the legal person loan contract standing book table, and counts the loan contract number which appears in the legal person loan borrowing data information table and the amount of the loan contract number which does not appear in the legal person loan contract standing book table to be G1The number of the loan contract numbers appearing in the corporate loan contract standing book table is counted asG, the error rate G of the loan agreement number of the legal loan borrowing information table and the legal loan agreement standing account table is G1And G, namely the correlation checking result corresponding to the loan contract number of the legal loan borrowing data information table and the legal loan contract standing book table is G. If the correlation check result g corresponding to the loan borrowing information table of the legal person and the loan contract number of the platform account table of the legal person loan contract is smaller than the third threshold value, the data to be checked corresponding to the loan contract number of the loan borrowing information table of the legal person and the loan contract number of the platform account table of the legal person loan contract passes the correlation check; and if the correlation check result g corresponding to the loan borrowing information table of the legal person and the loan contract number of the platform account table of the legal person loan contract is greater than or equal to the third threshold value, the pending check data corresponding to the loan borrowing information table of the legal person and the loan contract number of the platform account table of the legal person loan contract cannot pass through the correlation check, namely the pending check data cannot pass through the correlation check, namely the correlation check result corresponding to any one same index item in the same index items of different model tables of the pending data is greater than or equal to the third threshold value, and the pending data cannot pass through the correlation check.
For example, the preset model table includes a legal loan lending information table and a legal loan extension table, and the legal loan lending information table and the legal loan extension table include the same index items: the server carries out correlation check on the loan contract number and the debt number in the legal person loan lending data information table and the loan contract number and the debt number in the legal person loan extension table, and counts the loan contract number and the debt number which simultaneously appear in the legal person loan lending data information table and the amount of the loan contract number and the debt number which do not simultaneously appear in the legal person loan extension table to be P1And counting the number of the loan contract numbers and the debt number appearing in the legal loan extension table as P, wherein the error rate P of the loan contract numbers and the debt numbers of the legal loan data information table and the legal loan extension table is equal to P1and/P, namely the corresponding correlation checking result of the loan contract number and the debt number of the legal loan data information table and the legal loan extension table is P.
The model sheet may further include an asset liability statement, profit statement, code coding statement, teller statement, institution site statement, financial product transaction statement, financial product registration statement, financial product asset comparison statement, financial product asset element registration statement, bond transaction statement, bond information statement, third party deposit and transfer transaction statement, third party deposit and transfer account information statement, asset transfer relationship statement, credit asset transfer statement, loan approval and sale information statement, loan contract and security contract relationship statement, credit card history statement, personal loan data information statement, credit certificate statement, bank acceptance statement, legal loan extension statement, and the like.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and comparing the data to be audited with the corresponding indexes of the set report.
Specifically, the server compares the data to be audited with a corresponding index of a set report, so as to obtain an error rate of the corresponding index, and the error rate of the corresponding index is used as an index value check result of the corresponding index, where the corresponding index is, for example, a loan balance. If the error rate of the corresponding index is smaller than the fourth threshold value, the index value checking result of the corresponding index meets the requirement. The set report is set according to actual needs, for example, an off-site supervision report (1104 supervision report) is not limited in the embodiments of the present invention. The fourth threshold is set according to actual needs, for example, to be one ten thousandth, and the embodiment of the present invention is not limited.
For example, the set report is an off-site supervision report, and the data to be audited is data of banking industry, and relates to a legal loan borrowing data information table, a personal loan borrowing data information table, an asset liability table and a profit table. The pending counting data comprises the loan balance of the legal loan borrowing information table, the loan balance in the offsite supervision report is taken as a corresponding index, the loan balance corresponding to the loan balance of the legal loan borrowing information table in the offsite supervision report is extracted, the loan balance in the legal loan borrowing information table and the loan balance in the offsite supervision report are checked according to three modes of balance summary, five-level classification summary and industry classification summary, the error of the balance loan under each mode is calculated, and if the error of the loan balance under each mode is smaller than the fourth threshold value, the checking result of the loan balance of the legal loan borrowing information table is checked through an index value. If the error of the loan balance in one mode is larger than or equal to the fourth threshold value, the result of checking the index value of the loan balance of the legal loan data information table cannot pass the index value checking. Wherein, the five-level classification comprises five types of normal classification, concern classification, secondary classification, suspicious classification and loss classification, which are preset; the industry classification can be classified according to a first-class industry, the first-class industry is preset, and the embodiment of the invention is not limited.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and checking the detail account and the branch account in the data to be audited.
Specifically, the server checks the detail account and the account in the data to be audited, namely, the difference between the end-of-term balance and the initial-of-term balance of the account is compared with the transaction amount of the current detail account, namely, the debit and difference amount, and the error rate of the detail account and the account is calculated. And taking the error rates of the detailed account and the branch account as index value checking results corresponding to the detailed account and the branch account, wherein the error rates of the detailed account and the branch account are smaller than the fourth threshold value, and the index value checking results corresponding to the detailed account and the branch account meet requirements. The error rate of the detailed account and the branch account is | the difference between the end-of-term balance and the initial balance of the branch account-the transaction amount of the current-term detailed account is borrowed and deducted by the difference amount/the difference between the end-of-term balance and the initial balance of the branch account. The difference between the final balance and the initial balance of the account is the balance of the account in the current period and the balance of the account in the current period. When the account transaction amount borrowing offset amount is the sum of the account transaction amount multiplied by omega, when the borrowing direction of the account transaction amount is 'borrowing', omega is 1, and when the borrowing direction of the account transaction amount is 'lending', omega is-1.
It can be understood that since the audit data is accessed in full at the end of a month, the balance of the account in the current period has a condition of spanning the month, so that a checking error exists. Therefore, after the execution time of checking the detail account and the branch account in the data to be audited is waited for the transaction detail data of the next month No. 1 to arrive, the account balance in the current period is removed from the transaction amount generated before the corresponding time point of unloading, and the transaction amount can be checked to pass. 5 lists relating to the legal deposit category, the personal deposit category and the accounting information category: the difference between the end of deposit statement balance and the beginning balance in the regular deposit statement account table of the legal person is checked with the transaction amount of the current statement account by the difference between the end of deposit statement balance and the beginning balance, the difference between the end of deposit statement balance and the beginning balance in the personal regular deposit statement account table is checked with the transaction amount of the current statement account by the difference between the end of deposit statement balance and the beginning balance, the difference between the end of deposit statement balance and the beginning balance in the personal regular deposit statement account table is checked with the transaction amount of the current statement account, and the difference between the end of deposit statement balance and the beginning balance in the internal statement record table is checked with the transaction amount of the current statement account.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and carrying out balance summary statistics comparison on the account balance in the data to be audited and the corresponding subject balance.
Specifically, the server performs balance summarizing, counting and comparing on the account balance in the data to be audited and the corresponding subject balance, that is, performs balance summarizing, counting and comparing on the account balance in the data to be audited and the corresponding subject balance in an upstream system according to a first-level subject number corresponding to a service range, so as to obtain a comparison error, the comparison error is used as an index value checking result of the account balance and the corresponding subject balance, and if the comparison error is smaller than the fourth threshold, the account balance in the data to be audited passes through the index value checking.
For example, for the pending data stored in the legal deposit statement table: and checking the deposit list balance and the corresponding source system subject according to the primary subject balance to obtain a first checking difference, wherein the first error is the first checking difference/the corresponding source system subject balance. For the pending data stored in the legal deposit account table: and checking the account balance with the corresponding source system subject according to the primary subject balance to obtain a second checking difference, wherein the second error is the second checking difference/the corresponding source system subject balance. For the first audit data stored in the individual's periodic deposit statement table: and checking the deposit list balance with the corresponding source system subject according to the primary subject balance to obtain a third checking difference, wherein the third error is the third checking difference/the corresponding source system subject balance. For the pending data stored in the individual demand deposit account table: and checking the account balance with the corresponding source system subject according to the primary subject balance to obtain a fourth checking difference, wherein the fourth error is the fourth checking difference/the corresponding source system subject balance. For the pending data stored in the internal account table: and the debit balance and the credit balance are checked with the corresponding source system subject according to the primary subject balance to obtain a fifth checking difference, and the fifth error is the fifth checking difference/the corresponding source system subject balance.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and checking the amount of the appointed index item of the data to be audited.
Specifically, for the to-be-audited data which cannot be checked for the itemized account and the branch account, and the to-be-audited data which cannot be compared by balance summary statistics between the account balance and the corresponding subject balance, the server checks the amount of money of the specified index item in the to-be-audited data to obtain the amount total check error of the specified index item, that is, the amount total value of the specified index item in the preset model table is compared with the amount total value of the specified index item of the upstream system, and the to-be-audited data is stored in the preset model table. The checking error of the amount of the specified index item can be used as an index value checking result of the amount of the specified index item of the data to be audited, and if the checking error of the amount of the specified index item is smaller than the fourth threshold value, the amount of the specified index item passes the index value checking. The specified index item is set according to actual needs, and the embodiment of the invention is not limited.
For example, the data to be audited is checked by the appointed index amount, the sum of the transaction amounts of the two model tables of the enterprise online bank transfer detail table and the personal online bank transfer detail table is compared with the sum of the transaction amounts of the upstream system, and the sum of the transaction amounts of the two model tables of the enterprise online bank transfer detail table and the personal online bank transfer detail table is Q1The sum of the transaction amounts of the upstream system is Q2And then, the index value checking result Q of the transaction amount of the two model tables of the enterprise online bank transfer list and the personal online bank transfer list is equal to (Q)1-Q2)/Q1. The transaction sum value provided by the upstream system can provide a corresponding value to the server through the upstream system check statistical table interface. Wherein, the upstream system checks the statistical table and includes: rule ID, component number, component abbreviation, component name, middle layer table abbreviation, record number, mechanism number, check field name, check field value, execution frequency, data time point and other index items.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and checking a preset field of the model table of the data to be audited.
Specifically, the data to be audited may be stored in a preset model table, the server may check whether data corresponding to a preset field of the model table is set data, and if the data corresponding to the preset field is the set data, the data corresponding to the preset field of the model table is checked by an index value. The model table is preset, the preset field is set according to actual needs, and the embodiment of the invention is not limited.
For example, the preset field is a report mechanism number, the data corresponding to the report mechanism number is a total bank mechanism number of each bank, the server checks whether the data corresponding to the report structure number is the total bank mechanism number of the bank submitting the data to be audited, if so, the data corresponding to the report structure number meets the requirement, and the index value is checked.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and checking the data type of the data to be audited.
Specifically, the data to be audited may be divided into different data types, and in the process of obtaining the data to be audited from the upstream source table, the data to be audited is converted into a corresponding data type according to a preset data type conversion rule. In order to ensure the accuracy of the data type of the data to be audited, the server may verify the data type of the data to be audited, that is, compare the data type of the data to be audited with the data type specified by the preset data type conversion rule, and if the data type of the data to be audited is the same as the data type specified by the preset data type conversion rule, the data type of the data to be audited is accurate and is checked through the index value. The data type conversion rule is set according to actual needs, and the embodiment of the invention is not limited.
For example, the data types of the amount class data, the value class data and the percentage class data of the data to be audited are all defined as the number type, and the rest data types are defined as the character type. The data to be audited can be stored in a preset model table, the data type corresponding to the field name of the data to be audited is obtained by inquiring in the data type conversion rule according to the field name of the data to be audited, and if the data type obtained by inquiring is the same as the data type of the data to be audited, the data type of the data to be audited is correct.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and checking the date type data format length of the data to be audited.
Specifically, the server checks the date data format length of the data to be audited, that is, the date data format length of the data to be audited is compared with a first preset length, if the date data format length is equal to the first preset length, the date data format length of the data to be audited meets the requirement, and the date data format of the data to be audited passes through index value checking. The first preset length is set according to an actual situation, and the embodiment of the invention is not limited.
For example, if the format of the date class data is YYYYMMDD, YYYY represents year, MM represents month, and DD represents day, the first preset length is 8-bit characters.
On the basis of the foregoing embodiments, further, the performing, according to a fourth checking rule, index value checking on the data to be audited includes:
and checking the time type data format length of the data to be audited.
Specifically, the server checks the time-class data format length of the data to be audited, that is, the time-class data format length of the data to be audited is compared with a second preset length, if the time-class data format length is equal to the second preset length, the time-class data format length of the data to be audited meets the requirement, and the time-class data format of the data to be audited passes the index value check.
For example, if the format of the time class data is HHTTSS, HH represents time, TT represents minutes, and SS represents seconds, then the second preset length is 6-bit characters.
Fig. 2 is a schematic structural diagram of a data checking apparatus according to an embodiment of the present invention, and as shown in fig. 2, the data checking apparatus according to the embodiment of the present invention includes an obtaining unit 201, a checking unit 202, and a determining unit 203, where:
the obtaining unit 201 is configured to obtain data to be audited; the checking unit 202 is configured to perform record number checking on the data to be audited according to a first checking rule, perform null value checking on the data to be audited according to a second checking rule, perform association checking on the data to be audited according to a third checking rule, and perform index value checking on the data to be audited according to a fourth checking rule; the judging unit 203 is configured to determine that the data to be audited is qualified after judging that the data to be audited passes through record number checking, null value checking, association checking, and index value checking.
Specifically, the obtaining unit 201 may obtain data to be audited from a database, where the data to be audited may be data submitted by each bank for auditing. The data to be audited can be stored in a preset model table, and the model table is set according to actual needs.
After the data to be audited is obtained, the checking unit 202 performs record number checking on the data to be audited according to a first checking rule to obtain a record number checking result; performing null value check on the data to be audited according to a second check rule to obtain a null value check result; performing correlation check on the data to be audited according to a third check rule to obtain a correlation check result; and performing index value checking on the to-be-checked data according to a fourth checking rule to obtain an index value checking result.
After obtaining the record number checking result, the determining unit 203 may count the error rate of the record number checking result, and if the error rate of the record number checking result is smaller than a first threshold, the record number checking result meets the requirement, and the data to be audited passes the record number checking. After obtaining the null value check result, the determining unit 203 may count an error rate of the null value check result, and if the error rate of the null value check result is smaller than a second threshold, the recorded number check result meets a requirement, and the data to be audited passes the null value check. After obtaining the correlation check result, the determining unit 203 may count an error rate of the correlation check result, and if the error rate of the correlation check result is less than a third threshold, the correlation check result meets a requirement, and the data to be audited passes through the correlation check. After the index value check result is obtained, the determining unit 203 may determine whether the index value check result meets a requirement, and if the index value check result meets the requirement, the data to be audited passes through index check. After the judging unit 203 judges that the data to be audited passes through record number checking, null value checking, association checking and index value checking, it is determined that the data to be audited is qualified, that is, the data quality of the data to be audited meets the requirement of auditing. The first threshold, the second threshold, and the third threshold are set according to actual needs, for example, all are set to one in ten thousand, and the embodiment of the present invention is not limited.
The data checking device provided by the embodiment of the invention can acquire the data to be audited, then record number checking is carried out on the data to be audited according to the first checking rule, null value checking is carried out on the data to be audited according to the second checking rule, correlation checking is carried out on the data to be audited according to the third checking rule, index value checking is carried out on the data to be audited according to the fourth checking rule, and after the data to be audited is judged to pass through the record number checking, the null value checking, the correlation checking and the index value checking, the data to be audited is determined to be qualified, the data to be audited can be checked comprehensively, and the accuracy of checking the data to be audited is improved.
On the basis of the foregoing embodiments, further, the checking unit 202 is specifically configured to:
comparing the time point record number of the first time with the time point record number of the second time of the upstream source table corresponding to the to-be-examined data; the first time is the time when the upstream source table corresponding to the data to be audited is transmitted from an upstream system, and the second time is the time when the upstream source table corresponding to the data to be audited is received.
Specifically, the upstream source table corresponding to the data to be audited is the upstream source table of the data source to be audited. The upstream source table corresponding to the data to be audited is transmitted by an upstream system and can be received by a financial auditing data analysis platform, the time point record number of each upstream source table is counted when the upstream source table corresponding to the data to be audited is transmitted, and the time point record number of each upstream source table is counted when the upstream source table corresponding to the data to be audited is received. In order to prevent the upstream source table corresponding to the pending data from being missing during the transmission process, the checking unit 202 may compare the time point record number of the first time and the time point record number of the second time of the upstream source table corresponding to the pending data, and obtain a record number checking result. The first time is the time when the upstream source table corresponding to the data to be audited is transmitted from an upstream system, and the second time is the time when the upstream source table corresponding to the data to be audited is received. The upstream source table refers to a data table provided by an upstream system for a financial audit data analysis platform. The upstream system refers to a system for providing data for a financial audit data analysis platform, such as a deposit system, a loan system and the like of a bank. The time point record number refers to the number of all records in the data table at the time point of providing data. The data table may be an upstream source table.
On the basis of the foregoing embodiments, further, the checking unit 202 is specifically configured to:
counting the null value rate of preset index items in the model table of the data to be audited; wherein the model table is preset.
Specifically, the data to be audited may be stored in a preset model table, and the checking unit 202 may count a null value rate of a preset index item of each model table of the model table in which the data to be audited is stored, and use the null value rate of the preset index item of each model table as a null value checking result corresponding to each model table. And the preset index item is an index item which is not allowed to be a null value in each model table. And the model table of the data to be audited is the model table storing the data to be audited. And the purpose of checking the null value of the to-be-audited data is to ensure the integrity of the to-be-audited data. Index items in the model table are set according to actual needs, and the embodiment of the invention is not limited.
On the basis of the foregoing embodiments, further, the checking unit 202 is specifically configured to:
counting error rates of the same index items of different model tables of the data to be audited; wherein the model table is preset.
Specifically, the data to be audited may be stored in a preset model table, and for different model tables in which the same index item is stored, the checking unit 202 may count error rates of the same index item in the different model tables of the data to be audited, and use the error rate of the same index item in the different model tables as a related checking result of the same index item. It will be appreciated that each model table may include a plurality of different index entries. And performing correlation check on the to-be-checked data to verify the consistency of the service data.
On the basis of the foregoing embodiments, further, the checking unit 202 is specifically configured to:
comparing the to-be-audited data with corresponding indexes in the off-site supervision report, checking a detailed account and an individual account in the to-be-audited data, performing balance summary statistics comparison on an account balance in the to-be-audited data and a corresponding subject balance, checking the to-be-audited data by using a specified index amount, checking a preset field of a model table of the to-be-audited data, and checking the data type, date data format length and time data format length of the to-be-audited data; wherein the model table is preset.
Specifically, the checking unit 202 compares the data to be audited with the corresponding index of the set report, so as to obtain the error rate of the corresponding index, and uses the error rate of the corresponding index as the checking result of the index value of the corresponding index, where the corresponding index is, for example, a loan balance. If the error rate of the corresponding index is smaller than the fourth threshold value, the index value checking result of the corresponding index meets the requirement. The set report is set according to actual needs, for example, an off-site supervision report (1104 supervision report) is not limited in the embodiments of the present invention. The fourth threshold is set according to actual needs, for example, to be one ten thousandth, and the embodiment of the present invention is not limited.
The checking unit 202 checks the detail account and the branch account in the data to be audited, namely, the difference between the end-of-term balance and the beginning-of-term balance of the branch account is compared with the transaction amount of the current detail account, which is borrowed and deducted from the difference amount, and the error rate of the detail account and the branch account is calculated. And taking the error rates of the detailed account and the branch account as index value checking results corresponding to the detailed account and the branch account, wherein the error rates of the detailed account and the branch account are smaller than the fourth threshold value, and the index value checking results corresponding to the detailed account and the branch account meet requirements. The error rate of the detailed account and the branch account is | the difference between the end-of-term balance and the initial balance of the branch account-the transaction amount of the current-term detailed account is borrowed and deducted by the difference amount/the difference between the end-of-term balance and the initial balance of the branch account. The difference between the final balance and the initial balance of the account is the balance of the account in the current period and the balance of the account in the current period. When the account transaction amount borrowing offset amount is the sum of the account transaction amount multiplied by omega, when the borrowing direction of the account transaction amount is 'borrowing', omega is 1, and when the borrowing direction of the account transaction amount is 'lending', omega is-1.
The checking unit 202 performs balance summarizing, counting and comparing on the account balance in the data to be audited and the corresponding subject balance, that is, performs balance summarizing, counting and comparing on the account balance in the data to be audited and the corresponding subject balance in an upstream system according to a first-level subject number corresponding to a service range, so as to obtain a comparison error, and the comparison error is used as an index value checking result of the account balance and the corresponding subject balance, and if the comparison error is smaller than the fourth threshold, the account balance in the data to be audited passes through index value checking.
Specifically, for the to-be-audited data in which the itemized account and the branch account cannot be checked and the to-be-audited data in which the account balance and the corresponding subject balance cannot be subjected to balance summary statistical comparison, the checking unit 202 checks the amount of money of the specified index item in the to-be-audited data to obtain a total checking error of the amount of money of the specified index item, that is, the total value of the amount of money of the specified index item in the preset model table is compared with the total value of the amount of money of the specified index item of the upstream system, and the to-be-audited data is stored in the preset model table. The checking error of the amount of the specified index item can be used as an index value checking result of the amount of the specified index item of the data to be audited, and if the checking error of the amount of the specified index item is smaller than the fourth threshold value, the amount of the specified index item passes the index value checking. The specified index item is set according to actual needs, and the embodiment of the invention is not limited.
The data to be audited may be stored in a preset model table, and the checking unit 202 may check whether data corresponding to a preset field of the model table is set data, and if the data corresponding to the preset field is the set data, the data corresponding to the preset field of the model table passes through index value checking. The model table is preset, the preset field is set according to actual needs, and the embodiment of the invention is not limited.
Specifically, the data to be audited may be divided into different data types, and in the process of obtaining the data to be audited from the upstream source table, the data to be audited is converted into a corresponding data type according to a preset data type conversion rule. In order to ensure the accuracy of the data type of the data to be audited, the checking unit 202 may check the data type of the data to be audited, that is, compare the data type of the data to be audited with the data type specified by the preset data type conversion rule, and if the data type of the data to be audited is the same as the data type specified by the preset data type conversion rule, the data type of the data to be audited is accurate, and the data type is checked through the index value. The data type conversion rule is set according to actual needs, and the embodiment of the invention is not limited.
The checking unit 202 checks the date data format length of the data to be audited, that is, the date data format length of the data to be audited is compared with a first preset length, if the date data format length is equal to the first preset length, the date data format length of the data to be audited meets the requirement, and the date data format of the data to be audited passes through index value checking. The first preset length is set according to an actual situation, and the embodiment of the invention is not limited.
The checking unit 202 checks the time-class data format length of the data to be audited, that is, the time-class data format length of the data to be audited is compared with a second preset length, if the time-class data format length is equal to the second preset length, the time-class data format length of the data to be audited meets the requirement, and the time-class data format of the data to be audited passes through index value checking.
The embodiment of the apparatus provided in the embodiment of the present invention may be specifically configured to execute the processing flows of the above method embodiments, and the functions of the apparatus are not described herein again, and refer to the detailed description of the above method embodiments.
Fig. 3 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 3, the electronic device may include: a processor (processor)301, a communication Interface (communication Interface)302, a memory (memory)303 and a communication bus 304, wherein the processor 301, the communication Interface 302 and the memory 303 complete communication with each other through the communication bus 304. Processor 301 may call logic instructions in memory 303 to perform the following method: acquiring data to be audited; performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule; and if the data to be audited passes record number checking, null value checking, correlation checking and index value checking, determining that the data to be audited is qualified.
In addition, the logic instructions in the memory 303 may be implemented in the form of software functional units and stored in a computer readable storage medium when the logic instructions are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The present embodiment discloses a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the method provided by the above-mentioned method embodiments, for example, comprising: acquiring data to be audited; performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule; and if the data to be audited passes record number checking, null value checking, correlation checking and index value checking, determining that the data to be audited is qualified.
The present embodiment provides a computer-readable storage medium, which stores a computer program, where the computer program causes the computer to execute the method provided by the above method embodiments, for example, the method includes: acquiring data to be audited; performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule; and if the data to be audited passes record number checking, null value checking, correlation checking and index value checking, determining that the data to be audited is qualified.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In the description herein, reference to the description of the terms "one embodiment," "a particular embodiment," "some embodiments," "for example," "an example," "a particular example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (12)
1. A method for data detection, comprising:
acquiring data to be audited;
performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule;
and if the data to be audited passes record number checking, null value checking, correlation checking and index value checking, determining that the data to be audited is qualified.
2. The method of claim 1, wherein the performing record number checking on the data to be audited according to a first checking rule comprises:
comparing the time point record number of the first time with the time point record number of the second time of the upstream source table corresponding to the to-be-examined data; the first time is the time when the upstream source table corresponding to the data to be audited is transmitted from an upstream system, and the second time is the time when the upstream source table corresponding to the data to be audited is received.
3. The method of claim 1, wherein the performing null value checking on the data to be audited according to a second checking rule comprises:
counting the null value rate of preset index items in the model table of the data to be audited; wherein the model table is preset.
4. The method of claim 1, wherein the performing associated checking on the data to be audited according to a third checking rule comprises:
counting error rates of the same index items of different model tables of the data to be audited; wherein the model table is preset.
5. The method of claim 1, wherein the performing index value checking on the data to be audited according to a fourth checking rule comprises:
comparing the to-be-audited data with corresponding indexes in the off-site supervision report, checking a detailed account and an individual account in the to-be-audited data, performing balance summary statistics comparison on an account balance in the to-be-audited data and a corresponding subject balance, checking the to-be-audited data by using a specified index amount, checking a preset field of a model table of the to-be-audited data, and checking the data type, date data format length and time data format length of the to-be-audited data; wherein the model table is preset.
6. A data checking apparatus, comprising:
the acquiring unit is used for acquiring data to be audited;
the checking unit is used for performing record number checking on the data to be audited according to a first checking rule, performing null value checking on the data to be audited according to a second checking rule, performing association checking on the data to be audited according to a third checking rule, and performing index value checking on the data to be audited according to a fourth checking rule;
and the judging unit is used for determining that the to-be-audited data is qualified after judging and knowing that the to-be-audited data passes through record number checking, null value checking, association checking and index value checking.
7. The apparatus according to claim 6, wherein the examination unit is specifically configured to:
comparing the time point record number of the first time with the time point record number of the second time of the upstream source table corresponding to the to-be-examined data; the first time is the time when the upstream source table corresponding to the data to be audited is transmitted from an upstream system, and the second time is the time when the upstream source table corresponding to the data to be audited is received.
8. The apparatus according to claim 6, wherein the examination unit is specifically configured to:
counting the null value rate of preset index items in the model table of the data to be audited; wherein the model table is preset.
9. The apparatus according to claim 6, wherein the examination unit is specifically configured to:
counting error rates of the same index items of different model tables of the data to be audited; wherein the model table is preset.
10. The apparatus according to claim 6, wherein the examination unit is specifically configured to:
comparing the to-be-audited data with corresponding indexes in the off-site supervision report, checking a detailed account and an individual account in the to-be-audited data, performing balance summary statistics comparison on an account balance in the to-be-audited data and a corresponding subject balance, checking the to-be-audited data by using a specified index amount, checking a preset field of a model table of the to-be-audited data, and checking the data type, date data format length and time data format length of the to-be-audited data; wherein the model table is preset.
11. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method according to any of claims 1 to 5 are implemented when the computer program is executed by the processor.
12. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911314854.6A CN111061718A (en) | 2019-12-19 | 2019-12-19 | Data checking method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911314854.6A CN111061718A (en) | 2019-12-19 | 2019-12-19 | Data checking method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111061718A true CN111061718A (en) | 2020-04-24 |
Family
ID=70301196
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911314854.6A Pending CN111061718A (en) | 2019-12-19 | 2019-12-19 | Data checking method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111061718A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111709651A (en) * | 2020-06-18 | 2020-09-25 | 江西财经职业学院 | Digital auditing method and device for converting construction project into fixed asset |
| CN112199359A (en) * | 2020-09-18 | 2021-01-08 | 中国建设银行股份有限公司 | Data checking method and device, electronic equipment and storage medium |
| CN112597165A (en) * | 2020-12-28 | 2021-04-02 | 中国建设银行股份有限公司 | Supervision data quality verification method and device, electronic equipment and storage medium |
| CN113268553A (en) * | 2021-07-21 | 2021-08-17 | 国网汇通金财（北京）信息科技有限公司 | Data auditing method, system, electronic equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107426156A (en) * | 2017-04-18 | 2017-12-01 | 腾讯科技（深圳）有限公司 | The method and relevant device of a kind of data check |
| CN107657544A (en) * | 2017-09-14 | 2018-02-02 | 国网辽宁省电力有限公司 | A kind of automatic paying method of the improved electricity charge and system |
| CN108023874A (en) * | 2017-11-15 | 2018-05-11 | 平安科技（深圳）有限公司 | Calibration equipment, method and the computer-readable recording medium of single-sign-on |
| CN108920256A (en) * | 2018-06-22 | 2018-11-30 | 新华三大数据技术有限公司 | Check task executing method and device |
| CN109241068A (en) * | 2018-08-22 | 2019-01-18 | 中国平安人寿保险股份有限公司 | The method, apparatus and terminal device that foreground and background data compares |
| CN109714221A (en) * | 2017-10-25 | 2019-05-03 | 阿里巴巴集团控股有限公司 | The determination method, apparatus and system of network packet |
-
2019
- 2019-12-19 CN CN201911314854.6A patent/CN111061718A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107426156A (en) * | 2017-04-18 | 2017-12-01 | 腾讯科技（深圳）有限公司 | The method and relevant device of a kind of data check |
| CN107657544A (en) * | 2017-09-14 | 2018-02-02 | 国网辽宁省电力有限公司 | A kind of automatic paying method of the improved electricity charge and system |
| CN109714221A (en) * | 2017-10-25 | 2019-05-03 | 阿里巴巴集团控股有限公司 | The determination method, apparatus and system of network packet |
| CN108023874A (en) * | 2017-11-15 | 2018-05-11 | 平安科技（深圳）有限公司 | Calibration equipment, method and the computer-readable recording medium of single-sign-on |
| CN108920256A (en) * | 2018-06-22 | 2018-11-30 | 新华三大数据技术有限公司 | Check task executing method and device |
| CN109241068A (en) * | 2018-08-22 | 2019-01-18 | 中国平安人寿保险股份有限公司 | The method, apparatus and terminal device that foreground and background data compares |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111709651A (en) * | 2020-06-18 | 2020-09-25 | 江西财经职业学院 | Digital auditing method and device for converting construction project into fixed asset |
| CN112199359A (en) * | 2020-09-18 | 2021-01-08 | 中国建设银行股份有限公司 | Data checking method and device, electronic equipment and storage medium |
| CN112597165A (en) * | 2020-12-28 | 2021-04-02 | 中国建设银行股份有限公司 | Supervision data quality verification method and device, electronic equipment and storage medium |
| CN113268553A (en) * | 2021-07-21 | 2021-08-17 | 国网汇通金财（北京）信息科技有限公司 | Data auditing method, system, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110263024B (en) | Data processing method, terminal device and computer storage medium | |
| CN111061718A (en) | Data checking method and device | |
| CN111738844A (en) | Resource allocation system, method and device based on block chain | |
| CN112785292B (en) | Prepaid card management method and system based on blockchain, equipment and storage medium | |
| CN110852730B (en) | Transaction processing method and device based on digital currency and electronic equipment | |
| WO2013059134A1 (en) | System and methods for predictive modeling in making structured reference credit decisions | |
| CN110796539A (en) | Credit investigation evaluation method and device | |
| CN111598679A (en) | Multi-legal-person joint loan method, system and medium based on block chain | |
| CN116450951A (en) | Service recommendation method and device, storage medium and electronic equipment | |
| CN114862110A (en) | Method and device for building middle platform of commercial banking business, electronic equipment and storage medium | |
| CN114626936A (en) | Credit business data processing method and device, computer equipment and storage medium | |
| US8682684B2 (en) | Method, apparatus and computer program product for monitoring compliance in reporting unclaimed property | |
| CN113034275B (en) | Management system and method based on block chain network and terminal equipment | |
| Önkan et al. | The Impact of Blockchain Technology on Tax and Accounting Practices | |
| CN113487415B (en) | Credit evaluation and credit granting application system and method based on information data | |
| CN109325102B (en) | Method and device for identifying illegal document | |
| CN113379465A (en) | Block chain-based site selection method, device, equipment and storage medium | |
| CN113409129A (en) | Financing admission risk assessment method, device and computer storage medium | |
| CN113469801A (en) | Method and device for determining audit result | |
| CN112085461A (en) | Cross-sale-oriented commission settlement method, device and storage medium | |
| CN111079992A (en) | Data processing method, device and storage medium | |
| CN111932368B (en) | Credit card issuing system and construction method and device thereof | |
| CN113538157B (en) | Annuity cost management method and annuity cost management device | |
| CN114240610B (en) | Automatic fund collection method, device, computer equipment and storage medium | |
| CN115495453A (en) | Method and device for generating message, computing 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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220913 Address after: 25 Financial Street, Xicheng District, Beijing 100033 Applicant after: CHINA CONSTRUCTION BANK Corp. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |