公开(公告)号：US07984024B2

公开(公告)日：2011-07-19

申请号：US12140994

申请日：2008-06-17

申请人： Patrick Dooling Bossman ,  You-Chin Fuh ,  Chan-Hua Liu

发明人： Patrick Dooling Bossman ,  You-Chin Fuh ,  Chan-Hua Liu

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

CPC分类号： G06F17/30536 ,  G06F17/30306 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99945

摘要： Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.

摘要翻译： 公开了一种维护统计的技术。 接收到查询。 执行列组生成以形成一个或多个列组。 基于针对先前接收到的查询生成的统计数据执行列组细化。 统计检查自动执行。 生成统计信息收集命令，获取统计信息。

公开(公告)号：US07885953B2

公开(公告)日：2011-02-08

申请号：US11866907

申请日：2007-10-03

申请人： Ying-lin Chen ,  You-Chin Fuh ,  Wei Han ,  Fen-Ling Lin ,  Inderpal Singh Narang ,  Lin Qiao ,  Vijayshankar Raman ,  Kouhorng Allen Yang

发明人： Ying-lin Chen ,  You-Chin Fuh ,  Wei Han ,  Fen-Ling Lin ,  Inderpal Singh Narang ,  Lin Qiao ,  Vijayshankar Raman ,  Kouhorng Allen Yang

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

CPC分类号： G06F17/30498

摘要： A method, storage server, and computer readable medium for off-loading star-join operations from a host information processing system to a storage server. At least a first and second set of keys from a first and second dimension table, respectively are received from a host system. Each of the first and second set of keys is associated with at least one fact table. A set of locations associated with a set of foreign key indexes are received from the host system. A set of fact table indexes are traversed. At least a first set of Row Identifiers (“RIDs”) associated with the first set of keys and at least a second set of RIDs associated with the second set of keys are identified. An operation is performed on the first and second sets of RIDs to identify an intersecting set of RIDs. The intersecting set of RIDs are then stored.

摘要翻译： 一种用于从主机信息处理系统到存储服务器的卸载星形连接操作的方法，存储服务器和计算机可读介质。 分别从主机系统接收来自第一和第二维度表的至少第一和第二组密钥。 第一组和第二组中的每一个与至少一个事实表相关联。 从主机系统接收与一组外键索引相关联的一组位置。 遍历一组事实表索引。 识别与第一组密钥相关联的至少第一组行标识符（“RID”）和与第二组密钥相关联的至少第二组RID。 对第一和​​第二组RID执行操作以识别RID的交叉集合。 然后存储相交的RID集合。

公开(公告)号：US20100114868A1

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

申请号：US12255520

申请日：2008-10-21

申请人： Thomas A. Beavin ,  Patrick D. Bossman ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

发明人： Thomas A. Beavin ,  Patrick D. Bossman ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

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

CPC分类号： G06F17/30463

摘要： An apparatus, system, and method are disclosed for improving query execution plan efficiency in a database management system. The present invention binds both static database queries and dynamic database queries to new query execution plans (QEPs) that produce the same result set as a former QEP bound to the database queries. Next, the present invention identifies one of the former QEPs and the new QEP as an active QEP and automatically collects execution statistics for one of the former QEPs and the new QEP. Finally, the present invention automatically selects one of the former QEPs and the new QEP as the active QEP in response to completion of the automatic collection of execution statistics, the active QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the active QEP selected based on the execution statistics.

摘要翻译： 公开了一种用于提高数据库管理系统中的查询执行计划效率的装置，系统和方法。 本发明将静态数据库查询和动态数据库查询绑定到新的查询执行计划（QEP），该查询执行计划（QEP）产生与数据库查询绑定的前一个QEP相同的结果集。 接下来，本发明将前一个QEP和新的QEP之一识别为活动QEP，并自动收集前一个QEP和新的QEP之一的执行统计信息。 最后，本发明响应于完成执行统计的自动收集而自动选择前者QEP和新QEP中的一个作为活动QEP，选择活动QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比，基于执行统计信息选择活动QEP。

公开(公告)号：US07644063B2

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

申请号：US11840703

申请日：2007-08-17

申请人： Patrick D. Bossman ,  Frank D. Bower ,  John J. Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terrence P. Purcell

发明人： Patrick D. Bossman ,  Frank D. Bower ,  John J. Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terrence P. Purcell

IPC分类号： G06F17/30

CPC分类号： G06F17/30474

摘要： An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.

摘要翻译： 公开了一种用于确保数据库管理系统中的查询执行计划稳定性的装置，系统和方法。 本发明将静态数据库查询绑定到新的查询执行计划（QEP），该计划产生与绑定到静态数据库查询的原始QEP相同的结果集。 接下来，本发明将原始QEP和新QEP中的一个标识为主QEP，并自动收集原始QEP和新QEP的执行统计信息。 最后，本发明响应于完成执行统计的自动收集而自动选择原始QEP和新QEP中的一个作为主QEP，选择主QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比，基于执行统计信息选择主要QEP。

公开(公告)号：US20090083233A1

公开(公告)日：2009-03-26

申请号：US12276104

申请日：2008-11-21

申请人： You-Chin Fuh ,  Ping Wang ,  Li Xia ,  Binghua Zhen

发明人： You-Chin Fuh ,  Ping Wang ,  Li Xia ,  Binghua Zhen

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

