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

1. 发明授权

US08082265B2 Database query processing with dynamically activated buffers 失效
标题翻译：使用动态激活的缓冲区进行数据库查询处理
公开(公告)号：US08082265B2
公开(公告)日：2011-12-20
申请号：US12056344
申请日：2008-03-27
申请人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F7/00
CPC分类号： G06F17/30474 , G06F17/30445 , G06F17/30457 , G06F17/30466
摘要： A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.
摘要翻译：方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。

2. 发明申请

US20090248618A1 Database Query Processing with Dynamically Activated Buffers 失效
标题翻译：动态激活缓冲区的数据库查询处理
公开(公告)号：US20090248618A1
公开(公告)日：2009-10-01
申请号：US12056344
申请日：2008-03-27
申请人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F7/06
CPC分类号： G06F17/30474 , G06F17/30445 , G06F17/30457 , G06F17/30466
摘要： A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.
摘要翻译：方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。

3. 发明申请

US20090144307A1 Performing Hierarchical Aggregate Compression 审中-公开
标题翻译：执行层次聚合压缩
公开(公告)号：US20090144307A1
公开(公告)日：2009-06-04
申请号：US11946945
申请日：2007-11-29
申请人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
发明人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
IPC分类号： G06F17/30
CPC分类号： G06F16/24556
摘要： Methods, systems, and computer program products are provided for executing database rollup queries. Methods can include iterating through a database table which has been grouped and ordered on the different columns which are in the ROLLUP clause. In some embodiments, a GROUP BY ROLLUP construct can be executed while only requiring an additional one storage location per ordered column per each aggregate function to be performed on each database row. The higher level aggregate functions can be executed without relying on accessing any lower level aggregate results in some embodiments. A suitably grouped and ordered database table can have a multiple level hierarchical ROLLUP function executed in a single pass without having to retrieve lower level aggregate results.
摘要翻译：提供方法，系统和计算机程序产品用于执行数据库汇总查询。方法可以包括遍历已经在ROLLUP子句中的不同列上分组和排序的数据库表。在一些实施例中，可以执行GROUP BY ROLLUP构造，同时仅在每个数据库行上执行每个聚合函数需要每个排序列的附加一个存储位置。在一些实施例中，可以不依赖于访问任何较低级别的聚合结果来执行较高级别的聚合函数。适当分组和排序的数据库表可以具有在单次通过中执行的多级分层ROLLUP功能，而不必检索较低级别的聚合结果。

4. 发明授权

US09411861B2 Multiple result sets generated from single pass through a dataspace 有权
标题翻译：从单次通过数据空间生成的多个结果集
公开(公告)号：US09411861B2
公开(公告)日：2016-08-09
申请号：US11962980
申请日：2007-12-21
申请人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
发明人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： A method, apparatus and program product are provided for performing a query of a database. A database query is received, which includes first and second operations respectively configured to generate first and second disjoint results sets from a dataspace. The database query is analyzed to identify a set of attributes from the dataspace that are used by at least one of the first and second operations in the database query. During execution of the database query, a plurality of records from the dataspace is iteratively processed in a single pass, including, for each of the plurality of records, processing such record by retrieving the plurality of attributes for such record from the dataspace and performing each of the first and second operations on the record using the retrieved attributes for such record to build the first and second disjoint results sets.
摘要翻译：提供了一种用于执行数据库查询的方法，装置和程序产品。接收到数据库查询，其包括分别被配置为从数据空间生成第一和第二不相交结果集的第一和第二操作。分析数据库查询以从数据库空间识别由数据库查询中的第一和第二操作中的至少一个使用的一组属性。在执行数据库查询期间，来自数据空间的多个记录在单次传递中被迭代地处理，包括对于多个记录中的每一个记录，通过从数据空间检索这样的记录的多个属性并且执行每个记录使用检索到的这种记录的属性来构建第一和第二不相交结果集的记录上的第一和第二操作。

