专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US5875334A System, method, and program for extending a SQL compiler for handling control statements packaged with SQL query statements 失效
标题翻译：用于扩展SQL编译器以处理用SQL查询语句打包的控制语句的系统，方法和程序
公开(公告)号：US5875334A
公开(公告)日：1999-02-23
申请号：US548969
申请日：1995-10-27
申请人： Jyh-Herng Chow , You-Chin (Gene) Fuh , Nelson Mendonca Mattos , Brian T. Tran
发明人： Jyh-Herng Chow , You-Chin (Gene) Fuh , Nelson Mendonca Mattos , Brian T. Tran
IPC分类号： G06F9/45 , G06F17/30
CPC分类号： G06F17/30415 , G06F17/30433 , G06F8/427 , G06F8/433 , G06F8/443
摘要： This invention provides an integrated compiler for compiling SQL3 control statements having procedural, i.e., control, information packaged together with query, i.e., non-procedural, statements. A query extractor contained within the parser extracts the query statement from the control statement leaving a control skeleton. The query statement is processed as usual through a query compiler for generating executable plans with the exception that the name resolution function for resolving variables is modified for looking up local variables. This modification takes into account the mapping of local and host variables to create a unification of local and host variables. The control skeleton is processed through a control analyzer which generates a representation of the control flow and a scope and symbol table. The control analyzer also unifies the local and host variables. A plan synthesizer then takes as input the control flow information, symbol tables, and individual executable plans for the query statements and generates a meta-plan comprising a merger of a top level plan for the control skeleton and sub-plans representing the executable plans of the query statement. Therefore, this invention provides a uniform way of treating local and host variables, provides an efficient way of performing bind-in/bind-out processes, creates a single execution plan requiring only a single run-time interpreter, and requires minimum enhancements to existing SQL2 compilers. In addition, this invention enables the application of global optimization techniques for optimizing both the control aspects and query aspects of the original control statement.
摘要翻译：本发明提供了一种用于编译具有程序化即控制信息的SQL3控制语句的集成编译器，其中包含与查询（即非程序语句）一起打包的信息。解析器中包含的查询提取器从控制语句中提取查询语句，留下控制框架。查询语句通常通过用于生成可执行计划的查询编译器进行处理，但用于解析变量的名称解析功能被修改用于查找局部变量。此修改考虑了本地和主机变量的映射，以创建本地和主机变量的统一。控制骨架通过控制分析器进行处理，控制分析器生成控制流的表示以及范围和符号表。控制分析仪还统一了本地和主机变量。然后，计划合成器将查询语句的控制流信息，符号表和各个可执行计划作为输入，并生成包含控制框架的顶层计划的合并和表示可执行计划的子计划的元计划查询语句。因此，本发明提供了一种统一的方法来处理本地和主机变量，提供了一种执行绑定/绑定过程的有效方法，创建一个仅需要单个运行时解释器的单个执行计划，并且需要对现有的 SQL2编译器。另外，本发明能够应用全局优化技术来优化原始控制语句的控制方面和查询方面。

IPRDB

热门服务

关于我们

友情链接

联系方式