公开(公告)号：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).

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

公开(公告)号：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.

公开(公告)号：US07711746B2

公开(公告)日：2010-05-04

申请号：US11311810

申请日：2005-12-17

申请人： Margaret Ann Bernal ,  Yao-Ching Stephen Chen ,  Ding-Wei Chieh ,  Curt Lee Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Marion B. Farber ,  Georgia Carroll Fuller ,  Joe Cheng-yu Huang ,  Hui-An Lee ,  Claire Willey McFeely ,  Chunfeng Pei ,  James Willis Pickel ,  Yumi Kimura Tsuji ,  Jay A. Yothers ,  Margaret Alice Zagelow ,  Liyan Zhou

发明人： Margaret Ann Bernal ,  Yao-Ching Stephen Chen ,  Ding-Wei Chieh ,  Curt Lee Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Marion B. Farber ,  Georgia Carroll Fuller ,  Joe Cheng-yu Huang ,  Hui-An Lee ,  Claire Willey McFeely ,  Chunfeng Pei ,  James Willis Pickel ,  Yumi Kimura Tsuji ,  Jay A. Yothers ,  Margaret Alice Zagelow ,  Liyan Zhou

IPC分类号： G06F7/00

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

公开(公告)号：US07580958B2

公开(公告)日：2009-08-25

申请号：US11156509

申请日：2005-06-17

申请人： Yao-Ching Stephen Chen ,  Curt Lee Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Joe Cheng-yu Huang ,  Claire Willey McFeely ,  Robert Thomas Miller ,  Manogari Nogi Simanjuntak ,  Yumi Kimura Tsuji ,  Xiaoyu Yang ,  Jay A. Yothers ,  Margaret Alice Zagelow

发明人： Yao-Ching Stephen Chen ,  Curt Lee Cotner ,  Baoqiu Cui ,  Tammie Dang ,  Joe Cheng-yu Huang ,  Claire Willey McFeely ,  Robert Thomas Miller ,  Manogari Nogi Simanjuntak ,  Yumi Kimura Tsuji ,  Xiaoyu Yang ,  Jay A. Yothers ,  Margaret Alice Zagelow

IPC分类号： G06F12/00 ,  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.

摘要翻译： 提供了用于支持例程的版本的技术。 创建例程的第一个版本。 响应于接收到包含add version子句的alter语句，生成该例程的第二个版本。 响应于接收到包含activate version子句的alter语句，该例程的第二个版本被激活。

公开(公告)号：US20080155641A1

公开(公告)日：2008-06-26

申请号：US11614024

申请日：2006-12-20

申请人： Thomas A. Beavin ,  Baoqiu Cui ,  You-Chin Fuh ,  William Y. Kyu ,  Adarsh R. Pannu ,  Lin Qiao ,  Basuki N. Soetarman

发明人： Thomas A. Beavin ,  Baoqiu Cui ,  You-Chin Fuh ,  William Y. Kyu ,  Adarsh R. Pannu ,  Lin Qiao ,  Basuki N. Soetarman

IPC分类号： G06F17/00

CPC分类号： G06F16/217 ,  G06F16/21

摘要： A method and system for managing a computer system are described. The method and system include defining and storing a policy using a policy manager. In one aspect, the policy manager also activates and resolves conflicts between policies. The policy is a declarative statement of a directive to be carried out by the computer system. The method and system also include using a policy executor to determine whether a request to the computer system is covered by the policy. The method and system further include utilizing the computer system to carry out the directive for the policy if the request is covered by the policy through a policy enforcer.

摘要翻译： 描述了一种用于管理计算机系统的方法和系统。 该方法和系统包括使用策略管理器来定义和存储策略。 一方面，策略管理器也激活和解决策略之间的冲突。 该策略是由计算机系统执行的指令的声明性声明。 该方法和系统还包括使用策略执行器来确定对策略是否覆盖对计算机系统的请求。 该方法和系统还包括利用计算机系统执行策略的指示，如果该请求被策略执行者所涵盖。

公开(公告)号：US20070219973A1

公开(公告)日：2007-09-20

申请号：US11377328

申请日：2006-03-15

申请人： Baoqiu Cui ,  You-Chin Fuh ,  Jeff Sullivan ,  Yoichi Tsuji ,  Li Xia

发明人： Baoqiu Cui ,  You-Chin Fuh ,  Jeff Sullivan ,  Yoichi Tsuji ,  Li Xia

IPC分类号： G06F17/30

CPC分类号： G06F16/2435

摘要： A method, computer program product, and system for processing dynamic statements in a database system are provided. The method, computer program product, and system provide for calculating a first set of characteristics associated with a dynamic statement when the dynamic statement matches one of a plurality of dynamic statements previously processed by the system, comparing the first set of characteristics associated with the dynamic statement to a second set of characteristics associated with one of one or more access paths generated for the one previously processed dynamic statement, and utilizing the one access path to execute the dynamic statement when the comparison of the first set of characteristics to the second set of characteristics satisfies one or more predetermined criteria.

摘要翻译： 提供了一种用于处理数据库系统中的动态语句的方法，计算机程序产品和系统。 所述方法，计算机程序产品和系统提供用于当动态语句与先前由系统处理的多个动态语句中的一个动态语句匹配时计算与动态语句相关联的第一组特征，比较与动态语句相关联的第一组特征 语句到与针对一个先前处理的动态语句生成的一个或多个访问路径之一相关联的第二组特征，以及当第一组特征与第二组的特征比较时，利用一个访问路径来执行动态语句 特性满足一个或多个预定标准。