5. 发明申请

US20090164412A1 Multiple Result Sets Generated from Single Pass Through a Dataspace 有权
标题翻译：通过数据空间从单次生成的多个结果集
公开(公告)号：US20090164412A1
公开(公告)日：2009-06-25
申请号：US11962980
申请日：2007-12-21
申请人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
发明人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： A method, apparatus and program product are provided for performing a query of a database. A database query is received, which includes first and second operations respectively configured to generate first and second disjoint results sets from a dataspace. The database query is analyzed to identify a set of attributes from the dataspace that are used by at least one of the first and second operations in the database query. During execution of the database query, a plurality of records from the dataspace is iteratively processed in a single pass, including, for each of the plurality of records, processing such record by retrieving the plurality of attributes for such record from the dataspace and performing each of the first and second operations on the record using the retrieved attributes for such record to build the first and second disjoint results sets.
摘要翻译：提供了一种用于执行数据库查询的方法，装置和程序产品。接收到数据库查询，其包括分别被配置为从数据空间生成第一和第二不相交结果集的第一和第二操作。分析数据库查询以从数据库空间识别由数据库查询中的第一和第二操作中的至少一个使用的一组属性。在执行数据库查询期间，数据空间中的多个记录在单次传递中被迭代处理，包括对于多个记录中的每个记录，通过从数据空间检索这样的记录的多个属性并执行每个记录使用检索到的这种记录的属性来构建第一和第二不相交结果集的记录上的第一和第二操作。

6. 发明授权

US07512700B2 Real-time mining and reduction of streamed data 失效
标题翻译：实时挖掘和减少流数据
公开(公告)号：US07512700B2
公开(公告)日：2009-03-31
申请号：US11241708
申请日：2005-09-30
申请人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
发明人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
IPC分类号： G06K9/36
CPC分类号： G06F17/30516
摘要： A stream data node receives real-time streamed data from one or more input devices, dynamically filters the streamed data to reduce the streamed data, and delivers the reduced data when requested. By providing real-time filtering of the data, the amount of data that must be stored in a database may be substantially reduced. The stream data node can perform aggregation functions, group functions, and select functions, thereby also significantly reducing the amount of data that must be stored in a database. The stream data node may also be part of a query execution data structure, where it delivers its data when requested by another node in the query execution data structure.
摘要翻译：流数据节点从一个或多个输入设备接收实时流数据，动态地过滤流数据以减少流数据，并在请求时传送减少的数据。通过提供对数据的实时过滤，可以显着地减少必须存储在数据库中的数据量。流数据节点可以执行聚合功能，组功能和选择功能，从而大大减少必须存储在数据库中的数据量。流数据节点还可以是查询执行数据结构的一部分，其中当查询执行数据结构中的另一节点请求时，该数据结构传递其数据。

7. 发明申请

US20090150560A1 REAL-TIME MINING AND REDUCTION OF STREAMED DATA 失效
标题翻译：实时采矿和减少流动数据
公开(公告)号：US20090150560A1
公开(公告)日：2009-06-11
申请号：US12372850
申请日：2009-02-18
申请人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
发明人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
IPC分类号： G06F15/16 , G06K9/36 , G06F17/30
CPC分类号： G06F17/30516
摘要： A stream data node receives real-time streamed data from one or more input devices, dynamically filters the streamed data to reduce the streamed data, and delivers the reduced data when requested. By providing real-time filtering of the data, the amount of data that must be stored in a database may be substantially reduced. The stream data node can perform aggregation functions, group functions, and select functions, thereby also significantly reducing the amount of data that must be stored in a database. The stream data node may also be part of a query execution data structure, where it delivers its data when requested by another node in the query execution data structure.
摘要翻译：流数据节点从一个或多个输入设备接收实时流数据，动态地过滤流数据以减少流数据，并在请求时传送减少的数据。通过提供对数据的实时过滤，可以显着地减少必须存储在数据库中的数据量。流数据节点可以执行聚合功能，组功能和选择功能，从而大大减少必须存储在数据库中的数据量。流数据节点还可以是查询执行数据结构的一部分，其中当查询执行数据结构中的另一节点请求时，该数据结构传递其数据。

