公开(公告)号：US20060288052A1

公开(公告)日：2006-12-21

申请号：US11156509

申请日：2005-06-17

申请人： Yao-Ching Chen ,  Curt Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Joe Huang ,  Claire McFeely ,  Robert Miller ,  Manogari Simanjuntak ,  Yumi Tsuji ,  Xiaoyu Yang ,  Jay Yothers ,  Margaret Zagelow

发明人： Yao-Ching Chen ,  Curt Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Joe Huang ,  Claire McFeely ,  Robert Miller ,  Manogari Simanjuntak ,  Yumi Tsuji ,  Xiaoyu Yang ,  Jay Yothers ,  Margaret Zagelow

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99952 ,  Y10S707/99953

摘要： Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.

公开(公告)号：US20070143249A1

公开(公告)日：2007-06-21

申请号：US11311810

申请日：2005-12-17

申请人： Margaret Bernal ,  Yao-Ching Chen ,  Ding-Wei Chieh ,  Curt Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Marion Farber ,  Georgia Fuller ,  Joe Huang ,  Hui-An Lee ,  Claire McFeely ,  Chunfeng Pei ,  James Pickel ,  Yumi Tsuji ,  Jay Yothers ,  Margaret Zagelow ,  Liyan Zhou

发明人： Margaret Bernal ,  Yao-Ching Chen ,  Ding-Wei Chieh ,  Curt Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Marion Farber ,  Georgia Fuller ,  Joe Huang ,  Hui-An Lee ,  Claire McFeely ,  Chunfeng Pei ,  James Pickel ,  Yumi Tsuji ,  Jay Yothers ,  Margaret Zagelow ,  Liyan Zhou

IPC分类号： G06F17/30

CPC分类号： G06F17/30587

摘要： An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.

摘要翻译： SQL过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。 在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑 零件。 在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。 系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。 系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

公开(公告)号：US20070055644A1

公开(公告)日：2007-03-08

申请号：US11222884

申请日：2005-09-08

申请人： Margaret Bernal ,  Yao-Ching Chen ,  Ding-Wei Chieh ,  Christopher Crone ,  Baoqiu Cui ,  Tammie Dang ,  Marion Farber ,  Fen-Ling Lin ,  Chunfeng Pei ,  Yumi Tsuji ,  Jay Yothers ,  Liyan Zhou

发明人： Margaret Bernal ,  Yao-Ching Chen ,  Ding-Wei Chieh ,  Christopher Crone ,  Baoqiu Cui ,  Tammie Dang ,  Marion Farber ,  Fen-Ling Lin ,  Chunfeng Pei ,  Yumi Tsuji ,  Jay Yothers ,  Liyan Zhou

IPC分类号： G06F17/30

CPC分类号： G06F16/2453 ,  G06F16/24549

摘要： A method and system for using a procedure residing and executed entirely within a database system is disclosed. The procedure utilizes at least one variable, which has a plurality of attributes. The method and system include defining the at least one variable as at least one global variable prior to calling of the procedure. Defining the global variable(s) includes informing the database system of the plurality of attributes of the variable(s) and allowing the database system access to the at least one variable. The method and system also include tracking the global variable(s).

摘要翻译： 公开了一种使用驻留在数据库系统中完全执行的过程的方法和系统。 该过程利用至少一个具有多个属性的变量。 该方法和系统包括在调用该过程之前将至少一个变量定义为至少一个全局变量。 定义全局变量包括向数据库系统通知变量的多个属性并允许数据库系统访问至少一个变量。 该方法和系统还包括跟踪全局变量。

公开(公告)号：US20050065926A1

公开(公告)日：2005-03-24

申请号：US10669749

申请日：2003-09-24

申请人： Yao-Ching Chen ,  Ding-Wei Chieh ,  Huong Tran ,  Yumi Tsuji ,  Guogen Zhang

发明人： Yao-Ching Chen ,  Ding-Wei Chieh ,  Huong Tran ,  Yumi Tsuji ,  Guogen Zhang

IPC分类号： G06F17/30

CPC分类号： G06F17/30454 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization includes: (a) combining join predicates from a query with local predicates from each branch of one or more UNION ALL views referenced by the query; (b) analyzing the combined predicates; and (c) not generating the join when the analysis step indicates that the combined predicates lead to an empty result.

摘要翻译： 一种用于优化计算机系统中的查询的方法，装置和制品，其中所述查询由所述计算机系统执行以从存储在所述计算机系统上的数据库中检索数据。 优化包括：（a）将来自查询的连接谓词与来自查询引用的一个或多个UNION ALL视图的每个分支的本地谓词组合; （b）分析合并谓词; 和（c）当分析步骤指示组合的谓词导致空的结果时，不产生连接。

公开(公告)号：US20050138010A1

公开(公告)日：2005-06-23

申请号：US10744633

申请日：2003-12-22

申请人： Margaret Bernal ,  Karelle Cornwell ,  Hsuiying Cheng ,  Yao-Ching Chen ,  Christopher Crone ,  Fen-Ling Lin ,  James Pickel ,  Yumi Tsuji ,  Julie Watts

发明人： Margaret Bernal ,  Karelle Cornwell ,  Hsuiying Cheng ,  Yao-Ching Chen ,  Christopher Crone ,  Fen-Ling Lin ,  James Pickel ,  Yumi Tsuji ,  Julie Watts

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30463

摘要： A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.

摘要翻译： 一种用于生成用于在单个进程中从数据库更新和检索数据的执行计划的方法包括：由服务器接收用第一组数据更新数据库的语句，并从数据库中检索第二组数据; 构建第一个执行计划，用第一组数据更新数据库; 构建第二个执行计划以从数据库中检索第二组数据; 并构建包括第一和第二执行计划的组合的单个执行计划。 单个执行计划允许通过客户端和数据库之间的接口的单个​​交叉来更新和检索数据。 通过以这种方式执行这两个功能，在数据库上执行这样的任务的效率显着增加。

公开(公告)号：US20050165751A1

公开(公告)日：2005-07-28

申请号：US10764286

申请日：2004-01-23

申请人： Patrick Bossman ,  Lee-Chin Hsu Liu ,  Jerry Mukai ,  Yumi Tsuji

发明人： Patrick Bossman ,  Lee-Chin Hsu Liu ,  Jerry Mukai ,  Yumi Tsuji

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30451 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

摘要： A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization is performed by identifying a correlated subquery in the query that qualifies for transformation, transitively closing a local filtering predicate within the identified correlated subquery that is on a same column as a correlation join predicate within the identified correlated subquery, and pulling out or bubbling up the transitively closed predicate from the correlated subquery to a parent query block of the query.

摘要翻译： 一种用于优化计算机系统中的查询的方法，装置和制品，其中所述查询由所述计算机系统执行以从存储在所述计算机系统上的数据库中检索数据。 优化是通过识别查询中的相关子查询来进行的，该相关子查询符合转换规则，在识别的相关子查询中传递性地关闭与所识别的相关子查询中的关联连接谓词在同一列上的本地过滤谓词，并且拉出或冒泡 将关联子查询的过渡关闭谓词提升到查询的父查询块。