Open AccessDesign and implementation of a general SQL parser
Author(s) -
Kehe Wu,
Dan Di,
Wei Li,
Wenchao Cui
Publication year - 2021
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/2010/1/012093
Subject(s) - computer science , stored procedure , data definition language , parsing , programming language , sql/psm , sql injection , sql , pl/sql , query by example , data transformation services , syntax , database , natural language processing , information retrieval , web search query , search engine
With the rapid development of computer network, the information security of database becomes more and more important. In database security protection, SQL statements need to be parsed and reconstructed. However, the database audit products on the market lack accurate analysis of SQL statements. Therefore, this paper constructs an SQL parser from four aspects: lexical analysis, syntax analysis, SQL spanning tree optimization and error detection.