APLICAÇÃO HÍBRIDA DE BANCO DE DADOS

Pedro Henrique Nilson Mantovani; Fernando Tiosso

doi:10.31510/infa.v17i1.711

Authors

Pedro Henrique Nilson Mantovani Faculdade de Tecnologia de Taquaritinga (Fatec) – Taquaritinga - São Paulo – Brasil
Fernando Tiosso Faculdade de Tecnologia de Taquaritinga (Fatec) – Taquaritinga - São Paulo – Brasil

DOI:

https://doi.org/10.31510/infa.v17i1.711

Keywords:

Banco de Dados, SGBD, Banco Relacional, Banco Não Relacional, NoSQL, JsonB

Abstract

The purpose of this article is to provide an understanding of the operation of two types of databases that are currently widely used in e-commerce applications: relational and non-relational. In order to glimpse some scenarios and applications for these databases, it was necessary to review the concepts that permeate relational and non-relational databases, as well as to study the environment they support. In order to support the research, several publications were consulted involving the proposed objective, based on articles, documentation and books. For the practical development, an environment was used to manage the two types of databases, relational and non-relational, promoting a hybrid database scenario. With the experiments, it was possible to observe the results of the application, more specifically in relation to the storage of data in the two types of databases, highlighting characteristics such as security and performance, in addition to the emphasis on the use of JSONB data type, responsible for providing a differentiated performance in reading the data, justifying its possible use in e-commerce type applications.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

References

BONFIOLI, Guilherme Ferreira Bonfili. Banco de dados relacional e objeto-relacional: uma comparação usando PostgreSQL. Disponível em: < http://repositorio.ufla.br/bitstream/1/8354/1/MONOGRAFIA_Banco_de_dados_relacional_e_objeto_relacional_uma_compara%C3%A7%C3%A3o_usando_postgresql.pdf>. Acesso em: 01 mar. 2019.
COSTA, E. R. da. (2011). Elisângela Rocha da Costa BANCOS DE DADOS RELACIONAIS. 64. Acesso em: 15 jul. 2019.
DATE, C. J. Introdução a sistemas de bancos de dados. Rio de Janeiro: Campus, 1984. 513 p.
ELMASRI, R. e NAVATHE, S. B. (2010). Sistemas de Banco de Dados - 6a Edição.pdf . p. 790. Acesso em: 01 mar. 2019.
GIL, A. C. Métodos e Técnicas de Pesquisa Social. 5. ed. São Paulo: Atlas, 1999. Acesso em: 20 jul. 2019.
HAN, J. et al. Survey on nosql database. In Proceedings of 6th International Conference on Pervasive Computing and Applications (ICPCA 2011), 1:363–366, outubro 2011. Acesso em: 10 ago. 2019.
HECHT, R.; JABLONSKI, S. Nosql evaluation - a use case oriented survey. 2011 International Conference on Cloud and Service Computing, 1:336–341, dezembro 2011.
LAKATOS, E. M; MARCONI, M. A. Fundamentos de Metodologia Científica. 5. ed. São Paulo: Atlas, 2003. Acesso em: 22 jul. 2019.
VILELA, F. A., SILVA, J. C. (2015). Um método de integração de dados armazenados em bancos de dados relacionais e NOSQL. Disponível em: <https://pdfs.semanticscholar.org/badc/1769779cf862adee49cce011c02359c1e92e.pdf>. Acesso em: 15 jul. 2019.