20240054131. AUTOMATIC PARTITIONING OF MATERIALIZED VIEWS simplified abstract (Oracle International Corporation)
Contents
AUTOMATIC PARTITIONING OF MATERIALIZED VIEWS
Organization Name
Oracle International Corporation
Inventor(s)
Randall Bello of Austin TX (US)
Andrew Witkowski of Foster City CA (US)
AUTOMATIC PARTITIONING OF MATERIALIZED VIEWS - A simplified explanation of the abstract
This abstract first appeared for US patent application 20240054131 titled 'AUTOMATIC PARTITIONING OF MATERIALIZED VIEWS
Simplified Explanation
- Techniques for automatically partitioning materialized views are provided. - A definition of a materialized view is identified. - Multiple candidate partitioning schemes are identified based on the definition. - A query is generated indicating one or more of the candidate partitioning schemes. - The query is executed, resulting in partition counts for each candidate scheme. - A candidate partitioning scheme is selected based on the partition counts. - The materialized view is automatically partitioned based on the selected scheme.
Potential Applications
- Database management systems - Data warehousing - Business intelligence tools
Problems Solved
- Efficient management of materialized views - Optimization of query performance - Scalability of data storage
Benefits
- Automated partitioning process - Improved query performance - Scalability for large datasets
Original Abstract Submitted
techniques for automatically partitioning materialized views are provided. in one technique, a definition of a materialized view is identified. based on the definition, multiple candidate partitioning schemes are identified. a query is generated that indicates one or more of the candidate partitioning schemes. the query is then executed, where 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, a candidate partitioning scheme is selected from among the plurality of candidate partitioning schemes. the materialized view is automatically partitioned based on the candidate partitioning scheme.