Comparativo de desempenhos de armazenamento de dados de dispositivos IoT usando banco de dados relacionais e não relacionais

Abstract

This study aims to compare the performance of relational and non-relational databases in storing data generated by IoT (Internet of Things) devices. The choice of database type is critical to ensure efficiency and scalability in IoT applications, as relational databases, although widely used, may present limitations in managing large volumes of data and resource demands. On the other hand, non-relational databases are designed to handle large amounts of data, standing out for their efficiency and ease of use in high-scalability scenarios. To achieve this, the study adopts a comprehensive approach, combining a systematic literature review with practical experiments. The systematic review rigorously analyzes existing studies on the performance of these databases, while the practical experiments evaluate the behavior of solutions such as PostgreSQL (relational database) and MongoDB (non-relational database) in simulated IoT data collection and query scenarios. Performance metrics include response time, throughput, and resource consumption. The results provide a basis for selecting appropriate storage technologies, considering the specificities and demands of each IoT application.