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:
Jul. 04, 2023
Filed:
Dec. 27, 2012
Applicant:
Teradata Us, Inc., Dayton, OH (US);
Inventors:
Lu Ma, Tenafly, NJ (US);
Grace Kwan-On Au, Rancho Palos Verdes, CA (US);
Assignee:
Teradata US, Inc., San Diego, CA (US);
Attorney:
Primary Examiner:
Assistant Examiner:
Int. Cl.
CPC ...
G06F 16/27 (2019.01); G06F 16/2453 (2019.01);
U.S. Cl.
CPC ...
G06F 16/278 (2019.01); G06F 16/24542 (2019.01);
Abstract
Techniques for ordering predicates in column partitioned databases for query optimization. Predicates on a single CP table within a query are organized to predicate-CP nodes with various sets of column partitions. The predicates within each predicate-CP node and the predicate-CP nodes as a whole are ordered in ascending order of cost which is determined by CPU/IO cost and predicate selectivity. The reorganized query is then executed.
Ma, Lu. (2023). Techniques for ordering predicates in column partitioned databases for query optimization (U.S. Patent No. 11693883). U.S. Patent and Trademark Office. https://idiyas.com/patent/badge/11693883
Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile