The study of performance and methods of storage of JSON objects in PostgreSQL database management system
https://doi.org/10.34020/2073-6495-2023-3-144-153
Abstract
Currently there are several methods of data storage, such as table and object, as JSON objects. National and foreign scientists conducted studies on the comparison of performance of relational database management systems and NoSQL database management system, but there were no studies that compared the performance in data insertion and storage using ordinary records and JSON objects within the relational database management system. An experiment was carried out in terms of the real examples of corporate use of the database management system; the results show the relevance of the use of JSON objects in storage of large volumes of data.
References
1. Volushkova V.L., Volushkova A.Ju. Struktura dannyh dlja hranenija informacii v social’nyh setjah [Data structure for information storage in social networks], Obrazovatel’nye resursy i tehnologii [Educational resources and technologies], 2014, no. 2 (5).
2. D’jakonov A.V., Kozlova Ju.B. O sovremennyh tendencijah hranenija dannyh v dokumento-orientirovannyh SUBD [About modern trends of data storage in document-oriented DBMS], Aktual’nye problemy aviacii i kosmonavtiki [Actual problems of aviation and cosmonautics], 2015, no. 11, pp. 394–396.
3. Novikov B.A. Sravnitel’nyj analiz proizvoditel’nosti SQL I NOSQL SUBD [Comparative analysis of SQL AND NOSQL DBMS performance], KIO [KIO], 2017, no. 4.
4. Rudometkin V.A. Proektirovanie vysokonagruzhennyh sistem [Designing of the highly loaded systems], Trudy ISP RAN [Proceedings of ISP RAS], 2020, no. 6.
5. Shirokov I.A. Issledovanie vozmozhnostej hranenija i obrabotki mnogourovnevyh dannyh v PostgreSQL [Research of possibilities of storage and processing of multilevel data in PostgreSQL]. Kul’tura, nauka, obrazovanie: problemy i perspektivy: materialy X Vseros. nauch.-metod. konf. s mezhdunarodnym uchastiem (g. Nizhnevartovsk, 10–11 nojabrja 2022 g.). Nizhnevartovsk, 2022. Pp. 451–457.
6. Győrödi C., Sotoc R. A comparative study: MongoDB vs. MSSQL. Conference: 2015 13th International Conference on Engineering of Modern Electric Systems (EMES). 2015.
7. JSON Types [Electronic resource]. Available at: https://www.postgresql.org/docs/current/datatype-json.html#JSON-CONTAINMENT (accessed: 24.03.2023).
Review
For citations:
Shirokov I.A. The study of performance and methods of storage of JSON objects in PostgreSQL database management system. Vestnik NSUEM. 2023;(3):144–153. (In Russ.) https://doi.org/10.34020/2073-6495-2023-3-144-153
Email this article 
