Program script processing method and device, and server

Abstract

The embodiment of the invention relates to the technical field of databases and discloses a program script processing method, device and equipment. The method comprises steps of acquiring the programscript information; extracting key features from the program script information; performing anomaly detection on the key features; intercepting or correcting the program script of which the detectionresult is abnormal; and executing the intercepted or corrected program script. The method is advantaged in that the abnormal scripts are intercepted or corrected, exception checking efficiency is improved, and consumption of executing illegal SQL by the database is reduced under the condition that a large number of users request to access.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of databases, and in particular, to a program script processing method, device, and server. Background technique [0002] At present, the business running on the structured database in the system architecture of communication service provision is basically the core business, such as Oracle or SQL Server database, mainly including business, accounting and other businesses that have obvious perception of user experience. system. Since these systems carry the core business of mobile, the online processing volume is large, the data interaction is frequent, and the real-time requirements of the system are very high, and they are business systems with very strict requirements on performance indicators. How to ensure the superior performance of the business system under such a trend is a very important topic at present. [0003] As database applications become more and more widespread, it of...

AI Technical Summary

Problems solved by technology

[0003] As database applications become more and more widely used, it often occurs that due to improperly written SQL or grammatical errors in application development, frequent parsing of wrong SQL is required under high frequency, which impacts the database memory and seriously affects the business system.

Moreover, with the rapid growth of business, the amount of data has increased sharply. Due to the small amount of data in the development stage and the lack of concurrency, potential performance threats cannot be found in the test during the development stage. Moreover, the quality of developers is currently uneven, and inefficient SQL is extremely Destructive. In many production systems, a single SQL written carelessly by programmers may cause huge hidden dangers in performance.

Images