DSFB-Database: A Deterministic, Read-Only Structural Observer for Residual Trajectories in SQL Database Telemetry: An Empirical Prior-Art Demonstration on Five Public Workloads

Clariant (United States)

Indexed indatacite

Abstract

Abstract:We instantiate the Drift–Slew Fusion Bootstrap (DSFB) observer framework as a deter-ministic, read-only structural observer for residual trajectories emitted by production SQLengines (pg_stat_statements, pg_stat_io, SQL Server Query Store and DMVs, MySQL Per-formance Schema, Oracle ASH/AWR). Five operator-legible motif classes — plan-regressiononset, cardinality-mismatch regime, contention ramp, cache/buffer collapse, and workload phasetransition — are emitted as a replayable episode stream with bytewise-deterministic SHA256fingerprints. We evaluate on five public workloads — Snowset, SQLShare, CEB, JOB, and a TPC-DS-shaped controlled-perturbation harness — and report F1 = 1.0 across all five motifson…

Citation impact

13
total citations
FWCI
Percentile
References
25
Too recent for citation history.

Authors

1

Topics & keywords

Keywords
  • Residual
  • SQL
  • Observability
  • Oracle
  • Workload
  • Sql server
  • Predicate (mathematical logic)
  • Data definition language
No related works found for this paper.