Roantree, Mark, Scriney, MichaelORCID: 0000-0001-6813-2630 and O'Connor, Martin F.
(2017)
Integrating online data for smart city data marts.
In: 31st British International Conference on Databases, 10-12 July 2017, London, UK.
ISBN 978-3-319-60794-8
The development of smart city infrastructures is seen as an important strategic component for many countries with applications in the areas of government services, healthcare, transport and traffic management, energy, water, and the management of waste services. In general, each of these infrastructural components generates data as it delivers its service. The usage of this data is often crucial both to the continued development of the service and for forward planning. While the data sources are often not complex in structure, traditional decision support systems are not built to handle continuous data streams, new or disappearing data sources, or the integration of multiple online data sources. In this work, we develop a flexible ETL process to quickly process and integrate online smart city data sources to deliver information that can be used in close to real-time.
31st British International Conference on Databases, BICOD 2017, London, UK, July 10–12, 2017, Proceedings. Data Analytics
10365(1).
Springer International Publishing. ISBN 978-3-319-60794-8