SciELO - Scientific Electronic Library Online

vol.10 suppl.2Cálculo de prioridades de casos de prueba a partir de los requisitos funcionalesAndroid para escritorio índice de autoresíndice de assuntospesquisa de artigos
Home Pagelista alfabética de periódicos  

Serviços Personalizados




  • Não possue artigos citadosCitado por SciELO

Links relacionados

  • Não possue artigos similaresSimilares em SciELO


Revista Cubana de Ciencias Informáticas

versão On-line ISSN 2227-1899


VAZQUEZ ORTIZ, Yudisney; MIER PIERRE, Lisleydi  e  SOTOLONGO LEON, Anthony R.. No relational features of PostgreSQL: increase performance in JSON types use. Rev cuba cienc informat [online]. 2016, vol.10, suppl.2, pp.70-81. ISSN 2227-1899.

ABSTRACT The use of semi structured data for information storage has been a trend in the last years. Situation for which are emerging database management systems specialized in manipulate them, that not implement the relational model, widely used until now. These solutions were pooled under the name of “no relational” systems or NoSQL, which offer features like scalability and agility of its response times, higher than relational systems could offer. However, these databases do not overlap with relational types, because each one guarantees the functionalities for which they were developed, reason why many enterprises use them together. PostgreSQL has been included, gradually, NoSQL capabilities, which could be an advantage especially because it could be dispensed of a third tool. One of the steps for the gradual incorporation of these capabilities was the inclusion, in his 9.4 version, of the JSONB type, besides the existing JSON. The purpose of this paper is make an experiment to evaluate the PostgreSQL behavior using both types, respect to their response times. For this, were made benchmarking tests about data loads and selects, determining that with the JSONB implementation, PostgreSQL is moving in the NoSQL capabilities implementation, been an option to be considered.

Palavras-chave : json; jsonb; PostgreSQL no relational features.

        · resumo em Espanhol     · texto em Espanhol     · Espanhol ( pdf )


Creative Commons License Todo o conteúdo deste periódico, exceto onde está identificado, está licenciado sob uma Licença Creative Commons