Bruno Cabral
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Research Subjects
Bruno Cabral has a total of 71 co-authors. Here are the top co-authors by number of shared publications:
- Jorge Bernardino
Institute of Engineering of Coimbra—ISEC, Polytechnic University of Coimbra, Rua da Misericórdia, Lagar dos Cortiços, S. Martinho do Bispo, 3045-093 Coimbra, Portugal
18 shared publications - Alcides Fonseca
University of Lisbon, Lisbon, Portugal
13 shared publications - Gonçalo Carvalho
Centre for Informatics and Systems of the University of Coimbra, Department of Informatics Engineering, University of Coimbra, Coimbra, Portugal
7 shared publications - Vasco Pereira
CISUC, Department of Computer Science, Universidade de Coimbra
6 shared publications - João Ricardo Lourenço
Univ Coimbra, FCTUC, Ctr Informat & Syst, P-3030290 Coimbra, Portugal
3 shared publications - Marco Vieira
University of North Carolina at Charlotte
3 shared publications
Latest Publications
- Open Access
- 10 July 2025
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 13, 120830-120851
A Survey of Holistic Approaches for Distributed Database Systems: From Conceptual Model to Deployment
Database modeling defines the logical design, structure, and specifications for data storage and access within a DataBase Management System (DBMS), a core component of any Information System (IS). While conceptual database models (e.g., Entity-Relationship (ER) diagrams, Unified Modeling Language (UML)) facilitate the transition to physical models, they still fall short when it comes to supporting distributed and multi-layered architectures. Current approaches lack unified modeling abstractions, forcing manual reconciliation between high-level designs and their distributed implementations, leading to inefficiencies, deployment risks, and reliance on specialized teams. Existing tools (e.g., Kubernetes, Terraform) automate infrastructure but remain disconnected from Conceptual Models (CMs), requiring error-prone manual translation. This paper assesses the current state of the art in holistic approaches that aim to integrate modeling and deployment, identifies critical gaps in end-to-end automation, classifies the available deployment tools, and highlights advances that could enable building a distributed data management system based solely on its CM, potentially leading to greater agility and reduced operational complexity. Finally, the paper discusses open questions and research directions that indicate promising areas for future investigation.
- 10 July 2025
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 13, 120830-120851
Open AccessA Survey of Holistic Approaches for Distributed Database Systems: From Conceptual Model to Deployment
Database modeling defines the logical design, structure, and specifications for data storage and access within a DataBase Management System (DBMS), a core component of any Information System (IS). While conceptual database models (e.g., Entity-Relationship (ER) diagrams, Unified Modeling Language (UML)) facilitate the transition to physical models, they still fall short when it comes to supporting distributed and multi-layered architectures. Current approaches lack unified modeling abstractions, forcing manual reconciliation between high-level designs and their distributed implementations, leading to inefficiencies, deployment risks, and reliance on specialized teams. Existing tools (e.g., Kubernetes, Terraform) automate infrastructure but remain disconnected from Conceptual Models (CMs), requiring error-prone manual translation. This paper assesses the current state of the art in holistic approaches that aim to integrate modeling and deployment, identifies critical gaps in end-to-end automation, classifies the available deployment tools, and highlights advances that could enable building a distributed data management system based solely on its CM, potentially leading to greater agility and reduced operational complexity. Finally, the paper discusses open questions and research directions that indicate promising areas for future investigation.
- Open Access
- 19 June 2023
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 11, 62744-62757
ER+: A Conceptual Model for Distributed Multilayer Systems
Distributed databases and data transformation mechanisms are highly relevant to Business Intelligence and Data Analytics. Most enterprise systems today have multiple and distributed databases, and the growing dissemination of Edge-Oriented architectures is driving this trend across many industries and business domains. The Entity-Relationship (ER) model is fundamental to modeling complex enterprise systems, but it has shortcomings. In particular, the ER model cannot represent data transport between different locations (or databases) of a system, nor can it conceptually express data transformation operations, such as aggregate and line functions, that are standard in data analytics. Therefore, we propose ER+, an extension of the ER model, where data distribution, data transport, data transformation, and information generation for distributed operational and analytical systems can be visually identified. The new ER+ representation has another important benefit, it provides the basis for transforming conceptual models into physical implementations of distributed data-oriented systems. This work introduces new concepts in ER modeling and illustrates their application. The TPC-H use case is also used to demonstrate the the practicality of the ER+ model.
- 19 June 2023
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 11, 62744-62757
Open AccessER+: A Conceptual Model for Distributed Multilayer Systems
Distributed databases and data transformation mechanisms are highly relevant to Business Intelligence and Data Analytics. Most enterprise systems today have multiple and distributed databases, and the growing dissemination of Edge-Oriented architectures is driving this trend across many industries and business domains. The Entity-Relationship (ER) model is fundamental to modeling complex enterprise systems, but it has shortcomings. In particular, the ER model cannot represent data transport between different locations (or databases) of a system, nor can it conceptually express data transformation operations, such as aggregate and line functions, that are standard in data analytics. Therefore, we propose ER+, an extension of the ER model, where data distribution, data transport, data transformation, and information generation for distributed operational and analytical systems can be visually identified. The new ER+ representation has another important benefit, it provides the basis for transforming conceptual models into physical implementations of distributed data-oriented systems. This work introduces new concepts in ER modeling and illustrates their application. The TPC-H use case is also used to demonstrate the the practicality of the ER+ model.
- Open Access
Can We Trust Edge Computing Simulations? An Experimental Assessment
Simulators allow for the simulation of real-world environments that would otherwise be financially costly and difficult to implement at a technical level. Thus, a simulation environment facilitates the implementation and development of use cases, rendering such development cost-effective and faster, and it can be used in several scenarios. There are some works about simulation environments in Edge Computing (EC), but there is a gap of studies that state the validity of these simulators. This paper compares the execution of the EdgeBench benchmark in a real-world environment and in a simulation environment using FogComputingSim, an EC simulator. Overall, the simulated environment was 0.2% faster than the real world, thus allowing for us to state that we can trust EC simulations, and to conclude that it is possible to implement and validate proofs of concept with FogComputingSim.
Open AccessCan We Trust Edge Computing Simulations? An Experimental Assessment
Simulators allow for the simulation of real-world environments that would otherwise be financially costly and difficult to implement at a technical level. Thus, a simulation environment facilitates the implementation and development of use cases, rendering such development cost-effective and faster, and it can be used in several scenarios. There are some works about simulation environments in Edge Computing (EC), but there is a gap of studies that state the validity of these simulators. This paper compares the execution of the EdgeBench benchmark in a real-world environment and in a simulation environment using FogComputingSim, an EC simulator. Overall, the simulated environment was 0.2% faster than the real world, thus allowing for us to state that we can trust EC simulations, and to conclude that it is possible to implement and validate proofs of concept with FogComputingSim.
- Open Access
- 28 December 2021
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 10, 3351-3365
Comparative Analysis of Data Modeling Design Tools
Conceptual modeling describes the physical or social aspects of the world abstractly, encompassing the interpretation of data production, gathering, visualization, and analysis. The quality of the data analysis system will limit the excellence of any decision-making process. Thus, accurately specifying the physical data model is essential. The primary goal of our work is to compare tools that can create this physical model. We recognize several types of data models, but we only include the relational data model. We evaluate free and commercial data modeling tools. But it is challenging to decide how to compare them and which elements are crucial. We propose a new approach for software tools’ evaluation based on the Business Readiness Rating (BRR) model and the OSSpal evaluation methodology. In this work, we show that this new methodology can be tailored to the needs of each individual developer or team, thus providing proper and meaningful results. Also, by applying this hybrid approach to the evaluation of data modelling tools, we show it can robustly handle the bias from lesser relevant evaluation categories.
- 28 December 2021
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 10, 3351-3365
Open AccessComparative Analysis of Data Modeling Design Tools
Conceptual modeling describes the physical or social aspects of the world abstractly, encompassing the interpretation of data production, gathering, visualization, and analysis. The quality of the data analysis system will limit the excellence of any decision-making process. Thus, accurately specifying the physical data model is essential. The primary goal of our work is to compare tools that can create this physical model. We recognize several types of data models, but we only include the relational data model. We evaluate free and commercial data modeling tools. But it is challenging to decide how to compare them and which elements are crucial. We propose a new approach for software tools’ evaluation based on the Business Readiness Rating (BRR) model and the OSSpal evaluation methodology. In this work, we show that this new methodology can be tailored to the needs of each individual developer or team, thus providing proper and meaningful results. Also, by applying this hybrid approach to the evaluation of data modelling tools, we show it can robustly handle the bias from lesser relevant evaluation categories.
- Open Access
- 8 November 2021
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 9, 150459-150469
When Two are Better Than One: Synthesizing Heavily Unbalanced Data
Nowadays, data is king and if treated and used properly it promises to give organizations a competitive edge over rivals by enabling them to develop and design Intelligent Systems to improve their services. However, they need to fully comply with not only ethical but also regulatory obligations, where, e.g., privacy (strictly) needs to be respected when using or sharing data, thus protecting both the interests of users and organizations. Fraud Detection systems are examples of such systems where Machine Learning algorithms leverage information to classify financial transactions as legitimate or illicit. The data used to create these solutions is usually highly structured and contains categorical and continuous features characterised by complex distributions. One of the main challenges of fraud detection is concerned with the scarcity of fraudulent instances which results in highly unbalanced datasets. Additionally, privacy is crucial, and it is usually forbidden, or not possible, to share the data of organizations and individuals for creating or improving models.In this paper we propose a framework for private data sharing based on synthetic data generation using Generative Adversarial Networks (GAN) that learns the specificities of financial transactions data and generates fictitious data that keeps the utility of the original datasets. Our proposal, called Duo-GAN, uses two GAN generators to handle the data imbalance problem, one generator for fraudulent instances and the other for legitimate instances. With this approach, we observed, at most, a 5% disparity in F1 scores between classifiers trained and tested with actual data and the ones trained with synthetic data and tested with actual data.
- 8 November 2021
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 9, 150459-150469
Open AccessWhen Two are Better Than One: Synthesizing Heavily Unbalanced Data
Nowadays, data is king and if treated and used properly it promises to give organizations a competitive edge over rivals by enabling them to develop and design Intelligent Systems to improve their services. However, they need to fully comply with not only ethical but also regulatory obligations, where, e.g., privacy (strictly) needs to be respected when using or sharing data, thus protecting both the interests of users and organizations. Fraud Detection systems are examples of such systems where Machine Learning algorithms leverage information to classify financial transactions as legitimate or illicit. The data used to create these solutions is usually highly structured and contains categorical and continuous features characterised by complex distributions. One of the main challenges of fraud detection is concerned with the scarcity of fraudulent instances which results in highly unbalanced datasets. Additionally, privacy is crucial, and it is usually forbidden, or not possible, to share the data of organizations and individuals for creating or improving models.In this paper we propose a framework for private data sharing based on synthetic data generation using Generative Adversarial Networks (GAN) that learns the specificities of financial transactions data and generates fictitious data that keeps the utility of the original datasets. Our proposal, called Duo-GAN, uses two GAN generators to handle the data imbalance problem, one generator for fraudulent instances and the other for legitimate instances. With this approach, we observed, at most, a 5% disparity in F1 scores between classifiers trained and tested with actual data and the ones trained with synthetic data and tested with actual data.
- 20 March 2021
- Published by Springer Nature in Empirical Software Engineering
- Vol. 26 (3) , 1-55
GreenHub: a large-scale collaborative dataset to battery consumption analysis of android devices
- 20 March 2021
- Published by Springer Nature in Empirical Software Engineering
- Vol. 26 (3) , 1-55
GreenHub: a large-scale collaborative dataset to battery consumption analysis of android devices
- Top Cited Papers
- 18 January 2021
- Published by Springer Nature in Computing
- Vol. 103 (5) , 993-1023
Edge computing: current trends, research challenges and future directions
- 18 January 2021
- Published by Springer Nature in Computing
- Vol. 103 (5) , 993-1023
Top Cited PapersEdge computing: current trends, research challenges and future directions
- Open Access
- 20 November 2020
- Published by MDPI AG in Future Internet
- Vol. 12 (11) , 205
Failure Mode and Effect Analysis for Cyber-Physical Systems
Cyber-Physical Systems (CPS) are a prominent component of the modern digital transformation, which combines the dynamics of the physical processes with those of software and networks. Critical infrastructures have built-in CPS, and assessing its risk is crucial to avoid significant losses, both economic and social. As CPS are increasingly attached to the world’s main industries, these systems’ criticality depends not only on software efficiency and availability but also on cyber-security awareness. Given this, and because Failure Mode and Effect Analysis (FMEA) is one of the most effective methods to assess critical infrastructures’ risk, in this paper, we show how this method performs in the analysis of CPS threats, also exposing the main drawbacks concerning CPS risk assessment. We first propose a risk prevention analysis to the Communications-Based Train Control (CBTC) system, which involves exploiting cyber vulnerabilities, and we introduce a novel approach to the failure modes’ Risk Priority Number (RPN) estimation. We also propose how to adapt the FMEA method to the requirement of CPS risk evaluation. We applied the proposed procedure to the CBTC system use case since it is a CPS with a substantial cyber component and network data transfer.
- 20 November 2020
- Published by MDPI AG in Future Internet
- Vol. 12 (11) , 205
Open AccessFailure Mode and Effect Analysis for Cyber-Physical Systems
Cyber-Physical Systems (CPS) are a prominent component of the modern digital transformation, which combines the dynamics of the physical processes with those of software and networks. Critical infrastructures have built-in CPS, and assessing its risk is crucial to avoid significant losses, both economic and social. As CPS are increasingly attached to the world’s main industries, these systems’ criticality depends not only on software efficiency and availability but also on cyber-security awareness. Given this, and because Failure Mode and Effect Analysis (FMEA) is one of the most effective methods to assess critical infrastructures’ risk, in this paper, we show how this method performs in the analysis of CPS threats, also exposing the main drawbacks concerning CPS risk assessment. We first propose a risk prevention analysis to the Communications-Based Train Control (CBTC) system, which involves exploiting cyber vulnerabilities, and we introduce a novel approach to the failure modes’ Risk Priority Number (RPN) estimation. We also propose how to adapt the FMEA method to the requirement of CPS risk evaluation. We applied the proposed procedure to the CBTC system use case since it is a CPS with a substantial cyber component and network data transfer.
- 1 October 2020
- Published by Elsevier in Engineering Applications of Artificial Intelligence
- Vol. 95
Computation offloading in Edge Computing environments using Artificial Intelligence techniques
- 1 October 2020
- Published by Elsevier in Engineering Applications of Artificial Intelligence
- Vol. 95
Computation offloading in Edge Computing environments using Artificial Intelligence techniques
- 30 July 2020
- Published by Springer Nature
- p. 84-98
CBench-Dynamo: A Consistency Benchmark for NoSQL Database Systems
- 30 July 2020
- Published by Springer Nature
- p. 84-98
CBench-Dynamo: A Consistency Benchmark for NoSQL Database Systems