CN114490692A - Data checking method, device, equipment and storage medium - Google Patents

Data checking method, device, equipment and storage medium Download PDF

Info

Publication number
CN114490692A
CN114490692A CN202210138076.5A CN202210138076A CN114490692A CN 114490692 A CN114490692 A CN 114490692A CN 202210138076 A CN202210138076 A CN 202210138076A CN 114490692 A CN114490692 A CN 114490692A
Authority
CN
China
Prior art keywords
checked
preset
data
acquiring
field
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
Application number
CN202210138076.5A
Other languages
Chinese (zh)
Inventor
李萍
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Life Insurance Company of China Ltd
Original Assignee
Ping An Life Insurance Company of China Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Life Insurance Company of China Ltd filed Critical Ping An Life Insurance Company of China Ltd
Priority to CN202210138076.5A priority Critical patent/CN114490692A/en
Publication of CN114490692A publication Critical patent/CN114490692A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2365Ensuring data consistency and integrity
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2358Change logging, detection, and notification
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries

Abstract

The invention relates to the technical field of data processing, and provides a data checking method, a device, equipment and a storage medium. The method can acquire the form to be checked and the generation time of the form to be checked according to the data checking request when the data checking request is received; classifying the forms to be checked to obtain the form types of the forms to be checked; acquiring a reference form from a preset library based on the generation time and the form type; selecting check fields corresponding to the form types; comparing the form to be checked with the reference form based on the check field; and if the form to be checked is inconsistent with the reference form, detecting the form to be checked based on a preset change table to obtain a detection result, so that the data checking efficiency can be improved. In addition, the invention also relates to a block chain technology, and the detection result can be stored in the block chain.

Description