CPC分类号： G06F17/30864 ,  G06F17/30657 ,  Y10S707/99933

摘要： Techniques are provided for processing a query using an index. It is determined whether a number of consecutive keys that evaluate to a false-positive when applying a screening predicate in the query exceeds a false-positive predefined value. One or more keys in the index are skipped in response to determining that the number of consecutive keys exceeds the false-positive predefined value.

摘要翻译： 提供了使用索引处理查询的技术。 确定在查询中应用筛选谓词时评估为假阳性的多个连续密钥是否超过假阳性预定义值。 响应于确定连续键的数量超过假阳性预定义值，跳过索引中的一个或多个键。

公开(公告)号：US20090049012A1

公开(公告)日：2009-02-19

申请号：US11840703

申请日：2007-08-17

申请人： Patrick D. Bossman ,  Frank D. Bower ,  John J, Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

发明人： Patrick D. Bossman ,  Frank D. Bower ,  John J, Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

IPC分类号： G06F17/30

CPC分类号： G06F17/30474

摘要： An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.

摘要翻译： 公开了一种用于确保数据库管理系统中的查询执行计划稳定性的装置，系统和方法。 本发明将静态数据库查询绑定到新的查询执行计划（QEP），该计划产生与绑定到静态数据库查询的原始QEP相同的结果集。 接下来，本发明将原始QEP和新QEP中的一个标识为主QEP，并自动收集原始QEP和新QEP的执行统计信息。 最后，本发明响应于完成执行统计的自动收集而自动选择原始QEP和新QEP中的一个作为主QEP，选择主QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比，基于执行统计信息选择主要QEP。

公开(公告)号：US07487140B2

公开(公告)日：2009-02-03

申请号：US10320909

申请日：2002-12-17

申请人： Yao-Ching Chen ,  You-Chin Fuh ,  Allan B. Lebovitz ,  Li-Mey Lee ,  Fen-Ling Lin ,  Lee-Chin Hsu Liu ,  Yun Wang ,  Binghua Zhen

发明人： Yao-Ching Chen ,  You-Chin Fuh ,  Allan B. Lebovitz ,  Li-Mey Lee ,  Fen-Ling Lin ,  Lee-Chin Hsu Liu ,  Yun Wang ,  Binghua Zhen

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99933 ,  Y10S707/99937

摘要： A method for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method of the present invention includes providing a first DISTINCT operation on a first DISTINCT key, storing data fetched from the first DISTINCT operation in a master workfile if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations for the other DISTINCT keys.

摘要翻译： 公开了一种用于执行查询以访问存储在数据库中的数据的方法，其中所述查询包括多个DISTINCT键。 本发明的方法包括在第一DISTINCT密钥上提供第一DISTINCT操作，如果需要多于一个排序处理来执行查询，则将从第一DISTINCT操作获取的数据存储在主工作文件中，以及利用主工作文件执行 对其他DISTINCT键的后续DISTINCT操作。

公开(公告)号：US07480649B2

公开(公告)日：2009-01-20

申请号：US11176601

申请日：2005-07-06

申请人： You-Chin Fuh ,  Ping Wang ,  Li Xia ,  Binghua Zhen

发明人： You-Chin Fuh ,  Ping Wang ,  Li Xia ,  Binghua Zhen

IPC分类号： G06F7/00

CPC分类号： G06F17/30864 ,  G06F17/30657 ,  Y10S707/99933

摘要： Techniques are provided for processing a query using an index. It is determined whether a number of consecutive keys that evaluate to a false-positive when applying a screening predicate in the query exceeds a false-positive predefined value. One or more keys in the index are skipped in response to determining that the number of consecutive keys exceeds the false-positive predefined value.

摘要翻译： 提供了使用索引处理查询的技术。 确定在查询中应用筛选谓词时评估为假阳性的多个连续密钥是否超过假阳性预定义值。 响应于确定连续键的数量超过假阳性预定义值，跳过索引中的一个或多个键。

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

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

公开(公告)号：US20080091647A1

公开(公告)日：2008-04-17

申请号：US11766759

申请日：2007-06-21

申请人： Liang GAO ZHONG ,  Kun Peng Ren ,  Chan-Hua Liu ,  You-Chin Fuh ,  Ke Wei Wei ,  Wen Yang ,  Bing Jiang Sun

发明人： Liang GAO ZHONG ,  Kun Peng Ren ,  Chan-Hua Liu ,  You-Chin Fuh ,  Ke Wei Wei ,  Wen Yang ,  Bing Jiang Sun

IPC分类号： G06F7/00

CPC分类号： G06F16/2453

摘要： The application relates to a tool and a method for customizing hint. According to the invention, provided is at least one hint service adapter configured to collect relevant information of different database platforms, validate customized hint on real database platforms and provide feedback, and deploy the customized hint on database platform. Also provided is hint defining means configured to customize hint independently of database platforms, and providing customized hint to the at least one hint service adapter.

摘要翻译： 该应用涉及一种用于自定义提示的工具和方法。 根据本发明，提供了至少一个提示服务适配器，其被配置为收集不同数据库平台的相关信息，验证真实数据库平台上的定制提示并提供反馈，并在数据库平台上部署定制提示。 还提供了提示定义装置，被配置为独立于数据库平台定制提示，并且向至少一个提示服务适配器提供定制提示。