公开(公告)号：US12105710B2

公开(公告)日：2024-10-01

申请号：US18139077

申请日：2023-04-25

申请人： AtScale, Inc.

发明人： Daryl Odnert ,  Patrick J. Toole ,  Sarah Gerweck ,  Joseph Barefoot ,  Rouzbeh Safaie

IPC分类号： G06F16/24 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/28

CPC分类号： G06F16/24544 ,  G06F16/24561 ,  G06F16/283

摘要： A preferred aggregate store for a multidimensional database receives and stores intermediate data generated as part of a larger query for avoiding repetitive or redundant data retrievals incurring costly data paths. Aggregates include intermediate tables and sets of data, often generated from a join of two or more distinct data tables, combined for generating a query result. In the event an aggregate is called for, certain storage locations may be preferable to others due to network distance, fees for storage and processing, as in the case of cloud storage, or write accessibility. Designation of a preferred aggregate store ensures that aggregates called for by the query processing are stored in a beneficial location for cost and efficiency.

公开(公告)号：US20230342360A1

公开(公告)日：2023-10-26

申请号：US18139077

申请日：2023-04-25

申请人： AtScale, Inc.

发明人： Daryl Odnert ,  Patrick J. Toole ,  Sarah Gerweck ,  Joseph Barefoot ,  Rouzbeh Safaie

IPC分类号： G06F16/2453 ,  G06F16/2455 ,  G06F16/28

CPC分类号： G06F16/24544 ,  G06F16/24561 ,  G06F16/283

摘要： A preferred aggregate store for a multidimensional database receives and stores intermediate data generated as part of a larger query for avoiding repetitive or redundant data retrievals incurring costly data paths. Aggregates include intermediate tables and sets of data, often generated from a join of two or more distinct data tables, combined for generating a query result. In the event an aggregate is called for, certain storage locations may be preferable to others due to network distance, fees for storage and processing, as in the case of cloud storage, or write accessibility. Designation of a preferred aggregate store ensures that aggregates called for by the query processing are stored in a beneficial location for cost and efficiency.

公开(公告)号：US11899665B2

公开(公告)日：2024-02-13

申请号：US17529890

申请日：2021-11-18

申请人： Atscale, Inc.

发明人： Rouzbeh Safaie ,  Joseph Barefoot ,  Trystan R. Leftwich

IPC分类号： G06F16/2455 ,  G06F16/2453 ,  G06F16/242 ,  G06F11/34

CPC分类号： G06F16/24552 ,  G06F11/3419 ,  G06F16/244 ,  G06F16/2456 ,  G06F16/24544

摘要： A query engine or compute engine receiving a query request identifies a plurality of data sources for satisfying a query request, and determines, from among multiple data sources, one or more fields likely to incur substantial computational demands in processing the query request. Pre-positioning aggregation logic moves the determined fields one data source to another data source for positioning the moved fields to a single data source from which the query result will be computed.

公开(公告)号：US20220164354A1

公开(公告)日：2022-05-26

申请号：US17529890

申请日：2021-11-18

申请人： Atscale, Inc.

发明人： Rouzbeh Safaie ,  Joseph Barefoot ,  Trystan R. Leftwich

IPC分类号： G06F16/2455 ,  G06F16/2453 ,  G06F11/34 ,  G06F16/242

摘要： A query engine or compute engine receiving a query request identifies a plurality of data sources for satisfying a query request, and determines, from among multiple data sources, one or more fields likely to incur substantial computational demands in processing the query request. Pre-positioning aggregation logic moves the determined fields one data source to another data source for positioning the moved fields to a single data source from which the query result will be computed.

公开(公告)号：US12045246B2

公开(公告)日：2024-07-23

申请号：US17529898

申请日：2021-11-18

申请人： Atscale, Inc.

发明人： Rouzbeh Safaie ,  Daniel J. Dosch ,  Joseph Barefoot ,  Trystan R. Leftwich ,  Matthew Baird ,  Sarah Gerweck

IPC分类号： G06F16/2458 ,  G06F16/2455 ,  G06F16/28

CPC分类号： G06F16/2471 ,  G06F16/2456 ,  G06F16/283

摘要： A data query and retrieval system receives a query request and identifies a plurality of data warehouses, or stores, where data needed to satisfy the query is stored. Data items, or fields, called for by the query request are grouped into sets based on fields stored at the same data warehouse. Individual data connections are generated for each data warehouse accessed, and a database view defined for the fields available at each respective data warehouse. The individual views are invoked in a single query statement by a query processor for accessing the respective data warehouses via the corresponding database view. In this manner, a query operator or user need not define multiple query expressions or perform separate queries for accessing data fields or dimensions residing at different data warehouses.

公开(公告)号：US20220164349A1

公开(公告)日：2022-05-26

申请号：US17529898

申请日：2021-11-18

申请人： Atscale, Inc.

发明人： Rouzbeh Safaie ,  Daniel J. Dosch ,  Joseph Barefoot ,  Trystan R. Leftwich ,  Matthew Baird ,  Sarah Gerweck

IPC分类号： G06F16/2458 ,  G06F16/28 ,  G06F16/2455

摘要： A data query and retrieval system receives a query request and identifies a plurality of data warehouses, or stores, where data needed to satisfy the query is stored. Data items, or fields, called for by the query request are grouped into sets based on fields stored at the same data warehouse. Individual data connections are generated for each data warehouse accessed, and a database view defined for the fields available at each respective data warehouse. The individual views are invoked in a single query statement by a query processor for accessing the respective data warehouses via the corresponding database view. In this manner, a query operator or user need not define multiple query expressions or perform separate queries for accessing data fields or dimensions residing at different data warehouses.