DBScholar

Back to papers

SAM: Database Generation from Query Workloads with Supervised Autoregressive Models

Summary: SAM: supervised autoregressive model to generate synthetic DBs from query workloads. Linear in workload size, attributes, and domain; unbiased sampling with join-key assignment recovers full outer joins, yielding data matching input cardinalities. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6540
Venue
SIGMOD
Year
2022
Pagerank
6.3628539e-05
Overall Rank
5,105 | 64.98%
DOI
10.1145/3514221.3526168

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{yang_sigmod22,
        title = {{SAM: Database Generation from Query Workloads with Supervised Autoregressive Models}},
        author = {Yang, Jingyi and Wu, Peizhi and Cong, Gao and Zhang, Tieying and He, Xiao},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3526168},
        url = {https://dl.acm.org/doi/10.1145/3514221.3526168},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank Citing Paper Year Venue Pagerank
6,323 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9141228e-05
6,555 Controllable Tabular Data Synthesis Using Diffusion Models 2024 SIGMOD 5.8415111e-05
9,536 Database Gyms 2023 CIDR 5.2529727e-05
10,196 Are Learned DBMS Components Robust to Workload Drift?: [Experiments & Analysis] 2026 SIGMOD 5.093636e-05
10,199 Automated Discovery of Test Oracles for Database Management Systems Using LLMs 2026 SIGMOD 5.093636e-05
10,216 DBugScribe: Automatic Database Bug Reproduction from Community Reports 2026 SIGMOD 5.093636e-05
10,358 Detecting Logic Bugs in DBMSs via Equivalent Data Construction 2026 SIGMOD 5.093636e-05
10,501 SQLBarber: A System Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2026 SIGMOD 5.093636e-05
10,967 Privacy-Enhanced Database Synthesis for Benchmark Publishing 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
244 On the Design and Quantification of Privacy Preserving Data Mining Algorithms 2001 PODS 0.00023476901
280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022454217
323 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021264788
365 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00020041735
388 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019410042
401 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019092557
513 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017190574
734 QAGen: Generating Query-Aware Test Databases 2007 SIGMOD 0.00014525584
1,071 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012322342
1,468 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010686496
2,129 Data Synthesis based on Generative Adversarial Networks 2018 VLDB 9.1266572e-05
2,369 Data Generation using Declarative Constraints 2011 SIGMOD 8.682429e-05
3,086 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7708642e-05
3,994 Generating Databases for Query Workloads 2010 VLDB 6.9686731e-05
4,261 Relational Data Synthesis using Generative Adversarial Networks: A Design Space Exploration 2020 VLDB 6.7982037e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB
2 323 DeepDB: Learn from Data, not from Queries! 2020 VLDB
3 4,398 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB
4 1,573 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD
5 5,073 Database Workload Characterization with Query Plan Encoders 2022 VLDB
6 6,704 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD
7 4,053 Database-Agnostic Workload Management 2019 CIDR
8 3,338 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB
9 5,712 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB
10 3,086 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD