CN117056433A - Data report management method, device, terminal equipment and storage medium - Google Patents
Data report management method, device, terminal equipment and storage medium Download PDFInfo
- Publication number
- CN117056433A CN117056433A CN202310939771.6A CN202310939771A CN117056433A CN 117056433 A CN117056433 A CN 117056433A CN 202310939771 A CN202310939771 A CN 202310939771A CN 117056433 A CN117056433 A CN 117056433A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- service system
- check
- verification
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 51
- 238000003860 storage Methods 0.000 title claims abstract description 14
- 238000012795 verification Methods 0.000 claims abstract description 103
- 238000000034 method Methods 0.000 claims description 28
- 238000012545 processing Methods 0.000 claims description 24
- 238000012384 transportation and delivery Methods 0.000 claims description 9
- 238000010606 normalization Methods 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 claims 2
- 230000008569 process Effects 0.000 description 14
- 239000000047 product Substances 0.000 description 11
- 238000013523 data management Methods 0.000 description 8
- 230000001105 regulatory effect Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 230000008520 organization Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000012937 correction Methods 0.000 description 2
- 238000013524 data verification Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 238000002360 preparation method Methods 0.000 description 2
- 230000001502 supplementing effect Effects 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000005856 abnormality Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 238000000275 quality assurance Methods 0.000 description 1
- 238000003908 quality control method Methods 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/64—Protecting data integrity, e.g. using checksums, certificates or signatures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application discloses a data report management method, a device, a terminal device and a storage medium, wherein the data report management method comprises the following steps: acquiring first report data from a service system; according to preset multidimensional checking conditions, checking the first report data to obtain a corresponding checking result; and executing data treatment on the service system according to the verification result to obtain a treatment result of the first report data. According to the scheme of the application, the report data is checked by leading the check conditions of multiple dimensions in the service system, and then the service system is managed according to the check result, so that the report data is consistent with the data of the service system, the error report data is managed from the data source, the technical problem of low quality of the report data is effectively improved, and the data quality of the service system is further standardized.
Description
Technical Field
The present application relates to the field of data management technologies, and in particular, to a method and apparatus for managing data reporting, a terminal device, and a storage medium.
Background
At present, the processing method for supervising the report data is simpler, mainly relies on interpretation and understanding of supervising the report, and statistics is carried out on the business generated in a banking business system, generally, processing, integration and output of the report data are carried out in a data warehouse, and finally report is carried out.
However, if the supervision report data meets a coarser check rule proposed by a supervision center, the supervision report data defaults to no problem and is then reported, the report data is not well controlled and checked in quality, and the problems of false report, missing report, serious field deletion rate, inconsistent cross-system product verification and the like are easy to occur; if the problem exists, the data is directly modified and then submitted, so that the submitted data in the service system is still in error, and the quality of the submitted data is difficult to be standardized.
Therefore, a management scheme for improving the quality of the reported data is needed.
Disclosure of Invention
The application mainly aims to provide a data reporting management method, a device, terminal equipment and a storage medium, which aim to solve the technical problem of low reporting data quality and further standardize the data quality of a service system.
In order to achieve the above object, the present application provides a datagram delivery management method, including:
acquiring first report data from a service system;
checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result;
and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data.
Optionally, the step of verifying the first report data according to a preset multidimensional verification condition to obtain a corresponding verification result includes:
performing one or more of text rule check, deviation check, cross-system check, inter-table consistency check, field normalization check and field logic check on the first report data, and detecting whether the first report data passes the check;
and if the first report data does not pass the verification, obtaining the verification result.
Optionally, the step of acquiring the first report data from the service system includes:
acquiring a plurality of service apertures from the service system;
when the service apertures meet the preset rechecking condition, processing data according to the service apertures to generate second report data;
and verifying the second report data to obtain the first report data.
Optionally, the step of verifying the second report data to obtain the first report data includes:
acquiring a data range and a field value of the second report data;
when the data range and the field value meet the preset verification condition, detecting whether the second report data are consistent with the data of the service system or not according to the service caliber;
and if the second report data is consistent with the data of the service system, obtaining the first report data.
Optionally, the step of performing data governance on the service system according to the verification result to obtain a governance result of the first reported data includes:
analyzing the verification result, and determining a plurality of corresponding branch systems to obtain branch error data corresponding to the branch systems respectively;
and executing data treatment on the service system according to the verification result to obtain the treatment result.
Optionally, the step of performing data governance on the service system according to the verification result includes:
when the line error data is filling errors, maintaining data corresponding to the line error data in the service system;
when the branch error data is a business element error, a corresponding business element is input in the business system and/or a business report request is generated and sent.
Optionally, after the step of verifying the first report data according to the preset multidimensional verification condition to obtain the corresponding verification result, the method further includes:
and when a query access instruction is received, displaying the verification result through a pre-established supervision and report special area module.
The embodiment of the application also provides a data report management device, which comprises:
the acquisition module is used for acquiring first report data from the service system;
the verification module is used for verifying the first report data according to preset multidimensional verification conditions to obtain a corresponding verification result;
and the treatment module is used for carrying out data treatment on the service system according to the verification result to obtain a treatment result of the first report data.
The embodiment of the application also provides a terminal device, which comprises a memory, a processor and a data report management program stored on the memory and capable of running on the processor, wherein the data report management program realizes the steps of the data report management method when being executed by the processor.
The embodiment of the application also provides a computer readable storage medium, wherein the computer readable storage medium stores a data report management program, and the data report management program realizes the steps of the data report management method when being executed by a processor.
The data report management method, the device, the terminal equipment and the storage medium provided by the embodiment of the application acquire first report data from a service system; checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result; and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data. According to the scheme of the application, the report data is checked by leading the check conditions of multiple dimensions in the service system, and then the service system is managed according to the check result, so that the report data is consistent with the data of the service system, the error report data is managed from the data source, the technical problem of low quality of the report data is effectively improved, and the data quality of the service system is further standardized.
Drawings
FIG. 1 is a schematic diagram of functional modules of a terminal device to which a datagram management apparatus of the present application belongs;
FIG. 2 is a flowchart illustrating a datagram management method according to a first exemplary embodiment of the present application;
FIG. 3 is a flowchart illustrating a datagram management method according to a second exemplary embodiment of the present application;
FIG. 4 is a schematic overall flow chart of the data report management method of the present application;
FIG. 5 is a flowchart illustrating a datagram management method according to a third exemplary embodiment of the present application;
fig. 6 is a flowchart illustrating a datagram management method according to a fourth exemplary embodiment of the present application.
The achievement of the objects, functional features and advantages of the present application will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
The main solutions of the embodiments of the present application are: acquiring first report data from a service system; checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result; and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data. According to the scheme of the application, the report data is checked by leading the check conditions of multiple dimensions in the service system, and then the service system is managed according to the check result, so that the report data is consistent with the data of the service system, the error report data is managed from the data source, the technical problem of low quality of the report data is effectively improved, and the data quality of the service system is further standardized.
The embodiment of the application considers that the supervision report data is only counted according to the interpretation and understanding of supervision messages at present, generally, unified data processing, integration and output are carried out in a data warehouse, and then final report is carried out. The produced data is defaulted to be directly reported without problems as long as the coarser check rule proposed by supervision is met, and if the problems exist, the data is modified or special cases are reported and then reported. At present, the measures do not have good control and check on the data quality of each report, and the problems of false report, missing report, serious field missing rate, inconsistent cross-system product verification and the like are easy to occur frequently. Meanwhile, the report data is directly changed into report data with problems, and the data of the service system is kept wrong, so that the service data generated by the service system in the industry cannot be well regulated, the data quality of the service system cannot be standardized, and the current data supervision method is simpler and needs further optimization.
Therefore, the scheme of the embodiment of the application starts from the practical problem of improving the quality of the reported data, designs a management method for supervising the reported data based on multi-dimensional verification based on the verification capability of the multi-dimensional verification condition on the reported data, effectively improves the technical problem of low quality of the reported data, and further standardizes the data quality of a service system.
Specifically, referring to fig. 1, fig. 1 is a schematic functional block diagram of a terminal device to which the datagram management apparatus of the present application belongs. The datagram management apparatus may be an apparatus capable of datagram management independent of the terminal device, which may be carried on the terminal device in the form of hardware or software. The terminal equipment can be an intelligent mobile terminal with a data processing function such as a mobile phone and a tablet personal computer, and can also be a fixed terminal equipment or a server with a data processing function.
In this embodiment, the terminal device to which the datagram management apparatus belongs at least includes an output module 110, a processor 120, a memory 130 and a communication module 140.
The memory 130 stores an operating system and a data report management program, and the data report management device may store information such as the first report data, the verification result, the treatment result of the first report data, etc. in the memory 130; the output module 110 may be a display screen or the like. The communication module 140 may include a WIFI module, a mobile communication module, a bluetooth module, and the like, and communicates with an external device or a server through the communication module 140.
Wherein the datagram management program in the memory 130 when executed by the processor implements the steps of:
acquiring first report data from a service system;
checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result;
and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data.
Further, the datagram management program in the memory 130 when executed by the processor also implements the steps of:
performing one or more of text rule check, deviation check, cross-system check, inter-table consistency check, field normalization check and field logic check on the first report data, and detecting whether the first report data passes the check;
and if the first report data does not pass the verification, obtaining the verification result.
Further, the datagram management program in the memory 130 when executed by the processor also implements the steps of:
acquiring a plurality of service apertures from the service system;
when the service apertures meet the preset rechecking condition, processing data according to the service apertures to generate second report data;
and verifying the second report data to obtain the first report data.
Further, the datagram management program in the memory 130 when executed by the processor also implements the steps of:
acquiring a data range and a field value of the second report data;
when the data range and the field value meet the preset verification condition, detecting whether the second report data are consistent with the data of the service system or not according to the service caliber;
and if the second report data is consistent with the data of the service system, obtaining the first report data.
Further, the datagram management program in the memory 130 when executed by the processor also implements the steps of:
analyzing the verification result, and determining a plurality of corresponding branch systems to obtain branch error data corresponding to the branch systems respectively;
and executing data treatment on the service system according to the verification result to obtain the treatment result.
Further, the datagram management program in the memory 130 when executed by the processor also implements the steps of:
when the line error data is filling errors, maintaining data corresponding to the line error data in the service system;
when the branch error data is a business element error, a corresponding business element is input in the business system and/or a business report request is generated and sent.
Further, the datagram management program in the memory 130 when executed by the processor also implements the steps of:
and when a query access instruction is received, displaying the verification result through a pre-established supervision and report special area module.
According to the scheme, the first report data are obtained from the service system; checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result; and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data. According to the scheme of the application, the report data is checked by leading the check conditions of multiple dimensions in the service system, and then the service system is managed according to the check result, so that the report data is consistent with the data of the service system, the error report data is managed from the data source, the technical problem of low quality of the report data is effectively improved, and the data quality of the service system is further standardized.
The method embodiment of the application is proposed based on the above-mentioned terminal equipment architecture but not limited to the above-mentioned architecture.
Referring to fig. 2, fig. 2 is a flowchart illustrating a first exemplary embodiment of a datagram management method according to the present application. The datagram management method comprises the following steps:
step S210, acquiring first report data from a service system;
the execution subject of the method of the embodiment may be a data report management device, or may be a data report management terminal device or a server, and the embodiment uses the data report management device as an example, where the data report management device may be integrated on a terminal device such as a smart phone or a tablet computer with a data processing function.
In order to reduce the situations of supervision report error report and report missing and inconsistent data among cross supervision product systems, the embodiment of the application improves the accuracy of supervision report data, and finally ensures that the quality of the bottom data of an intra-line business system is more regular, more accurate and more perfect, and mainly realizes the management of supervision report data, in particular to the quality improvement of supervision report data.
Specifically, in daily operations of a financial institution or an enterprise, data reporting is a critical task, which involves providing critical business data and information to a regulatory agency or other related party, so that the first reporting data may be raw data extracted from a business system of a bank or other organization, and may be used to report data to the regulatory agency or other related party. The business systems may be systems for recording and managing various business transactions and operations, and the obtaining of the first reporting data may be extracting data from the business systems as initial data for reporting.
Step S220, checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result;
in particular, to ensure the quality and reliability of the reported data, a multidimensional check is often required. Multidimensional checking is a comprehensive data quality assurance measure and can comprise aspects of compliance, integrity, accuracy, logical relationship and the like of data.
After the first report data is acquired, the data is checked and verified according to preset multidimensional checking conditions. The verification results of the verification conditions can identify the report data which does not accord with the verification conditions, so that problems and potential errors in the data can be found rapidly, corresponding data management measures are taken, and the business system and the first report data are repaired and corrected.
And step S230, executing data treatment on the service system according to the verification result to obtain a treatment result of the first report data.
Specifically, the data management may be a process of repairing or updating data in the service system according to the verification result. After knowing which data do not meet the verification conditions according to the verification results, the data errors existing in the service system can be repaired, the outdated data can be updated, and the missing data can be supplemented, so that the data generated in the service system meet the preset verification conditions, and the high-quality reporting standard is achieved.
According to the scheme, the first report data are obtained from the service system; checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result; and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data. According to the scheme of the application, the report data is checked by leading the check conditions of multiple dimensions in the service system, and then the service system is managed according to the check result, so that the report data is consistent with the data of the service system, the error report data is managed from the data source, the technical problem of low quality of the report data is effectively improved, and the data quality of the service system is further standardized.
Referring to fig. 3, fig. 3 is a flowchart illustrating a second exemplary embodiment of a datagram management method according to the present application. Based on the embodiment shown in fig. 2, step S210, obtaining the first report data from the service system includes:
step S310, obtaining a plurality of service apertures from the service system;
specifically, the service caliber may be a specification or standard adopted in the service data reporting process, and may be a specific element, index or rule for describing service transaction or operation, and ITs form may be an information or an instruction, and the service calibers may respectively belong to one or more of service department responsible person, service system IT responsible person, source system responsible person and bazaar report developer. In the embodiment of the application, different service data specifications or elements may be extracted from the service system, and a plurality of different indexes or service rules may be involved.
Step S320, when the service apertures meet the preset rechecking condition, processing data according to the service apertures to generate second report data;
specifically, the rechecking condition is used for determining whether the service caliber is correct. After a plurality of service apertures are obtained, checking the check condition of the apertures can be performed, and if all the service apertures meet the preset check condition, data processing can be performed according to the service apertures. The second report data is initial report data obtained by processing, calculating or integrating the original business data.
Illustratively, the caliber for supervising the report product yield of the report product is compounded and verified by multiple parties, including the business department responsible person, the business system IT responsible person and the bazaar report developer, and the produced data is accepted and confirmed by the three parties.
Step S330, checking the second report data to obtain the first report data.
Specifically, verification is a process of verifying, examining and determining the second report data, so that consistency, accuracy and compliance of the second report data and data in the service system can be improved.
Referring to fig. 4, fig. 4 is an overall flow chart of the data report management method according to the present application. For supervision and report products, firstly, a service understands and supervises and answers according to supervision and report, a service caliber is combed to a service system responsible person, the service system responsible person rechecks the service caliber and produces an IT caliber, the service caliber is not opposite to the service caliber and is returned to the service responsible person to refill the service caliber, then a data mart developer rechecks the service caliber and the IT caliber, the IT caliber is not opposite to the service responsible person, and report data are generated according to the processing of the service caliber/the IT caliber. And distributing the processed data list to each source system responsible person and business department responsible person for checking and accepting data.
Further, step S330 includes verifying the second report data to obtain the first report data, including:
step S331, obtaining a data range and a field value of the second report data;
specifically, the data range may refer to a range of service data or an overlaid service transaction type included in the second report data. The field value may refer to a range of values or possible values or text contents allowed for each field (data item) in the second report data.
Step S332, detecting whether the second report data is consistent with the data of the service system according to the service caliber when the data range and the field value meet the preset verification condition;
specifically, the data range and the field value of the second report data are checked and compared, and if the verification of the data range and the verification of the field value meet the actual requirements, the verification condition is met. When the data range and the field area bureau meet the verification condition, the second report data and the corresponding data in the service system can be further compared according to the service caliber so as to judge whether the second report data and the corresponding data are consistent.
Step S333, if the second reporting data is consistent with the data of the service system, obtaining the first reporting data.
Specifically, if the second report data is found to be consistent with the data of the service system in terms of data range and field value after verification, it is indicated that the second report data is to be determined as satisfactory first report data. The first reporting data may be used to report data to a regulatory agency or other interested party.
The checking and accepting includes checking whether the data range, the value of each field and the like meet the requirements, whether the data range and the value of each field are consistent with the service system, if the data checking and accepting are not passed, returning to the main development person in the bazaar to modify the processing logic again, and outputting the number again until the final service system IT main and the service department main pass all checking and accepting.
According to the scheme, the second reporting data are generated according to the service apertures by extracting the service apertures from the service system, and the final first reporting data are obtained after verification, namely, the first reporting data are subjected to data processing and quality control, so that the accuracy, the integrity and the compliance of the reporting data can be improved, and the requirements of supervision and data reporting can be met.
Referring to fig. 5, fig. 5 is a flowchart illustrating a third exemplary embodiment of a datagram management method according to the present application. Based on the embodiment shown in fig. 2, step S220, according to a preset multidimensional checking condition, checks the first report data to obtain a corresponding checking result, including:
step S510, performing one or more of text rule check, deviation check, cross-system check, inter-table consistency check, field normalization check and field logic check on the first report data, and detecting whether the first report data passes the check;
specifically, referring to fig. 4, the multidimensional verification condition may include one or more of a palindromic rule check, a deviance check, a cross-system check, an inter-table consistency check, a field normalization check, and a field logical check.
The verification of the posting rules may be to verify the first posting data according to a rule (posting) issued by a regulatory or related organization, so as to ensure that the datagram conforms to the rule and requirement of posting. The deviation check may be a calculation and comparison of the deviation of the first reported data to detect whether the data deviates or differs from the expected or reference value. The cross-system verification may be to perform cross-system verification on the first reported data when multiple data systems or databases are involved, so as to confirm consistency and accuracy of the data between different systems. The inter-table consistency check may be a comparison and verification of data between multiple tables or data sets to ensure that the relevant data in the different tables or data sets are consistent. The field normalization check may be to check whether the format, type, length, etc. of each field in the first report data meets a predefined specification or standard. The field logical check may be to check a logical relationship between each field in the first reported data to confirm logical consistency and rationality of the data.
Step S520, if the first report data fails to pass the verification, the verification result is obtained.
In particular, the verification result may include which reported data fails verification, as well as possibly problems and error information. According to the verification process, a series of checks and verifications are performed on the first reported data. If all the checks are passed, the first reporting data is considered to be satisfactory and can be used as a report to the relevant party. If the first report data does not pass any one or more of the verification, a corresponding verification result is obtained, and measures such as data management, correction or report preparation can be performed on the first report data so as to ensure the data quality and compliance.
Illustratively, according to the requirement of supervision, each supervision product is butted through a supervision and reporting special area module, including 1104, EAST, gold examination, pedestrian count, customer risk and the like, business system data are generated, check data are checked according to the supervision check rules, deviation check, inter-table consistency check, cross-system check and other check rules, reporting is carried out without problems, and error detail data distribution processing is carried out for different branches if problems exist. Wherein, the processing content is as follows: the method comprises the steps of confirming the branch, analyzing the reasons of the branch, returning the processing results to the general line, counting and verifying the general line according to the analyzed reasons and the processing results of the branch, continuously returning the branch to process the branch in doubt, and carrying out problem-free sorting, summarizing and reporting to a supervision. The scheme ensures the accuracy of the reported data, and simultaneously, the supervision check rule is pre-arranged in the service system, and the post-service system checks and repairs and blocks the generation of the nonstandard service in advance to take effect at the same time, thereby further standardizing the data quality of the service system.
Further, step S220, after verifying the first report data according to a preset multidimensional verification condition to obtain a corresponding verification result, further includes:
and step S530, when a query access instruction is received, the verification result is displayed through a pre-established supervision report special area module.
Specifically, in order to facilitate the user or related departments to query and view the verification results, a supervision report special area module may be created in advance, and the supervision report special area module may include a plurality of supervision products and may also be used for displaying a specific application or page of report data verification results.
When a query access instruction is received, namely a user or a related department needs to check a verification result of first report data, the results can be displayed through a supervision report special area module, wherein the supervision report special area module possibly has the functions of user login and authority control so as to ensure that an authorized person can check the related verification result; different inquiry and screening functions can be provided according to the needs, so that a user can check a verification result according to specific conditions; the method can also have the functions of exporting reports, generating data quality analysis and the like, and help users to better understand the reporting condition and make corresponding decisions.
For example, for a regulatory newspaper item, a regulatory newspaper district module may be created. The administrative reporting area may contain a plurality of administrative products including, for example, 1104, EAST, censoring, pedestrian count, customer risk, and the like. The data table of each report product generated according to the supervision messages can be displayed in the supervision report special area, and the authority of each report responsible person in the headquarter and the branches for checking the data according to the authority of each data range in the headquarter and the branches can be shared for checking the data and processing the problems.
According to the online report products, a plurality of check rule systems can be established, including check rules required by supervision, cross-system check, deviation check, inter-table consistency check, field normalization check, field logic check and the like, and check result details and summarized data are displayed in a wind cloud supervision special area, including error detail data, branch statistical result data and the like.
According to the scheme, the first report data is checked and verified in multiple dimensions. If the first report data does not pass any one or more of the checks, a corresponding check result can be obtained, and measures such as data management, correction or report preparation are performed to ensure the data quality and compliance; in addition, the supervision and report special area module displays the verification result as a process of reporting and displaying the verified data quality condition, so that a user or related departments can know the quality condition of the first report data, the response capability of a financial institution to supervision requirements can be enhanced, the quality and efficiency of data report are improved, the report process is simplified, and the report cost is reduced.
Referring to fig. 6, fig. 6 is a flowchart illustrating a fourth exemplary embodiment of a datagram management method according to the present application. Based on the embodiment shown in fig. 2, step S230, according to the verification result, executes data governance on the service system to obtain a governance result of the first reported data, including:
step S610, analyzing the verification result, determining a plurality of corresponding branch systems, and obtaining branch error data corresponding to each of the plurality of branch systems;
specifically, referring to fig. 4, in analyzing the verification result, data that fails the verification may be carefully inspected and classified to further understand the data quality problem reflected in the verification result. The verification result may indicate that the first reported data is abnormal, and may also involve multiple branch systems or service departments, so that it may be determined, according to the data source or the identifier in the verification result, which branch systems involve data that fails the verification. The line error data may be data identified as erroneous or unsatisfactory, respectively, as referred to by the number of line systems.
And step S620, according to the verification result, executing data treatment on the service system to obtain the treatment result.
Specifically, the operation of data management is performed for the corresponding line error data of the line systems. The data management may include repairing, correcting, supplementing, deleting, etc. the data in the service system to ensure that the data in the service system is improved and perfected.
In addition, the first report data with the abnormality can be corrected according to the verification result, and the corrected first report data can be reported to a supervision organization or other related parties.
The business of the general line is checked and tidied according to the problems collected by the branches, and if the disputed place continues to send back the branches for processing until the business of the general line is not objectified after checking. If the data of the service system is maintained, the data can be re-stored and run again, so that the consistency of the reported data and the data of the service system is ensured, and the management of error data from a data source is ensured. Meanwhile, the checking rule required by supervision can be pre-arranged at the service system end, and the data quality of the service system can be standardized when the service is generated. For example, if some business elements are not allowed to be empty, the text box is controlled on the business system interface to be not empty, otherwise, the business flow is interrupted, and the next step cannot be continued.
Further, step S620, according to the verification result, executes data governance on the service system to obtain the governance result, including:
step S621, when the line error data is filling error, maintaining the data corresponding to the line error data in the service system;
specifically, when the line error data is a filling error, it means that the filling error or the incorrectly formatted data is found in the datagram process. To correct these errors, data corresponding to these line error data needs to be maintained in the service system. This may include modifying, updating or supplementing the data fields to ensure that the correct data is filled in to be stored in the business system.
Step S622, when the line error data is a service element error, a corresponding service element is entered in the service system and/or a service report request is generated and sent.
Specifically, when the line error data is a service element error, it means that an error or a loss involving the service element is found in the datagram. In this case, special processing is required in the service system. Including but not limited to entering business elements, generating and sending business report requests.
For the missing business elements, corresponding business element data is required to be recorded in a business system so as to supplement complete report data. For error business elements which are difficult to modify or input directly in a business system, a business report request can be generated, and the generated business report request is sent to a corresponding department or a supervision organization for indicating that the problem exists and requesting further processing or report.
Illustratively, error detail data generated for the checking rules is distributed to each branch by the sponsor for data problem determination and processing, the processing comprising: filling errors when handling business, and maintaining business system data; the historical data cannot find the corresponding business elements, and a backup request is generated to report and monitor; the special service scene does not meet the suggestion report of the check rule; the business system inputs the business elements temporarily in no place, carries out scheduling transformation, clarifies transformation content and plans, and the like.
The embodiment specifically analyzes and processes the found problem or error data based on the verification result through the scheme. Errors and problems in the data can be corrected through data management, the accuracy, compliance and credibility of the data are improved, and the reported data are ensured to meet the supervision and business requirements.
In addition, an embodiment of the present application further provides a datagram delivery management apparatus, where the datagram delivery management apparatus includes:
the acquisition module is used for acquiring first report data from the service system;
the verification module is used for verifying the first report data according to preset multidimensional verification conditions to obtain a corresponding verification result;
and the treatment module is used for carrying out data treatment on the service system according to the verification result to obtain a treatment result of the first report data.
The principle and implementation process of the datagram management are implemented in this embodiment, please refer to the above embodiments, and are not described herein again.
In addition, the embodiment of the application also provides a terminal device, which comprises a memory, a processor and a data report management program stored on the memory and capable of running on the processor, wherein the data report management program realizes the steps of the data report management method when being executed by the processor.
Because all the technical solutions of all the embodiments are adopted when the data report management program is executed by the processor, the data report management program at least has all the beneficial effects brought by all the technical solutions of all the embodiments and is not described in detail herein.
In addition, the embodiment of the application also provides a computer readable storage medium, wherein the computer readable storage medium stores a data report management program, and the data report management program realizes the steps of the data report management method when being executed by a processor.
Because all the technical solutions of all the embodiments are adopted when the data report management program is executed by the processor, the data report management program at least has all the beneficial effects brought by all the technical solutions of all the embodiments and is not described in detail herein.
Compared with the prior art, the data report management method, the device, the terminal equipment and the storage medium provided by the embodiment of the application acquire the first report data from the service system; checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result; and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data. According to the scheme of the application, the report data is checked by leading the check conditions of multiple dimensions in the service system, and then the service system is managed according to the check result, so that the report data is consistent with the data of the service system, the error report data is managed from the data source, the technical problem of low quality of the report data is effectively improved, and the data quality of the service system is further standardized.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The foregoing embodiment numbers of the present application are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as above, comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, a controlled terminal, or a network device, etc.) to perform the method of each embodiment of the present application.
The foregoing description is only of the preferred embodiments of the present application, and is not intended to limit the scope of the application, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (10)
1. The data report management method is characterized by comprising the following steps of:
acquiring first report data from a service system;
checking the first report data according to preset multidimensional checking conditions to obtain a corresponding checking result;
and executing data treatment on the service system according to the verification result to obtain a treatment result of the first reported data.
2. The datagram delivery management method as claimed in claim 1, wherein the step of verifying the first datagram data according to a preset multidimensional verification condition to obtain a corresponding verification result comprises:
performing one or more of text rule check, deviation check, cross-system check, inter-table consistency check, field normalization check and field logic check on the first report data, and detecting whether the first report data passes the check;
and if the first report data does not pass the verification, obtaining the verification result.
3. The datagram delivery management method as claimed in claim 1, wherein the step of acquiring the first delivery data from the service system comprises:
acquiring a plurality of service apertures from the service system;
when the service apertures meet the preset rechecking condition, processing data according to the service apertures to generate second report data;
and verifying the second report data to obtain the first report data.
4. The datagram management method as claimed in claim 3, wherein said step of verifying said second report data to obtain said first report data includes:
acquiring a data range and a field value of the second report data;
when the data range and the field value meet the preset verification condition, detecting whether the second report data are consistent with the data of the service system or not according to the service caliber;
and if the second report data is consistent with the data of the service system, obtaining the first report data.
5. The datagram delivery management method as claimed in claim 1, wherein the step of performing data governance on the service system according to the check result to obtain a governance result of the first delivered data includes:
analyzing the verification result, and determining a plurality of corresponding branch systems to obtain branch error data corresponding to the branch systems respectively;
and executing data treatment on the service system according to the verification result to obtain the treatment result.
6. The datagram management method according to claim 5, wherein the step of performing data governance on the service system according to the check result comprises:
when the line error data is filling errors, maintaining data corresponding to the line error data in the service system;
when the branch error data is a business element error, a corresponding business element is input in the business system and/or a business report request is generated and sent.
7. The method for managing data transmission according to claim 1, wherein after the step of verifying the first transmission data according to a preset multidimensional verification condition to obtain a corresponding verification result, the method further comprises:
and when a query access instruction is received, displaying the verification result through a pre-established supervision and report special area module.
8. A datagram delivery management apparatus, the datagram delivery management apparatus comprising:
the acquisition module is used for acquiring first report data from the service system;
the verification module is used for verifying the first report data according to preset multidimensional verification conditions to obtain a corresponding verification result;
and the treatment module is used for carrying out data treatment on the service system according to the verification result to obtain a treatment result of the first report data.
9. A terminal device comprising a memory, a processor and a datagram management program stored on the memory and operable on the processor, the datagram management program when executed by the processor implementing the steps of the datagram management method according to any of claims 1-7.
10. A computer readable storage medium, wherein a datagram management program is stored on the computer readable storage medium, which when executed by a processor implements the steps of the datagram management method according to any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310939771.6A CN117056433A (en) | 2023-07-28 | 2023-07-28 | Data report management method, device, terminal equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310939771.6A CN117056433A (en) | 2023-07-28 | 2023-07-28 | Data report management method, device, terminal equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117056433A true CN117056433A (en) | 2023-11-14 |
Family
ID=88661701
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310939771.6A Pending CN117056433A (en) | 2023-07-28 | 2023-07-28 | Data report management method, device, terminal equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117056433A (en) |
-
2023
- 2023-07-28 CN CN202310939771.6A patent/CN117056433A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3308297B1 (en) | Data quality analysis | |
| RU2549510C1 (en) | Systems and methods of creating large-scale architecture for processing credit information | |
| US6915234B2 (en) | Monitoring submission of performance data describing a relationship between a provider and a client | |
| US6035295A (en) | Computer system and method of data analysis | |
| US20200334267A1 (en) | System and method for automatic generation of extract, transform, load (etl) asserts | |
| US6850866B2 (en) | Managing performance metrics describing a relationship between a provider and a client | |
| CN111340584A (en) | Method, device, equipment and storage medium for determining fund side | |
| CN112862593A (en) | Credit scoring card model training method, device, system and computer storage medium | |
| US20180285433A1 (en) | Behavioral analytics in information technology infrasturcture incident management systems | |
| CN114969040A (en) | Data display method and device, electronic equipment and storage medium | |
| CN110895761B (en) | After-sales service application information processing method and device | |
| CN109947797B (en) | Data inspection device and method | |
| CN111353763A (en) | Method, device, server and storage medium for processing data | |
| CN117056433A (en) | Data report management method, device, terminal equipment and storage medium | |
| CN112734352A (en) | Document auditing method and device based on data dimensionality | |
| CN115147049A (en) | Order batch loading method and device, storage medium and computer equipment | |
| US9489438B2 (en) | Systems and methods for visualizing master data services information | |
| WO2020215542A1 (en) | Information notification method and device, computer apparatus, and storage medium | |
| CN112258151A (en) | Reconciliation method and device based on pandas, computer equipment and storage medium | |
| US8977564B2 (en) | Billing account reject solution | |
| CN113609407B (en) | Regional consistency verification method and device | |
| US20230252008A1 (en) | Systems and methods for data verification | |
| CN113158633A (en) | Statistical report processing method and device | |
| CN117132415A (en) | Account checking method, device, equipment and storage medium | |
| CN117290183A (en) | ETL-based cross-system exception monitoring processing method and device |
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 |