SQL parsing method based on regular and string cutting

Abstract

The invention discloses a SQL parsing method based on regularity and character string cutting, which relates to the technical field of SQL database. By splitting the original SQL statement into keywords, type format validation and field resolution, you can get a generic SQL statement, support for compatibility with all database operations, therefore, it reduces the developer's use cost of SQL. Inaddition, by parsing SQL statements to get table and table field structure, we can create our own database model (modeling) according to the parsed field information, so as to remove the hidden dangers of foreign databases such as IOE.

Description

technical field [0001] The invention relates to the technical field of SQL databases, in particular to an SQL parsing method based on regularization and character string cutting. Background technique [0002] At present, many enterprises use existing SQL databases for data storage. However, the types of SQL databases of each company are also different, including hivesql, mysql, sqllite, sqlserver, oracle, etc. For different types of SQL databases, the same intention The SQL syntax used for the operation will also be different, which greatly increases the developer's cost of using SQL. However, due to the increase in the cost of using SQL, the program cannot carefully filter the data entered by the user. Therefore, with the continuous injection of SQL data, the existing SQL database cannot meet the increasingly advanced security requirements, resulting in illegal data intrusion into the system. As a result, the enterprise suffers huge property losses, so the problem of SQL d...

AI Technical Summary

Problems solved by technology

[0002] At present, many enterprises use existing SQL databases for data storage. However, the types of SQL databases of each company are also different, including hivesql, mysql, sqllite, sqlserver, oracle, etc. For different types of SQL databases, the same intention The SQL syntax used for the corresponding operation will also be different, which greatly increases the developer's cost of using SQL

However, due to the increase in the cost of using SQL, the program cannot carefully filter the data entered by the user. Therefore, with the continuous injection of SQL data, the existing SQL database cannot meet the increasingly advanced security requirements, resulting in illegal data intrusion into the system. As a result, the enterprise suffered huge property losses, so the problem of SQL data security needs to be solved urgently

[0003] In addition, the SQL database currently used in my country is provided by foreign countries. Since the Prism Gate incident in 2013, the Chinese government has realized the importance of government data security and has also strengthened the work on government data security. The problem of going to IOE needs to be solved urgently

Images