Database replacement verification method and device, equipment and storage medium
By converting source library instructions into target library instructions and comparing the processing results using a comparison tool, the problem of low accuracy and efficiency in the verification of replacing domestic databases was solved, and fast and accurate database verification was achieved.
Patent Information
- Application Number
- CN202511101792.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-08-07
- Publication Date
- 2025-11-21
AI Technical Summary
In the context of the transformation towards domestic IT innovation, the existing manual verification methods cannot guarantee accuracy and efficiency during the replacement of domestic databases, especially during database version iterations.
The source library instructions are converted to generate target library instructions. The source and target library applications are scheduled to obtain the processing results. The results are then compared using a preset comparison tool to determine the database replacement verification result.
It enables the verification of accuracy and efficiency without human intervention, especially the ability to quickly verify the target database when database versions are frequently iterated.
Smart Images
Figure CN120994730A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of financial technology, and in particular to a database replacement verification method, apparatus, device, and storage medium. Background Technology
[0002] Banking systems generate a large amount of financial data every day, which is generally stored and managed using databases. These databases are usually foreign. However, under the background of information technology innovation transformation, it is necessary to replace foreign databases with domestic databases. In the process of replacing them with domestic databases, not only data migration is involved, but also changes to the underlying business logic code. Therefore, it is necessary to verify the replaced database.
[0003] Currently, the replacement database is typically verified by manually executing multiple commands and then manually judging the correctness of the execution results for each command.
[0004] However, the replaced database often undergoes version iterations, and if verification is carried out manually, the accuracy and efficiency of the verification cannot be guaranteed. Summary of the Invention
[0005] To improve the accuracy and efficiency of database verification, this application provides a database replacement verification method, apparatus, device, and storage medium.
[0006] Firstly, this application provides a database replacement verification method, including:
[0007] Convert source library instructions to obtain target library instructions;
[0008] Based on the source library instructions and the target library instructions, the source library application and the target library application are scheduled to obtain the source library processing result and the target library processing result.
[0009] The comparison results are obtained by comparing the processing results of the source library and the target library based on a preset comparison tool.
[0010] The database replacement verification result is determined based on the comparison results.
[0011] Through the above implementation, target library instructions with the same meaning as source library instructions but applicable only to the target database are first generated. Then, the source library application and the target library application are scheduled respectively using the source library instructions and the target library instructions to obtain the source library processing results corresponding to the source library instructions and the target library processing results corresponding to the target library instructions. Then, by comparing the consistency between the source library processing results and the target library processing results, the target library can be verified, thereby ensuring the accuracy of the verification. Moreover, this verification process does not require manual intervention. When the target database version is frequently iterated, it can achieve rapid verification of the target database, thereby ensuring the efficiency of the verification.
[0012] Preferably, the conversion of source library instructions to target library instructions includes:
[0013] The source library instructions are disassembled to obtain the source instruction statement body and the source instruction operation object;
[0014] The source instruction statement body and the source instruction operation object are converted to obtain the target library instruction.
[0015] Through the above implementation, the source instruction statement body and the source instruction operation object obtained after disassembling the source library instruction are converted respectively; this makes it easier to reassemble the converted results into the target library instruction corresponding to the source library instruction.
[0016] Preferably, the step of converting the source instruction statement body and the source instruction operation object to obtain the target library instruction includes:
[0017] Based on a preset instruction mapping tool, the source instruction statement body and the source instruction operation object are processed to obtain the target instruction statement body and the target instruction operation object;
[0018] Based on the target instruction statement body and the target instruction operation object, the target library instruction is determined.
[0019] Through the above implementation, the source instruction statement body and the source instruction operation object are mapped respectively, which makes it easy to obtain the target instruction statement body and the target instruction operation object applied to the target database, which correspond to the source instruction statement body and the source instruction operation object respectively.
[0020] Preferably, the step of scheduling the source library application and the target library application based on the source library instruction and the target library instruction to obtain the source library processing result and the target library processing result includes:
[0021] Based on the source library instructions and the target library instructions, the source library application and the target library application are scheduled in parallel to obtain the source library processing result and the target library processing result.
[0022] Through the above implementation, the source library application and the target library application are scheduled in parallel, and the efficiency of the source library application and the target library application in processing the corresponding database instructions is improved, thereby improving the database verification efficiency.
[0023] Preferably, the comparison of the source library processing results with the target library processing results based on a preset comparison tool to obtain the comparison results includes:
[0024] Invalid fields are removed from the source library processing results and the target library processing results respectively to obtain the remaining results of the source library and the remaining results of the target library;
[0025] The comparison results are obtained by comparing the remaining results of the source library and the remaining results of the target library using a preset comparison tool.
[0026] By implementing the above methods, invalid fields in the source and target database processing results are removed, which helps prevent invalid fields from affecting the comparison results in subsequent comparison processes.
[0027] Preferably, the comparison of the remaining results of the source library and the remaining results of the target library based on a preset comparison tool to obtain the comparison results includes:
[0028] The data in the remaining results of the source library and the remaining results of the target library are sorted separately to obtain the ordered results of the source library and the ordered results of the target library.
[0029] The comparison results are obtained by comparing the ordered results of the source library and the ordered results of the target library using a preset comparison tool.
[0030] By implementing the above methods, sorting the data in the remaining results of the source database and the remaining results of the target database separately, it is easier to ensure that the data in the source database and the target database that need to be compared in the subsequent steps correspond one-to-one in order, thereby improving the efficiency of verification.
[0031] Secondly, this application provides a database replacement verification device, comprising:
[0032] The instruction conversion module is used to convert source library instructions to target library instructions;
[0033] The program scheduling module schedules the source library application and the target library application based on the source library instructions and the target library instructions to obtain the source library processing result and the target library processing result.
[0034] The results comparison module uses a preset comparison tool to process and compare the processing results of the source library and the processing results of the target library to obtain the comparison results.
[0035] The result verification module uses the comparison results to determine the database replacement verification result.
[0036] Through the above implementation, target library instructions with the same meaning as source library instructions but applicable only to the target database are first generated. Then, the source library application and the target library application are scheduled respectively using the source library instructions and the target library instructions to obtain the source library processing results corresponding to the source library instructions and the target library processing results corresponding to the target library instructions. Then, by comparing the consistency between the source library processing results and the target library processing results, the target library can be verified, thereby ensuring the accuracy of the verification. Moreover, this verification process does not require manual intervention. When the target database version is frequently iterated, it can achieve rapid verification of the target database, thereby ensuring the efficiency of the verification.
[0037] Thirdly, this application provides a computer device, which includes a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the steps in the method described above.
[0038] Fourthly, this application provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps in the above-described method.
[0039] Fifthly, this application also provides a computer program product. The computer program product includes a computer program that, when executed by a processor, implements the steps in any of the above method embodiments.
[0040] The aforementioned database replacement verification method, apparatus, equipment, and storage medium convert source database instructions to target database instructions; based on the source and target database instructions, source and target database applications are scheduled to obtain source and target database processing results; the source and target database processing results are compared using a preset comparison tool to obtain a comparison result; and the database replacement verification result is determined based on the comparison result. Through this implementation, a target database instruction with the same meaning as the source database instruction but applicable only to the target database is first generated. Then, the source and target database applications are scheduled using the source and target database instructions respectively to obtain the source and target database processing results corresponding to the source and target database instructions. By comparing the consistency between the source and target database processing results, the target database can be verified, ensuring accuracy. This verification process requires no manual intervention and allows for rapid verification even when the target database version is frequently iterated, thus ensuring efficiency.
[0041] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of this application, nor is it intended to limit the scope of this application. Other features of this application will become readily apparent from the following description. Attached Figure Description
[0042] To more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings used in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of the present invention and should not be regarded as a limitation on the scope. For those skilled in the art, other related drawings can be obtained based on these drawings without creative effort.
[0043] Figure 1 This is a flowchart of a database replacement verification method provided in the embodiments of this application;
[0044] Figure 2 This is a schematic diagram of the structure of a database replacement verification device provided in the embodiments of this application;
[0045] Figure 3 This is a schematic diagram of the structure of a computer device provided in an embodiment of this application;
[0046] Figure 4 This is an internal structural diagram of a computer-readable storage medium provided in an embodiment of this application. Detailed Implementation
[0047] To make the objectives, technical solutions, and advantages of this disclosure clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this disclosure.
[0048] It should be noted that the terms "first," "second," etc., used in the specification, claims, and accompanying drawings herein are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, apparatus, product, or device that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or devices.
[0049] In this article, the term "and / or" is merely a description of the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A alone, A and B simultaneously, and B alone. Additionally, the character " / " in this article generally indicates that the preceding and following related objects have an "or" relationship.
[0050] Example 1
[0051] Figure 1 This is a flowchart of a database replacement verification method provided in Embodiment 1 of this application, for reference. Figure 1 The method can be executed by a device that performs the method, which can be implemented in software and / or hardware, and the method includes:
[0052] S110. Convert the source library instructions to obtain the target library instructions.
[0053] In the context of accelerating the replacement of foreign databases with domestic ones, the banking system still uses foreign databases for the storage and management of financial data before the complete replacement with domestic databases is achieved. Before using domestic databases to completely replace foreign databases, the domestic databases need to be verified to ensure that they are functioning properly and can store and manage financial data normally.
[0054] In this embodiment, the foreign database currently used by the banking system is designated as the source database, and the domestic database used to replace the foreign database is designated as the target database. This embodiment aims to verify the functionality of the domestic database by comparing the results generated after executing the same instructions in the source database and the target database. To this end, this embodiment predetermines the existence of such an instruction, which is generated according to the database statement requirements of the source database, and designates this instruction as the source database instruction. It should be noted that different databases use different database statements. The source database application used to operate the source database can use the source database instruction to operate the source database, but the target database application used to operate the target database cannot use the source database instruction to operate the target database. In order to verify the functionality of the domestic database by comparing the results generated after executing the same instructions in the source database and the target database, it is necessary to control the target database application to operate the target database using an instruction with the same meaning as the source database instruction. In this embodiment, the source database instruction is converted into the target database instruction by using a preset instruction conversion tool.
[0055] S120. Based on the source library instruction and the target library instruction, schedule the source library application and the target library application to obtain the source library processing result and the target library processing result.
[0056] The source library application is a program used to receive source library instructions and operate on the source database, and the target library application is a program used to receive target library instructions and operate on the target database. The processing result obtained by the source library application through processing source library instructions to operate on the source database is recorded as the source library processing result, and the processing result obtained by the target library application through processing target library instructions to operate on the target database is recorded as the target library processing result.
[0057] S130. Based on a preset comparison tool, the processing results of the source library and the processing results of the target library are compared to obtain a comparison result.
[0058] The preset comparison tool is used to compare the consistency between the processing results of the source library and the processing results of the target library, and the consistency found is recorded as the comparison result.
[0059] S140. Determine the database replacement verification result based on the comparison result.
[0060] The comparison results are used to characterize the similarity between the processing results of the source database and the processing results of the target database. If the similarity is high, it indicates that the function of the target database is better, and the database replacement verification result is that the target database verification is passed. If the similarity is low, it indicates that the function of the target database is worse, and the database replacement verification result is that the target database verification is failed. To measure whether the similarity is high, this embodiment presets a similarity threshold. For example, the similarity threshold is 0.98. If the similarity is greater than the similarity threshold, it indicates that the similarity is high; otherwise, it indicates that the similarity is low.
[0061] It should be noted that this embodiment first generates target library instructions that have the same meaning as source library instructions but are only applicable to the target database. Then, the source library application and the target library application are scheduled respectively using the source library instructions and the target library instructions to obtain the source library processing results corresponding to the source library instructions and the target library processing results corresponding to the target library instructions. Then, by comparing the consistency between the source library processing results and the target library processing results, the target library can be verified, thereby ensuring the accuracy of the verification. Moreover, this verification process does not require manual intervention. When the target database version is frequently iterated, it can achieve rapid verification of the target database, thereby ensuring the efficiency of the verification.
[0062] Example 2
[0063] This application provides a database replacement verification method in Embodiment 2, which optimizes the "conversion of source database instructions to obtain target database instructions" in Embodiment 1. It should be noted that for parts not detailed in this embodiment, please refer to the descriptions in other embodiments. The method includes:
[0064] S211. Disassemble the source library instructions to obtain the source instruction statement body and the source instruction operation object.
[0065] Database instructions include the instruction statement body and the instruction operation object; for example, a database instruction is "SELECT name FROM A", which means to query the name field from table A, where "SELECT XXX FROM XXX" is the instruction statement body, and "name" and "A" are the instruction operation objects; the source database instruction can be decomposed by a preset statement decomposition tool to obtain the source instruction statement body and source instruction operation object corresponding to the source database instruction.
[0066] S212. The source instruction statement body and the source instruction operation object are converted to obtain the target library instruction.
[0067] The preset instruction conversion tool can convert the source instruction statement body and the source instruction operation object to obtain the target library instruction. The target library instruction is used for execution by the target library application. The target library instruction and the source library instruction are different in form but have the same meaning.
[0068] Through the above implementation, the source instruction statement body and the source instruction operation object obtained after disassembling the source library instruction are converted respectively; this makes it easier to reassemble the converted results into the target library instruction corresponding to the source library instruction.
[0069] S220. Based on the source library instruction and the target library instruction, schedule the source library application and the target library application to obtain the source library processing result and the target library processing result.
[0070] S230. Based on a preset comparison tool, the processing results of the source library and the processing results of the target library are compared to obtain a comparison result.
[0071] S240. Determine the database replacement verification result based on the comparison result.
[0072] Example 3
[0073] This application provides a database replacement verification method in Embodiment 3, which optimizes the "conversion of the source instruction statement body and the source instruction operation object to obtain the target library instruction" in Embodiment 1. It should be noted that for parts not detailed in this embodiment, please refer to the descriptions in other embodiments. The method includes:
[0074] S311. Disassemble the source library instructions to obtain the source instruction statement body and the source instruction operation object.
[0075] S312A. Based on a preset instruction mapping tool, the source instruction statement body and the source instruction operation object are processed to obtain the target instruction statement body and the target instruction operation object.
[0076] The preset instruction mapping tools specifically include an instruction statement body mapping tool and an operation object mapping tool. The instruction statement body mapping tool is used to process the source instruction statement body, that is, to map the source instruction statement body to the target instruction statement body, wherein the target instruction statement body conforms to the target database statement syntax. The operation object mapping tool is used to process the source instruction operation object, that is, to map the source instruction operation object to the target instruction operation object, wherein the target instruction operation object is the instruction operation object name marked in the target database.
[0077] S312B. Based on the target instruction statement body and the target instruction operation object, determine the target library instruction.
[0078] Specifically, the target instruction operation object is inserted into the corresponding position in the body of the target instruction statement, thereby reconstructing a new instruction, which is recorded as the target library instruction. The target library instruction is used for execution by the target database application.
[0079] Through the above implementation, the source instruction statement body and the source instruction operation object are mapped respectively, which makes it easy to obtain the target instruction statement body and the target instruction operation object applied to the target database, which correspond to the source instruction statement body and the source instruction operation object respectively.
[0080] S320. Based on the source library instruction and the target library instruction, schedule the source library application and the target library application to obtain the source library processing result and the target library processing result.
[0081] S330. Based on a preset comparison tool, the processing results of the source library and the processing results of the target library are compared to obtain a comparison result.
[0082] S340. Determine the database replacement verification result based on the comparison result.
[0083] Example 4
[0084] This application provides a database replacement verification method in Embodiment 4, which optimizes the "scheduling of source database application and target database application based on the source database instruction and the target database instruction to obtain source database processing result and target database processing result" in Embodiment 1. It should be noted that for parts not detailed in this embodiment, please refer to the descriptions in other embodiments. The method includes:
[0085] S410: Convert the source library instructions to obtain the target library instructions.
[0086] S420. Based on the source library instructions and the target library instructions, the source library application and the target library application are scheduled in parallel to obtain the source library processing result and the target library processing result.
[0087] Parallel scheduling means simultaneously sending source library instructions to the source library application and target library instructions to the target library application; then, it also simultaneously controls the source library application to execute source library instructions and controls the target library application to execute target library instructions.
[0088] The source library application and the target library application are scheduled in parallel, and the efficiency of the source library application and the target library application in processing the corresponding database instructions is improved, thereby improving the database verification efficiency.
[0089] S430. Based on a preset comparison tool, the processing results of the source library and the processing results of the target library are compared to obtain a comparison result.
[0090] S440. Determine the database replacement verification result based on the comparison result.
[0091] Example 5
[0092] This application provides a database replacement verification method in Embodiment 5, which optimizes the "processing and comparing the source database processing result with the target database processing result based on a preset comparison tool to obtain a comparison result" in Embodiment 1. It should be noted that for parts not detailed in this embodiment, please refer to the descriptions in other embodiments. The method includes:
[0093] S510: Convert the source library instructions to obtain the target library instructions.
[0094] S520. Based on the source library instruction and the target library instruction, schedule the source library application and the target library application to obtain the source library processing result and the target library processing result.
[0095] S531. Remove invalid fields from the source library processing results and the target library processing results respectively to obtain the source library remaining results and the target library remaining results.
[0096] In this case, both the source database processing result and the target database processing result may contain invalid fields. For example, the source database processing result contains fields including name and age, and the target database processing result contains fields including name and organization. If the field that needs to be compared between the source database processing result and the target database processing result is the name field, then the age field is an invalid field in the source database processing result, and the organization field is an invalid field in the target database processing result.
[0097] Specifically, determine the fields to be compared in the source database processing results and the target database processing results, such as the "name field" mentioned above. Then, mark other fields in the source database processing results and the target database processing results that are not the fields to be compared as invalid fields. After that, remove the invalid fields from the source database processing results and the target database processing results respectively. The new result obtained after removing the invalid fields from the source database processing results is recorded as the source database remaining result, and the new result obtained after removing the invalid fields from the target database processing results is also recorded as the target database remaining result.
[0098] By removing invalid fields from the source and target database processing results, it is easier to prevent invalid fields from affecting the comparison results in subsequent comparison processes.
[0099] S532. Based on a preset comparison tool, the remaining results of the source library and the remaining results of the target library are compared to obtain the comparison results.
[0100] The remaining results of the source library and the remaining results of the target library can be compared with a preset comparison tool to obtain the comparison results.
[0101] S540. Determine the database replacement verification result based on the comparison result.
[0102] Example 6
[0103] This application provides a database replacement verification method in Embodiment Six, which optimizes the "processing and comparing the remaining results of the source database and the remaining results of the target database based on a preset comparison tool to obtain the comparison result" in Embodiment Five. It should be noted that for parts not detailed in this embodiment, please refer to the descriptions in other embodiments. The method includes:
[0104] S610: Convert the source library instructions to obtain the target library instructions.
[0105] S620. Based on the source library instruction and the target library instruction, schedule the source library application and the target library application to obtain the source library processing result and the target library processing result.
[0106] S631. Remove invalid fields from the source library processing results and the target library processing results respectively to obtain the source library remaining results and the target library remaining results.
[0107] S632A. Sort the data in the remaining results of the source library and the remaining results of the target library respectively to obtain the ordered results of the source library and the ordered results of the target library.
[0108] It should be noted that the data in both the source database and the target database are in an unordered state. For example, the source database's remaining results include A2, A1, and A3, while the target database's remaining results are a3, a2, and a1. Subsequent comparisons are performed sequentially; however, A2 and a3, A1 and a2, and A3 and a1 are not corresponding pairs of data. Therefore, it is necessary to sort the data in both the source and target databases separately. The sorted results from the source database are recorded as ordered results, and the sorted results from the target database are also recorded as ordered results. For example, the ordered results from the source database are A1, A1, and A3, while the ordered results from the target database are a1, a2, and a3.
[0109] By sorting the data in the remaining results of the source database and the remaining results of the target database respectively, it is easier to ensure that the data in the source database and the target database correspond one-to-one in order when they need to be compared later, thereby improving the efficiency of verification.
[0110] S632B: Based on a preset comparison tool, the ordered results of the source library and the ordered results of the target library are compared to obtain the comparison results.
[0111] The preset comparison tool is used to compare the data in the ordered results of the source library and the ordered results of the target library in sequence. For example, A1 is compared with a1, A2 with a2, and A3 with a3 in sequence. In the above three comparisons, each group has a corresponding comparison result, and the comparison result includes two possibilities: consistent and inconsistent. The number of groups with consistent comparison results is determined, and then the proportion of the number of groups in the total number of groups is calculated and recorded as the comparison result.
[0112] S640. Determine the database replacement verification result based on the comparison result.
[0113] It should be understood that although the steps in the flowcharts of the embodiments described above are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the embodiments described above may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.
[0114] Example 7
[0115] Based on the same inventive concept, this embodiment also provides a database replacement verification device for implementing the database replacement verification method described above. The solution provided by this device is similar to the solution described in the above method; therefore, the specific limitations in one or more embodiments of the database replacement verification device provided below can be found in the limitations of the database replacement verification method described above, and will not be repeated here.
[0116] In this embodiment, as Figure 2 As shown, a database replacement verification device is provided, comprising:
[0117] The instruction conversion module is used to convert source library instructions to target library instructions;
[0118] The program scheduling module schedules the source library application and the target library application based on the source library instructions and the target library instructions to obtain the source library processing result and the target library processing result.
[0119] The results comparison module uses a preset comparison tool to process and compare the processing results of the source library and the processing results of the target library to obtain the comparison results.
[0120] The result verification module uses the comparison results to determine the database replacement verification result.
[0121] The modules in the aforementioned database replacement verification device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in the processor of a computer device in hardware form or independent of it, or stored in the memory of the computer device in software form, so that the processor can call and execute the operations corresponding to each module.
[0122] It should be noted that this embodiment first generates target library instructions that have the same meaning as source library instructions but are only applicable to the target database. Then, the source library application and the target library application are scheduled respectively using the source library instructions and the target library instructions to obtain the source library processing results corresponding to the source library instructions and the target library processing results corresponding to the target library instructions. Then, by comparing the consistency between the source library processing results and the target library processing results, the target library can be verified, thereby ensuring the accuracy of the verification. Moreover, this verification process does not require manual intervention. When the target database version is frequently iterated, it can achieve rapid verification of the target database, thereby ensuring the efficiency of the verification.
[0123] In an optional embodiment, the instruction conversion module is specifically used for converting source library instructions into target library instructions:
[0124] The source library instructions are disassembled to obtain the source instruction statement body and the source instruction operation object;
[0125] The source instruction statement body and the source instruction operation object are converted to obtain the target library instruction.
[0126] In an optional embodiment, in converting the source instruction statement body and the source instruction operation object to obtain the target library instruction, the instruction conversion module is specifically used for:
[0127] Based on a preset instruction mapping tool, the source instruction statement body and the source instruction operation object are processed to obtain the target instruction statement body and the target instruction operation object;
[0128] Based on the target instruction statement body and the target instruction operation object, the target library instruction is determined.
[0129] In an optional embodiment, regarding scheduling the source library application and the target library application based on the source library instruction and the target library instruction to obtain the source library processing result and the target library processing result, the program scheduling module is specifically used for:
[0130] Based on the source library instructions and the target library instructions, the source library application and the target library application are scheduled in parallel to obtain the source library processing result and the target library processing result.
[0131] In an optional embodiment, in obtaining comparison results by comparing the processing results of the source library and the processing results of the target library based on a preset comparison tool, the result comparison module is specifically used for:
[0132] Invalid fields are removed from the source library processing results and the target library processing results respectively to obtain the remaining results of the source library and the remaining results of the target library;
[0133] The comparison results are obtained by comparing the remaining results of the source library and the remaining results of the target library using a preset comparison tool.
[0134] In an optional embodiment, in processing the comparison of the remaining results of the source library and the remaining results of the target library based on a preset comparison tool to obtain the comparison results, the result comparison module is specifically used for:
[0135] The data in the remaining results of the source library and the remaining results of the target library are sorted separately to obtain the ordered results of the source library and the ordered results of the target library.
[0136] The comparison results are obtained by comparing the ordered results of the source library and the ordered results of the target library using a preset comparison tool.
[0137] Example 8
[0138] In this embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows. Figure 3As shown, the computer device includes a processor, memory, and a network interface connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The database stores data. The network interface communicates with external terminals via a network connection. When executed by the processor, the computer program implements a database replacement verification method.
[0139] Those skilled in the art will understand that Figure 3 The structure shown is merely a block diagram of a portion of the structure related to the present disclosure and does not constitute a limitation on the computer device to which the present disclosure is applied. A specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.
[0140] Example 9
[0141] In this embodiment, a computer-readable storage medium is provided, such as... Figure 4 As shown, a computer program is stored thereon, and when the computer program is executed by the processor, it implements the steps in the above-described method embodiments.
[0142] Example 10
[0143] In this embodiment, a computer program product is provided, including a computer program that, when executed by a processor, implements the steps in the above-described method embodiments.
[0144] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this disclosure are all information and data authorized by the user or fully authorized by all parties.
[0145] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this disclosure can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this disclosure may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this disclosure may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.
[0146] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0147] The embodiments described above are merely illustrative of several implementations of this disclosure, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent disclosure. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this disclosure, and these all fall within the protection scope of this disclosure. Therefore, the protection scope of this disclosure should be determined by the appended claims.
Claims
1. A database replacement verification method, characterized in that, include: Convert source library instructions to obtain target library instructions; Based on the source library instructions and the target library instructions, the source library application and the target library application are scheduled to obtain the source library processing result and the target library processing result. The comparison results are obtained by comparing the processing results of the source library and the target library based on a preset comparison tool. The database replacement verification result is determined based on the comparison results.
2. The method according to claim 1, characterized in that, The process of converting source library instructions to target library instructions includes: The source library instructions are disassembled to obtain the source instruction statement body and the source instruction operation object; The source instruction statement body and the source instruction operation object are converted to obtain the target library instruction.
3. The method according to claim 2, characterized in that, The conversion between the source instruction statement body and the source instruction operation object to obtain the target library instruction includes: Based on a preset instruction mapping tool, the source instruction statement body and the source instruction operation object are processed to obtain the target instruction statement body and the target instruction operation object; Based on the target instruction statement body and the target instruction operation object, the target library instruction is determined.
4. The method according to claim 1, characterized in that, The step of scheduling the source library application and the target library application based on the source library instruction and the target library instruction to obtain the source library processing result and the target library processing result includes: Based on the source library instructions and the target library instructions, the source library application and the target library application are scheduled in parallel to obtain the source library processing result and the target library processing result.
5. The method according to claim 1, characterized in that, The comparison results obtained by processing the source library and the target library using a preset comparison tool include: Invalid fields are removed from the source library processing results and the target library processing results respectively to obtain the remaining results of the source library and the remaining results of the target library; The comparison results are obtained by comparing the remaining results of the source library and the remaining results of the target library using a preset comparison tool.
6. The method according to claim 5, characterized in that, The comparison results, obtained by processing and comparing the remaining results of the source library and the remaining results of the target library using a preset comparison tool, include: The data in the remaining results of the source library and the remaining results of the target library are sorted separately to obtain the ordered results of the source library and the ordered results of the target library. The comparison results are obtained by comparing the ordered results of the source library and the ordered results of the target library using a preset comparison tool.
7. A database replacement verification device, characterized in that, The device includes: The instruction conversion module is used to convert source library instructions to target library instructions; The program scheduling module schedules the source library application and the target library application based on the source library instructions and the target library instructions to obtain the source library processing result and the target library processing result. The results comparison module uses a preset comparison tool to process and compare the processing results of the source library and the processing results of the target library to obtain the comparison results. The result verification module uses the comparison results to determine the database replacement verification result.
8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 6.
9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 6.
10. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 6.