ANÁLISE COMPARATIVA ENTRE O BANCO DE DADOS CASSANDRA (MODELO NOSQL) E O POSTGRESQL (MODELO RELACIONAL) EM DUAS DIFERENTES ORGANIZAÇÕES EMPRESARIAIS

• Main Authors: Ricardo Ribeiro Secco, Francisco Assis da Silva, Francisco Virginio Maracci, Mário Augusto Pazoti
• Format: Article
• Language: Portuguese
• Published: Universidade do Oeste Paulista 2016-06-01
• Series: Colloquium Exactarum
• Subjects: Cassandra; PostgreSQL; DBMS; SQL; database; NoSQL
• Online Access: http://revistas.unoeste.br/revistas/ojs/index.php/ce/article/view/1324/1754

Nowadays, different organizations use technology as a helper tool for the job, the possible difficulties that may occur in the information management, both in business and administrative sectors. The Database choice should be careful to store relevant information, since the database must provide high power reliability. This work makes a comparative analysis between the Cassandra (NoSQL Model) and the PostgreSQL (Relational Model) databases. Tests were performed with Cassandra and PostgreSQL databases, so that the performance can be checked the same in two different business organizations. The X and Y companies use the same relational database to record products. Tests performed with the implantation of Cassandra in these companies proved their high scalability and agility as well as their advantages and disadvantages.