Custom Standard SQL Grammer Analysis Model
Li Hai · Mini-micro Systems · 2003
When a project meet the problem of construct custom SQL query, it is very crucial to analysis the SQL clause and give insrtuctional information on the same time.In this paper,we establish a model based on the knowledge of Complier Construction Principles and Logic Algebra.In the model,we define a standard SQL clause object ANSISQLO at fiest,then build many rule.We verify the SQL through two phases: Formal Rule phase and Logic Rule phase.In the paper,We also analysis the nesting SQL clause by building syntax tree and then go through syntax width first and semantic depth first.This model is very usefull for project about custom SQL query.