Logo image
TriORM: Workload-Aware Neural-Symbolic Multi-objective Optimization for ORM Mapping Design
Conference proceeding

TriORM: Workload-Aware Neural-Symbolic Multi-objective Optimization for ORM Mapping Design

Sasan Azizian, Ayoub Hazrati, Artin Azizian and Elham Rastegari
Proceedings of the 3rd ACM International Conference on AI-Powered Software, pp.299-307
ACM Conferences
AIware '26: 3rd ACM International Conference on AI-Powered Software
07/05/2026

Abstract

Software and its engineering -- Formal software verification
Object-relational mapping (ORM) frameworks simplify persistence, yet routine mapping choices—including inheritance strategy, association encoding, and denormalization—can substantially alter the generated SQL and the trade-offs among query latency, insert/update cost, and storage footprint. Existing optimization approaches either guarantee semantic validity but incur expensive per-candidate deployment and benchmarking, or learn from schema structure alone and therefore miss the fact that workload behavior is mapping-dependent. We present TriORM, a workload-aware neural symbolic framework for multi-objective ORM mapping design that removes per-candidateworkload execution from the online recommendation loop while preserving validity by construction. TriORM (i) enumerates admissible mappings via bounded relational synthesis in Alloy, (ii) concretizes an abstract workload into schema-specific SQL templates for each candidate, and (iii) predicts continuous objectives using a tri-input model that fuses a typed schema-graph encoder, a concretized-workload encoder, and interpretable static cost proxies. The resulting predictions enable Pareto filtering and user-weighted selection without deploying or executing each candidate at inference time; profiling is performed only offline to obtain supervision. On nine TradeMaker/Leant benchmark models, TriORM improves mean Pareto-front approximation over Leant (GD/HV 0.03/0.78 vs. 0.07/0.61) and reduces end-toend recommendation time (3.6×103s vs. 2.6×104s), while preserving semantic correctness within the chosen synthesis bounds.
url
https://doi.org/10.1145/3805760.3814920View
Published (Version of record) Open

Metrics

1 Record Views

Details

Logo image