  We present a system to support generalized SQL workload analysis and
management for multi-tenant and multi-database platforms. Workload analysis
applications are becoming more sophisticated to support database
administration, model user behavior, audit security, and route queries, but the
methods rely on specialized feature engineering, and therefore must be
carefully implemented and reimplemented for each SQL dialect, database system,
and application. Meanwhile, the size and complexity of workloads are increasing
as systems centralize in the cloud. We model workload analysis and management
tasks as variations on query labeling, and propose a system design that can
support general query labeling routines across multiple applications and
database backends. The design relies on the use of learned vector embeddings
for SQL queries as a replacement for application-specific syntactic features,
reducing custom code and allowing the use of off-the-shelf machine learning
algorithms for labeling. The key hypothesis, for which we provide evidence in
this paper, is that these learned features can outperform conventional feature
engineering on representative machine learning tasks. We present the design of
a database-agnostic workload management and analytics service, describe
potential applications, and show that separating workload representation from
labeling tasks affords new capabilities and can outperform existing solutions
for representative tasks, including workload sampling for index recommendation
and user labeling for security audits.
