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

1. 发明申请

US20090228433A1 SYSTEM AND METHOD FOR MULTIPLE DISTINCT AGGREGATE QUERIES 有权
标题翻译：多重异构群算法的系统与方法
公开(公告)号：US20090228433A1
公开(公告)日：2009-09-10
申请号：US12044348
申请日：2008-03-07
申请人： Josep AGUILAR SABORIT , Miroslaw Adam Flasza , Mokhtar Kandil , Serge Philippe Rielau , David C. Sharpe , Calisto Paul Zuzarte
发明人： Josep AGUILAR SABORIT , Miroslaw Adam Flasza , Mokhtar Kandil , Serge Philippe Rielau , David C. Sharpe , Calisto Paul Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30489
摘要： There is disclosed a system and method for executing multiple distinct aggregate queries. In an embodiment, the method comprises: providing at least one Counting Bloom Filter for each distinct column of an input data stream; reviewing count values in the at least one Counting Bloom Filter for the existence of duplicates in each distinct column; and if necessary, using a distinct hash operator to remove duplicates from each distinct column of the input data stream, thereby removing the need for replicating the input data stream and minimizing distinct hash operator processing. Also, the use of Counting Bloom Filters for monitoring data streams allow an early duplicate removal of the input stream of data, resulting in savings in computation time and memory resources.
摘要翻译：公开了一种用于执行多个不同聚合查询的系统和方法。在一个实施例中，该方法包括：为输入数据流的每个不同列提供至少一个计数布隆过滤器; 在每个不同列中存在重复项，查看至少一个计数布隆值过滤器中的计数值; 并且如果需要，使用不同的散列算子来从输入数据流的每个不同的列去除重复，从而消除对复制输入数据流的需要并使不同的散列算子处理最小化。此外，使用计数布隆过滤器监控数据流可以早日重复删除输入数据流，从而节省计算时间和内存资源。

2. 发明授权

US08005868B2 System and method for multiple distinct aggregate queries 有权
标题翻译：多个不同聚合查询的系统和方法
公开(公告)号：US08005868B2
公开(公告)日：2011-08-23
申请号：US12044348
申请日：2008-03-07
申请人： Josep Aguilar Saborit , Miroslaw Adam Flasza , Mokhtar Kandil , Serge Philippe Rielau , David C. Sharpe , Calisto Paul Zuzarte
发明人： Josep Aguilar Saborit , Miroslaw Adam Flasza , Mokhtar Kandil , Serge Philippe Rielau , David C. Sharpe , Calisto Paul Zuzarte
IPC分类号： G06F7/00 , G06F17/00 , G06F9/26 , G06F17/20
CPC分类号： G06F17/30489
摘要： There is disclosed a system and method for executing multiple distinct aggregate queries. In an embodiment, the method comprises: providing at least one Counting Bloom Filter for each distinct column of an input data stream; reviewing count values in the at least one Counting Bloom Filter for the existence of duplicates in each distinct column; and if necessary, using a distinct hash operator to remove duplicates from each distinct column of the input data stream, thereby removing the need for replicating the input data stream and minimizing distinct hash operator processing. Also, the use of Counting Bloom Filters for monitoring data streams allow an early duplicate removal of the input stream of data, resulting in savings in computation time and memory resources.
摘要翻译：公开了一种用于执行多个不同聚合查询的系统和方法。在一个实施例中，该方法包括：为输入数据流的每个不同列提供至少一个计数布隆过滤器; 在每个不同列中存在重复项，查看至少一个计数布隆值过滤器中的计数值; 并且如果需要，使用不同的散列算子来从输入数据流的每个不同的列去除重复，从而消除对复制输入数据流的需要并使不同的散列算子处理最小化。此外，使用计数布隆过滤器监控数据流可以早日重复删除输入数据流，从而节省计算时间和内存资源。

3. 发明授权

US07725461B2 Management of statistical views in a database system 有权
标题翻译：管理数据库系统中的统计视图
公开(公告)号：US07725461B2
公开(公告)日：2010-05-25
申请号：US11374812
申请日：2006-03-14
申请人： Mokhtar Kandil , Alberto Lerner , Volker Gerhard Markl , Daniele Costante Zilio , Calisto Paul Zuzarte
发明人： Mokhtar Kandil , Alberto Lerner , Volker Gerhard Markl , Daniele Costante Zilio , Calisto Paul Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30536 , G06F17/30306
摘要： A method, computer program product, and system for managing statistical views in a database system are provided. The method, computer program product, and system provide for collecting data relating to optimization and execution of a workload in the database system and automatically generating a set of one or more statistical views based on the collected optimization and execution data.
摘要翻译：提供了一种用于管理数据库系统中的统计视图的方法，计算机程序产品和系统。所述方法，计算机程序产品和系统提供用于收集与数据库系统中的工作负载的优化和执行有关的数据，并且基于所收集的优化和执行数据自动生成一组或多个统计视图。

4. 发明申请

