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: 6427
Venue: SIGMOD
Year: 2022
Pagerank: 4.3698717e-05
Overall Rank: 9,205 | 36.03%
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,684	TDSQL: Tencent Distributed Database System	2024	VLDB	4.6754482e-05
8,880	Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like?	2025	VLDB	4.4254065e-05
11,087	Presto’s History-based Query Optimizer	2024	VLDB	4.1905499e-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.00039408116
208	Schism: a Workload-Driven Approach to Database Replication and Partitioning	2010	VLDB	0.00034478612
424	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.00023604384
662	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.00018478597
704	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017785557
1,017	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB	0.00014627121
2,959	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	7.8116974e-05
4,075	Towards Predicting Query Execution Time for Concurrent and Dynamic Database Workloads	2013	VLDB	6.4699689e-05
4,547	Database-Agnostic Workload Management	2019	CIDR	6.0904384e-05
5,524	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	5.4589341e-05
6,655	Fast and Effective Distribution-Key Recommendation for Amazon Redshift	2020	VLDB	4.9693109e-05
9,839	Rapid Adoption of Cloud Data Warehouse Technology Using Datometry Hyper-Q	2018	SIGMOD	4.2698419e-05
11,592	A Framework for Emulating Database Operations in Cloud Data Warehouses	2020	SIGMOD	4.1905499e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
7,564	Modeling Shifting Workloads for Learned Database Systems	2024	SIGMOD	4.7049893e-05
10,322	SafeLoad: Efficient Admission Control Framework for Identifying Memory-Overloading Queries in Cloud Data Warehouses	2026	VLDB	4.1905499e-05
4,592	Auto-WLM: Machine Learning Enhanced Workload Management in Amazon Redshift	2023	SIGMOD	6.056004e-05
12,483	Deadline and QoS Aware Data Warehouse	2007	VLDB	4.1905499e-05
7,602	Oracle Workload Intelligence	2015	SIGMOD	4.6964845e-05
7,787	Cost-Intelligent Data Analytics in the Cloud	2024	CIDR	4.6468106e-05
11,592	A Framework for Emulating Database Operations in Cloud Data Warehouses	2020	SIGMOD	4.1905499e-05
4,547	Database-Agnostic Workload Management	2019	CIDR	6.0904384e-05
5,645	Database Workload Characterization with Query Plan Encoders	2022	VLDB	5.3928148e-05
9,839	Rapid Adoption of Cloud Data Warehouse Technology Using Datometry Hyper-Q	2018	SIGMOD	4.2698419e-05