Intelligent Automated Workload Analysis for Database Replatforming

Summary: qInsight automates deep workload analysis for database replatforming, extracting features and structural signals from queries via Hyper-Q beyond standard profilers. It scores rewrite difficulty with expert judgment, guiding migration order, as shown on 1.7B real-world queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 6426
Venue: SIGMOD
Year: 2022
Pagerank: 4.3740313e-05
Overall Rank: 9,203 | 35.98%
DOI: 10.1145/3514221.3526050

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,683	TDSQL: Tencent Distributed Database System	2024	VLDB	4.6799361e-05
8,884	Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like?	2025	VLDB	4.4283999e-05
11,084	Presto’s History-based Query Optimizer	2024	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
167	The Snowflake Elastic Data Warehouse	2016	SIGMOD	0.00039180521
209	Schism: a Workload-Driven Approach to Database Replication and Partitioning	2010	VLDB	0.00034468292
426	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.00023594359
661	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.00018481174
716	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017723171
1,019	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB	0.00014625603
2,965	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	7.8059273e-05
4,088	Towards Predicting Query Execution Time for Concurrent and Dynamic Database Workloads	2013	VLDB	6.4603918e-05
4,549	Database-Agnostic Workload Management	2019	CIDR	6.0926728e-05
5,473	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	5.4885366e-05
6,659	Fast and Effective Distribution-Key Recommendation for Amazon Redshift	2020	VLDB	4.9710856e-05
9,840	Rapid Adoption of Cloud Data Warehouse Technology Using Datometry Hyper-Q	2018	SIGMOD	4.2739372e-05
11,588	A Framework for Emulating Database Operations in Cloud Data Warehouses	2020	SIGMOD	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
7,828	Modeling Shifting Workloads for Learned Database Systems	2024	SIGMOD	4.6407986e-05
10,310	SafeLoad: Efficient Admission Control Framework for Identifying Memory-Overloading Queries in Cloud Data Warehouses	2026	VLDB	4.1945683e-05
4,593	Auto-WLM: Machine Learning Enhanced Workload Management in Amazon Redshift	2023	SIGMOD	6.0606891e-05
12,474	Deadline and QoS Aware Data Warehouse	2007	VLDB	4.1945683e-05
7,597	Oracle Workload Intelligence	2015	SIGMOD	4.7007801e-05
7,889	Cost-Intelligent Data Analytics in the Cloud	2024	CIDR	4.6253386e-05
11,588	A Framework for Emulating Database Operations in Cloud Data Warehouses	2020	SIGMOD	4.1945683e-05
4,549	Database-Agnostic Workload Management	2019	CIDR	6.0926728e-05
5,637	Database Workload Characterization with Query Plan Encoders	2022	VLDB	5.3979505e-05
9,840	Rapid Adoption of Cloud Data Warehouse Technology Using Datometry Hyper-Q	2018	SIGMOD	4.2739372e-05