A NEW APPROACH TO STORING DYNAMIC DATA IN RELATIONAL DATABASES USING JSON
A NEW APPROACH TO STORING DYNAMIC DATA IN RELATIONAL DATABASES USING JSON
复制标题
DOI：
10.7494/csci.2018.19.1.2505
复制
发表时间：
2018-01-01
影响因子：
0.5
通讯作者：
Marcjan, Robert
中科院分区：
文献类型：
--
作者：
Piech, Mateusz;Marcjan, Robert
JavaScript Object Notation最初是为了传输数据而设计的;然而，它很快就发现了另一种用途，即在NoSQL数据库中持久化数据的方式。最近，最流行的关系数据库都引入了JSON作为原生列类型，这使得存储和查询动态数据库模式变得更加容易。在本文中，我们回顾了目前流行的技术，存储数据的动态模型与大量的实体之间的关系在关系数据库中。我们专注于在最流行的关系数据库中使用JSON创建一个简单的动态模式，并将其与著名的EAV数据模型和文档数据库进行比较。在犯罪数据领域精确选择的测试结果表明，与广泛使用的方法相比，在动态数据库模式中使用JSON大大简化了查询并减少了执行时间。
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.