-
1.
公开(公告)号:US20170116290A1
公开(公告)日:2017-04-27
申请号:US15332948
申请日:2016-10-24
IPC分类号: G06F17/30
CPC分类号: G06F16/22 , G06F16/24562 , G06F16/283
摘要: In accordance with an embodiment, described herein is a system and method for use of a dynamic flow process (referred to herein in some examples as Query Processing Dynamic Flow (QPDF)) in a multidimensional database computing environment. The dynamic flow process enables hybrid use of, for example, aggregate storage option, block storage option, or other types of storage containers, and provides a common flow to process a received input query in bottom-up mode. The approach can be used to reduce the size of the cube, which provides for efficient calculation of dynamic members.
-
公开(公告)号:US11188554B2
公开(公告)日:2021-11-30
申请号:US16374402
申请日:2019-04-03
IPC分类号: G06F7/00 , G06F17/00 , G06F16/25 , G06F16/2455
摘要: 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.
-
公开(公告)号:US11797559B2
公开(公告)日:2023-10-24
申请号:US17494233
申请日:2021-10-05
IPC分类号: G06F7/00 , G06F17/00 , G06F16/25 , G06F16/2455
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.
-
公开(公告)号:US20230089618A1
公开(公告)日:2023-03-23
申请号:US17992805
申请日:2022-11-22
IPC分类号: G06F16/22 , G06F16/28 , G06F16/2455
摘要: In accordance with an embodiment, described herein is a system and method for use of a dynamic flow process (referred to herein in some examples as Query Processing Dynamic Flow (QPDF)) in a multidimensional database computing environment. The dynamic flow process enables hybrid use of, for example, aggregate storage option, block storage option, or other types of storage containers, and provides a common flow to process a received input query in bottom-up mode. The approach can be used to reduce the size of the cube, which provides for efficient calculation of dynamic members.
-
公开(公告)号:US11531662B2
公开(公告)日:2022-12-20
申请号:US16735448
申请日:2020-01-06
IPC分类号: G06F7/00 , G06F16/00 , G06F16/22 , G06F16/28 , G06F16/2455
摘要: In accordance with an embodiment, described herein is a system and method for use of a dynamic flow process (referred to herein in some examples as Query Processing Dynamic Flow (QPDF)) in a multidimensional database computing environment. The dynamic flow process enables hybrid use of, for example, aggregate storage option, block storage option, or other types of storage containers, and provides a common flow to process a received input query in bottom-up mode. The approach can be used to reduce the size of the cube, which provides for efficient calculation of dynamic members.
-
6.
公开(公告)号:US11520760B2
公开(公告)日:2022-12-06
申请号:US15333022
申请日:2016-10-24
发明人: Alexey Roytman , Natasha Reichman , Victor Belyaev
IPC分类号: G06F16/00 , G06F16/22 , G06F16/28 , G06F16/2455 , G06F16/30
摘要: In accordance with an embodiment, the system supports bottom-up aggregation in a multidimensional database computing environment. A dynamic flow, coupled with a data retrieval layer or data fetching component, which in some environments can incorporate 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, enables bottom-up aggregation of cube data which, for example with pure aggregating queries, provides considerable run time improvement.
-
7.
公开(公告)号:US12079245B2
公开(公告)日:2024-09-03
申请号:US17234479
申请日:2021-04-19
发明人: Alexey Roytman
IPC分类号: G06F7/00 , G06F16/00 , G06F16/22 , G06F16/245 , G06F16/28 , G06F16/903
CPC分类号: G06F16/283 , G06F16/2264 , G06F16/245 , G06F16/90335
摘要: 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.
-
8.
公开(公告)号:US20210240735A1
公开(公告)日:2021-08-05
申请号:US17234479
申请日:2021-04-19
发明人: Alexey Roytman
IPC分类号: G06F16/28 , G06F16/22 , G06F16/903 , G06F16/245
摘要: 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.
-
9.
公开(公告)号:US10984020B2
公开(公告)日:2021-04-20
申请号:US15333051
申请日:2016-10-24
发明人: Alexey Roytman
IPC分类号: G06F7/00 , G06F16/00 , G06F16/28 , G06F16/22 , G06F16/903 , G06F16/245
摘要: 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.
-
10.
公开(公告)号:US20170116313A1
公开(公告)日:2017-04-27
申请号:US15333051
申请日:2016-10-24
发明人: Alexey Roytman
IPC分类号: G06F17/30
CPC分类号: G06F16/283 , G06F16/2264 , G06F16/245 , G06F16/90335
摘要: 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.
-
-
-
-
-
-
-
-
-