CN117149745A - Report form checking method, device, equipment and storage medium of new and old systems - Google Patents
Report form checking method, device, equipment and storage medium of new and old systems Download PDFInfo
- Publication number
- CN117149745A CN117149745A CN202311236380.4A CN202311236380A CN117149745A CN 117149745 A CN117149745 A CN 117149745A CN 202311236380 A CN202311236380 A CN 202311236380A CN 117149745 A CN117149745 A CN 117149745A
- Authority
- CN
- China
- Prior art keywords
- checking
- data
- report
- old
- new
- 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
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000012545 processing Methods 0.000 claims description 15
- 238000004364 calculation method Methods 0.000 claims description 4
- 238000012795 verification Methods 0.000 description 11
- 230000008569 process Effects 0.000 description 10
- 238000012544 monitoring process Methods 0.000 description 7
- 230000003287 optical effect Effects 0.000 description 6
- 238000013508 migration Methods 0.000 description 5
- 230000005012 migration Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 238000011022 operating instruction Methods 0.000 description 3
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 238000013524 data verification Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000018109 developmental process Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 230000001105 regulatory effect Effects 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 238000012546 transfer Methods 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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Abstract
The application provides a report checking method, a device, equipment and a storage medium of a new and old system, which are applied to the financial field or other fields, wherein the method comprises the following steps: and acquiring a report check range between the new supervision report system and the old supervision report system, and generating a parameter state log table according to the report check range. According to the parameter state log table, the data checking task is automatically executed, and the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints, so that the automatic checking of the data of the new supervision and reporting system and the old supervision and reporting system can be realized through one parameter state log table, the checking efficiency is greatly improved, the data fingerprints are adopted for checking, the data itself is not required to be checked directly, the checking logic is simple and flexible and changeable, the checking time is short, the occupied resources are less, the checking efficiency can be further improved, and the probability of checking errors is reduced.
Description
Technical Field
The present application relates to the field of computers, and in particular, to a method, an apparatus, a device, and a storage medium for checking a report form of a new and old system.
Background
With the current society's financial and computer developments, banks are involved in more and more financial transactions. The financial transaction generates more data, and the data is required to be processed by a supervision reporting system to form a report, so that supervision of the financial transaction is realized. The supervision report system needs to accurately process data in time to form a report. When the supervision report system is updated, in order to ensure the accuracy of the report, the bank generally synchronously operates the new supervision report system and the old supervision report system for a period of time so as to ensure the consistency of the supervision report. At this time, the report forms of the new supervision report system and the old supervision report system need to be checked one by one so as to avoid the problem caused by inconsistent report forms, but the report forms are checked manually at present, so that the checking efficiency is low and errors are easy to occur.
Disclosure of Invention
Therefore, the application aims to provide a report checking method, device, equipment and storage medium for new and old systems, which can automatically check the report of the new and old supervision reporting systems, greatly improve the checking efficiency and reduce the checking error.
The application provides a report form checking method of a new system and an old system, which comprises the following steps:
acquiring a report checking range between a new supervision report system and an old supervision report system, and generating a parameter state log table according to the report checking range, wherein the parameter state log table comprises a checking scene, a checking table name, a checking condition and a checking date;
and automatically executing a data checking task according to the parameter state log table, wherein the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints.
Optionally, the data checking task includes a source data table data checking task;
the automatic execution of the data checking task according to the parameter state log table comprises the following steps:
reading the parameter state log table, and acquiring the new data and the old data corresponding to the checking scene, the checking table name, the checking condition and the checking date;
and automatically executing the data checking task of the source data table of the new data and the old data.
Optionally, the data checking task includes a report data checking task;
the method further comprises the steps of:
the new supervision report system and the old supervision report system respectively use the new data and the old data to execute report processing to respectively obtain a new report and an old report;
the automatic execution of the data checking task according to the parameter state log table comprises the following steps:
and reading the parameter state log table, obtaining the new report and the old report corresponding to the checking scene, the checking table name, the checking condition and the checking date, and automatically executing the report data checking task of the new report and the old report.
Optionally, the method further comprises:
a checkup result list is formed, and the checkup result list is returned to the user.
Optionally, the data fingerprint is obtained by performing hash calculation after performing character string splicing on the fields.
The application provides a report checking device of new and old systems, which comprises:
the acquisition unit is used for acquiring a report form checking range between the new supervision report system and the old supervision report system, and generating a parameter state log table according to the report form checking range, wherein the parameter state log table comprises a checking scene, a checking name, a checking condition and a checking date;
and the execution unit is used for automatically executing a data checking task according to the parameter state log table, wherein the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints.
Optionally, the data checking task includes a source data table data checking task;
the execution unit is used for:
reading the parameter state log table, and acquiring the new data and the old data corresponding to the checking scene, the checking table name, the checking condition and the checking date;
and automatically executing the data checking task of the source data table of the new data and the old data.
Optionally, the data checking task includes a report data checking task;
the device further comprises a processing unit for:
the new supervision report system and the old supervision report system respectively use the new data and the old data to execute report processing to respectively obtain a new report and an old report;
the execution unit is used for:
and reading the parameter state log table, obtaining the new report and the old report corresponding to the checking scene, the checking table name, the checking condition and the checking date, and automatically executing the report data checking task of the new report and the old report.
The application provides report checking equipment of new and old systems, which comprises: a processor and a memory;
the memory is used for storing instructions;
the processor is configured to execute the instructions in the memory and perform the method according to the foregoing embodiment.
The present application provides a computer readable storage medium comprising instructions which, when run on a computer, cause the computer to perform a method as described in the above embodiments.
The application provides a report form checking method of a new system and an old system, which comprises the following steps: and acquiring a report check range between the new supervision report system and the old supervision report system, and generating a parameter state log table according to the report check range, wherein the parameter state log table comprises a check scene, a check table name, check conditions and check dates. According to the parameter state log table, the data checking task is automatically executed, and the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints, so that the automatic checking of the data of the new supervision and reporting system and the old supervision and reporting system can be realized through one parameter state log table, the checking efficiency is greatly improved, the data fingerprints are adopted for checking, the data itself is not required to be checked directly, the checking logic is simple and flexible and changeable, the checking time is short, the occupied resources are less, the checking efficiency can be further improved, and the probability of checking errors is reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic flow chart of a report checking method of a new and old system according to an embodiment of the present application;
FIG. 2 shows a network topology structure diagram of report form verification of a new and old system according to an embodiment of the present application;
fig. 3 is a schematic flow chart of data processing and data checking performed by the new and old supervision reporting system according to the embodiment of the present application;
FIG. 4 is a schematic flow chart of a data checking task of a source data table according to an embodiment of the present application;
fig. 5 shows a schematic structural diagram of a report checking device for a new and old system according to an embodiment of the present application.
Detailed Description
In order to make the present application better understood by those skilled in the art, the following description will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the accompanying drawings, and it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present application, but the present application may be practiced in other ways other than those described herein, and persons skilled in the art will readily appreciate that the present application is not limited to the specific embodiments disclosed below.
The report checking method, device, equipment and storage medium of the new and old systems can be used in the financial field or other fields, for example, the report checking application scene of the new and old systems in the financial field. Other fields are any field other than the financial field, for example, the computer field. The foregoing is merely an example, and the application fields of the report checking method, the apparatus, the device and the storage medium of the new and old systems provided by the present application are not limited.
With the current society's financial and computer developments, banks are involved in more and more financial transactions. The financial transaction generates more data, and the data is required to be processed by the overseas monitoring and reporting system to form a report, so that the financial transaction is monitored, and the overseas report is required to be formed by the overseas monitoring and reporting system especially for overseas business. The supervision report system needs to accurately process data in time to form a report. When the supervision report system is updated, in order to ensure the accuracy of the report, the bank generally synchronously operates the new supervision report system and the old supervision report system for a period of time so as to ensure the consistency of the supervision report. At this time, the report forms of the new supervision report system and the old supervision report system need to be checked one by one to avoid the problem caused by inconsistent report forms, but the report forms are checked manually at present, the report forms are checked manually, the report form data sources are not clear, the checking workload is huge, and the checking efficiency is low. And, the current report check is to compare the data one by one, but the database types of the new supervision report system and the old supervision report system may be different, and the data one by one comparison may have errors.
When the supervision and reporting system is upgraded, the data of the old supervision and reporting system needs to be migrated to the new supervision and reporting system, and although the stored data is migrated, the data of the old supervision and reporting system may not be suitable for the report model of the new supervision and reporting system. For example, migration from relational databases to NoSQL databases, the storage format of data has changed tremendously. In addition, some data are stateful, and if the problem of writing storage data of a new supervision and reporting system is found after data migration, the data are difficult to repair at this time.
Based on the above, the application provides a report checking method of new and old systems, which comprises the following steps: and acquiring a report check range between the new supervision report system and the old supervision report system, and generating a parameter state log table according to the report check range, wherein the parameter state log table comprises a check scene, a check table name, check conditions and check dates. According to the parameter state log table, the data checking task is automatically executed, and the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints, so that the automatic checking of the data of the new supervision and reporting system and the old supervision and reporting system can be realized through one parameter state log table, the checking efficiency is greatly improved, the data fingerprints are adopted for checking, the data itself is not required to be checked directly, the checking logic is simple and flexible and changeable, the checking time is short, the occupied resources are less, the checking efficiency can be further improved, and the probability of checking errors is reduced.
For a better understanding of the technical solutions and technical effects of the present application, specific embodiments will be described in detail below with reference to the accompanying drawings.
Referring to fig. 1, the flow chart of a report checking method of a new and old system according to an embodiment of the present application is shown.
The report form checking method of the new and old systems provided by the embodiment of the application can be applied to a data checking platform, wherein the data checking platform can comprise a plurality of servers, and is shown by referring to fig. 2, which is a network topology structure diagram of report form checking of the new and old systems. In fig. 2, the new line application server and the new line database server belong to a new supervision and delivery system, and the old line application server and the old line database server belong to an old supervision and delivery system.
Referring to fig. 3, a flow chart of data processing and data checking by the new and old supervision and report system is shown. It can be seen that the data checking task includes two stages, namely, a source data table data checking task before report processing and a report data checking task after report processing.
The new administrative reporting system may be referred to as a new line system, and the database in which the new administrative reporting system stores new data may be referred to as a new line database, and the new data may be stored in a new line data table. Accordingly, the old supervision and reporting system may be referred to as an old line system, and the database in which the old supervision and reporting system stores old data may be referred to as an old line database, and the old data may be stored in the old line data table.
The report checking method of the new and old systems provided by the embodiment comprises the following steps:
s101, acquiring a report check range between the new supervision report system and the old supervision report system, and generating a parameter state log table according to the report check range.
In the embodiment of the application, in order to perform report form verification between the new supervision and delivery system and the old supervision and delivery system, a report form verification range between the new supervision and delivery system and the old supervision and delivery system can be obtained, and a parameter state log table is generated according to the report form verification range, wherein the parameter state log table can comprise verification parameters such as a verification scene, a verification table name, a verification condition, a verification date and the like, so that the verification parameters in the parameter state log table can be directly read later, and a data verification task can be automatically executed.
In practical application, business personnel audit the report range and the report content to be checked, perform data analysis on the confirmed report range and the report content, determine the source data range and the source data field related to the report to be checked, and maintain the source data field to be checked in the parameter state log table so as to configure the checking task.
As an example, the parameter status log table may be as follows, where the database of the new regulatory reporting system may be Oracle and the database of the old regulatory reporting system may be Gbase:
the application can utilize the parameter state log table to check the report, and can also monitor and check the data transferred from the database of the old supervision report system to the database of the new supervision report system in real time, thereby ensuring the consistency in the data transfer process.
In practical applications, after the parameter status log table is generated, the new and old supervision reporting systems may receive source data from a source system pushed by a data layer, such as a data lake, and load the received source data into a database.
S102, automatically executing a data checking task according to the parameter state log table.
In the embodiment of the application, after the parameter state log table is obtained, the parameter state log table can be automatically read, so that the data checking task is automatically executed. The data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints. The data fingerprint refers to that after character string splicing is carried out on the fields, hash calculation is carried out, so that a data fingerprint value is obtained, and the data fingerprint value is the unique identification value of the field for verification. For example, the hash computation may be an MD5 algorithm.
The application adopts the data fingerprint to check, does not need to directly check the data, has simple, flexible and changeable check logic, short check time and less occupied resources, can further improve the check efficiency and reduces the probability of check errors.
As one example, the data fingerprint table may be as follows:
| english name | Data type | Chinese name | |
| 1 | KEY1 | VARchar2(3200) | Key value |
| 2 | DACTY1 | VARchar2(32) | Data fingerprint |
| 3 | ROWID1 | VARchar2(18) | Row address |
Since the data collation task includes the source data table data collation task and the report data collation task, the source data table data collation task and the report data collation task can be automatically executed in accordance with the parameter status log table.
The following describes automatically performing a source data table data collation task based on a parameter status log table:
and reading the parameter state log table, acquiring new data and old data corresponding to the checking scene, the checking table name, the checking condition and the checking date, and automatically executing the data checking task of the source data table of the new data and the old data.
Specifically, since the data check involves data migration, during data check, it involves migrating old data of the old monitoring and reporting system to the new monitoring and reporting system, and then checking with new data received by the new monitoring and reporting system, thereby determining whether there is a change in the old data migrated to the new monitoring and reporting system.
Referring to fig. 4, a flow chart of a data checking task of a source data table is shown. The parameter state log table can be read, the checking scene, the checking table name, the checking condition and the checking date are obtained, so that the primary key and the column name of the data table corresponding to the data to be checked are obtained, the old line checking table is created, and the data fingerprint value is obtained by calculating the data fingerprint value according to the checking condition, for example, the checking condition is that multiple fields are spliced into a character string in sequence. And (3) inserting the data fingerprint into a temporary check table A in batches, wherein the temporary check table A is an old line md5 table, and finally exporting the temporary check table A as a text file in an OCI mode of a downloading tool such as Oracle. And acquiring loading information, loading the text file to the new line check list A, and thus obtaining a data list for migrating the old data to the new supervision report system.
Reading a parameter state log table, acquiring a checking scene, a checking table name, checking conditions and a checking date so as to acquire a primary key and a column name of a data table corresponding to data to be checked, creating a new line checking table, and calculating a data fingerprint value according to the checking conditions, such as multi-field sequential spelling as a character string. The data fingerprint is inserted into a new line check table B in batches.
And carrying out data check on the new line check list A and the new line check list B, subtracting the new line check list B from the new line check list A, and obtaining a unilateral record of the old line to obtain a check result of the old supervision report system. And subtracting the new line check table A from the new line check table B to obtain a record of a single side of the new line, and obtaining a check result of the new supervision and reporting system. The new line check table A is associated with the new line check table B, and a difference record between the new data and the old data is obtained.
The following describes the task of automatically executing report data verification according to the parameter status log table:
after the new supervision and report system and the old supervision and report system receive the source data from the source system pushed by the data lake, the corresponding database storage is performed respectively to obtain new data and old data. And executing report processing by using the new supervision report system and the old supervision report system respectively by using the new data and the old data to obtain a new report and an old report respectively. And then reading the parameter state log table, obtaining a new report and an old report corresponding to the checking scene, the checking name, the checking condition and the checking date, and automatically executing the report data checking task of the new report and the old report. The data fingerprint is adopted to carry out indirect check when the check task is specifically executed.
In the embodiment of the application, after the data checking task is automatically executed according to the parameter state log table, a checking result detail table can be formed, and the checking result detail table can be returned to the user so that the user can obtain the data checking result in time.
The front-end interface can receive the query conditions input by the user, read the check result detail list and return the check result detail record to the user. Specifically, the check result detail table can be queried, and then the related records of the new line source data table and the old line source data table are retrieved and displayed on the front end interface.
As one example, the collation result detail table may be as follows:
| english name | Data type | Chinese name | |
| 1 | DB_DB | VARchar2(3) | Checking a scene |
| 2 | GBA_NM | VARchar2(100) | Gbase table name |
| 3 | ORA_NM | VARchar2(100) | Oracle table name |
| 4 | RPT_DT | VARchar2(8) | Number of period |
| 5 | RGN_NO | VARchar2(5) | Region(s) |
| 6 | KEY1 | VARchar2(3200) | Main key |
| 7 | ROWID1 | VARchar2(18) | Row address |
| 8 | DET_ST | VARchar2(1) | Checking state |
| 9 | UPT_TM | VARchar2(30) | Update time |
| 10 | MSG | VARchar2(500) | Prompt message |
In the embodiment of the application, the data can be migrated from the database of the old supervision reporting system to the database of the new supervision reporting system by utilizing the parameter state log table for real-time monitoring and checking, thereby ensuring the consistency in the data migration process.
That is, all recorded data in the parameter state log table are scanned, a corresponding kind of operation is started, 4 processing steps of checking the new line source data table and the old line database table, checking and exporting the old line database table, loading the new line database table, checking the source data table data, checking the report data and the like are executed, and a checking complete flow is completed sequentially. The execution process and the result form running water and log information, and the running water and log information are inserted and updated into the checking result flow water meter, so that the checking task of thousands of reports is automatically completed, and the formed checking result provides inquiry service for users.
As one example, the inspection result flow meter may be as follows:
| english name | Data type | Chinese name | |
| 1 | DB_DB | VARchar2(3) | Checking a scene |
| 2 | DBS_FG | VARchar2(1) | Database identification |
| 3 | TAB_NM | VARchar2(100) | Table name |
| 4 | RPT_DT | VARchar2(8) | Number of period |
| 5 | RGN_NO | VARchar2(5) | Region(s) |
| 6 | ALS_NM | VARchar2(100) | Table alias |
| 7 | RCD_CN | NUMBER(25) | Record number |
| 8 | UPT_TM | VARchar2(30) | Update time |
| 9 | MSG | VARchar2(500) | Prompt message |
And executing new and old line source data table checking, old line database table checking export and new line database table loading, and realizing the data checking process in the data migration process as follows:
the old line local checking service is used for checking parameters in the loop scanning parameter state log table, checking the state of the old line data table, and starting the cross-database checking and exporting operation of the old line database according to the checking parameters, the checking conditions and the like. The cross-database checking and exporting operation of the old line database is to check the old line source data table, process the corresponding data fingerprint value according to the checking parameters and the checking conditions, export the data fingerprint value into a compressed file, and automatically transmit the compressed file to the appointed catalogue of the new line server.
The new line local checking service is used for checking parameters in the circular scanning parameter state log table, checking the state of the new line source data table, and starting the new line local checking operation according to the checking parameters, checking conditions and the like. The new line local checking operation is to check the new line source data table, process the corresponding data fingerprint value according to the checking parameters and the checking conditions, and newly generate a new line data fingerprint table in the new line database.
The new line local loading service is used for checking parameters in a circular scanning parameter state log table, checking the state of an old line data file, and starting the new line local loading operation according to loading control parameters. The new line local loading operation is to check the state of the local data fingerprint compressed file, load the compressed file in the new line database according to the loading template, and newly generate an old line data fingerprint table.
The new line local checking service is used for checking parameters in the circular scanning parameter state log table, checking the data fingerprint table state and starting the new line local checking operation according to the checking parameters. The new line local checking operation is to check the old line data fingerprint table and the new line data fingerprint table, and according to the checking flow rule, the checking results of the old line data fingerprint table and the new line data fingerprint table, such as the checking total number and the detail data, are generated and inserted into the checking result detail table.
In practical application, after the report data are checked to be consistent, the new line system and the old line system are switched on the basis of completing the old line data backup, and after the switching, the new line service is taken as the main service, and the old line is stopped.
In practical application, when the old line system is switched to the new line system and a problem occurs, the rollback process can be started immediately, the old line system service is restarted, the old line data is loaded, and the new line and old line parallel working mode is restored, so that the normal on-line service of the supervision and reporting system is ensured, and sufficient time is left for a developer to repair the problem.
The application provides a report form checking method of a new system and an old system, which comprises the following steps: and acquiring a report check range between the new supervision report system and the old supervision report system, and generating a parameter state log table according to the report check range, wherein the parameter state log table comprises a check scene, a check table name, check conditions and check dates. According to the parameter state log table, the data checking task is automatically executed, and the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints, so that the automatic checking of the data of the new supervision and reporting system and the old supervision and reporting system can be realized through one parameter state log table, the checking efficiency is greatly improved, the data fingerprints are adopted for checking, the data itself is not required to be checked directly, the checking logic is simple and flexible and changeable, the checking time is short, the occupied resources are less, the checking efficiency can be further improved, and the probability of checking errors is reduced.
Based on the report form checking method of the new and old systems provided by the above embodiment, the embodiment of the application also provides a report form checking device of the new and old systems, and the working principle of the report form checking device is described in detail below with reference to the accompanying drawings.
Referring to fig. 5, the structure of a report checking device for a new and old system according to an embodiment of the present application is shown.
The report checking device 200 of the new and old systems provided in this embodiment includes:
an obtaining unit 210, configured to obtain a report checking range between a new supervision reporting system and an old supervision reporting system, and generate a parameter status log table according to the report checking range, where the parameter status log table includes a checking scene, a checking name, a checking condition, and a checking date;
and the execution unit 220 is configured to automatically execute a data checking task according to the parameter status log table, where the data checking task performs field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by using a data fingerprint.
Optionally, the data checking task includes a source data table data checking task;
the execution unit 220 is configured to:
reading the parameter state log table, and acquiring the new data and the old data corresponding to the checking scene, the checking table name, the checking condition and the checking date;
and automatically executing the data checking task of the source data table of the new data and the old data.
Optionally, the data checking task includes a report data checking task;
the device further comprises a processing unit for:
the new supervision report system and the old supervision report system respectively use the new data and the old data to execute report processing to respectively obtain a new report and an old report;
the execution unit 220 is configured to:
and reading the parameter state log table, obtaining the new report and the old report corresponding to the checking scene, the checking table name, the checking condition and the checking date, and automatically executing the report data checking task of the new report and the old report.
Optionally, the apparatus further comprises a forming unit for:
a checkup result list is formed, and the checkup result list is returned to the user.
Optionally, the data fingerprint is obtained by performing hash calculation after performing character string splicing on the fields.
Based on the report form checking method of the new and old systems provided in the above embodiment, the embodiment of the present application further provides a report form checking device of the new and old systems, where the report form checking device of the new and old systems includes:
processors and memory, the number of processors may be one or more. In some embodiments of the application, the processor and memory may be connected by a bus or other means.
The memory may include read only memory and random access memory and provide instructions and data to the processor. A portion of the memory may also include NVRAM. The memory stores operating means and operating instructions, executable modules or data structures, or a subset thereof, or an extended set thereof, wherein the operating instructions may include various operating instructions for performing various operations. The operating device may include various device programs for implementing various basic services and handling hardware-based tasks.
The processor controls the operation of the terminal device, which may also be referred to as a CPU.
The method disclosed by the embodiment of the application can be applied to a processor or realized by the processor. The processor may be an integrated circuit chip with signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or by instructions in the form of software. The processor described above may be a general purpose processor, DSP, ASIC, FPGA or other programmable logic device, discrete gate or transistor logic device, discrete hardware components. The disclosed methods, steps, and logic blocks in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present application may be embodied directly in the execution of a hardware decoding processor, or in the execution of a combination of hardware and software modules in a decoding processor. The software modules may be located in a random access memory, flash memory, read only memory, programmable read only memory, or electrically erasable programmable memory, registers, etc. as well known in the art. The storage medium is located in a memory, and the processor reads the information in the memory and, in combination with its hardware, performs the steps of the above method.
The embodiments of the present application also provide a computer readable storage medium storing a program code for executing any one of the methods of the foregoing embodiments.
In the context of the present application, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution apparatus, device, or apparatus. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. The machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor apparatus, device, or apparatus, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
The computer readable medium of the present application may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor apparatus, device, or means, or any combination of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution apparatus, device, or apparatus. In the present application, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution apparatus, device, or apparatus. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
When introducing elements of various embodiments of the present application, the articles "a," "an," "the," and "said" are intended to mean that there are one or more of the elements. The terms "comprising," "including," and "having" are intended to be inclusive and mean that there may be additional elements other than the listed elements.
It should be noted that, it will be understood by those skilled in the art that all or part of the above-mentioned method embodiments may be implemented by a computer program to instruct related hardware, where the program may be stored in a computer readable storage medium, and the program may include the above-mentioned method embodiments when executed. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a random-access Memory (Random Access Memory, RAM), or the like.
Computer program code for carrying out operations of the present application may be written in one or more programming languages, including, but not limited to, an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for the device embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and reference is made to the description of the method embodiments for relevant points. The apparatus embodiments described above are merely illustrative, wherein the units and modules illustrated as separate components may or may not be physically separate. In addition, some or all of the units and modules can be selected according to actual needs to achieve the purpose of the embodiment scheme. Those of ordinary skill in the art will understand and implement the present application without undue burden.
The foregoing is merely a preferred embodiment of the present application, and the present application has been disclosed in the above description of the preferred embodiment, but is not limited thereto. Any person skilled in the art can make many possible variations and modifications to the technical solution of the present application or modifications to equivalent embodiments using the methods and technical contents disclosed above, without departing from the scope of the technical solution of the present application. Therefore, any simple modification, equivalent variation and modification of the above embodiments according to the technical substance of the present application still fall within the scope of the technical solution of the present application.
Claims (10)
1. A report form checking method of a new and old system, the method comprising:
acquiring a report checking range between a new supervision report system and an old supervision report system, and generating a parameter state log table according to the report checking range, wherein the parameter state log table comprises a checking scene, a checking table name, a checking condition and a checking date;
and automatically executing a data checking task according to the parameter state log table, wherein the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints.
2. The method of claim 1, wherein the data collation task comprises a source data table data collation task;
the automatic execution of the data checking task according to the parameter state log table comprises the following steps:
reading the parameter state log table, and acquiring the new data and the old data corresponding to the checking scene, the checking table name, the checking condition and the checking date;
and automatically executing the data checking task of the source data table of the new data and the old data.
3. The method of claim 1, wherein the data reconciliation task comprises a report data reconciliation task;
the method further comprises the steps of:
the new supervision report system and the old supervision report system respectively use the new data and the old data to execute report processing to respectively obtain a new report and an old report;
the automatic execution of the data checking task according to the parameter state log table comprises the following steps:
and reading the parameter state log table, obtaining the new report and the old report corresponding to the checking scene, the checking table name, the checking condition and the checking date, and automatically executing the report data checking task of the new report and the old report.
4. The method according to claim 1, wherein the method further comprises:
a checkup result list is formed, and the checkup result list is returned to the user.
5. The method according to claim 1, wherein the data fingerprint is obtained by performing a hash calculation after performing a string concatenation on the fields.
6. A report form collation apparatus of a new and old system, characterized by comprising:
the acquisition unit is used for acquiring a report form checking range between the new supervision report system and the old supervision report system, and generating a parameter state log table according to the report form checking range, wherein the parameter state log table comprises a checking scene, a checking name, a checking condition and a checking date;
and the execution unit is used for automatically executing a data checking task according to the parameter state log table, wherein the data checking task is to perform field checking on new data corresponding to the new supervision and reporting system and old data corresponding to the old supervision and reporting system by utilizing data fingerprints.
7. The apparatus of claim 6, wherein the data collation task comprises a source data table data collation task;
the execution unit is used for:
reading the parameter state log table, and acquiring the new data and the old data corresponding to the checking scene, the checking table name, the checking condition and the checking date;
and automatically executing the data checking task of the source data table of the new data and the old data.
8. The apparatus of claim 6, wherein the data reconciliation task comprises a report data reconciliation task;
the device further comprises a processing unit for:
the new supervision report system and the old supervision report system respectively use the new data and the old data to execute report processing to respectively obtain a new report and an old report;
the execution unit is used for:
and reading the parameter state log table, obtaining the new report and the old report corresponding to the checking scene, the checking table name, the checking condition and the checking date, and automatically executing the report data checking task of the new report and the old report.
9. A report collation apparatus of a new and old system, characterized by comprising: a processor and a memory;
the memory is used for storing instructions;
the processor being configured to execute the instructions in the memory and to perform the method of any of claims 1-5.
10. A computer readable storage medium comprising instructions which, when run on a computer, cause the computer to perform the method of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311236380.4A CN117149745A (en) | 2023-09-22 | 2023-09-22 | Report form checking method, device, equipment and storage medium of new and old systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311236380.4A CN117149745A (en) | 2023-09-22 | 2023-09-22 | Report form checking method, device, equipment and storage medium of new and old systems |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117149745A true CN117149745A (en) | 2023-12-01 |
Family
ID=88912125
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311236380.4A Pending CN117149745A (en) | 2023-09-22 | 2023-09-22 | Report form checking method, device, equipment and storage medium of new and old systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117149745A (en) |
-
2023
- 2023-09-22 CN CN202311236380.4A patent/CN117149745A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114528008A (en) | Code control method, device and medium based on distributed version control system | |
| CN110795447A (en) | Data processing method, data processing system, electronic device, and medium | |
| CN115168341A (en) | Service processing method, system, medium and equipment | |
| CN103678591A (en) | Device and method for automatically executing multi-service receipt statistical treatment | |
| CN115858488A (en) | Parallel migration method and device based on data governance and readable medium | |
| CN109857806B (en) | Synchronous verification method and device for database table | |
| CN114564500A (en) | Method and system for implementing structured data storage and query in block chain system | |
| CN109597819B (en) | Method and apparatus for updating a database | |
| CN116644122A (en) | Data transaction processing method, device, computer equipment and storage medium | |
| CN117149745A (en) | Report form checking method, device, equipment and storage medium of new and old systems | |
| CN114356454A (en) | Account checking data processing method, account checking data processing device, account checking data storage medium and program product | |
| CN114496139A (en) | Quality control method, device, equipment and system of electronic medical record and readable medium | |
| CN114490415A (en) | Service testing method, computer device, storage medium, and computer program product | |
| CN114637672A (en) | Automatic data testing method and device, computer equipment and storage medium | |
| CN109582330B (en) | Data model upgrading method, device, equipment and readable storage medium | |
| CN113592645A (en) | Data verification method and device | |
| CN108628909B (en) | Information pushing method and device | |
| CN110609790A (en) | Analytic program test method, device, medium and computer equipment | |
| CN114238292B (en) | Data cleaning method, device, computer equipment and computer readable storage medium | |
| CN117573199B (en) | Model difference comparison analysis method, device, equipment and medium | |
| US11392373B1 (en) | System and methods for code base transformations | |
| US20240078221A1 (en) | Systems and methods of modeling and querying dynamic temporal graph on massive parallel graph processing and storage engine | |
| CN115147212A (en) | Verification method and device for account checking system | |
| CN113360511A (en) | Method, device and equipment for processing credit investigation information | |
| CN117827661A (en) | Code grammar checking method, system, computer 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 |