System and method for real time data aggregation in a virtual cube in a multidimensional database environment

    公开(公告)号:US11188554B2

    公开(公告)日:2021-11-30

    申请号:US16374402

    申请日:2019-04-03

    摘要: In accordance with an embodiment, described herein are systems and methods for real time data aggregation in a virtual cube in a multidimensional database, in accordance with an embodiment. A method can provide, at a computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, a data source associated with the multidimensional cube, and at least one source of real-time data accessible by the data source. The method can query, by the multidimensional cube, the data source, the query comprising an identification of the at least one source of real-time data. The method can provide, by the data source, on-demand access to the multidimensional cube to the at least one source of real-time data. The method can use targeted data from the at least one source of real-time data within the multidimensional cube without being stored therein.

    System and method for real time data aggregation in a virtual cube in a multidimensional database environment

    公开(公告)号:US11797559B2

    公开(公告)日:2023-10-24

    申请号:US17494233

    申请日:2021-10-05

    CPC分类号: G06F16/254 G06F16/2455

    摘要: In accordance with an embodiment, described are systems and methods for real time data aggregation in a virtual cube in a multidimensional database. A method can provide, at a computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, a data source associated with the multidimensional cube, and at least one source of real-time data accessible by the data source. The method can query, by the multidimensional cube, the data source, the query comprising an identification of the at least one source of real-time data. The method can provide, by the data source, on-demand access to the multidimensional cube to the at least one source of real-time data. The method can use targeted data from the at least one source of real-time data within the multidimensional cube without being stored therein.

    SYSTEM AND METHOD FOR SUPPORTING LARGE QUERIES IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT

    公开(公告)号:US20210240735A1

    公开(公告)日:2021-08-05

    申请号:US17234479

    申请日:2021-04-19

    发明人: Alexey Roytman

    摘要: In accordance with an embodiment, the system provides support for large queries in a multidimensional database computing environment. A kernel-based data structure, referred to herein as an odometer retriever, or odometer, that manages pointers to data blocks, contains control information, or otherwise operates as an array of arrays of pointers to stored members. When used with a dynamic flow, the approach enables the system to be used, for example to handle grid queries, Multidimensional Expressions (MDX) queries, or other types of queries in which the potential size of the query can be up to 264 bits.

    SYSTEM AND METHOD FOR SUPPORTING LARGE QUERIES IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT

    公开(公告)号:US20170116313A1

    公开(公告)日:2017-04-27

    申请号:US15333051

    申请日:2016-10-24

    发明人: Alexey Roytman

    IPC分类号: G06F17/30

    摘要: In accordance with an embodiment, the system provides support for large queries in a multidimensional database computing environment. A kernel-based data structure, referred to herein as an odometer retriever, or odometer, that manages pointers to data blocks, contains control information, or otherwise operates as an array of arrays of pointers to stored members. When used with a dynamic flow, the approach enables the system to be used, for example to handle grid queries, Multidimensional Expressions (MDX) queries, or other types of queries in which the potential size of the query can be up to 264 bits.