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

1. 发明授权

US08812487B2 Addition and processing of continuous SQL queries in a streaming relational database management system 有权
公开(公告)号：US08812487B2
公开(公告)日：2014-08-19
申请号：US12398944
申请日：2009-03-05
申请人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
发明人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30516 , G06F17/30445 , G06F17/30545
摘要： Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time.

2. 发明申请

US20120124096A1 ADDITION AND PROCESSING OF CONTINUOUS SQL QUERIES IN A STREAMING RELATIONAL DATABASE MANAGEMENT SYSTEM 有权
标题翻译：流态关系数据库管理系统中连续SQL查询的处理与处理
公开(公告)号：US20120124096A1
公开(公告)日：2012-05-17
申请号：US13344559
申请日：2012-01-05
申请人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
发明人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
IPC分类号： G06F17/30
CPC分类号： G06F17/30516 , G06F17/30445 , G06F17/30545
摘要： Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time
摘要翻译：本文公开的系统，方法和媒体可以体现在传统的关系数据库管理系统（RDBMS）中，以便将其转换为流关系数据库管理系统（SRDBMS）。 SRDBMS可以提供诸如管理和填充流，表和归档流历史的功能，并且支持对流和表的连续查询的评估。连续和快照查询支持行业标准，广泛使用的结构化查询语言的全部范围。本技术可以使用可扩展和高效的共享查询评估方案来支持大量并发连续查询，支持将连续查询即时添加到实现共享评估方案的机制中，重用RDBMS模块，如关系运算符和表达式求值程序，并实时可视化连续查询的结果

3. 发明申请

US20090228434A1 ADDITION AND PROCESSING OF CONTINUOUS SQL QUERIES IN A STREAMING RELATIONAL DATABASE MANAGEMENT SYSTEM 有权
标题翻译：流态关系数据库管理系统中连续SQL查询的处理与处理
公开(公告)号：US20090228434A1
公开(公告)日：2009-09-10
申请号：US12398944
申请日：2009-03-05
申请人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
发明人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
IPC分类号： G06F17/30
CPC分类号： G06F17/30516 , G06F17/30445 , G06F17/30545
摘要： Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time
摘要翻译：本文公开的系统，方法和媒体可以体现在传统的关系数据库管理系统（RDBMS）中，以便将其转换为流关系数据库管理系统（SRDBMS）。 SRDBMS可以提供诸如管理和填充流，表和归档流历史的功能，并支持对流和表的连续查询的评估。连续和快照查询支持行业标准，广泛使用的结构化查询语言的全部范围。本技术可以使用可扩展和高效的共享查询评估方案来支持大量并发连续查询，支持将连续查询即时添加到实现共享评估方案的机制中，重用RDBMS模块，如关系运算符和表达式求值程序，并实时可视化连续查询的结果

4. 发明授权

US08745070B2 Addition and processing of continuous SQL queries in a streaming relational database management system 有权
标题翻译：在流媒体关系数据库管理系统中添加和处理连续SQL查询
公开(公告)号：US08745070B2
公开(公告)日：2014-06-03
申请号：US13344559
申请日：2012-01-05
申请人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
发明人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hoyer
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30516 , G06F17/30445 , G06F17/30545
摘要： Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time.
摘要翻译：本文公开的系统，方法和媒体可以体现在传统的关系数据库管理系统（RDBMS）中，以便将其转换为流关系数据库管理系统（SRDBMS）。 SRDBMS可以提供诸如管理和填充流，表和归档流历史的功能，并支持对流和表的连续查询的评估。连续和快照查询支持行业标准，广泛使用的结构化查询语言的全部范围。本技术可以使用可扩展和高效的共享查询评估方案来支持大量并发连续查询，支持将连续查询即时添加到实现共享评估方案的机制中，重用RDBMS模块，如关系运算符和表达式求值程序，并实时可视化连续查询的结果。

5. 发明授权

US08903802B2 Systems and methods for managing queries 有权
标题翻译：用于管理查询的系统和方法
公开(公告)号：US08903802B2
公开(公告)日：2014-12-02
申请号：US12398959
申请日：2009-03-05
申请人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li
发明人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li
IPC分类号： G06F17/30
CPC分类号： G06F17/30516 , G06F17/30445 , G06F17/30545
摘要： A streaming database management system may provide support for creating a new continuous query operator for on-the-fly addition of a new query, e.g., a new SQL query and/or new continuous query operator, into a shared continuous query plan. Alternatively, the streaming database management system may associate the new query on-the-fly with an existing continuous query operator, such as a relational operator and expression evaluator, to reuse the existing continuous query operator. In some embodiments, multiple operators are grouped for on-the-fly addition to the shared continuous query plan. Alternatively, the streaming database management system may identify a group of multiple operators in the shared continuous query plan for reuse by the new query.
摘要翻译：流数据库管理系统可以为创建新的连续查询运算符提供支持，以便将新查询（例如，新的SQL查询和/或新的连续查询运算符）新增到共享的连续查询计划中。或者，流数据库管理系统可以将新查询与现有的连续查询运算符（例如关系运算符和表达式求值器）进行即时关联，以重用现有的连续查询运算符。在一些实施例中，多个运算符被分组以用于共享连续查询计划的即时添加。或者，流数据库管理系统可以在共享连续查询计划中识别一组多个运算符，以供新查询重新使用。

