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

Authors: de Beer, Riaan

Subject Terms: SQL databases, runtime diagnostics, DSFB Database, deterministic systems, structural motifs, residual trajectories, query performance analysis, PostgreSQL, reproducibility pipeline, observer layer, systems engineering, structural inference, SQL Server, SQLShare, drift-slew decomposition, residual primacy, observer-only systems, TPC-DS, fault detection, query optimization diagnostics, deterministic causal structure, PELT, deterministic replay systems, baseline comparison, transactional workloads, OLTP systems, plan regression detection, certification-oriented systems, deterministic benchmarking, distributed systems diagnostics, trajectory grammar, fault injection, residual analysis, database telemetry, read-only observability, reproducible research, Endoduction, structural semiotics, performance monitoring, change point detection, non-intrusive monitoring, deterministic replay, BOCPD, auditability, motif grammar, software observability, DSFB, database observability, Drift-Slew Fusion Bootstrap, residual-based inference, semiotic manifolds, deterministic augmentation, non-stochastic modeling, ADWIN, cardinality estimation error, JOB benchmark, Snowset, controlled perturbation, prior art, deterministic inference

Mining SQL workloads for learning analysis behavior

Authors: Moreau, Clement, Legroux, Clement, Peralta, Veronika ^⁎, Hamrouni, Mohamed Ali

Source: In Information Systems September 2022 108