We found a match
Your institution may have access to this item. Find your institution then sign in to continue.
- Title
A NEW APPROACH TO STORING DYNAMIC DATA IN RELATIONAL DATABASES USING JSON.
- Authors
PIECH, MATEUSZ; MARCJAN, ROBERT
- Abstract
JavaScript Object Notation was originally designed to transfer data; however, it soon found another use as a way of persisting data in NoSQL databases. Recently, the most-popular relational databases have introduced JSON as a native column type, which makes it easier to store and query dynamic database schema. In this paper, we review the currently popular techniques of storing data with a dynamic model with a large number of relationships between entities in relational databases. We focus on creating a simple dynamic schema with JSON in the most-popular relational databases, and we compare it with the well-known EAV data model and the document database. The results of precisely selected tests in the field of criminal data suggest that the use of JSON in dynamic database schema greatly simplifies queries and reduces their execution time compared to the widely used approaches.
- Subjects
JAVASCRIPT programming language; JSON (Document markup language); DATABASE management
- Publication
Computer Science, 2018, Vol 19, Issue 1, p3
- ISSN
1508-2806
- Publication type
Article
- DOI
10.7494/csci.2018.19.1.2505