ADDITION AND PROCESSING OF CONTINUOUS SQL QUERIES IN A STREAMING RELATIONAL DATABASE MANAGEMENT SYSTEM
    1.
    发明申请
    ADDITION AND PROCESSING OF CONTINUOUS SQL QUERIES IN A STREAMING RELATIONAL DATABASE MANAGEMENT SYSTEM 有权
    流态关系数据库管理系统中连续SQL查询的处理与处理

    公开(公告)号:US20120124096A1

    公开(公告)日:2012-05-17

    申请号:US13344559

    申请日:2012-01-05

    IPC分类号: G06F17/30

    摘要: 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模块,如关系运算符和 表达式求值程序,并实时可视化连续查询的结果

    Addition and processing of continuous SQL queries in a streaming relational database management system
    3.
    发明授权
    Addition and processing of continuous SQL queries in a streaming relational database management system 有权
    在流媒体关系数据库管理系统中添加和处理连续SQL查询

    公开(公告)号:US08745070B2

    公开(公告)日:2014-06-03

    申请号:US13344559

    申请日:2012-01-05

    IPC分类号: G06F7/00 G06F17/30

    摘要: 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模块,如关系运算符和 表达式求值程序,并实时可视化连续查询的结果。

    Systems and methods for managing queries
    4.
    发明授权
    Systems and methods for managing queries 有权
    用于管理查询的系统和方法

    公开(公告)号:US08903802B2

    公开(公告)日:2014-12-02

    申请号:US12398959

    申请日:2009-03-05

    IPC分类号: G06F17/30

    摘要: 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查询和/或新的连续查询运算符)新增到共享的连续查询计划中。 或者,流数据库管理系统可以将新查询与现有的连续查询运算符(例如关系运算符和表达式求值器)进行即时关联,以重用现有的连续查询运算符。 在一些实施例中,多个运算符被分组以用于共享连续查询计划的即时添加。 或者,流数据库管理系统可以在共享连续查询计划中识别一组多个运算符,以供新查询重新使用。

    ADDITION AND PROCESSING OF CONTINUOUS SQL QUERIES IN A STREAMING RELATIONAL DATABASE MANAGEMENT SYSTEM
    5.
    发明申请
    ADDITION AND PROCESSING OF CONTINUOUS SQL QUERIES IN A STREAMING RELATIONAL DATABASE MANAGEMENT SYSTEM 有权
    流态关系数据库管理系统中连续SQL查询的处理与处理

    公开(公告)号:US20090228434A1

    公开(公告)日:2009-09-10

    申请号:US12398944

    申请日:2009-03-05

    IPC分类号: G06F17/30

    摘要: 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模块,如关系运算符和 表达式求值程序,并实时可视化连续查询的结果

    Systems and Methods for Managing Queries
    7.
    发明申请
    Systems and Methods for Managing Queries 有权
    管理查询的系统和方法

    公开(公告)号:US20090228465A1

    公开(公告)日:2009-09-10

    申请号:US12398959

    申请日:2009-03-05

    IPC分类号: G06F17/30

    摘要: 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查询和/或新的连续查询运算符)新增到共享的连续查询计划中。 或者,流数据库管理系统可以将新查询与现有的连续查询运算符(例如关系运算符和表达式求值器)进行即时关联,以重用现有的连续查询运算符。 在一些实施例中,多个运算符被分组以用于共享连续查询计划的即时添加。 或者,流数据库管理系统可以在共享连续查询计划中标识一组多个运算符,以供新查询重新使用。

    Order-Independent Stream Query Processing
    8.
    发明申请
    Order-Independent Stream Query Processing 有权
    与订单无关的流查询处理

    公开(公告)号:US20110302164A1

    公开(公告)日:2011-12-08

    申请号:US13101967

    申请日:2011-05-05

    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.

    摘要翻译: 在用于与秩序无关的流查询处理的系统和方法中,接收一个或多个输入数据流,并且分析一个或多个输入流以确定比已经发射的进度指示符更早的数据。 比已经发射的进度指示符更老的数据被分割成一个或多个分区,并且使用无序处理技术来独立地处理一个或多个分区中的每一个。 查询被接收,重写并分解成一个或多个子查询,其产生针对一个或多个分区中的每个分区的部分结果,其中一个或多个子查询中的每一个对应于分区。 还会生成一个整合每个分区的部分结果的视图。 部分结果在查询指定的合并时间内合并,以生成最终结果,并提供最终结果。

    Method for providing for persistence of java classes where the persistence semantics may be orthogonal to the class definition
    10.
    发明授权
    Method for providing for persistence of java classes where the persistence semantics may be orthogonal to the class definition 有权
    用于提供持久化Java类的方法,其中持久性语义可以与类定义正交

    公开(公告)号:US06505211B1

    公开(公告)日:2003-01-07

    申请号:US09488305

    申请日:2000-01-20

    IPC分类号: G06F1730

    摘要: A method, apparatus, and article of manufacture for providing for persistence of Java™ objects. A Java™ object is instantiated from its corresponding Java™ class definition and then loaded into a Java™ virtual machine. The class definition corresponding to the Java™ object can be derived using either the Java™ Reflection API. Once the class definition is derived, it can be used to inspect the contents of the Java™ object. A structured type instance is then generated from the inspected contents of the Java™ object, wherein the structured type instance is stored in a column of a table of a relational database managed by a relational database management system. As a result of these steps, the Java™ object is persistently stored in the database, yet the persistence semantics for storing the object are not specified as part of the class definition of the object, which means that the persistence semantics are orthogonal to the class definition.

    摘要翻译: 一种用于提供Java(TM)对象的持久性的方法,装置和制品。 Java(TM)对象从其对应的Java(TM)类定义中实例化,然后加载到Java(TM)虚拟机中。 可以使用Java(TM)Reflection API来导出与Java(TM)对象相对应的类定义。 一旦导出了类定义,它可以用于检查Java(TM)对象的内容。 然后从Java(TM)对象的被检查内容生成结构化类型实例,其中结构化类型实例被存储在由关系数据库管理系统管理的关系数据库的表的列中。 作为这些步骤的结果,Java(TM)对象被持久地存储在数据库中,而用于存储对象的持久性语义不被指定为对象的类定义的一部分,这意味着持久性语义与 类定义。