Invention Grant
- Patent Title: Hybrid declarative query compiler and optimizer framework
-
Application No.: US16016966Application Date: 2018-06-25
-
Publication No.: US11423022B2Publication Date: 2022-08-23
- Inventor: Jian Wen , Sam Idicula , Nitin Kunal , Farhan Tauheed , Seema Sundara , Nipun Agarwal , Indu Bhagat
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F9/50 ; G06F16/2453 ; G06F16/22

Abstract:
Techniques are described herein for building a framework for declarative query compilation using both rule-based and cost-based approaches for database management. The framework involves constructing and using: a set of rule-based properties tables that contain optimization parameters for both logical and physical optimization, a recursive algorithm to form candidate physical query plans that is based on the rule based tables, and a cost model for estimating the cost of a generated physical query plan that is used with the rule based properties tables to prune inferior query plans.
Public/Granted literature
- US20190392068A1 HYBRID DECLARATIVE QUERY COMPILER AND OPTIMIZER FRAMEWORK Public/Granted day:2019-12-26
Information query