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

1. 发明授权

US08244715B2 System and method for processing database queries 有权
标题翻译：用于处理数据库查询的系统和方法
公开(公告)号：US08244715B2
公开(公告)日：2012-08-14
申请号：US12757639
申请日：2010-04-09
申请人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, Jr.
发明人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, Jr.
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30466
摘要： A system and/or method are implemented to process queries to a database. In particular, the processing of queries to the database is enhanced by enhancing the determination of join orders of tables implicated in queries. Join orders between relatively large numbers of tables are determined by dividing the set of tables to be ordered into a plurality of subsets of tables, and ordering the individual subsets of tables.
摘要翻译：实现一种系统和/或方法来处理对数据库的查询。特别地，通过增强对查询中涉及的表的连接顺序的确定来增强对数据库的查询的处理。通过将要排序的表的集合划分成多个表的子集，并排序各个表的子集来确定相对大数目的表之间的连接顺序。

2. 发明授权

US09183254B1 Optimizing database queries using subquery composition 有权
标题翻译：使用子查询组合优化数据库查询
公开(公告)号：US09183254B1
公开(公告)日：2015-11-10
申请号：US13799126
申请日：2013-03-13
申请人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, Jr.
发明人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, Jr.
IPC分类号： G06F17/30
CPC分类号： G06F17/30451 , G06F17/30339 , G06F17/30442
摘要： A database system optimizes database queries that comprise subqueries. The database system factors out computation from two or more subqueries to a reusable subquery. The reusable subquery returns a result set. The subqueries are rewritten to use the result set and the database query modified to use the rewritten subqueries. The modified database query performs efficiently since the result set is computed only once for each subquery that uses the reusable query. The database system also composes nested subqueries that compute aggregate values. The database system identifies an inner subquery nested within an outer subquery, each subquery computing an aggregate value. The database system determines a new aggregate function corresponding to a composition of aggregate functions of the inner and the outer queries. The database system determines a composed query using the inner query with the outer query. The composed query uses the new aggregate function.
摘要翻译：数据库系统优化包含子查询的数据库查询。数据库系统将计算从两个或多个子查询转换为可重用的子查询。可重用的子查询返回一个结果集。子查询被重写以使用结果集和修改的数据库查询来使用重写的子查询。由于对于使用可重用查询的每个子查询，仅对结果集进行一次计算，所以修改后的数据库查询将会有效执行。数据库系统还构成计算聚合值的嵌套子查询。数据库系统标识嵌套在外部子查询内的内部子查询，每个子查询计算聚合值。数据库系统确定对应于内部和外部查询的聚合函数的组合的新聚合函数。数据库系统使用具有外部查询的内部查询来确定组合查询。组合查询使用新的聚合函数。

3. 发明授权

US08510291B2 System and method for processing database queries 有权
标题翻译：用于处理数据库查询的系统和方法
公开(公告)号：US08510291B2
公开(公告)日：2013-08-13
申请号：US13546989
申请日：2012-07-11
申请人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, Jr.
发明人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, Jr.
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30466
摘要： A system and/or method are implemented to process queries to a database. In particular, the processing of queries to the database is enhanced by enhancing the determination of join orders of tables implicated in queries. Join orders between relatively large numbers of tables are determined by dividing the set of tables to be ordered into a plurality of subsets of tables, and ordering the individual subsets of tables.
摘要翻译：实现一种系统和/或方法来处理对数据库的查询。特别地，通过增强对查询中涉及的表的连接顺序的确定来增强对数据库的查询的处理。通过将要排序的表的集合划分成多个表的子集，并排序各个表的子集来确定相对大数目的表之间的连接顺序。

4. 发明申请

US20110035368A1 System And Method For Processing Database Queries 有权
标题翻译：用于处理数据库查询的系统和方法
公开(公告)号：US20110035368A1
公开(公告)日：2011-02-10
申请号：US12757639
申请日：2010-04-09
申请人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, JR.
发明人： Richard L. Cole , Yijou Chen , William J. McKenna , Sergei Perfilov , Aman Sinha , Eugene Szedenits, JR.
IPC分类号： G06F17/30
CPC分类号： G06F17/30466
摘要： A system and/or method are implemented to process queries to a database. In particular, the processing of queries to the database is enhanced by enhancing the determination of join orders of tables implicated in queries. Join orders between relatively large numbers of tables are determined by dividing the set of tables to be ordered into a plurality of subsets of tables, and ordering the individual subsets of tables.
摘要翻译：实现一种系统和/或方法来处理对数据库的查询。特别地，通过增强对查询中涉及的表的连接顺序的确定来增强对数据库的查询的处理。通过将要排序的表的集合划分成多个表的子集，并排序各个表的子集来确定相对大数目的表之间的连接顺序。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式