{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,10,26]],"date-time":"2023-10-26T16:17:34Z","timestamp":1698337054724},"reference-count":26,"publisher":"MDPI AG","issue":"11","license":[{"start":{"date-parts":[[2023,10,25]],"date-time":"2023-10-25T00:00:00Z","timestamp":1698192000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"name":"NORTE 2020","award":["NORTE-01-0247-FEDER-045397"]},{"name":"European Regional Development Fund"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information"],"abstract":"Due to the amount of data emerging, it is necessary to use an online analytical processing (OLAP) framework capable of responding to the needs of industries. Processes such as drill-down, roll-up, three-dimensional analysis, and data filtering are fundamental for the perception of information. This article demonstrates the OLAP framework developed as a valuable and effective solution in decision making. To develop an OLAP framework, it was necessary to create the extract, transform and load the (ETL) process, build a data warehouse, and develop the OLAP via cube.js. Finally, it was essential to design a solution that adds more value to the organizations and presents several characteristics to support the entire data analysis process. A backend API (application programming interface) to route the data via MySQL was required, as well as a frontend and a data visualization layer. The OLAP framework was developed for the ioCity project. However, its great advantage is its versatility, which allows any industry to use it in its system. One ETL process, one data warehouse, one OLAP model, six indicators, and one OLAP framework were developed (with one frontend and one API backend). In conclusion, this article demonstrates the importance of a modular, adaptable, and scalable tool in the data analysis process and in supporting decision making.<\/jats:p>","DOI":"10.3390\/info14110584","type":"journal-article","created":{"date-parts":[[2023,10,25]],"date-time":"2023-10-25T08:14:47Z","timestamp":1698221687000},"page":"584","source":"Crossref","is-referenced-by-count":0,"title":["Pervasive Real-Time Analytical Framework\u2014A Case Study on Car Parking Monitoring"],"prefix":"10.3390","volume":"14","author":[{"given":"Francisca","family":"Barros","sequence":"first","affiliation":[{"name":"Algoritmi Centre, University of Minho, 4800-058 Braga, Portugal"}]},{"given":"Beatriz","family":"Rodrigues","sequence":"additional","affiliation":[{"name":"Algoritmi Centre, University of Minho, 4800-058 Braga, Portugal"}]},{"given":"Jos\u00e9","family":"Vieira","sequence":"additional","affiliation":[{"name":"IOTECH, 4785-588 Trofa, Portugal"}]},{"ORCID":"http:\/\/orcid.org\/0000-0003-2181-6837","authenticated-orcid":false,"given":"Filipe","family":"Portela","sequence":"additional","affiliation":[{"name":"Algoritmi Centre, University of Minho, 4800-058 Braga, Portugal"},{"name":"IOTECH, 4785-588 Trofa, Portugal"}]}],"member":"1968","published-online":{"date-parts":[[2023,10,25]]},"reference":[{"key":"ref_1","unstructured":"(2022, June 07). Onesmus Mbaabu. MOLAP vs ROLAP vs HOLAP in Online Analytical Processing (OLAP). Engineering Education (EngEd) Program|Section 2021. Available online: https:\/\/www.section.io\/engineering-education\/molap-vs-rolap-vs-holap\/."},{"key":"ref_2","unstructured":"(2022, June 07). Cube Cube\u2014Headless BI for Building Data Applications. CubeDev 2022. Available online: https:\/\/cube.dev\/."},{"key":"ref_3","unstructured":"Portela, F., Fernandes, G., Alves, P., and Ferreira, J.A. (2022). Method to Execute Offline Data Analysis, IOTECHPIS-Innovation on Technology, Lda.. Portugal PT. ID. 116393, IPC: G06F 16\/00 (2019.01)."},{"key":"ref_4","doi-asserted-by":"crossref","unstructured":"Fernandes, G., Portela, F., and Santos, M.F. (2019, January 26\u201328). Towards the Development of a Data Science Modular Solution. Proceedings of the 2019 7th International Conference on Future Internet of Things and Cloud Workshops (FiCloudW), Istanbul, Turkey.","DOI":"10.1109\/FiCloudW.2019.00030"},{"key":"ref_5","unstructured":"(2022, December 28). ioCity. Available online: https:\/\/iocity.research.iotech.pt\/."},{"key":"ref_6","unstructured":"Francisca, B., Beatriz, P., Vasco, P., Jos\u00e9 VCarlos, F., and Filipe, P. (2022). An analysis of Smart Cities Initiatives in Portugal. Springer EAI\u2014Sustainable, Innovative and Intelligent Societies and Cities, Springer."},{"key":"ref_7","doi-asserted-by":"crossref","first-page":"1641","DOI":"10.1007\/s11276-019-02048-w","article-title":"Impact of enterprise information systems on selected key performance indicators in construction project management: An empirical study","volume":"27","year":"2021","journal-title":"Wirel. Netw."},{"key":"ref_8","doi-asserted-by":"crossref","first-page":"481","DOI":"10.1140\/epjst\/e2012-01703-3","article-title":"Smart cities of the future","volume":"214","author":"Batty","year":"2012","journal-title":"Eur. Phys. J. Spec. Top."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"3","DOI":"10.1016\/j.techfore.2015.12.019","article-title":"Big data analytics: Understanding its capabilities and potential benefits for healthcare organizations","volume":"126","author":"Wang","year":"2018","journal-title":"Technol. Forecast. Soc. Change"},{"key":"ref_10","unstructured":"(2022, June 14). TOTVS An\u00e1lise de dados: O que \u00e9, Vantagens, Tipos e como Fazer. Available online: https:\/\/www.totvs.com\/blog\/negocios\/analise-de-dados\/."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"927","DOI":"10.1016\/j.is.2012.12.001","article-title":"Scheduling strategies for efficient ETL execution","volume":"38","author":"Karagiannis","year":"2013","journal-title":"Inf. Syst."},{"key":"ref_12","unstructured":"(2022, June 14). IBM Cloud Education What is ETL (Extract, Transform, Load)?. Available online: https:\/\/www.ibm.com\/cloud\/learn\/etl."},{"key":"ref_13","first-page":"48","article-title":"A Structural Model of Data Warehousing Success","volume":"49","author":"Hwang","year":"2008","journal-title":"J. Comput. Inf. Syst."},{"key":"ref_14","first-page":"368","article-title":"Implementation of Extract, Transform, Load on Data Warehouse and Business Intelligence Using Pentaho and Tableau to Analyse Sales Performance of Olist Store","volume":"7","author":"Anggrainy","year":"2022","journal-title":"Science"},{"key":"ref_15","unstructured":"(2022, December 23). What Is Power BI? Definition and Features|Microsoft Power BI. Available online: https:\/\/powerbi.microsoft.com\/en-us\/what-is-power-bi\/."},{"key":"ref_16","unstructured":"(2022, December 23). MultiTech. What Are the Advantages and Dis Advantages in Power BI. Medium 2020. Available online: https:\/\/informationit27.medium.com\/what-are-the-advantages-and-dis-advantages-in-power-bi-98b49152daf4."},{"key":"ref_17","unstructured":"Lu, M. (2022, December 23). Discovering Microsoft Self-service BI solution: Power BI. Available online: https:\/\/www.theseus.fi\/handle\/10024\/76619."},{"key":"ref_18","unstructured":"(2022, December 23). What Is Tableau?. Available online: https:\/\/www.tableau.com\/why-tableau\/what-is-tableau."},{"key":"ref_19","unstructured":"(2022, December 23). Advantages and Disadvantages of Tableau. Available online: https:\/\/absentdata.com\/advantages-and-disadvantages-of-tableau\/."},{"key":"ref_20","doi-asserted-by":"crossref","unstructured":"Leite, N., Pedrosa, I., and Bernardino, J. (2019, January 19\u201322). Open Source Business Intelligence on a SME: A Case Study Using Pentaho. Proceedings of the 2019 14th Iberian Conference on Information Systems and Technologies (CISTI), Coimbra, Portugal.","DOI":"10.23919\/CISTI.2019.8760740"},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"29","DOI":"10.32358\/rpd.2018.v4.274","article-title":"Business intelligence na educa\u00e7\u00e3o: Uma aplica\u00e7\u00e3o do software pentaho","volume":"4","author":"Cordeiro","year":"2018","journal-title":"Rev. Produ\u00e7\u00e3o Desenvolv."},{"key":"ref_22","doi-asserted-by":"crossref","unstructured":"Guarda, T., Portela, F., and Augusto, M.F. (2022). Advanced Research in Technologies, Information, Innovation and Sustainability. ARTIIS 2022. Communications in Computer and Information Science, Springer.","DOI":"10.1007\/978-3-031-20316-9"},{"key":"ref_23","doi-asserted-by":"crossref","first-page":"05014011","DOI":"10.1061\/(ASCE)ME.1943-5479.0000280","article-title":"Application of KDD Techniques to Extract Useful Knowledge from Labor Resources Data in Industrial Construction Projects","volume":"30","author":"Hammad","year":"2014","journal-title":"J. Manag. Eng."},{"key":"ref_24","doi-asserted-by":"crossref","first-page":"45","DOI":"10.2753\/MIS0742-1222240302","article-title":"A Design Science Research Methodology for Information Systems Research","volume":"24","author":"Peffers","year":"2007","journal-title":"J. Manag. Inf. Syst."},{"key":"ref_25","unstructured":"(2022, June 14). Kimball DW\/BI Lifecycle Methodology. Available online: https:\/\/www.kimballgroup.com\/data-warehouse-business-intelligence-resources\/kimball-techniques\/dw-bi-lifecycle-method\/."},{"key":"ref_26","unstructured":"Builder, P. (2022, April 27). Entenda a metodologia Scrum e como utiliz\u00e1-la na empresa. Project Builder 2020. Available online: https:\/\/www.projectbuilder.com.br\/blog\/o-que-e-scrum\/."}],"container-title":["Information"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2078-2489\/14\/11\/584\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,25]],"date-time":"2023-10-25T09:10:52Z","timestamp":1698225052000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2078-2489\/14\/11\/584"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,10,25]]},"references-count":26,"journal-issue":{"issue":"11","published-online":{"date-parts":[[2023,11]]}},"alternative-id":["info14110584"],"URL":"http:\/\/dx.doi.org\/10.3390\/info14110584","relation":{},"ISSN":["2078-2489"],"issn-type":[{"value":"2078-2489","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,10,25]]}}}
