公开(公告)号：US20230350864A1

公开(公告)日：2023-11-02

申请号：US17661066

申请日：2022-04-28

Applicant: TERADATA US, INC.

Inventor： Rangavajjula K N Sai Krishna ,  Chandrasekhar Tekur ,  Bhashyam Ramesh ,  Shambhu Sree Vegunta ,  Venkata Ramana Jyothula

IPC: G06F16/2453

CPC classification number: G06F16/24539 ,  G06F16/24537

Abstract: A database system includes a storage medium to store a semi-materialized view (MV) defined on an MV condition, the semi-MV including metadata containing references to objects containing data of one or more tables that satisfy the MV condition, the objects stored in a remote data store that is coupled to the database system over a network. The database system includes at least one processor to receive a query including a query condition, determine that the semi-MV can be used to satisfy the query based on the MV condition and the query condition, and use the metadata in the semi-MV to retrieve data of the objects in the remote data store for the query.