Data checking method, device, equipment and storage medium
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data checking method, apparatus, device, and storage medium.
Background
To ensure data consistency, data is usually checked. In the existing data checking scheme, the data to be checked is usually checked and matched with a large amount of data in a database, and the data checking efficiency is low and the development of work tasks is not facilitated due to the fact that the data cannot be checked in a targeted manner.
Disclosure of Invention
In view of the above, it is desirable to provide a data collation method, apparatus, device and storage medium, which can improve data collation efficiency.
In one aspect, the present invention provides a data checking method, where the data checking method includes:
when a data checking request is received, acquiring a form to be checked and the generation time of the form to be checked according to the data checking request;
classifying the forms to be checked to obtain the form types of the forms to be checked;
acquiring a reference form from a preset library based on the generation time and the form type;
selecting check fields corresponding to the form types;
comparing the form to be checked with the reference form based on the check field;
and if the form to be checked is inconsistent with the reference form, detecting the form to be checked based on a preset change table to obtain a detection result.
According to a preferred embodiment of the present invention, the acquiring the to-be-checked form according to the data checking request and the generating time of the to-be-checked form include:
analyzing the message of the data checking request to obtain the data information carried by the message;
extracting form identification and path address from the data information;
acquiring a form corresponding to the form identification from the path address as the form to be checked, and acquiring a creating user of the form to be checked from the path address;
acquiring a form generation log from the binding terminal of the creating user based on the form identification and a preset event;
and extracting the generation time from the form generation log.
According to a preferred embodiment of the present invention, the detecting the to-be-checked form based on the preset change table, and obtaining a detection result includes:
traversing the preset change table based on the form identification to obtain a traversal result;
if the traversal result indicates that the preset change table contains the form identifier, obtaining a form record corresponding to the form identifier from the preset change table;
positioning a target field inconsistent with the reference form in the form to be checked;
detecting whether the target field is contained in the form record or not;
and if the form record contains the target field, comparing third information corresponding to the target field in the form to be checked with fourth information corresponding to the target field in the form record to obtain the detection result.
According to a preferred embodiment of the present invention, the classifying the form to be checked to obtain the form type of the form to be checked includes:
acquiring a type keyword of each preset type;
extracting form vocabularies in the form to be checked;
matching the form vocabulary with the type keywords, and counting the vocabulary number of the form vocabulary successfully matched with the type keywords;
and determining the preset type with the maximum vocabulary number as the form type.
According to a preferred embodiment of the present invention, the obtaining a reference form from a preset library based on the generation time and the form type includes:
calculating the sum of the generation time and a preset time period to obtain a target time period;
writing the target time interval and the form type into a preset search instruction to obtain a query statement;
running the query statement based on the preset library to obtain a form to be screened;
and acquiring the form state of the form to be screened, and determining the form to be screened with the form state as a preset state as the reference form.
According to a preferred embodiment of the present invention, the comparing the form to be checked with the reference form based on the check field includes:
detecting whether the form to be checked and the reference form contain the check field or not;
if the check field is not contained in the form to be checked and the check field is contained in the reference form, acquiring an operation formula of the check field, wherein the operation formula comprises a plurality of index fields;
if the form to be checked contains the index fields, acquiring index information corresponding to the index fields from the form to be checked, and calculating the index information based on the operation formula to obtain field information corresponding to the check fields in the form to be checked;
acquiring information corresponding to the check field from the reference form as reference information, and comparing the field information with the reference information;
and if the field information is the same as the reference information, determining that the form to be checked is consistent with the reference form.
According to a preferred embodiment of the present invention, after detecting whether the check field is included in the to-be-checked form and the reference form, the data check method further includes:
if the check field is not contained in the form to be checked and the check field is not contained in the reference form, detecting whether the form to be checked and the reference form contain the index fields or not;
if the form to be checked and the reference form both contain the index fields, comparing the index information with information corresponding to the index fields in the reference form;
and if the index information is the same as the information corresponding to the index fields in the reference form, determining that the form to be checked is consistent with the reference form.
In another aspect, the present invention further provides a data collation apparatus, including:
the acquisition unit is used for acquiring a form to be checked and the generation time of the form to be checked according to a data checking request when the data checking request is received;
the classification unit is used for classifying the forms to be checked to obtain the form types of the forms to be checked;
the obtaining unit is further configured to obtain a reference form from a preset library based on the generation time and the form type;
the selecting unit is used for selecting the check field corresponding to the form type;
the comparison unit is used for comparing the form to be checked with the reference form based on the check field;
and the detection unit is used for detecting the form to be checked based on a preset change table to obtain a detection result if the form to be checked is inconsistent with the reference form.
In another aspect, the present invention further provides an electronic device, including:
a memory storing computer readable instructions; and
a processor executing computer readable instructions stored in the memory to implement the data collation method.
In another aspect, the present invention further provides a computer-readable storage medium, in which computer-readable instructions are stored, and the computer-readable instructions are executed by a processor in an electronic device to implement the data checking method.
According to the technical scheme, the forms to be checked are classified, the types of the forms can be accurately identified, the reference forms can be accurately positioned from the preset library in combination with the types of the forms and the generation time, the reference forms are positioned, the forms to be checked do not need to be compared with all the forms in the preset library by positioning the reference forms, so that the data checking efficiency is improved, the check fields needing to be checked can be accurately positioned by the types of the forms, the forms to be checked are compared with the reference forms on the basis of the check fields, all the fields in the forms to be checked do not need to be compared with all the fields in the reference forms, so that the data checking efficiency can be further improved, and when the forms to be checked are inconsistent with the reference forms, the form to be checked is further detected based on the preset change table, so that the inconsistency between the form to be checked and the reference form caused by the condition that the state of the form to be checked is changed and the like can be avoided, and the accuracy of data checking is improved.
Drawings
FIG. 1 is a flow chart of a data checking method according to a preferred embodiment of the present invention.
FIG. 2 is a functional block diagram of a preferred embodiment of the data verification apparatus of the present invention.
FIG. 3 is a schematic structural diagram of an electronic device implementing a data checking method according to a preferred embodiment of the invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in detail with reference to the accompanying drawings and specific embodiments.
FIG. 1 is a flow chart of a data checking method according to a preferred embodiment of the present invention. The order of the steps in the flow chart may be changed and some steps may be omitted according to different needs.
The data checking method can acquire and process related data based on artificial intelligence technology. Among them, Artificial Intelligence (AI) is a theory, method, technique and application system that simulates, extends and expands human Intelligence using a digital computer or a machine controlled by a digital computer, senses the environment, acquires knowledge and uses the knowledge to obtain the best result.
The artificial intelligence infrastructure generally includes technologies such as sensors, dedicated artificial intelligence chips, cloud computing, distributed storage, big data processing technologies, operation/interaction systems, mechatronics, and the like. The artificial intelligence software technology mainly comprises a computer vision technology, a robot technology, a biological recognition technology, a voice processing technology, a natural language processing technology, machine learning/deep learning and the like.
The data checking method is applied to one or more electronic devices, which are devices capable of automatically performing numerical calculation and/or information processing according to computer readable instructions set or stored in advance, and the hardware thereof includes, but is not limited to, a microprocessor, an Application Specific Integrated Circuit (ASIC), a Programmable Gate Array (FPGA), a Digital Signal Processor (DSP), an embedded device, and the like.
The electronic device may be any electronic product capable of performing human-computer interaction with a user, for example, a Personal computer, a tablet computer, a smart phone, a Personal Digital Assistant (PDA), a game machine, an interactive Internet Protocol Television (IPTV), a smart wearable device, and the like.
The electronic device may include a network device and/or a user device. Wherein the network device includes, but is not limited to, a single network electronic device, an electronic device group consisting of a plurality of network electronic devices, or a Cloud Computing (Cloud Computing) based Cloud consisting of a large number of hosts or network electronic devices.
The network in which the electronic device is located includes, but is not limited to: the internet, a wide area Network, a metropolitan area Network, a local area Network, a Virtual Private Network (VPN), and the like.
And S10, when a data checking request is received, acquiring the form to be checked and the generation time of the form to be checked according to the data checking request.
In at least one embodiment of the invention, the data reconciliation request may be generated periodically triggered by the data system. Wherein the data system has a need to collate data.
The form to be checked refers to a form to be checked, and the number of the forms to be checked can be multiple. For example, the form to be checked may be a form recorded with claim data, and the like.
The generation time refers to the time point of generating the form to be checked.
In at least one embodiment of the present invention, the acquiring, by the electronic device according to the data check request, the to-be-checked form and the generation time of the to-be-checked form by the electronic device include:
analyzing the message of the data checking request to obtain the data information carried by the message;
extracting form identification and path address from the data information;
acquiring a form corresponding to the form identification from the path address as the form to be checked, and acquiring a creating user of the form to be checked from the path address;
acquiring a form generation log from a binding terminal of the creation user based on the form identification and a preset event;
and extracting the generation time from the form generation log.
The data information stores a mapping relation between a first label and the form identifier, a mapping relation between a second label and the path address, and the like.
The form identifier may be a single number of the form to be checked, and the path address stores a plurality of forms and a creator of each form.
The preset event may be a generation event.
The form identifier and the path address can be accurately obtained through the data information, the form to be checked and the creating user can be accurately obtained from the path address based on the form identifier, and the form generation log can be accurately obtained through the form identifier and the preset event, so that the accuracy of the generation time is improved.
S11, classifying the forms to be checked to obtain the form types of the forms to be checked.
In at least one embodiment of the present invention, the form type refers to a type corresponding to information recorded in the form to be checked, for example, the form type may include, but is not limited to: a scratch form type, a share form type, a claim form type, or a financial form type, etc.
In at least one embodiment of the present invention, the classifying, by the electronic device, the form to be checked, and obtaining the form type of the form to be checked includes:
acquiring a type keyword of each preset type;
extracting form vocabularies in the form to be checked;
matching the form vocabulary with the type keywords, and counting the vocabulary number of the form vocabulary successfully matched with the type keywords;
and determining the preset type with the maximum vocabulary number as the form type.
Wherein the preset types may include, but are not limited to: a scratch form type, a share form type, a claim form type, a financial form type, and the like. Accordingly, the type keyword refers to a keyword specific to the preset type, for example, in a claim sharing form type, the type keyword may have claim sharing money, and the like.
The form vocabulary refers to the tag information in the form to be checked, for example, the form vocabulary may include claim amortization and the like.
By matching the form vocabulary with the type keywords, the vocabulary quantity of the form vocabulary successfully matched with the type keywords can be accurately counted, and the form type of the form to be checked can be accurately determined based on the vocabulary quantity.
And S12, acquiring a reference form from a preset library based on the generation time and the form type.
In at least one embodiment of the present invention, the preset library may refer to a database in which various form information is recorded.
The reference form refers to a specific form corresponding to the form type and the generation time when the form state is in a preset state.
In at least one embodiment of the present invention, the obtaining, by the electronic device, the reference form from the preset library based on the generation time and the form type includes:
calculating the sum of the generation moment and a preset time period to obtain a target time period;
writing the target time interval and the form type into a preset search instruction to obtain a query statement;
running the query statement based on the preset library to obtain a form to be screened;
and acquiring the form state of the form to be screened, and determining the form to be screened with the form state as a preset state as the reference form.
The preset time period refers to the time spent by the form to synchronize to the preset library when the user triggers the form generation, and the preset time period may be determined to be generated after the electronic device intercepts a certain number of forms for statistics.
The preset search instruction may be an SQL statement, and the preset search instruction does not include a query object.
The preset state may be set according to actual requirements, and the preset state may include, but is not limited to: effective payment, pay, exempt payment, reduced payment, extended term, death claim, stop effect, self-cushion pay and clear, self-cushion stop effect and the like.
The target time interval is generated through the preset time interval, and then the preset library is inquired by combining the target time interval and the form type, so that the problem that a reference form corresponding to the form to be checked cannot be acquired due to the fact that a certain time is spent when the form is synchronized to the preset library can be avoided, the acquisition accuracy of the reference form is improved, the inquiry statement is directly generated through the preset search instruction, and the acquisition efficiency of the reference form is improved because the preset search instruction does not need to be reconstructed.
And S13, selecting a check field corresponding to the form type.
In at least one embodiment of the present invention, the check field refers to a specific field in the form to be checked, which needs to be checked, for example, the check field may be a risk premium, a dividend amount, a branch premium, a commission fee, a dividend fee, or the like. It will be appreciated that there is a possibility that the check fields for different form types may overlap.
In at least one embodiment of the invention, the electronic device may select a check field corresponding to the form type from a type field check table.
S14, comparing the form to be checked with the reference form based on the check field.
In at least one embodiment of the present invention, the electronic device comparing the form to be collated with the reference form based on the collation field includes:
detecting whether the form to be checked and the reference form contain the check field or not;
if the check field is not contained in the form to be checked and the check field is contained in the reference form, acquiring an operation formula of the check field, wherein the operation formula comprises a plurality of index fields;
if the form to be checked contains the index fields, acquiring index information corresponding to the index fields from the form to be checked, and calculating the index information based on the operation formula to obtain field information corresponding to the check fields in the form to be checked;
acquiring information corresponding to the check field from the reference form as reference information, and comparing the field information with the reference information;
and if the field information is the same as the reference information, determining that the form to be checked is consistent with the reference form.
Wherein the plurality of index fields refer to indexes that enable the collation field to be generated based on the operation formula. For example, the check fields are: risk quota, the operation formula is: the risk warranty is the warranty and the policy risk factor-reserve, the index fields may include the warranty, the policy risk factor, the reserve, etc.
By the embodiment, when the check field is not contained in the to-be-checked form and the check field is contained in the reference form, the field information can be accurately generated by using the operation formula, so that the comparison accuracy of the to-be-checked form and the reference form is improved.
In at least one embodiment of the present invention, after detecting whether the check field is included in the to-be-checked form and the reference form, the data check method further includes:
if the check field is not contained in the form to be checked and the check field is not contained in the reference form, detecting whether the form to be checked and the reference form contain the index fields or not;
if the form to be checked and the reference form both contain the index fields, comparing the index information with information corresponding to the index fields in the reference form;
and if the index information is the same as the information corresponding to the index fields in the reference form, determining that the form to be checked is consistent with the reference form.
By the embodiment, when the check field is not contained in the to-be-checked form and the check field is not contained in the reference form, the to-be-checked form and the reference form can be directly compared based on the plurality of index fields without calculating and generating the check field, so that the comparison efficiency is improved.
In at least one embodiment of the present invention, after detecting whether the check field is included in the to-be-checked form and the reference form, the data check method further includes:
if the check field is not contained in the form to be checked and the reference form, comparing first information corresponding to the check field in the form to be checked with second information corresponding to the check field in the reference form;
and if the first information is the same as the second information, determining that the form to be checked is consistent with the reference form.
And S15, if the form to be checked is inconsistent with the reference form, detecting the form to be checked based on a preset change table to obtain a detection result.
It should be emphasized that, in order to further ensure the privacy and security of the detection result, the detection result may also be stored in a node of a block chain.
In at least one embodiment of the present invention, the preset change table stores change information of each form, where the change information includes: specific data changes, status changes, etc.
The detection result may include: the form to be checked is inconsistent with the reference form, and the form to be checked is consistent with the reference form.
In at least one embodiment of the present invention, the detecting, by the electronic device, the to-be-checked form based on a preset change table, and obtaining a detection result includes:
traversing the preset change table based on the form identification to obtain a traversal result;
if the traversal result indicates that the preset change table contains the form identifier, obtaining a form record corresponding to the form identifier from the preset change table;
positioning a target field inconsistent with the reference form in the form to be checked;
detecting whether the target field is contained in the form record or not;
and if the form record contains the target field, comparing third information corresponding to the target field in the form to be checked with fourth information corresponding to the target field in the form record to obtain the detection result.
By the embodiment, when the form to be checked is inconsistent with the reference form, the form to be checked can be further detected based on the preset change table, and the inconsistency between the form to be checked and the reference form caused by the change of the form to be checked can be avoided, so that the accuracy of the detection result is improved.
In at least one embodiment of the present invention, after detecting whether the target field is contained in the form record, the data checking method further includes:
if the form record does not contain the target field, detecting whether the form record contains state change information of the form to be checked;
generating prompt information according to the state change information and the form identifier;
acquiring a trigger system of the data checking request;
and sending the prompt information to the trigger system.
With the above embodiment, when the form record does not include the target field, the prompt information is generated based on the state change information, so that it is possible to avoid that the corresponding reference form cannot be grasped due to a state change in the form to be checked.
According to the technical scheme, the forms to be checked are classified, the types of the forms can be accurately identified, the reference forms can be accurately positioned from the preset library in combination with the types of the forms and the generation time, the reference forms are positioned, the forms to be checked do not need to be compared with all the forms in the preset library by positioning the reference forms, so that the data checking efficiency is improved, the check fields needing to be checked can be accurately positioned by the types of the forms, the forms to be checked are compared with the reference forms on the basis of the check fields, all the fields in the forms to be checked do not need to be compared with all the fields in the reference forms, so that the data checking efficiency can be further improved, and when the forms to be checked are inconsistent with the reference forms, the form to be checked is further detected based on the preset change table, so that the inconsistency between the form to be checked and the reference form caused by the condition that the state of the form to be checked is changed and the like can be avoided, and the accuracy of data checking is improved.
FIG. 2 is a functional block diagram of a data verification apparatus according to a preferred embodiment of the present invention. The data collating device 11 includes an acquiring unit 110, a classifying unit 111, a selecting unit 112, a comparing unit 113, a detecting unit 114, a determining unit 115, a generating unit 116, and a transmitting unit 117. The module/unit referred to herein is a series of computer readable instruction segments that can be accessed by the processor 13 and perform a fixed function and that are stored in the memory 12. In the present embodiment, the functions of the modules/units will be described in detail in the following embodiments.
When receiving a data check request, the obtaining unit 110 obtains a to-be-checked form and a generation time of the to-be-checked form according to the data check request.
In at least one embodiment of the invention, the data collation request may be generated periodically as triggered by the data system. Wherein the data system has a need to collate data.
The form to be checked refers to a form to be checked, and the number of the forms to be checked can be multiple. For example, the form to be checked may be a form recorded with claim data, and the like.
The generation time refers to the time point of generating the form to be checked.
In at least one embodiment of the present invention, the obtaining unit 110, according to the data checking request, obtains the form to be checked and the generation time of the form to be checked, including:
analyzing the message of the data checking request to obtain the data information carried by the message;
extracting form identification and path address from the data information;
acquiring a form corresponding to the form identification from the path address as the form to be checked, and acquiring a creating user of the form to be checked from the path address;
acquiring a form generation log from the binding terminal of the creating user based on the form identification and a preset event;
and extracting the generation time from the form generation log.
The data information stores a mapping relation between a first label and the form identifier, a mapping relation between a second label and the path address, and the like.
The form identifier may be a single number of the form to be checked, and the path address stores a plurality of forms and a creator of each form.
The preset event may be a generation event.
The form identifier and the path address can be accurately obtained through the data information, the form to be checked and the creating user can be accurately obtained from the path address based on the form identifier, and the form generation log can be accurately obtained through the form identifier and the preset event, so that the accuracy of the generation time is improved.
The classification unit 111 classifies the form to be checked to obtain the form type of the form to be checked.
In at least one embodiment of the present invention, the form type refers to a type corresponding to information recorded in the form to be checked, for example, the form type may include, but is not limited to: a scratch form type, a share form type, a claim form type, or a financial form type, etc.
In at least one embodiment of the present invention, the classifying unit 111 classifies the form to be checked, and obtaining the form type of the form to be checked includes:
acquiring a type keyword of each preset type;
extracting form vocabularies in the form to be checked;
matching the form vocabulary with the type keywords, and counting the vocabulary number of the form vocabulary successfully matched with the type keywords;
and determining the preset type with the maximum vocabulary number as the form type.
Wherein the preset types may include, but are not limited to: a scratch form type, an underwriting form type, a claim sharing form type, a financial form type and the like. Accordingly, the type keyword refers to a keyword specific to the preset type, for example, in the claim sharing form type, the type keyword may have claim sharing money and the like.
The form vocabulary refers to the tag information in the form to be checked, for example, the form vocabulary may include claim amortization and the like.
By matching the form vocabulary with the type keywords, the vocabulary quantity of the form vocabulary successfully matched with the type keywords can be accurately counted, and the form type of the form to be checked can be accurately determined based on the vocabulary quantity.
The obtaining unit 110 obtains a reference form from a preset library based on the generation time and the form type.
In at least one embodiment of the present invention, the preset library may refer to a database in which various form information is recorded.
The reference form refers to a specific form corresponding to the form type and the generation time when the form state is in a preset state.
In at least one embodiment of the present invention, the obtaining unit 110 obtains the reference form from the preset library based on the generation time and the form type includes:
calculating the sum of the generation time and a preset time period to obtain a target time period;
writing the target time interval and the form type into a preset search instruction to obtain a query statement;
running the query statement based on the preset library to obtain a form to be screened;
and acquiring the form state of the form to be screened, and determining the form to be screened with the form state as a preset state as the reference form.
The preset time period refers to the time spent by the form to synchronize to the preset library when the user triggers the form generation, and the preset time period may be determined to be generated after the electronic device intercepts a certain number of forms for statistics.
The preset search instruction may be an SQL statement, and the preset search instruction does not include a query object.
The preset state may be set according to actual requirements, and the preset state may include, but is not limited to: effective payment, pay, exempt payment, reduced payment, extended term, death claim, stop effect, self-cushion pay and clear, self-cushion stop effect and the like.
The target time interval is generated through the preset time interval, and then the preset library is inquired by combining the target time interval and the form type, so that the problem that a reference form corresponding to the form to be checked cannot be acquired due to the fact that a certain time is spent when the form is synchronized to the preset library can be avoided, the acquisition accuracy of the reference form is improved, the inquiry statement is directly generated through the preset search instruction, and the acquisition efficiency of the reference form is improved because the preset search instruction does not need to be reconstructed.
The selecting unit 112 selects the check field corresponding to the form type.
In at least one embodiment of the present invention, the check field refers to a specific field in the form to be checked, which needs to be checked, for example, the check field may be a risk premium, a dividend amount, a branch premium, a commission fee, a dividend fee, or the like. It will be appreciated that there is a possibility that the check fields for different form types may overlap.
In at least one embodiment of the present invention, the selecting unit 112 may select a check field corresponding to the form type from a type field check table.
The comparison unit 113 compares the form to be collated with the reference form based on the collation field.
In at least one embodiment of the present invention, the comparing unit 113 comparing the form to be collated with the reference form based on the collation field includes:
detecting whether the form to be checked and the reference form contain the check field or not;
if the check field is not contained in the form to be checked and the check field is contained in the reference form, acquiring an operation formula of the check field, wherein the operation formula comprises a plurality of index fields;
if the form to be checked contains the index fields, acquiring index information corresponding to the index fields from the form to be checked, and calculating the index information based on the operation formula to obtain field information corresponding to the check fields in the form to be checked;
acquiring information corresponding to the check field from the reference form as reference information, and comparing the field information with the reference information;
and if the field information is the same as the reference information, determining that the form to be checked is consistent with the reference form.
Wherein the plurality of index fields refer to indexes that enable the collation field to be generated based on the operation formula. For example, the check fields are: risk quota, the operation formula is: the risk premium or the policy risk factor-reserve, the index fields may include the premium, the policy risk factor, the reserve, etc.
By the embodiment, when the check field is not contained in the to-be-checked form and the check field is contained in the reference form, the field information can be accurately generated by using the operation formula, so that the comparison accuracy of the to-be-checked form and the reference form is improved.
In at least one embodiment of the present invention, after detecting whether the check field is included in the to-be-checked form and the reference form, if the check field is not included in the to-be-checked form and the check field is not included in the reference form, the detecting unit 114 detects whether the index fields are included in the to-be-checked form and the reference form;
if the form to be checked and the reference form both include the plurality of index fields, the comparing unit 113 compares the index information with information corresponding to the plurality of index fields in the reference form;
if the index information is the same as the information corresponding to the index fields in the reference form, the determining unit 115 determines that the form to be checked is consistent with the reference form.
By the embodiment, when the to-be-checked form does not contain the check field and the reference form does not contain the check field, the to-be-checked form and the reference form can be directly compared based on the index fields without calculation and generation of the check field, and the comparison efficiency is improved.
In at least one embodiment of the present invention, after detecting whether the check field is included in the to-be-checked form and the reference form, if the check field is not included in the to-be-checked form and the reference form, the comparing unit 113 compares first information corresponding to the check field in the to-be-checked form with second information corresponding to the check field in the reference form;
if the first information is the same as the second information, the determining unit 115 determines that the form to be checked is consistent with the reference form.
If the to-be-checked form is inconsistent with the reference form, the detecting unit 114 detects the to-be-checked form based on a preset change table to obtain a detection result.
It should be emphasized that, in order to further ensure the privacy and security of the detection result, the detection result may also be stored in a node of a block chain.
In at least one embodiment of the present invention, the preset change table stores change information of each form, where the change information includes: specific data changes, status changes, etc.
The detection result may include: the form to be checked is inconsistent with the reference form, and the form to be checked is consistent with the reference form.
In at least one embodiment of the present invention, the detecting unit 114 detects the to-be-checked form based on a preset change table, and obtaining a detection result includes:
traversing the preset change table based on the form identification to obtain a traversal result;
if the traversal result indicates that the preset change table contains the form identifier, obtaining a form record corresponding to the form identifier from the preset change table;
positioning a target field inconsistent with the reference form in the form to be checked;
detecting whether the target field is contained in the form record or not;
and if the form record contains the target field, comparing third information corresponding to the target field in the form to be checked with fourth information corresponding to the target field in the form record to obtain the detection result.
By the embodiment, when the form to be checked is inconsistent with the reference form, the form to be checked can be further detected based on the preset change table, and the inconsistency between the form to be checked and the reference form caused by the change of the form to be checked can be avoided, so that the accuracy of the detection result is improved.
In at least one embodiment of the present invention, after detecting whether the form record includes the target field, if the form record does not include the target field, the detecting unit 114 detects whether the form record includes the state change information of the form to be checked;
the generating unit 116 generates prompt information according to the state change information and the form identifier;
the acquiring unit 110 acquires a trigger system of the data collation request;
the sending unit 117 sends the prompt information to the trigger system.
With the above embodiment, when the form record does not include the target field, the prompt information is generated based on the state change information, so that it is possible to avoid that the corresponding reference form cannot be grasped due to a state change in the form to be checked.
According to the technical scheme, the forms to be checked are classified, the types of the forms can be accurately identified, the reference forms can be accurately positioned from the preset library in combination with the types of the forms and the generation time, the reference forms are positioned, the forms to be checked do not need to be compared with all the forms in the preset library by positioning the reference forms, so that the data checking efficiency is improved, the check fields needing to be checked can be accurately positioned by the types of the forms, the forms to be checked are compared with the reference forms on the basis of the check fields, all the fields in the forms to be checked do not need to be compared with all the fields in the reference forms, so that the data checking efficiency can be further improved, and when the forms to be checked are inconsistent with the reference forms, the form to be checked is further detected based on the preset change table, so that the inconsistency between the form to be checked and the reference form caused by the condition that the state of the form to be checked is changed and the like can be avoided, and the accuracy of data checking is improved.
Fig. 3 is a schematic structural diagram of an electronic device implementing a data checking method according to a preferred embodiment of the present invention.
In one embodiment of the present invention, the electronic device 1 includes, but is not limited to, a memory 12, a processor 13, and computer readable instructions, such as a data collation program, stored in the memory 12 and executable on the processor 13.
It will be appreciated by a person skilled in the art that the schematic diagram is only an example of the electronic device 1 and does not constitute a limitation of the electronic device 1, and that it may comprise more or less components than shown, or some components may be combined, or different components, e.g. the electronic device 1 may further comprise an input output device, a network access device, a bus, etc.
The Processor 13 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component, etc. The processor 13 is an operation core and a control center of the electronic device 1, and is connected to each part of the whole electronic device 1 by various interfaces and lines, and executes an operating system of the electronic device 1 and various installed application programs, program codes, and the like.
Illustratively, the computer readable instructions may be partitioned into one or more modules/units that are stored in the memory 12 and executed by the processor 13 to implement the present invention. The one or more modules/units may be a series of computer readable instruction segments capable of performing specific functions, which are used for describing the execution process of the computer readable instructions in the electronic device 1. For example, the computer-readable instructions may be divided into an acquisition unit 110, a classification unit 111, a selection unit 112, a comparison unit 113, a detection unit 114, a determination unit 115, a generation unit 116, and a transmission unit 117.
The memory 12 may be used for storing the computer readable instructions and/or modules, and the processor 13 implements various functions of the electronic device 1 by executing or executing the computer readable instructions and/or modules stored in the memory 12 and invoking data stored in the memory 12. The memory 12 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data created according to use of the electronic device, and the like. The memory 12 may include non-volatile and volatile memories, such as: a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other storage device.
The memory 12 may be an external memory and/or an internal memory of the electronic device 1. Further, the memory 12 may be a memory having a physical form, such as a memory stick, a TF Card (Trans-flash Card), or the like.
The integrated modules/units of the electronic device 1 may be stored in a computer-readable storage medium if they are implemented in the form of software functional units and sold or used as separate products. Based on such understanding, all or part of the flow of the method of the embodiments described above can be realized by the present invention, and the computer readable instructions can also be used for instructing the related hardware, and the computer readable instructions can be stored in a computer readable storage medium, and when the computer readable instructions are executed by a processor, the steps of the method embodiments described above can be realized.
Wherein the computer readable instructions comprise computer readable instruction code which may be in source code form, object code form, an executable file or some intermediate form, and the like. The computer-readable medium may include: any entity or device capable of carrying said computer readable instruction code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM).
The block chain is a novel application mode of computer technologies such as distributed data checking, 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.
In conjunction with fig. 1, the memory 12 in the electronic device 1 stores computer-readable instructions to implement a data reconciliation method, and the processor 13 executes the computer-readable instructions to implement:
when a data checking request is received, acquiring a form to be checked and the generation time of the form to be checked according to the data checking request;
classifying the forms to be checked to obtain the form types of the forms to be checked;
acquiring a reference form from a preset library based on the generation time and the form type;
selecting check fields corresponding to the form types;
comparing the form to be checked with the reference form based on the check field;
and if the form to be checked is inconsistent with the reference form, detecting the form to be checked based on a preset change table to obtain a detection result.
Specifically, the processor 13 may refer to the description of the relevant steps in the embodiment corresponding to fig. 1 for a specific implementation method of the computer readable instructions, which is not described herein again.
In the embodiments provided in the present invention, it should be understood that the disclosed system, apparatus and method may 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 computer readable storage medium has computer readable instructions stored thereon, wherein the computer readable instructions when executed by the processor 13 are configured to implement the steps of:
when a data checking request is received, acquiring a form to be checked and the generation time of the form to be checked according to the data checking request;
classifying the forms to be checked to obtain the form types of the forms to be checked;
acquiring a reference form from a preset library based on the generation time and the form type;
selecting check fields corresponding to the form types;
comparing the form to be checked with the reference form based on the check field;
and if the form to be checked is inconsistent with the reference form, detecting the form to be checked based on a preset change table to obtain a detection result.
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.
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.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. The plurality of units or devices may also be implemented by one unit or device through software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only intended to illustrate the technical solutions of the present invention and not to limit the same, 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 can be made to 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 data collation method, characterized in that said data collation method comprises:
when a data checking request is received, acquiring a form to be checked and the generation time of the form to be checked according to the data checking request;
classifying the forms to be checked to obtain the form types of the forms to be checked;
acquiring a reference form from a preset library based on the generation time and the form type;
selecting check fields corresponding to the form types;
comparing the form to be checked with the reference form based on the check field;
and if the form to be checked is inconsistent with the reference form, detecting the form to be checked based on a preset change table to obtain a detection result.
2. The data collation method according to claim 1, wherein said acquiring the form to be collated and the generation timing of the form to be collated according to the data collation request includes:
analyzing the message of the data checking request to obtain the data information carried by the message;
extracting form identification and path address from the data information;
acquiring a form corresponding to the form identification from the path address as the form to be checked, and acquiring a creating user of the form to be checked from the path address;
acquiring a form generation log from the binding terminal of the creating user based on the form identification and a preset event;
and extracting the generation time from the form generation log.
3. The data verification method of claim 2, wherein the detecting the form to be verified based on the preset change table to obtain a detection result comprises:
traversing the preset change table based on the form identification to obtain a traversal result;
if the traversal result indicates that the preset change table contains the form identifier, obtaining a form record corresponding to the form identifier from the preset change table;
positioning a target field inconsistent with the reference form in the form to be checked;
detecting whether the target field is contained in the form record or not;
and if the form record contains the target field, comparing third information corresponding to the target field in the form to be checked with fourth information corresponding to the target field in the form record to obtain the detection result.
4. The data collation method according to claim 1, wherein said classifying said form to be collated, and obtaining a form type of said form to be collated includes:
acquiring a type keyword of each preset type;
extracting form vocabularies in the form to be checked;
matching the form vocabulary with the type keywords, and counting the vocabulary number of the form vocabulary successfully matched with the type keywords;
and determining the preset type with the maximum vocabulary number as the form type.
5. The data collation method according to claim 1, wherein said acquiring a reference form from a preset library based on said generation timing and said form type includes:
calculating the sum of the generation time and a preset time period to obtain a target time period;
writing the target time interval and the form type into a preset search instruction to obtain a query statement;
running the query statement based on the preset library to obtain a form to be screened;
and acquiring the form state of the form to be screened, and determining the form to be screened with the form state as a preset state as the reference form.
6. The data collation method according to claim 1, wherein said comparing said form to be collated with said reference form based on said collation field includes:
detecting whether the form to be checked and the reference form contain the check field or not;
if the check field is not contained in the form to be checked and the check field is contained in the reference form, acquiring an operation formula of the check field, wherein the operation formula comprises a plurality of index fields;
if the form to be checked contains the index fields, acquiring index information corresponding to the index fields from the form to be checked, and calculating the index information based on the operation formula to obtain field information corresponding to the check fields in the form to be checked;
acquiring information corresponding to the check field from the reference form as reference information, and comparing the field information with the reference information;
and if the field information is the same as the reference information, determining that the form to be checked is consistent with the reference form.
7. The data collation method according to claim 6, wherein after detecting whether or not said collation field is included in said form to be collated and said reference form, said data collation method further comprises:
if the check field is not contained in the form to be checked and the check field is not contained in the reference form, detecting whether the form to be checked and the reference form contain the index fields or not;
if the form to be checked and the reference form both contain the index fields, comparing the index information with information corresponding to the index fields in the reference form;
and if the index information is the same as the information corresponding to the index fields in the reference form, determining that the form to be checked is consistent with the reference form.
8. A data collation apparatus, characterized in that said data collation apparatus comprises:
the acquisition unit is used for acquiring a form to be checked and the generation time of the form to be checked according to a data checking request when the data checking request is received;
the classification unit is used for classifying the forms to be checked to obtain the form types of the forms to be checked;
the obtaining unit is further configured to obtain a reference form from a preset library based on the generation time and the form type;
the selecting unit is used for selecting the check field corresponding to the form type;
the comparison unit is used for comparing the form to be checked with the reference form based on the check field;
and the detection unit is used for detecting the form to be checked based on a preset change table to obtain a detection result if the form to be checked is inconsistent with the reference form.
9. An electronic device, characterized in that the electronic device comprises:
a memory storing computer readable instructions; and
a processor executing computer readable instructions stored in the memory to implement the data collation method according to any one of claims 1 to 7.
10. A computer-readable storage medium characterized by: the computer-readable storage medium stores therein computer-readable instructions which are executed by a processor in an electronic device to implement the data collation method according to any one of claims 1 to 7.
CN202210138076.5A 2022-02-15 2022-02-15 Data checking method, device, equipment and storage medium Pending CN114490692A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210138076.5A CN114490692A (en) 2022-02-15 2022-02-15 Data checking method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210138076.5A CN114490692A (en) 2022-02-15 2022-02-15 Data checking method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN114490692A true CN114490692A (en) 2022-05-13

