Distributed queries through dynamic views

    公开(公告)号:US12045246B2

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

    申请号:US17529898

    申请日:2021-11-18

    申请人: Atscale, Inc.

    摘要: 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.

    DISTRIBUTED QUERIES THROUGH DYNAMIC VIEWS

    公开(公告)号:US20220164349A1

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

    申请号:US17529898

    申请日:2021-11-18

    申请人: Atscale, Inc.

    摘要: 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.