Database version package detection method and device

Abstract

The invention provides a database version package detection method and device, relates to the field of database maintenance, can be applied to the financial field and other fields, and comprises the following steps: obtaining all downloaded file data in a downloading directory of a database target application, and identifying the downloaded file data according to a preset rule to obtain a version package file; analyzing the version package file identification through a preset database statement identification template to obtain a database version issuing statement; performing error correction verification on the database edition issuing statement according to a preset statement rule to obtain a verification result; performing risk identification on the database edition issuing statement through a preset risk statement identifier according to the verification result, and comparing an identification result with a preset corresponding table to obtain an early warning strategy; and associating the early warning strategy with a database version issuing statement corresponding to the identification result to generate early warning information, and providing the early warning information to a predetermined position.

Description

technical field [0001] The invention relates to the field of database maintenance and can be applied to the financial field and other fields, in particular to a database version package detection method and device. Background technique [0002] In order to adapt to the rapid changes in the market, continue to provide customers with more convenient and high-quality services, and seize the first share of the market, there are currently many iterations of R&D projects in the financial industry, agile product development, and heavy project testing have greatly increased the operation and maintenance requirements of the test center. Therefore, it is no longer possible to manually review version content as before. After the test center receives a large number of version packages every day, only the programs in the version packages of the database are completely visible, and the installation error rate is high. In order to reduce the error rate of version loading and identify prod...

AI Technical Summary

Problems solved by technology

[0004] 1. With the rapid iteration of the project, a large number of versions have increased, and the workload has doubled. Without increasing manpower, manual version checking takes too long;

[0005] 2. The accuracy of manual version checking depends on the work experience of the checker;

[0006] 3. The number of versions is large, the human brain cannot remember the release history, and the release version number cannot be quickly retrieved when developing programs, analyzing problems, and tracking problems

Images