[Back]

S. Glawischnig, H. Hofstätter, R. Bräuer, A. Mahdavi:
"Bridging RDBMS and NoSQL to build a high-performance and scalable storage engine for building information systems";
Talk: ECPPM 2014 eWork and eBusiness in Architecture, Engineering and Construction, Wien, Österreich; 2014-09-17 - 2014-09-19; in: "Proceedings of the 10th European Conference on Product and Process Modelling (ECPPM2014), Vienna, Austria, 17-19 September 2014", A. Mahdavi, B. Martens, R.J. Scherer (ed.); Taylor & Francis - Balkema, 1/1/Boca Raton|London|New York|Leiden (2014), ISBN: 978-1-138-02710-7; 231 - 236.

Building Information Systems handle non-abstract data that is directly related to the built environment
(e.g., indoor climate, energy use, building systems´ states). Buildings are equipped with sensors that
measure various phenomena (e.g., occupancy, temperature, electrical energy consumption, light states, CO2
concentration, etc.). This contribution documents the development of a hybrid RDBMS-NoSQL database solution
for a vendor independent building monitoring toolkit that is developed at the Department of Building
Physics and Building Ecology, Vienna University of Technology. The existing framework is optimized to resolve
performance problems. The existing relational database schema is analyzed and divided into static and
dynamic entities. Static entities (e.g. configurations) are kept in a MySQL database. Dynamic sensor measurements
are moved to a NoSQL cluster. Data access routines are generalized and standardized to allow database
independent data processing.

none - see english version