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

1. 发明申请

US20130198164A1 Executing CASE Expressions Containing Subqueries 有权
标题翻译：执行包含子查询的CASE表达式
公开(公告)号：US20130198164A1
公开(公告)日：2013-08-01
申请号：US13358779
申请日：2012-01-26
申请人： Qi Cheng , John F. Hornibrook , Jose A. Saborit , David C. Sharpe , Calisto P. Zuzarte
发明人： Qi Cheng , John F. Hornibrook , Jose A. Saborit , David C. Sharpe , Calisto P. Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30483
摘要： Methods and apparatus, including computer program products, implementing and using techniques for executing a query in a computer to retrieve data from a relational database stored on a data storage device. A query is received that contains a CASE expression having one or more subqueries. A query execution plan is generated. The query execution plan uses a parameterized union all operator to keep the semantics of the CASE expression, and a nested loop join operator to drive data across the section of the query execution plan that executes the CASE expression without performing any join operations. The generated query execution plan is executed in the computer to retrieve data from the relational database.
摘要翻译：方法和装置，包括计算机程序产品，用于在计算机中执行查询以从存储在数据存储设备上的关系数据库中检索数据的实现和使用技术。接收到包含具有一个或多个子查询的CASE表达式的查询。生成查询执行计划。查询执行计划使用参数化的联合所有运算符来保留CASE表达式的语义，以及嵌套循环连接运算符来驱动执行CASE表达式的查询执行计划部分中的数据，而不执行任何连接操作。生成的查询执行计划在计算机中执行以从关系数据库检索数据。

2. 发明授权

US08626744B2 Executing CASE expressions containing subqueries 有权
标题翻译：执行包含子查询的CASE表达式
公开(公告)号：US08626744B2
公开(公告)日：2014-01-07
申请号：US13358779
申请日：2012-01-26
申请人： Qi Cheng , John F. Hornibrook , Jose A. Saborit , David C. Sharpe , Calisto P. Zuzarte
发明人： Qi Cheng , John F. Hornibrook , Jose A. Saborit , David C. Sharpe , Calisto P. Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30483
摘要： Methods and apparatus, including computer program products, implementing and using techniques for executing a query in a computer to retrieve data from a relational database stored on a data storage device. A query is received that contains a CASE expression having one or more subqueries. A query execution plan is generated. The query execution plan uses a parameterized union all operator to keep the semantics of the CASE expression, and a nested loop join operator to drive data across the section of the query execution plan that executes the CASE expression without performing any join operations. The generated query execution plan is executed in the computer to retrieve data from the relational database.
摘要翻译：方法和装置，包括计算机程序产品，用于在计算机中执行查询以从存储在数据存储设备上的关系数据库中检索数据的实现和使用技术。接收到包含具有一个或多个子查询的CASE表达式的查询。生成查询执行计划。查询执行计划使用参数化的联合所有运算符来保留CASE表达式的语义，以及嵌套循环连接运算符来驱动执行CASE表达式的查询执行计划部分中的数据，而不执行任何连接操作。生成的查询执行计划在计算机中执行以从关系数据库检索数据。

3. 发明授权

US08825616B2 Execution of database queries including filtering 有权
标题翻译：执行数据库查询，包括过滤
公开(公告)号：US08825616B2
公开(公告)日：2014-09-02
申请号：US11780777
申请日：2007-07-20
申请人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
发明人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , G06F17/30492 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.
摘要翻译：查询处理系统具有查询处理器和数据管理器。查询处理器调用数据管理器对包括过滤操作的查询执行数据访问。数据管理器访问一组数据中的数据，并在返回数据之前，向查询处理器发起回调，以确定所查找的数据是否满足过滤条件。在数据不满足过滤标准的情况下，数据管理器在数据集中寻求附加数据，而不必将第一定位数据返回给查询处理器。

4. 发明申请

US20130117255A1 ACCESSING A DIMENSIONAL DATA MODEL WHEN PROCESSING A QUERY 有权
标题翻译：在处理查询时访问维度数据模型
公开(公告)号：US20130117255A1
公开(公告)日：2013-05-09
申请号：US13291566
申请日：2011-11-08
申请人： Shaorong Liu , David C. Sharpe , Chi Man J. Sizto
发明人： Shaorong Liu , David C. Sharpe , Chi Man J. Sizto
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30498
摘要： Techniques are disclosed for accessing a dimensional data model when processing a query. In one embodiment, the query is processed by performing a two-stage zigzag join operation including a zigzag main join and a zigzag back join. The zigzag main join is configured to generate a set of row identifiers of fact records satisfying any local predicates in the query. The zigzag back join is configured to generate query results based on the set of row identifiers. The query results are returned responsive to the query.
摘要翻译：公开了在处理查询时访问维度数据模型的技术。在一个实施例中，通过执行包括Z字形主连接和之字形回连接的两阶段之字形连接操作来处理查询。之字形主连接配置为生成满足查询中任何本地谓词的事实记录的一组行标识符。曲折返回连接被配置为基于行标识符集生成查询结果。响应于查询返回查询结果。

