THE STUDY OF PERFORMANCE AND METHODS OF STORAGE OF JSON OBJECTS IN POSTGRESQL DATABASE MANAGEMENT SYSTEM
Ivan A. Shirokov
ITMO University, St. Petersburg, Russian Federation
Keywords: database management system, PostgreSQL, data storage, JSON, productivity
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.
|
