Resumo

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 )