Pre-training Summarization Models of Structured Datasets for Cardinality Estimation

Download PDF

Abstract

We consider the problem of pre-training models which convert unseen structured datasets into succinct summaries that can be used to answer cardinality estimation queries. Doing so uniquely avoids per-dataset training and, in our experiments, reduces the time to construct summaries by up to 100x. When datasets change, our summaries are incrementally updateable. Our key insights are to use multiple summaries per dataset, use learned summaries for columnsets for which other simpler techniques do not achieve high accuracy and that analogous to similar pre-trained models for images and text, structured datasets have some common frequency and correlation patterns which our models learn to capture by pre-training on a large and diverse corpus of datasets.