US20070220058A1 Management of statistical views in a database system 有权
标题翻译：管理数据库系统中的统计视图
公开(公告)号：US20070220058A1
公开(公告)日：2007-09-20
申请号：US11374812
申请日：2006-03-14
申请人： Mokhtar Kandil , Alberto Lerner , Volker Markl , Daniele Zilio , Calisto Zuzarte
发明人： Mokhtar Kandil , Alberto Lerner , Volker Markl , Daniele Zilio , Calisto Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , G06F17/30306
摘要： A method, computer program product, and system for managing statistical views in a database system are provided. The method, computer program product, and system provide for collecting data relating to optimization and execution of a workload in the database system and automatically generating a set of one or more statistical views based on the collected optimization and execution data.
摘要翻译：提供了一种用于管理数据库系统中的统计视图的方法，计算机程序产品和系统。所述方法，计算机程序产品和系统提供用于收集与数据库系统中的工作负载的优化和执行有关的数据，并且基于所收集的优化和执行数据自动生成一组或多个统计视图。

5. 发明授权

US07765200B2 SQL query problem determination tool 失效
标题翻译： SQL查询问题确定工具
公开(公告)号：US07765200B2
公开(公告)日：2010-07-27
申请号：US11089677
申请日：2005-03-25
申请人： Mokhtar Kandil , Volker Gerhard Markl
发明人： Mokhtar Kandil , Volker Gerhard Markl
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F11/362
摘要： A method and system for query problem determination have been disclosed. The method includes receiving a database query; creating a query execution plan for the database query comprising a plurality of query plan operators; and executing the query execution plan, wherein a progress indicator is displayed for each query plan operator. The system includes a query progress monitor, which collects progress information for each query plan operator during the execution of the query execution plan. This progress information is then communicated to a query progress visualizer and a query progress analyzer, which graphically displays the progress information as a progress indicator for each query plan operator and performs debugger type operations, respectively. In this manner, information concerning the progress of the query execution is provided at a query operator level, such that the information may be used to more efficiently debug any problems with the query.
摘要翻译：已经公开了一种用于查询问题确定的方法和系统。该方法包括接收数据库查询; 为包括多个查询计划运算符的数据库查询创建查询执行计划; 以及执行所述查询执行计划，其中针对每个查询计划运算符显示进度指示符。该系统包括查询进度监视器，它在执行查询执行计划期间收集每个查询计划运算符的进度信息。然后将该进度信息传递给查询进度可视化器和查询进度分析器，该分析器以图形方式将进度信息显示为每个查询计划操作符的进度指示符，并分别执行调试器类型操作。以这种方式，在查询操作者级别提供关于查询执行进度的信息，使得可以使用该信息来更有效地调试查询的任何问题。

6. 发明申请

US20060218125A1 SQL query problem determination tool 失效
标题翻译： SQL查询问题确定工具
公开(公告)号：US20060218125A1
公开(公告)日：2006-09-28
申请号：US11089677
申请日：2005-03-25
申请人： Mokhtar Kandil , Volker Gerhard Markl
发明人： Mokhtar Kandil , Volker Gerhard Markl
IPC分类号： G06F17/30
CPC分类号： G06F11/362
摘要： A method and system for query problem determination have been disclosed. The method includes receiving a database query; creating a query execution plan for the database query comprising a plurality of query plan operators; and executing the query execution plan, wherein a progress indicator is displayed for each query plan operator. The system includes a query progress monitor, which collects progress information for each query plan operator during the execution of the query execution plan. This progress information is then communicated to a query progress visualizer and a query progress analyzer, which graphically displays the progress information as a progress indicator for each query plan operator and performs debugger type operations, respectively. In this manner, information concerning the progress of the query execution is provided at a query operator level, such that the information may be used to more efficiently debug any problems with the query.
摘要翻译：已经公开了一种用于查询问题确定的方法和系统。该方法包括接收数据库查询; 为包括多个查询计划运算符的数据库查询创建查询执行计划; 以及执行所述查询执行计划，其中针对每个查询计划运算符显示进度指示符。该系统包括查询进度监视器，它在执行查询执行计划期间收集每个查询计划运算符的进度信息。然后将该进度信息传递给查询进度可视化器和查询进度分析器，该分析器以图形方式将进度信息显示为每个查询计划操作符的进度指示符，并分别执行调试器类型操作。以这种方式，在查询操作者级别提供关于查询执行进度的信息，使得可以使用该信息来更有效地调试查询的任何问题。

7. 发明申请

US20060020760A1 Method, system, and program for storing sensor data in autonomic systems 审中-公开
标题翻译：用于在自治系统中存储传感器数据的方法，系统和程序
公开(公告)号：US20060020760A1
公开(公告)日：2006-01-26
申请号：US10898466
申请日：2004-07-22
申请人： Mokhtar Kandil , Volker Markl
发明人： Mokhtar Kandil , Volker Markl
IPC分类号： G06F12/00
CPC分类号： G06F11/3495 , G06F9/52
摘要： An autonomic system directed to opportunistically store captured data from at least two writer processes executing in an autonomic system. The method includes: creating a pool of storage locations in which data can be stored by the at least two writing processes, one of the at least two writer processes capturing data to be stored; selecting a storage location from the pool for the one of said at least two writer processes; and determining if the selected file is available for writing by the one of the at least two writer processes and writing the captured data to the storage location if it is available.
摘要翻译：一种用于机会地存储在自主系统中执行的至少两个写入器进程的捕获数据的自主系统。该方法包括：创建存储位置池，通过所述至少两个写入过程可以存储数据，所述至少两个写入器进程之一捕获要存储的数据; 从所述池中为所述至少两个写入器进程之一选择存储位置; 以及确定所选择的文件是否可用于由所述至少两个写入器进程中的一个写入，并且将所捕获的数据写入所述存储位置（如果所述文件可用）。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式