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. 25, 2026
Filed:
Dec. 27, 2019
Teradata Us, Inc., San Diego, CA (US);
Grace Kwan-on Au, Rancho Palos Verdes, CA (US);
Nobul Reddy Goli, Hyderabad, IN;
Vivek Kumar, Jharkhand, IN;
Ming Zhang, Rolling Hills Estates, CA (US);
Bin Cao, Redondo Beach, CA (US);
Sanjay Nair, El Segundo, CA (US);
Kanaka Durga Rajanala, El Segundo, CA (US);
Sanjib Mishra, Hyderabad, IN;
Naveen Jaiswal, Hyderabad, IN;
Lu MA, Tenafly, NJ (US);
Xiaorong Luo, Bellevue, WA (US);
Teradata US, Inc., San Diego, CA (US);
Abstract
An apparatus, method and computer program product for query optimization in a Relational Database Management System (RDBMS), wherein an optimizer accesses a query expression repository (QER), so that the optimizer learns from previous versions of the queries to improve current and subsequent versions of the queries. The QER stores planning and execution information for QEs from the previous versions of the queries, wherein the QEs comprise table relations, intermediate results and/or final results of operations in the previous versions of the queries. The optimizer searches the QER for QEs from the query execution plans, and uses information from the QEs stored in the QER when optimizing the current and subsequent versions of the queries. The optimizer may also reuses results from the QEs stored in the QER.