CPC G06F 16/24545 (2019.01) [G06F 16/24537 (2019.01); G06F 16/24544 (2019.01)] | 26 Claims |
1. A method for cardinality estimation using machine learning, the method comprising:
accessing database relations;
collecting a random sample from each of the database relations;
generating training data for creating a cumulative frequency function (CFF) model from the random sample collected from each of the database relations, the cumulative frequency function (CFF) model predicted using a machine learning model;
creating the cumulative frequency function (CFF) model from the generated training data using the machine learning model; and
predicting a cardinality estimation of a plurality of structured query language (SQL) predicates, the cardinality estimation based upon the cumulative frequency function (CFF) model.
|