5. 发明授权

US07010552B2 Optimizing command execution in database systems that provide support for updatable scrollable cursors 有权
标题翻译：优化在可更新的可滚动游标中提供支持的数据库系统中的命令执行
公开(公告)号：US07010552B2
公开(公告)日：2006-03-07
申请号：US09872827
申请日：2001-05-31
申请人： Iqbal A. Goralwalla , Michael J. Winer , David C. Sharpe , Matthew A. Huras
发明人： Iqbal A. Goralwalla , Michael J. Winer , David C. Sharpe , Matthew A. Huras
IPC分类号： G06F17/30
CPC分类号： G06F17/30351 , G06F17/30353 , G06F17/30356 , Y10S707/99943 , Y10S707/99954
摘要： A procedure optimizes command execution in a database system. According to one embodiment, the database system stores data records on data pages, and provides an identifier for each data page. The identifier indicates when any of the data records contained in the data page were last modified. A data record is selected from a data page and copied to a second storage area. Verification that the selected data record has not been modified since the time that is was copied to the second storage area is based upon the identifier, and then the command is executed.
摘要翻译：一个过程优化数据库系统中的命令执行。根据一个实施例，数据库系统将数据记录存储在数据页上，并为每个数据页提供标识符。标识符表示最后一次修改数据页中包含的任何数据记录。从数据页面选择数据记录并复制到第二存储区域。验证所选择的数据记录自被复制到第二存储区域的时间以来未被修改是基于标识符，然后执行该命令。

6. 发明授权

US09043310B2 Accessing a dimensional data model when processing a query 有权
标题翻译：处理查询时访问维数据模型
公开(公告)号：US09043310B2
公开(公告)日：2015-05-26
申请号：US13291566
申请日：2011-11-08
申请人： Shaorong Liu , David C. Sharpe , Chi Man J. Sizto
发明人： Shaorong Liu , David C. Sharpe , Chi Man J. Sizto
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30498
摘要： Techniques are disclosed for accessing a dimensional data model when processing a query. In one embodiment, the query is processed by performing a two-stage zigzag join operation including a zigzag main join and a zigzag back join. The zigzag main join is configured to generate a set of row identifiers of fact records satisfying any local predicates in the query. The zigzag back join is configured to generate query results based on the set of row identifiers. The query results are returned responsive to the query.
摘要翻译：公开了在处理查询时访问维度数据模型的技术。在一个实施例中，通过执行包括Z字形主连接和之字形回连接的两阶段之字形连接操作来处理查询。之字形主连接配置为生成满足查询中任何本地谓词的事实记录的一组行标识符。曲折返回连接被配置为基于行标识符集生成查询结果。响应于查询返回查询结果。

7. 发明授权

US07539667B2 Method, system and program for executing a query having a union operator 有权
标题翻译：用于执行具有联合运算符的查询的方法，系统和程序
公开(公告)号：US07539667B2
公开(公告)日：2009-05-26
申请号：US10982441
申请日：2004-11-05
申请人： Bruce Gilbert Lindsay , Linqi Liu , Robert Paul Neugebauer , Mir Hamid Pirahesh , David C. Sharpe , Nattavut Sutyanyong , Calisto Paul Zuzarte
发明人： Bruce Gilbert Lindsay , Linqi Liu , Robert Paul Neugebauer , Mir Hamid Pirahesh , David C. Sharpe , Nattavut Sutyanyong , Calisto Paul Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30454 , Y10S707/99932 , Y10S707/99933
摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. A data processing system implemented method direct the data processing system to execute a query against a database having data objects. The query has sub-queries and having a union operator. The union operator is operable on sub-queries associated with the query. The database is operatively coupled to the data processing system. The data processing system implemented method including grouping the sub-queries of the union operator according to identified structural similarities, the identified structural similarities being based on an analysis of the sub-queries, grouping the data objects of the database according to the grouped sub-queries, replacing the grouped data objects and any sub-queries associated with the grouped data objects with a reference to a representative data object and a representative sub-query, and accessing at least one member of the grouped data objects, the accessing of the at least one member of the grouped data object being based on the reference.
摘要翻译：公开了一种用于执行具有联合运算符的查询的数据处理系统实现方法，数据处理系统和制品。数据处理系统实现的方法指导数据处理系统对具有数据对象的数据库执行查询。该查询具有子查询并具有联合运算符。联合运算符可用于与查询相关联的子查询。数据库可操作地耦合到数据处理系统。所述数据处理系统实现方法包括根据所识别的结构相似性对所述联合运算符的子查询进行分组，所识别的结构相似性基于所述子查询的分析，根据所述分组子集对数据库的数据对象进行分组，查询，通过参考代表性数据对象和代表性子查询替换分组数据对象和与分组数据对象相关联的任何子查询，以及访问分组数据对象的至少一个成员，访问at 分组数据对象的至少一个成员基于参考。

