US 12,135,719 B2
Automatic partitioning of materialized views
Rafi Ahmed, Fremont, CA (US); Randall Bello, Austin, TX (US); and Andrew Witkowski, Foster City, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Aug. 10, 2022, as Appl. No. 17/884,917.
Prior Publication US 2024/0054131 A1, Feb. 15, 2024
Int. Cl. G06F 16/245 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24554 (2019.01) [G06F 16/24539 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
identifying a definition of a materialized view that contains a result of a particular query, wherein the definition indicates one or more columns of one or more base tables;
based on the definition, identifying a plurality of candidate partitioning schemes;
generating a query that indicates one or more candidate partitioning schemes in the plurality of candidate partitioning schemes;
executing the query, wherein executing the query results in one or more partition counts, each corresponding to a different candidate partitioning scheme of the one or more candidate partitioning schemes;
based on the one or more partition counts, selecting a candidate partitioning scheme from among the plurality of candidate partitioning schemes;
automatically partitioning the materialized view based on the candidate partitioning scheme;
storing the partitioned materialized view on physical storage media;
wherein the method is performed by one or more computing devices.