公开(公告)号：US20220309063A1

公开(公告)日：2022-09-29

申请号：US17214298

申请日：2021-03-26

Applicant: Oracle International Corporation

Inventor： Binglu Du ,  Murali Thiyagarajah ,  Praveen Tupati Jaganath Kumar ,  Randall Bello

IPC: G06F16/2453 ,  G06F16/2455

Abstract: Using Logical Partition Change Tracking (LPCT), a database system is able track the staleness of a materialized view at the level of logical partitions of a base database object, in addition to or instead of tracking the staleness of a materialized view at the level of physical partitions of the base database object. When the base database object is logically partitioned, it is possible using LPCT for the system to identify the records of the materialized view that correspond to changed logical partitions of the base database object. The records of the materialized view corresponding to the changed logical partitions become stale while other records of the materialized view corresponding to unchanged logical partitions remain fresh. The ability to identify which records of a materialized view are fresh and which are stale at the level of logical partitions of the base database object allows the system to rewrite user queries to use those records of the materialized view that are fresh.