Scriney, Michael ORCID: 0000-0001-6813-2630, O'Connor, Martin F. and Roantree, Mark (2017) Generating cubes from smart city web data. In: Australasian Computer Science Week (ACSW 2016), 31 Jan - 3 Feb, 2017, Geelong, Australia. ISBN 978-1-4503-4768-6
Abstract
A smart city necessitates the incorporation of data sources from multiple providers and data formats. Similar to the Internet Of Things, this data is primarily obtained from web streams producing XML or JSON data. Various combinations of data obtained from different providers can be used to enhance the lives of citizens with respect to different characteristics such as transport, city planning, the environment and housing. However, data provided from these streams is not necessarily in a format suitable for analysis and OLAP queries, despite the fact that these streams often provide measures and some elements of dimensionality often found in OLAP queries. In this research, we present a StarGraph construct which is designed to import web generated data streams and automatically generate the cube format necessary for OLAP queries. Our validation shows how the data streams can be captured as StarGraphs and using a traffic data case study, demonstrates an efficiency for populating and updating the data cube.
Metadata
Item Type: | Conference or Workshop Item (Paper) |
---|---|
Event Type: | Conference |
Refereed: | Yes |
Uncontrolled Keywords: | Data Warehousing; Data Cubes; OLAP; Smart City |
Subjects: | Computer Science > Computer software Computer Science > Computer engineering |
DCU Faculties and Centres: | Research Institutes and Centres > INSIGHT Centre for Data Analytics DCU Faculties and Schools > Faculty of Engineering and Computing > School of Computing |
Published in: | Proceedings of the Australasian Computer Science Week Multiconference. . ACM New York, NY, USA. ISBN 978-1-4503-4768-6 |
Publisher: | ACM New York, NY, USA |
Official URL: | https://doi.org/10.1145/3014812.3014863 |
Copyright Information: | © 2017 ACM. |
Use License: | This item is licensed under a Creative Commons Attribution-NonCommercial-Share Alike 3.0 License. View License |
Funders: | Science Foundation Ireland, SFI/12/RC/2289 |
ID Code: | 21466 |
Deposited On: | 03 Feb 2017 14:35 by Michael John Scriney . Last Modified 23 Aug 2019 08:55 |
Documents
Full text available as:
Preview |
PDF
- Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
468kB |
Metrics
Altmetric Badge
Dimensions Badge
Downloads
Downloads
Downloads per month over past year
Archive Staff Only: edit this record