arrow
返回

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

delete2022-08-03
delete1
delete
OA
AI
L
Lei Zhang
K
Ke Pang *
J
Jiangtao Xu
B
Bingxin Niu
DOI:10.1186/s13677-022-00302-9delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
A 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.
Keyword:
Simultaneous control
Data conversion
Hybrid cloud database
Native JSON
NoSQL
RDBMS

期刊

J
Journal of Cloud Computing-Advances Systems and Applications
IF:
4.3
论文数:
760
被引数:
2.2K

机构

T
tianjin university
学者数:
8.0W
论文数: 5.8W
被引数: 88
H
hebei university of technology
学者数:
1.8W
论文数: 1.2W
被引数: 10
引用论文

引用论文

Calorimetric determination of the enthalpies of formation of liquid and solid YbPb alloys
err1995-01-01
err0
PREAI
errF. Sommer; B. Predel; G. Borzone; N. Parodi; R. Ferro
err分享
err收藏
Inhibitory Control and Information Processing in ADHD: Comparing the Dual Task and Performance Adjustment Hypotheses
err2018-12-13
err0
errOAAI
errWhitney D. Fosco; Michael J. Kofler; R. Matt Alderson; Stephanie J. Tarle; Joseph S. Raiker; Dustin E. Sarver
err分享
err收藏