Family

ID=81479538

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210138076.5A Pending CN114490692A (en) 2022-02-15 2022-02-15 Data checking method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN114490692A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115102759A (en) * 2022-06-21 2022-09-23 南京质子链科技有限公司 Interface backtracking system based on block chain

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115102759A (en) * 2022-06-21 2022-09-23 南京质子链科技有限公司 Interface backtracking system based on block chain
CN115102759B (en) * 2022-06-21 2023-09-12 南京质子链科技有限公司 Interface backtracking system based on block chain

Similar Documents

Publication Publication Date Title
CN112669138B (en) Data processing method and related equipment
CN111538816B (en) Question-answering method, device, electronic equipment and medium based on AI identification
CN113283675B (en) Index data analysis method, device, equipment and storage medium
CN111797351A (en) Page data management method and device, electronic equipment and medium
CN112711398A (en) Method, device and equipment for generating buried point file and storage medium
CN109711849B (en) Ether house address portrait generation method and device, electronic equipment and storage medium
CN115222443A (en) Client group division method, device, equipment and storage medium
CN114490692A (en) Data checking method, device, equipment and storage medium
CN112199483B (en) Information input assisting method and device, electronic equipment and storage medium
CN114372060A (en) Data storage method, device, equipment and storage medium
CN113900955A (en) Automatic testing method, device, equipment and storage medium
CN113918467A (en) Financial system testing method, device, equipment and storage medium
CN108846292A (en) Desensitization process method and device
CN111986771A (en) Medical prescription query method and device, electronic equipment and storage medium
CN115205032A (en) Credit investigation query method, apparatus, device and storage medium
CN114925033A (en) Information uplink method, device, system and storage medium
CN113269179B (en) Data processing method, device, equipment and storage medium
CN115169360A (en) User intention identification method based on artificial intelligence and related equipment
CN114692204A (en) Data query method, device, equipment and storage medium
CN113902302A (en) Data analysis method, device, equipment and storage medium based on artificial intelligence
CN114841579A (en) Index data generation method, device, equipment and storage medium
CN114238296A (en) Product index data display method, device, equipment and storage medium
CN113886263A (en) System testing method, device, equipment and storage medium
CN112949305A (en) Negative feedback information acquisition method, device, equipment and storage medium
CN111933241A (en) Medical data analysis method, medical data analysis device, electronic 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