Online structured query language script processing method and apparatus

Abstract

An embodiment of the invention discloses an online structured query language (SQL) script processing method. The method comprises the steps of obtaining an online SQL script of a current processing file in a file list; reviewing an SQL statement in the online SQL script, and outputting error information, wherein the error information comprises position information and an error explanation of an error SQL statement or an error annotation in the online SQL script, and the error information is used for prompting an operator to modify the error SQL statement or the error annotation; and for standard SQL statements passing the review, according to the statement types of the standard SQL statements, performing splitting and combination on the standard SQL statements in processing files of the file list. An embodiment of the invention discloses an online SQL script processing apparatus.

Description

technical field [0001] The present invention relates to the field of databases, in particular to a method and device for processing structured query language (Structured Query Language, SQL) scripts. Background technique [0002] Large-scale enterprise information technology (Information Technology, IT) systems are huge and complex, and business requirements are strong. In order to quickly respond to new functional requirements, the IT system needs to be launched quickly and frequently iteratively. Most of the new functional requirements will involve changes in the IT system data model (Data Model), so every time a new functional requirement is launched, the physical model of the database supporting the IT system may be changed. [0003] The normal IT system online process is generally divided into four links: requirement analysis, development, testing, and online. In the online link, it is necessary to execute several online SQL scripts of the database to change the physica...

AI Technical Summary

Problems solved by technology

[0006] (1) High labor costs: Due to the large number of online SQL scripts involved in each IT system launch, for example, each daily launch of the telecom BSS (Basic Service Set) system will involve at least dozens of business requirements, several The change and release of hundreds of SQL scripts requires a large number of database development administrators to test and optimize the online SQL scripts, resulting in high labor costs.

[0007] (2) The quality of the online SQL scripts cannot be guaranteed: due to the inconsistent understanding of the developers on the specification documents on which the online SQL scripts are written, the quality of the online SQL scripts written is uneven, and the database development administrators are not sure about the compliance of the online SQL scripts. Performance testing also depends entirely on personal experience and judgment, and it is difficult to fully control the quality of online SQL scripts

[0008] (3) The execution efficiency of the online SQL scripts is not high: the existing technology only checks the compliance of the SQL statements in the online SQL scripts, and does not optimize the online SQL scripts such as merging. During the process of launching the online SQL scripts, due to the intricate relationship between the online SQL scripts, the database development administrator needs to copy and paste a large number of online SQL scripts into the execution box. During the copying and pasting operations, it is difficult to ensure that no errors occur in the online SQL scripts , at the same time, copying and pasting operations take a lot of execution time, so the execution efficiency of the database online SQL script is not high

[0009] To sum up, when the existing manual method is used to review the online SQL script, there are problems such as high labor cost, unguaranteed quality of the online SQL script, and low execution efficiency, which affect the online progress of the IT system.

Images