PhD Seminar • Data Systems • ARM & SQLP: Introducing the new foundation of a Path-Aware Query Language to bridge Relational and Graph Data

Wednesday, August 20, 2025 12:00 pm - 1:00 pm EDT (GMT -04:00)

Please note: This PhD seminar will take place in DC 3301.

Enamul Haque (Moni), PhD candidate
David R. Cheriton School of Computer Science

Supervisors: Professors Grant Weddell & David Toman

In this talk we introduce a new foundation for structured data integration built on the Abstract Relational Model (ARM) and SQL with paths (SQLP). Our approach unifies tabular and graphical perspectives by adopting a labelled property graph semantics, offering a conceptual framework that supports models like LPGs and RDF while addressing identity issues through an abstract “EID” domain alongside standard types such as INTEGER and VARCHAR. Entities without literal identifiers are referenced via referring expression types, enabling incremental, orthogonal identity resolution. SQLP extends SQL with a concise navigational syntax (“x.f1…fk”) for compactly expressing unary foreign key joins, and we demonstrate how SQLP queries over ARM schemas can be rewritten into equivalent executable RM queries, ensuring seamless interplay between property graphs and relational views. This foundation promises a flexible, powerful basis for integrating structured data, benefiting both conceptual modelling and physical database design.