公开(公告)号：US5930795A

公开(公告)日：1999-07-27

申请号：US786603

申请日：1997-01-21

申请人： Yao-Ching Stephen Chen ,  Jyh-Herng Chow ,  Roberta Jo Cochrane ,  Gene Y.C. Fuh ,  Nelson Mendonca Mattos ,  Mir Hamid Pirahesh ,  Jeffrey D. Richey ,  Brian Thinh-Vinh Tran ,  Tuong Chanh Truong

发明人： Yao-Ching Stephen Chen ,  Jyh-Herng Chow ,  Roberta Jo Cochrane ,  Gene Y.C. Fuh ,  Nelson Mendonca Mattos ,  Mir Hamid Pirahesh ,  Jeffrey D. Richey ,  Brian Thinh-Vinh Tran ,  Tuong Chanh Truong

IPC分类号： G06F17/30

CPC分类号： G06F17/30421 ,  G06F17/30474

摘要： A framework for a query compiler and run-time environment for resolving a table reference to a dynamic table that is first identified at run-time but is initially unknown at compile-time. A parser parses the table reference and creates a parsed representation for the table that identifies the type of dynamic table. A code generator creates executable plans containing run-time table object representations (TAOB), from the parsed representations, that contain the type of dynamic table. The TAOB is also extended to provide for parameters that are definable at run-time, including a table ID of the actual table entity being referenced. A routine is embedded in a run-time routine that checks the type of dynamic table in the TAOB and dispatches control to one of a plurality of corresponding routines, depending upon the type of dynamic table. The corresponding routines use the extended TAOB to dynamically link the table reference to the dynamic table, depending upon the type of dynamic table. Once the dynamic table has been linked to the table reference, query processing continues as if that table were a base or derived table.

摘要翻译： 用于查询编译器和运行时环境的框架，用于解析对运行时首先标识但最初在编译时未知的动态表的表引用。 解析器解析表引用，并创建用于标识动态表类型的表的解析表示。 代码生成器从解析的表示形式创建包含运行时表对象表示（TAOB）的可执行计划，其中包含动态表的类型。 TAOB还被扩展以提供在运行时可定义的参数，包括被引用的实际表实体的表ID。 例程被嵌入到运行时程序中，该运行时程序检查TAOB中的动态表的类型，并根据动态表的类型将控制调度到多个相应的例程之一。 相应的例程使用扩展TAOB来动态地将表引用动态链接到动态表，这取决于动态表的类型。 一旦将动态表链接到表引用，查询处理将继续进行，就像该表是基类或派生表一样。