cs.DBSep 13, 2026

Towards Anticipatory Databases Through Shared Data and Workload Semantics

Authors: Farzaneh Zirak, Kasper Overgaard Mortensen, Farhana Choudhury, Renata Borovica-Gajic

Organizations: University of Melbourne · Aarhus University

Abstract

Database management systems increasingly serve dynamic and exploratory workloads, yet many of their decisions still rely on low-level signals such as recency, frequency, and address locality. These signals capture how data was accessed, but not what is being examined or how an analytical focus evolves. We argue for treating workload semantics as a first-class control signal for anticipatory decision making. Central to this view, we introduce semantic locality and semantic trajectories, which capture relationships among nearby queries and how those relationships evolve across a session. We propose a framework that represents semantic context at the data, query, and session levels, models its evolution over time, and translates it into task-specific utility estimates. We instantiate this framework in semantic prefetching and semantic cache eviction, which share a semantic layer to make two separate decisions. Prefetching uses semantic trajectories to anticipate future accesses beyond what address-based locality can capture, while eviction uses semantic relevance to inform block replacement. These systems provide initial evidence that shared semantic context can support multiple DBMS components. We further outline how this principle can extend to other decisions and data systems, and discuss key challenges in representation, cost, adaptation, and evaluation.

Figures & tables

Explore similar work

CardsList
  1. SemJoin: Semantic Join Optimization

    Jun 28, 2026Christopher Gou, Aditya Banerjee, Jiaxuan Wang +1Large Language Model-Guided OptimizationCost-Aware Inference

  2. Kalypso: Relational LLM Serving

    Jul 26, 2026Hojae Son, Md Ashraful Islam, Huy Gia Cao +2LLM ServingLLM Inference Scheduling

  3. Prompt as a Data Type: In-Database LLM Prompt Management and Rewriting

    Jul 23, 2026Denis Mayr Lima Martins, Gottfried VossenLLM PromptingPrompt Optimization