Abstract
This study shows the importance of online analytical processing (OLAP), the efficiency and effectiveness in supporting decision-making and how the entire flow is crucial for developing smart cities. Without a complete discharge from data collection, extraction, transformation and loading (ETL), data warehouse building, KPIs’ (key performance indicators) development and building of multidimensional cubes, it would be impossible to get practical and valuable information from the city sensors. In this sense, a study was conducted to understand the data context and what information it could extract from them. Then, a model was built to store this data. Some schemas and pre-aggregations were defined to support the parking flow monitoring. These tasks allowed us to extract valuable information from the data and assist in decision-making. The speed and veracity of the indicators obtained enabled the team to conclude that the OLAP mechanism is an asset that allows decision-makers to have a quality data analysis tool. This mechanism makes it possible to determine several indicators, such as which park is the busiest by week and which has the total capacity. This way, the solution consists of six indicators and a data warehouse with four dimensions and two fact tables containing the data necessary to respond to the predefined indicators.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
T.A. Litman, Parking. Management 32 (2021)
J.B. Anthony, Managing digital transformation of smart cities through enterprise architecture – A review and research agenda. Enterp. Inf. Syst. 15, 299–331 (2021). https://doi.org/10.1080/17517575.2020.1812006
A. Khalil, M. Belaissaoui, Key-value data warehouse: Models and OLAP analysis, in 2020 IEEE 2nd International Conference on Electronics, Control, Optimization and Computer Science (ICECOCS), vol. 2020, pp. 1–6. https://doi.org/10.1109/ICECOCS50124.2020.9314447
Onesmus Mbaabu, MOLAP vs ROLAP vs HOLAP in Online Analytical Processing (OLAP). Engineering Education (EngEd) Program | Section 2021. https://www.section.io/engineering-education/molap-vs-rolap-vs-holap/. Accessed 7 June 2022
S. Das, A novel parking management system, for smart cities, to save fuel, time, and money, in 2019 IEEE 9th Annual Computing and Communication Workshop and Conference (CCWC), (2019), pp. 0950–0954. https://doi.org/10.1109/CCWC.2019.8666537
CORPORATIVA I, Business Intelligence ou como interpretar os dados para tomar as melhores decisões de negócio. Iberdrola (2022). https://www.iberdrola.com/inovacao/o-que-e-business-intelligence Accessed 14 June 2022
TOTVS, Análise de dados: o que é, vantagens, tipos e como fazer (TOTVS, 2022). https://www.totvs.com/blog/negocios/analise-de-dados/. Accessed 14 June 2022
IBM Cloud Education. What is ETL (Extract, Transform, Load)? (2022). https://www.ibm.com/cloud/learn/etl. Accessed 14 June 2022
R. F. Teixeira, O que são KPIs e qual a sua importância para gerir um negócio? Tudo sobre sistema de Help Desk, Service Desk, Atendimento e Gestão (2017). . https://deskmanager.com.br/blog/o-que-sao-kpis/ Accessed 7 June 2022
What is a Data Warehouse? (n.d.). https://www.oracle.com/pt/database/what-is-a-data-warehouse/. Accessed 14 June 2022
A. Hammad, S. AbouRizk, Y. Mohamed, Application of KDD techniques to extract useful knowledge from labor resources data in industrial construction projects. J. Manag. Eng. 30, 05014011 (2014). https://doi.org/10.1061/(ASCE)ME.1943-5479.0000280
V. Ferreira, F. Portela, M.F. Santos, A practical solution to synchronize structured and non-structured repositories, in Trends and Applications in Information Systems and Technologies, ed. by Á. Rocha, H. Adeli, G. Dzemyda, F. Moreira, A.M. Ramalho Correia, (Springer, Cham, 2021), pp. 356–365. https://doi.org/10.1007/978-3-030-72654-6_35
G. Fernandes, F. Portela, M.F. Santos, Towards the development of a data science modular solution, in 2019 7th International Conference on Future Internet of Things and Cloud Workshops (FiCloudW), (2019), pp. 96–103. https://doi.org/10.1109/FiCloudW.2019.00030
Pandas documentation—pandas 1.4.2 documentation (n.d.). https://pandas.pydata.org/docs/#. Accessed 14 June 2022
Visual Studio Code – Code Editing. Redefined (n.d.). https://code.visualstudio.com/. Accessed 14 June 2022
MySQL:: MySQL Workbench (n.d.). https://www.mysql.com/products/workbench/. Accessed June 7, 2022
Cube—Headless BI for Building Data Applications. CubeDev (n.d.). https://cube.dev/. Accessed 7 June 2022
Kimball DW/BI Lifecycle Methodology. Kimball Group (n.d.) https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dw-bi-lifecycle-method/. Accessed 14 June 2022
The Kimball Lifecycle. Wikipedia (2018)
P. Builder, Entenda a metodologia Scrum e como utilizá-la na empresa. Project Builder (2020). https://www.projectbuilder.com.br/blog/o-que-e-scrum/. Accessed 27 Apr 2022
Acknowledgement
This work has also been developed under the scope of the project NORTE-01-0247-FEDER-045397, supported by the Northern Portugal Regional Operational Programme (NORTE 2020), under the Portugal 2020 Partnership Agreement, through the European Regional Development Fund (ERDF).
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this chapter
Cite this chapter
Barros, F., Oliveira, J., Vieira, J., Fernandes, C., Portela, F. (2023). Intelligent Dashboards for Car Parking Flow Monitoring. In: da Silva Portela, C.F. (eds) Sustainable, Innovative and Intelligent Societies and Cities. EAI/Springer Innovations in Communication and Computing. Springer, Cham. https://doi.org/10.1007/978-3-031-30514-6_3
Download citation
DOI: https://doi.org/10.1007/978-3-031-30514-6_3
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-30513-9
Online ISBN: 978-3-031-30514-6
eBook Packages: EngineeringEngineering (R0)