8. 发明授权

US07533087B2 Method, system, and program for executing a query having a union all operator and data modifying operations 失效
标题翻译：用于执行具有联合的所有操作符和数据修改操作的查询的方法，系统和程序
公开(公告)号：US07533087B2
公开(公告)日：2009-05-12
申请号：US10982367
申请日：2004-11-05
申请人： Linqi Liu , Robert Paul Neugebauer , David C. Sharpe , Nattavut Sutyanyong , Calisto Paul Zuzarte
发明人： Linqi Liu , Robert Paul Neugebauer , David C. Sharpe , Nattavut Sutyanyong , Calisto Paul Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30418 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942
摘要： Disclosed is a data processing system, a data processing system implemented method and an article of manufacture for executing a query having a union all operator. The data processing system implemented method directs the data processing system to execute a query against a data object. The query has a union all operator and has a set of data modifying operators. The set of data modifying operators is associated with the union all operator. The union all operator references the data object. The data processing system implemented method includes preventing the union all operator from being applied to the data object, and applying the set of data modifying operators against the data object.
摘要翻译：公开了一种数据处理系统，数据处理系统实现方法和用于执行具有联合全部操作者的查询的制品。数据处理系统实现的方法指导数据处理系统对数据对象执行查询。该查询具有一个union all运算符，并具有一组数据修改运算符。数据修改运算符的集合与union all运算符相关联。 union all操作符引用数据对象。数据处理系统实现的方法包括防止所有操作员的联合被应用于数据对象，并且对数据对象应用一组数据修改运算符。

9. 发明授权

US07409385B2 Method, system and program for executing a query having a UNION operator 失效
标题翻译：用于执行具有UNION运算符的查询的方法，系统和程序
公开(公告)号：US07409385B2
公开(公告)日：2008-08-05
申请号：US10982337
申请日：2004-11-05
申请人： Bruce Gilbert Lindsay , Linqi Liu , Robert Paul Neugebauer , Mir Hamid Pirahesh , David C. Sharpe , Nattavut Sutyanyong , Calisto Paul Zuzarte
发明人： Bruce Gilbert Lindsay , Linqi Liu , Robert Paul Neugebauer , Mir Hamid Pirahesh , David C. Sharpe , Nattavut Sutyanyong , Calisto Paul Zuzarte
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30454 , Y10S707/99933 , Y10S707/99934
摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. The data processing system implemented method directs the data processing system to process a query against data objects. The data objects are operatively coupled to the data processing system. The query includes a parent operator. The parent operator references a union operator. The union operator references sub-queries. The sub-queries reference the data objects. The data processing system implemented method includes noting a set of partitionings for the union operator, the noted set of partitionings being based on the sub-queries and being based on the data objects reference by the sub-queries, and executing the query having the union operator, the execution of the query being based on the noted set of partitionings and the parent operator.
摘要翻译：公开了一种用于执行具有联合运算符的查询的数据处理系统实现方法，数据处理系统和制品。数据处理系统实现的方法指导数据处理系统处理对数据对象的查询。数据对象可操作地耦合到数据处理系统。该查询包括父操作符。父操作员引用联合运算符。联合运算符引用子查询。子查询引用数据对象。所述数据处理系统实现的方法包括注意用于联合运算符的一组分区，所述一组分区基于子查询，并且基于由子查询引用的数据对象，并且执行具有联合的查询操作员，查询的执行是基于所述的一组分区和父操作符。

10. 发明授权

US06879977B2 Execution of database queries including filtering 有权
公开(公告)号：US06879977B2
公开(公告)日：2005-04-12
申请号：US09757428
申请日：2001-01-10
申请人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
发明人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30486 , G06F17/30492 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式