Database
Logical Design Tuning via Workload-aware E/R-to-Relational Mapping
arXiv cs.DB0 views
arXiv:2611.23632v1 Announce Type: new Abstract: Conceptual data models, like the E/R model, can provide a more stable and intuitive user-facing interface and better logical independence for applications, compared to the relational model which is forced to closely mirror the physical representation. However, this flexibility introduces a challenge as well as an opportunity: a single conceptual schema admits many semantically equivalent relational schemas, whose performance can differ substantially across workloads. Traditional mapping methods use a set of predefined transformation rules or designer-selected mapping strategies, rather than optimizing the relational realization with respect to the expected workload. In this paper, we present a cost-based framework for workload-aware conceptual-to-relational mapping. Given an E/R schema and a representative workload, our framework automatically selects an efficient relational schema by optimizing mapping decisions, including inheritance, entity and relationship representations. User-specified E/R queries are compiled into SQL over the selected relational realization, allowing existing relational query optimizers to determine the physical execution plan. Experiments on real-world-inspired schemas show that mapping choices strongly affect performance; fixed or heuristic strategies exhibit large variability across workloads, whereas our approach consistently achieves competitive performance avoiding pathological cases.
Source:https://arxiv.org/abs/2611.23632PreviousThe Value Semantics Layer: Enabling Machine-Understandable Databases for Agentic AINextCascadeability and the Realization Gap: An Empirical Study of LLM-Powered Semantic Filtering
Related posts
Azure Free Account in 2026: $200 Credit, 12-Month and Always-Free Services
0dev.to Tutorial
Upgrade Laravel to PHP 8.6: Step-by-Step Guide (2026)
0dev.to PHP
Benchmarking TypeScript KV & Cache Engines in 2026: KVDock vs. Unstorage vs. Keyv
0dev.to Node
Contract Review Retrieval Explained: Node.js Fallbacks for Cited Change Alerts
0dev.to Node

SQL Running Total: Calculate Cumulative Daily Sales Using SUM() OVER() in Oracle SQL
0dev.to Database
Ephyra: A Property-Based Testing Framework for the LLM Era
0arXiv cs.SE