Backend
Efficient Path Query Processing in Relational Database Systems
arXiv cs.DB0 views
arXiv:2604.02553v2 Announce Type: replace Abstract: Path queries are crucial for property graphs, and there is growing interest in queries that combine regular expressions over labels with constraints on property values of vertices and edges. Efficient evaluation of such general path queries requires that intermediate results be eliminated early when there is no possible completion to a full result path. Neither state-of-the-art (SOA) graph DBMS nor relational DBMS currently can do this effectively for a large class of queries. We show that this problem can be addressed by giving a relational optimizer ``a little help'' by specifying early filtering opportunities explicitly in the query. To this end, we propose ReCAP, an abstraction that greatly simplifies the implementation of early filtering techniques for any type of property constraint for which such early filtering can be derived. No matter how complex the constraint, one only needs to implement (1) an NFA-style state transition function and (2) a handful of functions that mirror those needed for user-defined aggregates. We show that when using ReCAP, a standard relational DBMS like DuckDB can effectively push property constraints deep into the query plan, beating the SOA graph and relational DBMS by a factor up to 400,000 over a variety of queries and input graphs.
Source:https://arxiv.org/abs/2604.02553PreviousResilience for Regular Path Queries: Towards a Complexity ClassificationNextOzone: A Unified Platform for Transportation Research
Related posts
Actuator-Aware Observer Inputs for Cascade ADRC of Quadrotors Under Rotor Lag, Measurement Delay and Sensor Noise
0arXiv cs.RO
Keeping the Franka Emika Panda alive: a ROS 2 stack with a reliable position interface
0arXiv cs.RO
Rapid co-design of Buoyancy-assisted robots for Challenging Locomotion using Gaussian Evolutionary Specialists
0arXiv cs.RO
Specification-Aware Distribution Shaping for Robotics Foundation Models
0arXiv cs.RO
Sensorium: An Open-Source Multimodal Data Collection and Curation Library for Embodied Surgical AI
0arXiv cs.RO

Copilot Fusion Takes Local Models, and the Offline Boundary Is Somewhere Else
0dev.to AI