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

1. 发明授权

US06847962B1 Analyzing, optimizing and rewriting queries using matching and compensation between query and automatic summary tables 有权
标题翻译：使用查询和自动汇总表之间的匹配和补偿来分析，优化和重写查询
公开(公告)号：US06847962B1
公开(公告)日：2005-01-25
申请号：US09502821
申请日：2000-02-11
申请人： Roberta Jo Cochrane , George Lapis , Ting Yu Leung , Mark A. Paskin , Mir Hamid Pirahesh , Yang Sun , Monica Sachiye Urata , Markos Zaharioudakis
发明人： Roberta Jo Cochrane , George Lapis , Ting Yu Leung , Mark A. Paskin , Mir Hamid Pirahesh , Yang Sun , Monica Sachiye Urata , Markos Zaharioudakis
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method, apparatus, and article of manufacture for optimizing database queries using a derived summary table, wherein a definition of the summary table is based on a full select statement, including, but not limited to, a derived table involving nested GROUP BY operations and complex HAVING clauses with subqueries or joins, that is materialized in the table and describes how the summary table was derived. A query is analyzed using matching/compensation tests between the query and the definition of the summary table (that is, a query by itself) to determine whether expressions occurring anywhere in the query, but not in the summary table, can be derived using either the content in the summary table alone, or after combining (through some relational operator) the content of the summary table with other base tables, and hence the query is subsumed by or overlaps with the summary table definition.
摘要翻译：一种用于使用导出的摘要表优化数据库查询的方法，装置和制品，其中所述汇总表的定义基于完整的选择语句，包括但不限于涉及嵌套的GROUP BY操作的导出表，以及具有子查询或联接的复杂HAVING子句，在表中实现，并描述了汇总表的派生方式。使用查询和汇总表的定义（即自身的查询）之间的匹配/补偿测试来分析查询，以确定查询中任何地方（而不是摘要表中）中发生的表达式是否可以使用汇总表中的内容，或者通过一些关系运算符将汇总表的内容与其他基表合并，因此该查询被归纳或与汇总表定义重叠。

2. 发明授权

US08583672B1 Displaying multiple spelling suggestions 有权
标题翻译：显示多个拼写建议
公开(公告)号：US08583672B1
公开(公告)日：2013-11-12
申请号：US13087323
申请日：2011-04-14
申请人： Mark A. Paskin , Kelly Poon , Yew Jin Lim , Jon M. Wiley , Jonathan J. Effrat
发明人： Mark A. Paskin , Kelly Poon , Yew Jin Lim , Jon M. Wiley , Jonathan J. Effrat
IPC分类号： G06F17/30
CPC分类号： G06F17/30864 , G06F17/3064
摘要： Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for presenting spelling suggestions. In one aspect, a method includes receiving first search results for a first search query and a plurality of spelling suggestions for a first term in the first search query, wherein the first search results are provided by a search engine as a response to the first search query; displaying the plurality of spelling suggestions and the first search results in a user interface; receiving a user input selecting one of the plurality of spelling suggestions; transmitting data identifying the selected spelling suggestion to request second search results for a second search query comprising the selected spelling suggestion from the search engine; and displaying the second search results in place of the first search results in the user interface.
摘要翻译：方法，系统和装置，包括在计算机存储介质上编码的计算机程序，用于呈现拼写建议。一方面，一种方法包括接收第一搜索查询的第一搜索结果和针对第一搜索查询中的第一项的多个拼写建议，其中第一搜索结果由搜索引擎提供作为对第一搜索的响应查询; 在用户界面中显示多个拼写建议和第一搜索结果; 接收选择所述多个拼写建议之一的用户输入; 发送标识所选择的拼写建议的数据，以便为搜索引擎中包含所选择的拼写建议的第二搜索查询请求第二搜索结果; 以及在所述用户界面中显示所述第二搜索结果来代替所述第一搜索结果。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式