Hernández, José L; Arévalo, David; Martín, Susana; Katsigarakis, Kyriakos; Lilis, Georgios N; Rovas, Dimitrios; De Miguel, Ignacio; (2024) Using Extraction, Transformation and Loading Procedures for Digitalisation of Buildings. In: 2024 9th International Conference on Smart and Sustainable Technologies (SpliTech). IEEE: Bol and Split, Croatia.

Preview

Text SpliTech_ETL.pdf - Accepted Version Download (767kB) | Preview

Abstract

The digitalisation of the building stock necessitates the integration of a wide array of digital and non-digital data sources into a cohesive framework that adheres to standardized data formats. Achieving this integration involves employing various extraction, transformation, and loading processes. These processes play a crucial role in converting raw data collected from building sites into instances that align with the specified unified format. This work delves into extraction, transformation, and loading methods utilized across nine pilot building sites situated in different countries, each marked by substantial data diversity. The heterogeneity among data sources and, consequently, datasets, is effectively addressed by a customized gathering process. This process incorporates static data to enhance the overall quality, enabling better-informed decision-making. The result is a harmonized building data repository with 10 use cases and more than 8000 data points, facilitating the application of intelligent services for energy-efficient management strategies. Enrichment of data is also achieved by synchronization approaches to ensure the coherence of the data.

Download activity - last month

Export as CSVJSONXML

Download activity - last 12 months

Export as CSVJSONXML

Downloads by country - last 12 months

Export as XMLJSONCSV

Archive Staff Only

View Item