JSON-based control model for SQL and NoSQL data conversion in hybrid cloud database-Reference-Cited by-同舟云学术

JSON-based control model for SQL and NoSQL data conversion in hybrid cloud database

Published:2022-08-03 Issue:1 Volume:11 Page:
ISSN:2192-113X
Container-title:Journal of Cloud Computing
language:en
Short-container-title:J Cloud Comp

Author:

Zhang Lei,Pang Ke,Xu Jiangtao,Niu Bingxin

Abstract

AbstractA data interaction transformation model, XYJSON, that is suitable for all data using current standard SQL syntax and JSON document data is proposed to solve the problem of increasing development workload and difficulty caused by using different control methods for corresponding types of databases under the cloud hybrid storage. A control program was studied to control relational and NoSQL data at the same time, by establishing a general conversion model between relational and NoSQL data and converting standard SQL statements into JSON. The performance of XYJSON was compared with that of the traditional mode. The results show that the performance difference between XYJSON and the traditional mode is small. In addition, a developer survey was conducted on XYJSON for user friendliness and compatibility. All developers rated XYJSON as excellent. The current cloud hybrid storage cannot use a unified control model to realize data control. XYJSON breaks through this bottleneck, making it easier and more efficient to control different types of databases under cloud hybrid storage.

Funder

Tianjin Science and Technology Plan project

Publisher

Springer Science and Business Media LLC

Subject

Computer Networks and Communications,Software

Link

https://link.springer.com/content/pdf/10.1186/s13677-022-00302-9.pdf

Reference19 articles.

1. Liu ZH, Hammerschmidt B, McMahon D, Chang H, Lu Y, Spiegel J, Sosa AC, Suresh S, Arora G, Arora V (2020) Native JSON datatype support: maturing SQL and NoSQL convergence in Oracle database. In: Proceedings of the VLDB Endowment 13(12):3059–3071. https://doi.org/10.14778/3415478.3415534

2. Bahta R, Atay M (2019) Translating JSON data into relational data using schema-oblivious approaches. In: Proceedings of the 2019 ACM Southeast Conference, New York

3. Oracle JSON support. (2021). https://docs.oracle.com/en/database/other-databases/nosql-database/20.3/admin/index.html. Accessed on 15 Apr 2021

4. Microsoft SQL Server JSON support. (2021). https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver15. Accessed on 10 Jun 2021

5. MySQL JSON DataType. https://dev.mysql.com/doc/refman/8.0/en/json.html. Accessed on 10 Apr 2021