SQL script fault recovery method and terminal

Abstract

The invention is suitable for the technical field of databases and provides an SQL script fault recovery method and a terminal. The method comprises the steps of obtaining a script identifier of a faulted SQL script if the faulted SQL script is monitored; according to the script identifier, querying running control files corresponding to the faulted SQL script; based on a pre-stored call resourceoccupation record, determining a corresponding consumption eigenvalue during execution of each running control file and an abnormal consumption ratio corresponding to the faulted SQL script; if the abnormal consumption ratio is greater than a preset ratio threshold, determining that a query factor sequence in the faulted SQL script is abnormal; and if the abnormal consumption ratio is smaller thanor equal to the preset ratio threshold, identifying the running control file with the consumption eigenvalue greater than a preset consumption threshold as a fault control file. The problem that theSQL script fault response efficiency is reduced because manual fault recovery is performed by depending on professional knowledge of maintenance personnel in an existing SQL script fault recovery technology is solved.

Description

technical field [0001] The invention belongs to the technical field of databases, and in particular relates to a method for repairing failures of SQL scripts and a terminal thereof. Background technique [0002] SQL scripts, as a common means of data query, are widely used in the field of network services. The data search strategy of each SQL script is mainly determined by the query factor sequence in the SQL script. The order of the query factors determines which type of keyword to search for first and then which type of keyword to search for when determining data query. Therefore, the order of each query factor in the SQL script will directly determine the efficiency of its operation and the response of the service. speed. On the other hand, in order to improve the efficiency of data query, users can formulate an operation control file for each SQL script according to their own search habits and search purposes. Assign preset parameter values ​​to each query factor in th...

AI Technical Summary

Problems solved by technology

[0004] In view of this, the embodiment of the present invention provides a method for repairing faults of SQL scripts and a terminal thereof, so as to solve the problem of repairing the faults of existing SQL scripts, it is necessary to manually check the SQL scripts contained in the database one by one. The detection efficiency is low, and after detecting the faulty SQL script, it also relies on the professional knowledge of the maintenance personnel to perform manual fault repair, which further reduces the efficiency of the SQL script fault response

Images