The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 23, 2022
Filed:
Jun. 25, 2018
Oracle International Corporation, Redwood Shores, CA (US);
Jian Wen, Hollis, NH (US);
Sam Idicula, Santa Clara, CA (US);
Nitin Kunal, Zurich, DE;
Farhan Tauheed, Zurich, DE;
Seema Sundara, Nashua, NH (US);
Nipun Agarwal, Saratoga, CA (US);
Indu Bhagat, Vancouver, CA;
Oracle International Corporation, Redwood Shores, CA (US);
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.