CN114443485A - Service system function verification method and system based on data migration - Google Patents
Service system function verification method and system based on data migration Download PDFInfo
- Publication number
- CN114443485A CN114443485A CN202210108821.1A CN202210108821A CN114443485A CN 114443485 A CN114443485 A CN 114443485A CN 202210108821 A CN202210108821 A CN 202210108821A CN 114443485 A CN114443485 A CN 114443485A
- Authority
- CN
- China
- Prior art keywords
- verification
- information
- data
- service
- distributed
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3692—Test management for test results analysis
-
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention relates to a business system function verification method and a system based on data migration.A centralized system is provided with at least one piece of label information, a distributed system is provided with at least one processing node, the processing node generates verification information when processing business transaction, and the verification information and the corresponding label information have a matching relation; respectively operating service processing verification on the distributed system and the centralized system; when the business transaction runs to a processing node, generating verification information; matching the verification information with corresponding label information; when the verification information and the label information accord with a matching relation, outputting a service processing result of the centralized system and a service processing result of the distributed system; and when the service processing result of the centralized system is not matched with the service processing result of the distributed system, outputting the label information, the processing node and the verification information. The invention breaks through a black box test method for judging test results from an application interface, and designs a database layer checking method. And data verification is carried out in the service operation, so that the accuracy and comprehensiveness of a service test result are guaranteed.
Description
Technical Field
The invention relates to the technical field of data verification, in particular to a service system function verification method and system based on data migration.
Background
After the commercial bank system is migrated from the centralized architecture to the distributed architecture, the deployment mode, data assembly, loading and storage of the database are changed, and no verification method exists on how to verify that the data can correctly process the service based on the distributed database tables, how to ensure the global uniqueness of the data fields and how to ensure the synchronous consistency of parameter maintenance.
Each computer in the distributed data system is an independent and autonomous node, and devices in different places and networks are combined into a complete, global, logically centralized and physically distributed large database through network connection. The application program realizes the dispersion, sharing and consistency processing of data. In a system under a general distributed architecture, a test is only used as a black box, and a service processing result at an application level is used as a reference basis. The key points and the method for verifying the key design characteristics of the distributed database in a targeted manner are lacked. Under the conditions of unclear data sources and single-service processing result, defects and problems are difficult to comprehensively discover, and higher risks and hidden dangers exist for accurate operation of the system.
Disclosure of Invention
Aiming at the defects of the prior art, the invention designs a matched verification scheme aiming at the data storage mode of the distributed sub-database and sub-table and the change of data migration to a new database, and two key technologies deeply drill down the application processing mode and technical characteristics, breaks through a black box test method for judging test results from an application interface, and designs a database layer check method.
In order to achieve the above purpose, the invention provides a service system function verification method and system based on data migration, which solves the problems that the defects and the problems are difficult to comprehensively discover when the processing result of the service is inquired only by a service operation client, and the data storage mode is changed and the data checking method is lost after the data is migrated to a distributed sub-library and sub-table.
The service system function verification method based on data migration comprises the following steps:
s1, setting at least one label information in a centralized system, setting at least one processing node in a distributed system, wherein the processing node generates verification information when processing business transaction, and the verification information has a matching relation with the corresponding label information;
s2, respectively operating service processing verification on the distributed system and the centralized system;
s3, the transaction calling party initiates the service transaction, and when the service transaction runs to the processing node, verification information is generated;
s4, matching the verification information with corresponding label information;
when the verification information does not accord with the corresponding label information, outputting the processing node;
s5, when the verification information and the label information accord with the matching relationship, outputting the service processing result of the centralized system and the service processing result of the distributed system;
s6, judging whether the service processing result of the centralized system is matched with the service processing result of the distributed system;
when the service processing result of the centralized system is not matched with the service processing result of the distributed system, outputting the label information, the processing node and the verification information;
s7, when the service processing result of the centralized system is matched with the service processing result of the distributed system, respectively running data compatibility verification on the distributed system and the centralized system;
s8, judging whether the data compatibility verification results are matched or not;
and when the data compatibility verification result is matched, judging that the service system function verification result is passed.
Further, the method according to claim 1, wherein the step S3 further includes: and the business transaction is identified and distributed through a distributed route, synchronously sent to a distributed system and a centralized system, and respectively processed.
Further, the data compatibility verification method comprises the following steps:
verifying whether the processing result of the SQL statement of the database of the distributed system is correct or not;
and/or comparing whether the types and the lengths of the fields of the business transactions in the database of the distributed system and the database of the centralized system are consistent;
and/or comparing whether the data content, the data structure and the data entry number in the database of the distributed system and the database of the centralized system are consistent or not;
and/or comparing whether the data of the specific character in the database of the distributed system and the database of the centralized system are consistent.
Furthermore, the transaction calling party initiates a service transaction, and the information of the service transaction comprises component number information, a service transaction code and a branch organization number to which the service belongs;
the method for identifying and distributing through the distributed routing comprises the steps of obtaining a service path of the business transaction, wherein the service path comprises component number information, and obtaining a logic address of the business transaction distributed to a distributed system and a centralized system according to the component number information, a business transaction code and a branch organization number to which the business belongs.
Further, the specific character includes a special character, an attachment class, and a money amount field.
Further, the result of the business processing verification and the result of the data compatibility verification are displayed through a data verification platform.
The invention also relates to a service system function verification system based on data migration, which comprises:
the setting module is used for setting the matching relationship between the label information, the processing node and the verification information and the corresponding label information;
the generation module is used for generating verification information;
the storage module is used for storing label information, processing nodes, verification information, matching relations, business data of different branches, business transaction information, component number information, processing results of business transactions, SQL statements, processing results of SQL statements and data compatibility verification results;
the acquisition module is used for acquiring information of business transaction, a service path of the business transaction and a logic address of a distributed system and a centralized system;
the verification module is used for verifying whether the node information and the label information have a matching relation, whether the service processing results are matched and data compatibility;
a display module for displaying the result of the business processing verification and the result of the data compatibility verification
The invention also relates to a computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the above-mentioned method.
The invention also relates to an electronic device, characterized in that it comprises a processor and a memory;
the memory is used for storing label information, processing nodes, verification information, matching relations, business data of different branches, business transaction information, component number information, processing results of business transactions, SQL statements, processing results of SQL statements and data compatibility verification results;
the processor is configured to execute the computer program stored in the memory and execute the method described above.
The invention also relates to a computer program product comprising a computer program and/or instructions, characterized in that the computer program and/or instructions, when executed by a processor, implement the steps of the above-mentioned method.
The invention has the beneficial effects that:
by adopting the service system function verification method and system based on data migration, aiming at the data storage mode of the distributed sub-database and sub-table and the change of data migration to a new database, two key technologies deeply drill down on the application processing mode and technical characteristics, a matched verification scheme is designed, a black box test method for judging a test result from an application interface is broken, and a database level checking method is designed. Meanwhile, the transaction is accurately forwarded to a centralized or distributed system in real time by taking the distributed application route as the identification and distribution of the nodes according to the database types of different branch organization data, so that a large amount of time is saved.
Drawings
Fig. 1 is a schematic diagram of a service system function verification method based on data migration according to the present invention.
Fig. 2 is a schematic structural diagram of a service system function verification system based on data migration according to the present invention.
Fig. 3 is a schematic diagram illustrating a service processing verification result in an embodiment of the present invention.
FIG. 4 is a diagram illustrating data extraction according to an embodiment of the present invention.
Fig. 5 is a schematic diagram illustrating a result of data compatibility verification according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The first aspect of the present invention relates to a method for verifying a service system function based on data migration, which comprises the following steps:
step one, setting at least one piece of label information in a centralized system, setting at least one processing node in a distributed system, wherein the processing node generates verification information when processing business transactions, and the verification information and the corresponding label information have a matching relationship.
In the system migration execution process, it is generally considered that the original system (corresponding to the centralized system in the method) can correctly process and output the result, and the necessary verification work is whether the new system (corresponding to the distributed system in the method) can also correctly process the corresponding request to obtain the matched result. In the prior art, verification is usually performed by directly comparing the processing results of the original system and the new system. This approach can inherently be used to resolve whether a new system can correctly execute a request, but is not friendly to fault resolution when the results are abnormal. In particular, the new system has a great structural difference from the old system, for example, the centralized system is different from the distributed system in the method, and the difference of the final result only indicates that the new system cannot operate correctly, but the specific fault cause is difficult to distinguish.
From another perspective, the functions that it ultimately needs to perform are consistent whether the old system or the new system is migrated. Although the operation process of the system is not directly comparable due to the difference of the system structures, the positions of key processing nodes in the operation process of the new system and the old system can be positioned through a preset logical matching relationship, and whether the new system is normal when the new system operates to the position of the processing node is judged by verifying the output content of the position of the processing node (or according to preset intercepted operation process information), so that a user can position the fault position of the new system more conveniently.
For example, take an intermediate process of obtaining user account information in operation as an example. It is assumed that the user account information a can be directly obtained during the operation of the old system, but the direct explicit obtaining of the user account information a is not involved in the entire operation of the new system. At this time, a processing node can be located according to the actual operation process of the new system, a data message B can be obtained at the processing node, and the data message B is generated by including the user account information a, so that a logical matching relationship can be set, and when the data message B satisfies the matching relationship, it is indicated that the data message B includes the correct user account information a, thereby indicating that the new system can normally operate at the processing node. Otherwise, the new system is abnormal at the position of the processing node, and the user can check the relevant operation steps in a targeted manner.
Respectively operating service processing verification on the distributed system and the centralized system;
step three, the transaction calling party initiates a service transaction, and when the service transaction runs to a processing node, verification information is generated; specifically, the service transaction is identified and distributed through a distributed route, synchronously sent to a distributed system and a centralized system, and respectively processed, the transaction caller initiates the service transaction, the information of the service transaction includes component number information, a service transaction code and a branch organization number to which the service belongs, a service path of the service transaction is obtained, the service path includes the component number information, and the logic address of the service transaction distributed to the distributed system and the centralized system is obtained according to the component number information, the service transaction code and the branch organization number to which the service belongs.
Specifically, the "distributed application routing" distribution mechanism is that an initiated transaction first obtains a service path through an enterprise-level service bus, where the service path has component number information, such as a component number of the transaction on a distributed architecture is F5001_ DSDF, and a centralized transaction component number is a5001_ DSDF. Different component numbers, business transaction codes and branch agency numbers to which business belongs are combined, and distributed and centralized logic addresses to which the transactions are sent are judged. And aiming at the distributed architecture, data distribution information and available addresses of load balancing services are acquired according to the component numbers and the branch organization numbers in the logical addresses, and are sent to a distributed database through a route.
Step four, matching the verification information with corresponding label information;
when the verification information and the corresponding label information do not accord with the matching relationship, outputting the processing node;
according to the invention, a double-architecture parallel system is constructed, one is a distributed architecture and the other is an original centralized architecture which is put into production and operated, in the traditional method for verifying the function of the service system after data migration, only the service processing results are verified, if the service processing results cannot be matched with each other, the specific error in the operation of the system is inconvenient to search only through the results, and through the embodiment, the matching verification of information is carried out in time in the operation process of the system, the correctness of data migration is not required to be verified according to the processing results after the operation of the system is finished, but the processing nodes with problems are output in time.
Step five, when the verification information and the label information accord with a matching relation, outputting a service processing result of the centralized system and a service processing result of the distributed system;
step six, judging whether the service processing result of the centralized system is matched with the service processing result of the distributed system;
when the service processing result of the centralized system is not matched with the service processing result of the distributed system, outputting the label information, the processing node and the verification information;
step seven, when the service processing result of the centralized system is matched with the service processing result of the distributed system, respectively operating data compatibility verification on the distributed system and the centralized system;
step eight, judging whether the results of the data compatibility verification are matched or not;
verification of data generally includes six aspects. One is data format checking. And checking whether the format of the data is consistent and available, wherein the target data is required to be number type. Second is data length checking. Checking the effective length of the data requires special attention for conversion of the char type field into the varchar type. And thirdly, checking the range of the interval. It is checked whether the data are contained in the interval of the defined maximum and minimum values. For example, an age of 300 or an entry date of 4000-1 is obviously problematic. And four is null, default check. Whether the null values and default values defined by the new system and the old system are the same or not is checked, the definitions of the null values by different database systems can be different, and special attention is needed. Fifthly, integrity check. The data is checked for integrity of association. Such as recording the presence of referenced code values, it is important to note that some systems remove foreign key constraints for efficiency after a period of use. And sixthly, checking consistency. The logical presence of data violating consistency is checked, particularly if there are systems that respectively commit the operations. In this embodiment, the key field includes one or more of the type, length, data content, data structure, number of data entries, and special characters of the field of the business transaction, and the comparison analysis method of the key field includes: verifying whether the processing result of the SQL statement of the database of the distributed system is correct or not; and/or comparing whether the types and the lengths of the fields of the business transactions in the database of the distributed system and the database of the centralized system are consistent; and/or comparing whether the data content, the data structure and the data entry number in the database of the distributed system and the database of the centralized system are consistent or not; and/or comparing whether the data of the specific character in the database of the distributed system and the database of the centralized system are consistent.
Specifically, after the centralized DB2 database is replaced with the distributed database, the interaction between the application and the new database is a key point of the functional verification. The verification method after the distributed database is replaced is divided into four methods: 1. when the application interacts with the database, the SQL sentences are checked to be correctly processed, and each SQL sentence can accurately operate data to a corresponding database table according to the program instruction; 2. and acquiring the type and length of each field in the business transaction, and accurately performing database table operation on each instruction data through SQL statements executed by an application program. Executing SQL sentences through a tool platform, acquiring elements such as the content and the length of each field of the service in a new database, and comparing the filed content in storage with the field content completely consistent after being updated to the database; 3. and migrating a part of the historical inventory data from the centralized DB2 database to a new database, and designing a migration script to import the data into the new database. After migration, the data content is consistent with the content of the original database, the number of data items in the two databases is completely consistent, and after migration to the new database, the content of a plurality of data with the same table structure in each database fragment is the same and consistent; 4. acquiring service type input specific service element data, and performing compatibility verification on two databases, wherein specific characters comprise: special characters, accessory classes, and fields of extra large or extra small amount can be compatible with the novel database. When the data compatibility verification result is matched, judging that the service system function verification result is passed
And the service processing verification result and the data compatibility verification result are displayed through a data verification platform. Specifically, the data verification platform extracts various data in the distributed and centralized databases according to certain rules, and data comparison, data analysis and data query functions are realized.
Aiming at the comparison and analysis of the results of the business processing verification, a corresponding relation table of the business types and the centralized database table is established, namely which database table the business relates to. And then establishing a corresponding relation table of the service type and the distributed database table. Key information such as a service name, a transaction operator number, an initiating organization number, a receiving organization number, a transaction amount, a client initiating name, a client receiving name and the like which need to be inquired is input in a data verification platform interface, the platform inquires data in a plurality of centralized and distributed corresponding database tables respectively, and all field contents in the database tables related to the service are displayed to a tool platform interface. The tester compares the results of the distributed and centralized tests with the interface data, as shown in fig. 3.
On the other hand, for comparison and analysis of the results of data compatibility verification, it is assumed that the data of the distributed database is dispersed in two databases, namely, SPU1 and SPU2, and when data comparison is performed, the data are respectively queried from the centralized OCL1 database and the distributed database.
Specifically, data merging is performed after data extraction by distributed SPU1 and SPU2, in which data items that SPU1 and SPU2 are completely consistent with each other are deduplicated, and new table data SPU 12' is generated in the data validation platform. The database table fields remain unchanged from the original design. Importing the data extracted from centralized OCL1 into a data verification platform as table data OCL1 ', and comparing the number of data pieces of SPU12 ' and OCL1 '; a table of correspondence between the primary key of OCL1 'and the distributed database instance of SPU 12' is established, and each data table in SPU12 'is compared with OCL 1' after being queried based on the primary key, as shown in fig. 4.
And displaying the comparison result through a data verification platform, and establishing a corresponding relation between the centralized table name before migration and the table name imported into the distributed database after migration. By inputting the names of the centralized database tables needing to be compared, the platform automatically associates the distributed corresponding databases and the table names, and then performs comparison between the number of data pieces and the data content, as shown in fig. 5. Another aspect of the present invention also relates to a service system function verification system based on data migration, whose structure is shown in fig. 2, including:
the setting module is used for setting the matching relationship between the label information, the processing node and the verification information and the corresponding label information;
the generation module is used for generating verification information;
the storage module is used for storing label information, processing nodes, verification information, matching relations, business data of different branches, business transaction information, component number information, processing results of business transactions, SQL statements, processing results of SQL statements and data compatibility verification results;
the acquisition module is used for acquiring information of business transaction, a service path of the business transaction and a logic address of the distributed system and the centralized system;
the verification module is used for verifying whether the node information and the label information have a matching relation, whether the service processing results are matched and data compatibility;
and the display module is used for displaying the result of the business processing verification and the result of the data compatibility verification. By using this system, the above-described arithmetic processing method can be executed and a corresponding technical effect can be achieved.
An embodiment of the present invention further provides a computer-readable storage medium capable of implementing all steps in the data migration-based service system function verification method in the foregoing embodiment, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the computer program implements all steps of the data migration-based service system function verification method in the foregoing embodiment.
An embodiment of the present invention further provides an electronic device for executing the method, as an implementation apparatus of the method, the electronic device at least has a processor and a memory, and particularly, the memory stores data and related computer programs required for executing the method, such as tag information, processing nodes, verification information, matching relationships, business data of different branches, business transaction information, component number information, processing results of business transactions, processing results of SQL statements and SQL statements, and data compatibility verification results, and the like, and all steps of the implementation method are executed by calling the data and the programs in the memory by the processor, and corresponding technical effects are obtained.
Preferably, the electronic device may comprise a bus architecture, which may include any number of interconnected buses and bridges linking together various circuits including one or more processors and memory. The bus may also link various other circuits such as peripherals, voltage regulators, power management circuits, and the like, which are well known in the art, and therefore, will not be described any further herein. A bus interface provides an interface between the bus and the receiver and transmitter. The receiver and transmitter may be the same element, i.e., a transceiver, providing a means for communicating with various other systems over a transmission medium. The processor is responsible for managing the bus and general processing, while the memory may be used for storing data used by the processor in performing operations.
Additionally, the electronic device may further include a communication module, an input unit, an audio processor, a display, a power source, and the like. The processor (or controller, operational controls) employed may include a microprocessor or other processor device and/or logic device that receives input and controls the operation of various components of the electronic device; the memory may be one or more of a buffer, a flash memory, a hard drive, a removable medium, a volatile memory, a non-volatile memory or other suitable devices, and may store the above-mentioned related data information, and may also store a program for executing the related information, and the processor may execute the program stored in the memory to realize information storage or processing, etc.; the input unit is used for providing input to the processor, and can be a key or a touch input device; the power supply is used for supplying power to the electronic equipment; the display is used for displaying display objects such as images and characters, and may be an LCD display, for example. The communication module is a transmitter/receiver that transmits and receives signals via an antenna. The communication module (transmitter/receiver) is coupled to the processor to provide an input signal and receive an output signal, which may be the same as in the case of a conventional mobile communication terminal. Based on different communication technologies, a plurality of communication modules, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be disposed in the same electronic device. The communication module (transmitter/receiver) is also coupled to a speaker and a microphone via an audio processor to provide audio output via the speaker and receive audio input from the microphone to implement the usual telecommunication functions. The audio processor may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor is also coupled to the central processor, so that recording on the local machine can be realized through the microphone, and sound stored on the local machine can be played through the loudspeaker.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create a system for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including an instruction system which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks. While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. The service system function verification method based on data migration is characterized by comprising the following steps:
s1, setting at least one label information in a centralized system, setting at least one processing node in a distributed system, wherein the processing node generates verification information when processing business transaction, and the verification information has a matching relation with the corresponding label information;
s2, respectively operating service processing verification on the distributed system and the centralized system;
s3, the transaction calling party initiates the service transaction, and when the service transaction runs to the processing node, verification information is generated;
s4, matching the verification information with corresponding label information;
when the verification information does not accord with the corresponding label information, outputting the processing node;
s5, when the verification information and the label information accord with the matching relationship, outputting the service processing result of the centralized system and the service processing result of the distributed system;
s6, judging whether the service processing result of the centralized system is matched with the service processing result of the distributed system;
when the service processing result of the centralized system is not matched with the service processing result of the distributed system, outputting the label information, the processing node and the verification information;
s7, when the service processing result of the centralized system is matched with the service processing result of the distributed system, respectively running data compatibility verification on the distributed system and the centralized system;
s8, judging whether the data compatibility verification results are matched or not;
and when the data compatibility verification result is matched, judging that the service system function verification result is passed.
2. The method according to claim 1, wherein the step S3 further comprises: and the business transaction is identified and distributed through a distributed route, synchronously sent to a distributed system and a centralized system, and respectively processed.
3. The method of claim 2, wherein the method of data compatibility verification comprises:
verifying whether the processing result of the SQL statement of the database of the distributed system is correct or not;
and/or comparing whether the types and the lengths of the fields of the business transactions in the database of the distributed system and the database of the centralized system are consistent;
and/or comparing whether the data content, the data structure and the data entry number in the database of the distributed system and the database of the centralized system are consistent or not;
and/or comparing whether the data of the specific character in the database of the distributed system and the database of the centralized system are consistent.
4. The method of claim 3, wherein the transaction invoker initiates a business transaction, the information for the business transaction including component number information, a business transaction code, and a branch agency number to which the business belongs;
the method for identifying and distributing through the distributed routing comprises the steps of obtaining a service path of the business transaction, wherein the service path comprises component number information, and obtaining a logic address of the business transaction distributed to a distributed system and a centralized system according to the component number information, a business transaction code and a branch organization number to which the business belongs.
5. The method of claim 4, wherein the specific characters include a special character, an attachment class, and a dollar amount field.
6. The method of claim 1, wherein the results of the business process validation and the results of the data compatibility validation are exposed through a data validation platform.
7. The service system function verification system based on data migration is characterized by comprising the following components:
the setting module is used for setting the matching relationship between the label information, the processing node and the verification information and the corresponding label information;
the generation module is used for generating verification information;
the storage module is used for storing label information, processing nodes, verification information, matching relations, business data of different branches, business transaction information, component number information, processing results of business transactions, SQL statements, processing results of SQL statements and data compatibility verification results;
the acquisition module is used for acquiring information of business transaction, a service path of the business transaction and a logic address of the distributed system and the centralized system;
the verification module is used for verifying whether the node information and the label information have a matching relation, whether the service processing results are matched and data compatibility;
and the display module is used for displaying the result of the business processing verification and the result of the data compatibility verification.
8. A computer-readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when being executed by a processor, carries out the method of any one of claims 1 to 6.
9. An electronic device comprising a processor and a memory,
the memory is used for storing business data, business transaction information, component number information, business transaction processing results, SQL statements, SQL statement processing results and data compatibility verification results of different branches;
the processor, for executing a computer program stored in a memory, performs the method of any of claims 1 to 6.
10. A computer program product comprising a computer program and/or instructions, characterized in that the computer program and/or instructions, when executed by a processor, implement the steps of the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210108821.1A CN114443485A (en) | 2022-01-28 | 2022-01-28 | Service system function verification method and system based on data migration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210108821.1A CN114443485A (en) | 2022-01-28 | 2022-01-28 | Service system function verification method and system based on data migration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114443485A true CN114443485A (en) | 2022-05-06 |
Family
ID=81372431
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210108821.1A Pending CN114443485A (en) | 2022-01-28 | 2022-01-28 | Service system function verification method and system based on data migration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114443485A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117079182A (en) * | 2023-07-31 | 2023-11-17 | 上海启呈信息科技有限公司 | Pipe network management method and system based on big data analysis |
-
2022
- 2022-01-28 CN CN202210108821.1A patent/CN114443485A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117079182A (en) * | 2023-07-31 | 2023-11-17 | 上海启呈信息科技有限公司 | Pipe network management method and system based on big data analysis |
| CN117079182B (en) * | 2023-07-31 | 2024-02-23 | 上海启呈信息科技有限公司 | Pipe network management method and system based on big data analysis |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6185583B1 (en) | Parallel rule-based processing of forms | |
| CN102236672B (en) | A kind of data lead-in method and device | |
| CN111722839B (en) | Code generation method and device, electronic equipment and storage medium | |
| US10560484B2 (en) | Managing access in one or more computing systems | |
| CN108984712A (en) | Counting method, equipment and readable storage medium storing program for executing are made based on business scenario | |
| CN109582550B (en) | Method, device and server for acquiring full-service scene fault set | |
| CN102760096A (en) | Test data generation method, unit testing method and unit testing system | |
| CN112699151B (en) | Data processing method, device, equipment and medium | |
| CN108520019A (en) | Data managing method, device, equipment and computer readable storage medium | |
| CN114443485A (en) | Service system function verification method and system based on data migration | |
| CN106708897B (en) | Data warehouse quality guarantee method, device and system | |
| CN114281803A (en) | Data migration method, device, equipment, medium and program product | |
| CN113297179A (en) | Method and device for processing supervision submission data | |
| CN111290961A (en) | Interface test management method and device and terminal equipment | |
| CN115809228A (en) | Data comparison method and device, storage medium and electronic equipment | |
| US20220035621A1 (en) | Software query information management system and software query information management method | |
| CN109597828A (en) | A kind of off-line data checking method, device and server | |
| CN115600972A (en) | Method, device, equipment and storage medium for verifying and selling of bad assets | |
| CN111639478B (en) | Automatic data auditing method and system based on EXCEL document | |
| CN114238273A (en) | Database management method, device, equipment and storage medium | |
| CN112817931B (en) | Incremental version file generation method and device | |
| CN113094419A (en) | Data analysis system, method, client and storage medium | |
| CN102663614B (en) | Customer relation management is to the collocation method of service release and system | |
| CN111737135A (en) | General test method, device, equipment and storage medium for trusted system | |
| CN112052262A (en) | Method and device for displaying payment order processing line and electronic equipment |
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 |