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:
Oct. 11, 2022
Filed:
Dec. 12, 2018
Teradata Us, Inc., Dayton, OH (US);
Bin Cao, Redondo Beach, CA (US);
Yi Xia, Rancho Palos Verdes, CA (US);
Sanjib Mishra, Hyderabad, IN;
Rama Krishna Korlapati, El Segundo, CA (US);
Tri Minh Tran, Los Alamitos, CA (US);
Mohammed Al-Kateb, Rolling Hills Estates, CA (US);
Paul Laurence Sinclair, Manhattan Beach, CA (US);
Chengyang Zhang, Bellevue, WA (US);
Teradata US, Inc., San Diego, CA (US);
Abstract
Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan for a received database query based on metrics. When a dynamic query execution plan is adopted, the database query is separated into query fragments. A plan fragment is generated for each query fragment and executed to generate feedback for the plan fragment. The feedback from the execution of each plan fragment is used to initiate query rewrite rules to simplify the corresponding query fragments. The rewritten query fragments are combined to generate the dynamic query plan.