公开(公告)号：US20220012242A1

公开(公告)日：2022-01-13

申请号：US17368932

申请日：2021-07-07

申请人： AtScale, Inc

发明人： Daniel J. Dosch ,  Sarah Gerweck

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

摘要： A multidimensional database query engine processes a query request by forming a logical plan of subqueries for retrieving and assembling the data called for by the query request. A multi-pass analysis identifies a granularity of facts needed to fulfill the query request. A recursive analysis parses the query request and identifies components comprising the full query request. The analysis derives a subquery from each component, and identifies dependencies on other subqueries. The subqueries are arranged in a tree structure based on the dependencies. The tree represents subqueries as nodes, with query operations denoted by parent nodes for the dependent subqueries. The result is a hierarchical tree of subqueries associated based on operations between the subqueries and dependent subqueries descending from their parent subqueries.

公开(公告)号：US12026161B2

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

申请号：US17368932

申请日：2021-07-07

申请人： AtScale, Inc.

发明人： Daniel J. Dosch ,  Sarah Gerweck

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

CPC分类号： G06F16/24544 ,  G06F11/3419 ,  G06F16/2246 ,  G06F16/24556 ,  G06F16/2456 ,  G06F16/283

摘要： A multidimensional database query engine processes a query request by forming a logical plan of subqueries for retrieving and assembling the data called for by the query request. A multi-pass analysis identifies a granularity of facts needed to fulfill the query request. A recursive analysis parses the query request and identifies components comprising the full query request. The analysis derives a subquery from each component, and identifies dependencies on other subqueries. The subqueries are arranged in a tree structure based on the dependencies. The tree represents subqueries as nodes, with query operations denoted by parent nodes for the dependent subqueries. The result is a hierarchical tree of subqueries associated based on operations between the subqueries and dependent subqueries descending from their parent subqueries.

公开(公告)号：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.