6. 发明申请

US20120124031A1 ADDITION AND PROCESSING OF CONTINUOUS SQL QUERIES IN A STREAMING RELATIONAL DATABASE MANAGEMENT SYSTEM 审中-公开
公开(公告)号：US20120124031A1
公开(公告)日：2012-05-17
申请号：US13344562
申请日：2012-01-05
申请人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hover
发明人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li , Morten Hover
IPC分类号： G06F17/30
CPC分类号： G06F16/24568 , G06F16/24532 , G06F16/2471
摘要： Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time

7. 发明申请

US20090228465A1 Systems and Methods for Managing Queries 有权
标题翻译：管理查询的系统和方法
公开(公告)号：US20090228465A1
公开(公告)日：2009-09-10
申请号：US12398959
申请日：2009-03-05
申请人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li
发明人： Saileshwar Krishnamurthy , Neil Thombre , Neil Conway , Wing Hang Li
IPC分类号： G06F17/30
CPC分类号： G06F17/30516 , G06F17/30445 , G06F17/30545
摘要： A streaming database management system may provide support for creating a new continuous query operator for on-the-fly addition of a new query, e.g., a new SQL query and/or new continuous query operator, into a shared continuous query plan. Alternatively, the streaming database management system may associate the new query on-the-fly with an existing continuous query operator, such as a relational operator and expression evaluator, to reuse the existing continuous query operator. In some embodiments, multiple operators are grouped for on-the-fly addition to the shared continuous query plan. Alternatively, the streaming database management system may identify a group of multiple operators in the shared continuous query plan for reuse by the new query.
摘要翻译：流数据库管理系统可以为创建新的连续查询运算符提供支持，以便将新查询（例如，新的SQL查询和/或新的连续查询运算符）新增到共享的连续查询计划中。或者，流数据库管理系统可以将新查询与现有的连续查询运算符（例如关系运算符和表达式求值器）进行即时关联，以重用现有的连续查询运算符。在一些实施例中，多个运算符被分组以用于共享连续查询计划的即时添加。或者，流数据库管理系统可以在共享连续查询计划中标识一组多个运算符，以供新查询重新使用。

8. 发明申请

US20110302164A1 Order-Independent Stream Query Processing 有权
标题翻译：与订单无关的流查询处理
公开(公告)号：US20110302164A1
公开(公告)日：2011-12-08
申请号：US13101967
申请日：2011-05-05
申请人： Saileshwar Krishnamurthy , Michael R. Lewis , Wing Li , Neil Thombre , Jeffrey A. Davis , Daniel Robert Farina
发明人： Saileshwar Krishnamurthy , Michael R. Lewis , Wing Li , Neil Thombre , Jeffrey A. Davis , Daniel Robert Farina
IPC分类号： G06F17/30
CPC分类号： G06F17/30979 , G06F17/30516
摘要： In a system and method for order-independent stream query processing, one or more input streams of data are received, and the one or more input streams are analyzed to determine data which is older than an already emitted progress indicator. The data which is older than the already emitted progress indicator is partitioned into one or more partitions, and each of the one or more partitions are independently processed using out-of-order processing techniques. A query is received, rewritten and decomposed into one or more sub-queries that produce partial results for each of the one or more partitions, where each of the one or more sub-queries correspond to a partition. A view is also produced that consolidates the partial results for each partition. The partial results are consolidated at a consolidation time specified by the query to produce final results, and the final results are provided.
摘要翻译：在用于与秩序无关的流查询处理的系统和方法中，接收一个或多个输入数据流，并且分析一个或多个输入流以确定比已经发射的进度指示符更早的数据。比已经发射的进度指示符更老的数据被分割成一个或多个分区，并且使用无序处理技术来独立地处理一个或多个分区中的每一个。查询被接收，重写并分解成一个或多个子查询，其产生针对一个或多个分区中的每个分区的部分结果，其中一个或多个子查询中的每一个对应于分区。还会生成一个整合每个分区的部分结果的视图。部分结果在查询指定的合并时间内合并，以生成最终结果，并提供最终结果。

9. 发明授权

US08484243B2 Order-independent stream query processing 有权
公开(公告)号：US08484243B2
公开(公告)日：2013-07-09
申请号：US13101967
申请日：2011-05-05
申请人： Saileshwar Krishnamurthy , Michael R. Lewis , Wing Li , Neil Thombre , Jeffrey A. Davis , Daniel Robert Farina
发明人： Saileshwar Krishnamurthy , Michael R. Lewis , Wing Li , Neil Thombre , Jeffrey A. Davis , Daniel Robert Farina
IPC分类号： G06F17/30
CPC分类号： G06F17/30979 , G06F17/30516
摘要： In a system and method for order-independent stream query processing, one or more input streams of data are received, and the one or more input streams are analyzed to determine data which is older than an already emitted progress indicator. The data which is older than the already emitted progress indicator is partitioned into one or more partitions, and each of the one or more partitions are independently processed using out-of-order processing techniques. A query is received, rewritten and decomposed into one or more sub-queries that produce partial results for each of the one or more partitions, where each of the one or more sub-queries correspond to a partition. A view is also produced that consolidates the partial results for each partition. The partial results are consolidated at a consolidation time specified by the query to produce final results, and the final results are provided.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式