HodDB: Design and Analysis of a Query Processor for Brick.
Conference
·
· Proceedings of The 4th International Conference on Systems for Energy-Efficient Built Environments (BuildSys ‘17)
OSTI ID:1420425
- UC Berkeley; California Institute for Energy and Environment, UC Berkeley
- UC Berkeley
Brick is a recently proposed metadata schema and ontology for describing building components and the relationships between them. It represents buildings as directed labeled graphs using the RDF data model. Using the SPARQL query language, building-agnostic applications query a Brick graph to discover the set of resources and relationships they require to operate. Latency-sensitive applications, such as user interfaces, demand response and modelpredictive control, require fast queries — conventionally less than 100ms. We benchmark a set of popular open-source and commercial SPARQL databases against three real Brick models using seven application queries and find that none of them meet this performance target. This lack of performance can be attributed to design decisions that optimize for queries over large graphs consisting of billions of triples, but give poor spatial locality and join performance on the small dense graphs typical of Brick. We present the design and evaluation of HodDB, a RDF/SPARQL database for Brick built over a node-based index structure. HodDB performs Brick queries 3-700x faster than leading SPARQL databases and consistently meets the 100ms threshold, enabling the portability of important latency-sensitive building applications.
- Research Organization:
- Regents of the University of California, Berkeley; California Institute for Energy and Environment
- Sponsoring Organization:
- USDOE Office of Energy Efficiency and Renewable Energy (EERE), Building Technologies Office (EE-5B)
- Contributing Organization:
- UC Berkeley
- DOE Contract Number:
- EE0007685
- OSTI ID:
- 1420425
- Report Number(s):
- DOE-UCB-EE0007685-2; FOA-0001383 (BENEFIT)
- Conference Information:
- Journal Name: Proceedings of The 4th International Conference on Systems for Energy-Efficient Built Environments (BuildSys ‘17)
- Country of Publication:
- United States
- Language:
- English
Similar Records
Query relaxation for portable brick-based applications
Composing Data Parallel Code for a SPARQL Graph Engine
Brick : Metadata schema for portable smart building applications
Conference
·
Tue Nov 16 23:00:00 EST 2021
· Proceedings of the 8th ACM International Conference on Systems for Energy-Efficient Buildings, Cities, and Transportation
·
OSTI ID:1880038
Composing Data Parallel Code for a SPARQL Graph Engine
Conference
·
Sun Sep 08 00:00:00 EDT 2013
·
OSTI ID:1123246
Brick : Metadata schema for portable smart building applications
Journal Article
·
Thu Feb 22 19:00:00 EST 2018
· Applied Energy
·
OSTI ID:1537997