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

31. 发明授权

US07447676B2 Method and system of collecting execution statistics of query statements 有权
标题翻译：收集查询语句执行统计信息的方法和系统
公开(公告)号：US07447676B2
公开(公告)日：2008-11-04
申请号：US10420475
申请日：2003-04-21
申请人： Mohamed Zait , Ari Mozes , Cetin Ozbutun
发明人： Mohamed Zait , Ari Mozes , Cetin Ozbutun
IPC分类号： G06F17/30 , G06F15/00
CPC分类号： G06F17/30463 , G06F17/30312 , Y10S707/99933
摘要： A method and system of collecting execution statistics of query statements is disclosed. An execution plan is generated for a query statement in one embodiment of the invention. The execution plan includes one or more operations. One of the one or more operations is selected. The selected execution plan is then executed and a plurality of execution statistics of the selected operation is collected.
摘要翻译：公开了一种收集查询语句执行统计信息的方法和系统。在本发明的一个实施例中为查询语句生成执行计划。执行计划包括一个或多个操作。选择一个或多个操作之一。然后执行所选择的执行计划，并且收集所选择的操作的多个执行统计。

32. 发明申请

US20050240570A1 Partial query caching 有权
标题翻译：部分查询缓存
公开(公告)号：US20050240570A1
公开(公告)日：2005-10-27
申请号：US10830510
申请日：2004-04-22
申请人： Cetin Ozbutun
发明人： Cetin Ozbutun
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99933
摘要： When a query is performed an execution plan is formed, which is made up of a plurality of plan operators. Before executing any given plan operator, a storage area is checked. If a results set has been stored corresponding to the plan operator, then the cached results set is used instead of the executing the plan operator. If no results set exists that corresponds to the particular plan operator, the plan operator is executed, and the results set that is output may be stored for use by another plan operator of another execution plan.
摘要翻译：当执行查询时，形成由多个计划运算符组成的执行计划。在执行任何给定的计划运算符之前，检查存储区域。如果对应于计划运算符存储结果集，则使用缓存的结果集而不是执行计划运算符。如果没有与特定计划运算符相对应的结果集，则执行计划运算符，并且输出的结果集可以存储供另一计划运算符使用。

33. 发明授权

US06546382B1 Finding the TOP N values through the execution of a query 有权
标题翻译：通过执行查询查找TOP N值
公开(公告)号：US06546382B1
公开(公告)日：2003-04-08
申请号：US09433827
申请日：1999-11-03
申请人： Angela Amor , Cetin Ozbutun
发明人： Angela Amor , Cetin Ozbutun
IPC分类号： G06F1730
CPC分类号： G06F17/30451 , G06F17/3053 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A method and mechanism is provided for executing a query that includes a subquery, where the subquery includes an ORDER BY clause. The results generated by executing the subquery are ordered as specified by the ORDER BY clause. When the results of the subquery are referenced by the outer query, the results generated for the subquery satisfy the restriction. For example, the restriction may specify that the row number pseudo-column be less than a threshold. In response, a TOP N operation is performed to return the rows that are TOP N in order. The order is based on the ORDER BY clause.
摘要翻译：提供了一种方法和机制，用于执行包含子查询的查询，其中子查询包含ORDER BY子句。通过执行子查询生成的结果按照ORDER BY子句的指定进行排序。当子查询的结果由外部查询引用时，为子查询生成的结果满足限制。例如，限制可以指定行号伪列小于阈值。作为响应，执行TOP N操作以依次返回TOP N的行。该订单基于ORDER BY子句。

你已经成功收藏专利！

检索式保存成功!

IPRDB