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. 08, 2023
Filed:
Aug. 27, 2020
International Business Machines Corporation, Armonk, NY (US);
Mohamad F. Kalil, Ottawa, CA;
Calisto Zuzarte, Pickering, CA;
Mustafa Dawoud, London, CA;
Mohammed Fahd Alhamid, North York, CA;
Vincent Corvinelli, Mississauga, CA;
Wai Keat Tan, Vancouver, CA;
Ronghao Yang, Toronto, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method, a computer system, and a computer program product for cardinality estimation is provided. Embodiments of the present invention includes accessing database relations. The database relations are utilized to collect a random sample from each of the database relations. Training data is then generated from the random sample. The training data is used to build a cumulative frequency function (CFF) model. The cumulative frequency function (CFF) model then provides a cardinality estimation for an output for SQL operators.