公开(公告)号：US11514041B2

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

申请号：US17127716

申请日：2020-12-18

Applicant: Oracle International Corporation

Inventor： Murali Thiyagarajan ,  Praveen T. J. Kumar

IPC: G06F16/2453 ,  G06F16/23 ,  G06F16/248 ,  G06K9/62 ,  G06N20/00

Abstract: Techniques for a database management system to estimate a time needed to refresh a materialized view. This is a followed by an approach that uses estimated refresh duration to determine an optimized schedule for refreshing the materialized view. The approach combines the refresh duration estimate with a query rewrite pattern prediction for the materialized view and a quiet period prediction for the materialized view to determine the optimized refresh schedule for the materialized view.

公开(公告)号：US11995081B2

公开(公告)日：2024-05-28

申请号：US17127845

申请日：2020-12-18

Applicant: Oracle International Corporation

Inventor： Murali Thiyagarajan ,  Praveen T. J. Kumar

IPC: G06F16/2453 ,  G06F16/23 ,  G06F16/248 ,  G06F18/214 ,  G06F18/24

CPC classification number: G06F16/24539 ,  G06F16/2358 ,  G06F16/2393 ,  G06F16/248 ,  G06F18/2148 ,  G06F18/24765

Abstract: Techniques for a database management system to predict when in the future a materialized view will be used for query rewrite. This is a followed by an approach that uses the quiet rewrite pattern prediction to determine an optimized schedule for refreshing the materialized view. The approach combines the query rewrite pattern prediction with a quiet period prediction for the materialized view and an estimated refresh duration for the materialized view to determine the optimized refresh schedule for the materialized view.

公开(公告)号：US11921717B2

公开(公告)日：2024-03-05

申请号：US17127712

申请日：2020-12-18

Applicant: Oracle International Corporation

Inventor： Murali Thiyagarajan ,  Praveen T. J. Kumar

IPC: G06F16/2453 ,  G06F16/23 ,  G06F16/248 ,  G06F18/214 ,  G06F18/24

CPC classification number: G06F16/24539 ,  G06F16/2358 ,  G06F16/2393 ,  G06F16/248 ,  G06F18/2148 ,  G06F18/24765

Abstract: Techniques for a database management system to predict when in the future a materialized view will have a quiet period during which the materialized view will not be stale. This is a followed by an approach that uses the quiet period prediction to determine an optimized schedule for refreshing the materialized view. The approach combines the quiet period prediction with a query rewrite pattern prediction for the materialized view and an estimated refresh duration for the materialized view to determine the optimized refresh schedule for the materialized view.

公开(公告)号：US11379476B2

公开(公告)日：2022-07-05

申请号：US16653639

申请日：2019-10-15

Applicant: Oracle International Corporation

Inventor： Sabina Petride ,  Mohamed Ziauddin ,  Praveen T. J. Kumar ,  Huagang Li ,  Andrew Witkowski ,  Sankar Subramanian

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/23 ,  G06F16/242

Abstract: Techniques are described for storing and maintaining, in a materialized view, bitmap data that represents a bitmap of each possible distinct value of an expression and rewriting a query for a count of distinct values of the expression using the materialized view. The materialized view contains bitmap data that represents a bitmap of each possible distinct value of a first expression, and aggregate values of additional expressions, and is stored in memory or on disk by a database system. The database system receives a query that requests a number of distinct values, of the first expression, and an aggregate value for an additional expression. In response, the database system, rewrites the query to: compute the number of distinct values by counting the bits in the bitmap data of the materialized view that are set to the first value, and obtains the aggregate value for the additional expression in the materialized view.