Análise comparativa de arquiteturas de bancos de dados distribuídos para documentos fiscais eletrônicos

Abstract

The large volume of data moved when handling digital fiscal documents raises the need to optimize their storage and access, one of these forms of optimization being the partitioning and distribution of databases. In this study, a comparative analysis of distributed PostgreSQL database architectures was conducted in order to determine the impact of distribution on the query performance of these databases. It was found that the cost of transmitting results exceeds the performance gains due to parallelization in the most common forms of query.