8. 发明申请

US20080148103A1 APPARATUS AND METHOD FOR MONITORING AND DEBUGGING QUERY EXECUTION OBJECTS 审中-公开
标题翻译：用于监视和调试查询执行对象的装置和方法
公开(公告)号：US20080148103A1
公开(公告)日：2008-06-19
申请号：US12038446
申请日：2008-02-27
申请人： David Glenn Carlson , Steven Virgil Hoeschen , Kevin James Kathmann
发明人： David Glenn Carlson , Steven Virgil Hoeschen , Kevin James Kathmann
IPC分类号： G06F11/32 , G06F17/30
CPC分类号： G06F17/30289 , G06F3/048 , G06F17/30483
摘要： Nodes in a query execution data structure have monitor and dump methods defined. The monitor method enables the collection of information from the node. The dump method outputs the monitored information from each node. A monitor and debug mechanism of the preferred embodiments includes a graphical user interface that allows a user to graphically examine a query execution tree, to enable monitoring of the nodes on a node-by-node basis, and to view information dumped from the query execution data structure as the query is executed or after the query is executed. The result is a powerful tool that allows efficiently monitoring and debugging a query implemented in an object oriented query execution data structure.
摘要翻译：查询执行数据结构中的节点定义了监视和转储方法。监视器方法可以从节点收集信息。 dump方法从每个节点输出监视的信息。优选实施例的监视器和调试机制包括图形用户界面，其允许用户以图形方式检查查询执行树，以便逐节点地监视节点，以及查看从查询执行转发的信息查询执行时或执行查询后的数据结构。结果是一个强大的工具，可以有效地监视和调试在面向对象的查询执行数据结构中实现的查询。

9. 发明授权

US07089230B2 Method for efficient processing of multi-state attributes 失效
公开(公告)号：US07089230B2
公开(公告)日：2006-08-08
申请号：US10164767
申请日：2002-06-07
申请人： David Glenn Carlson , Kevin James Kathmann
发明人： David Glenn Carlson , Kevin James Kathmann
IPC分类号： G06F17/30
CPC分类号： G06F17/30483 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99943
摘要： Methods, systems and articles of manufacture of processing a multi-state attribute field query. One embodiment provides a method of processing a multi-state attribute field query, comprising instantiating a plurality of live objects; performing, by each live object, an attribute operation, wherein at least one attribute operation is a comparison operation associated with attributes of the query. The plurality of live objects access a global status storage area only when an operand of the comparison operation is null or error. In any case, execution control is passed from each live object to an adjacent live object.

10. 发明授权

US09390108B2 Monitoring and debugging query execution objects 有权
公开(公告)号：US09390108B2
公开(公告)日：2016-07-12
申请号：US12038446
申请日：2008-02-27
申请人： David Glenn Carlson , Steven Virgil Hoeschen , Kevin James Kathmann
发明人： David Glenn Carlson , Steven Virgil Hoeschen , Kevin James Kathmann
IPC分类号： G06F17/30 , G06F3/048
CPC分类号： G06F17/30289 , G06F3/048 , G06F17/30483
摘要： Nodes in a query execution data structure have monitor and dump methods defined. The monitor method enables the collection of information from the node. The dump method outputs the monitored information from each node. A monitor and debug mechanism of the preferred embodiments includes a graphical user interface that allows a user to graphically examine a query execution tree, to enable monitoring of the nodes on a node-by-node basis, and to view information dumped from the query execution data structure as the query is executed or after the query is executed. The result is a powerful tool that allows efficiently monitoring and debugging a query implemented in an object oriented query execution data structure.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式