Method for quickly detecting impact caused by database modification to current service

Abstract

The present invention discloses a method for quickly detecting impacts caused by database modifications to the current services. The method comprises the following steps: a) installing in a test environment an operating system and database software that are the same as a production system; b) synchronizing metadata in the database of the production system to the database in the test environment, collecting statistics for SQL information more relevant to data sheet modifications and synchronizing the SQL information to the database in the test environment; c) simulating in the database in the test environment the modifications to be made in the database of the production system, and generating an execution plane after the modification; and d) comparing and analyzing performance changes in the test environment before and after the modification, and acquiring SQL statements whose access is affected. According to the method for quickly detecting impacts caused by database modifications to the current services provided by the present invention, a test environment that is the same as the production environment does not need to be set up, thereby preventing a large amount of time and huge human costs needed for synchronization of massive data, and accurately and quickly detecting impacts caused by the database modifications to the current services.

Description

technical field [0001] The invention relates to a database processing method, in particular to a method for quickly detecting the impact of database changes on existing services. Background technique [0002] During the operation and maintenance of large-scale information systems, the addition and modification of functions and the performance optimization of some modules are routine tasks, such as the mobile BOSS system, the launch of new services, and the change of phone bill plans. To complete these tasks, it may be necessary to change the table structure and index structure of the database, such as adding, modifying, and deleting fields and indexes in tables, which may cause poor execution efficiency of database access statements and affect the normal business functions of the system . In order to avoid this situation, it is necessary to perform a performance test on the change in the test environment before implementing the database change. The test verifies the stabili...

AI Technical Summary

Problems solved by technology

Since the existing large-scale information system (BOSS system) includes at least multiple layers such as presentation layer, business logic layer, and data layer, and involves multiple development languages ​​and middleware, the architecture is very complex, so it is very difficult to design a good use case. Access statements related to database changes can only be accurately covered by designing a large number of test cases

[0004] The testing scheme of the existing technology is an end-to-end test from the periphery. It is necessary to build a test environment the same as the production environment, including the database environment, middleware environment, network environment, application program, etc., requiring a lot of manpower and material resources, and will also Time consuming and not suitable for such routine system changes

Moreover, due to the complexity of the large-scale information system structure, it is very difficult to find out the modules and function points related to database changes, so it is difficult for test cases to accurately cover the impact points of database changes, and the test results cannot be guaranteed. There are many unknown risks

Images