通用标准SQL语法分析模型

Custom Standard SQL Grammer Analysis Model

在构造通用 SQL 查询的工程项目中 ,对 SQL 语句准确的分析验证并给出有指导性的错误信息是非常关键的 .本文根据编译原理中的句法分析 ,并利用了逻辑代数的知识和方法建立了一个完善的标准 SQL 验证模型 ,模型中首先定义了一个标准 SQL语句对象 ANSISQL O,然后分别针对句法和文法建立了详尽的规则 ,分 Form al- Rule和L ogic- Rule两个阶段建立 ANSISQL O对象并进行验证 .文中还对嵌套的 SQL 语句做了进一步分析 ,建立了句法树以及句法广度优先和语义深度优先的验证原则 .模型对涉及到通用

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.