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

1. 发明申请

US20060288052A1 Supporting multiple versions of a routine 有权
公开(公告)号：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.

2. 发明申请

US20070143249A1 System and method for deploying an SQL procedure 有权
标题翻译：用于部署SQL过程的系统和方法
公开(公告)号：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过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

3. 发明申请

US20070055644A1 Global dynamic variable storage for SQL procedures 审中-公开
标题翻译：用于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).
摘要翻译：公开了一种使用驻留在数据库系统中完全执行的过程的方法和系统。该过程利用至少一个具有多个属性的变量。该方法和系统包括在调用该过程之前将至少一个变量定义为至少一个全局变量。定义全局变量包括向数据库系统通知变量的多个属性并允许数据库系统访问至少一个变量。该方法和系统还包括跟踪全局变量。

4. 发明授权

US07580958B2 Supporting multiple versions of a routine 有权
标题翻译：支持多个版本的例程
公开(公告)号：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语句，该例程的第二个版本被激活。

5. 发明授权

US07711746B2 System and method for deploying an SQL procedure 有权
标题翻译：用于部署SQL过程的系统和方法
公开(公告)号：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过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

6. 发明申请

US20080155641A1 METHOD AND SYSTEM MANAGING A DATABASE SYSTEM USING A POLICY FRAMEWORK 审中-公开
标题翻译：使用政策框架的数据库系统的方法和系统管理
公开(公告)号：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.
摘要翻译：描述了一种用于管理计算机系统的方法和系统。该方法和系统包括使用策略管理器来定义和存储策略。一方面，策略管理器也激活和解决策略之间的冲突。该策略是由计算机系统执行的指令的声明性声明。该方法和系统还包括使用策略执行器来确定对策略是否覆盖对计算机系统的请求。该方法和系统还包括利用计算机系统执行策略的指示，如果该请求被策略执行者所涵盖。

7. 发明申请

US20070219973A1 Dynamic statement processing in database systems 审中-公开
标题翻译：数据库系统中的动态语句处理
公开(公告)号：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.
摘要翻译：提供了一种用于处理数据库系统中的动态语句的方法，计算机程序产品和系统。所述方法，计算机程序产品和系统提供用于当动态语句与先前由系统处理的多个动态语句中的一个动态语句匹配时计算与动态语句相关联的第一组特征，比较与动态语句相关联的第一组特征语句到与针对一个先前处理的动态语句生成的一个或多个访问路径之一相关联的第二组特征，以及当第一组特征与第二组的特征比较时，利用一个访问路径来执行动态语句特性满足一个或多个预定标准。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式