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

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 un...

Full description

Saved in:
Bibliographic Details
Published in:Journal of cloud computing : advances, systems and applications Vol. 11; no. 1; pp. 1 - 12
Main Authors: Zhang, Lei, Pang, Ke, Xu, Jiangtao, Niu, Bingxin
Format: Journal Article
Language:English
Published: Berlin/Heidelberg Springer Berlin Heidelberg 03.08.2022
Springer Nature B.V
SpringerOpen
Subjects:
Big Data
Cloud computing
Computer Communication Networks
Computer Science
Computer System Implementation
Computer Systems Organization and Communication Networks
Control methods
Data conversion
Data exchange
Data models
Hybrid cloud database
Information Systems Applications (incl.Internet)
Native JSON
NoSQL
Open access publishing
Queries
Query languages
RDBMS
Relational data bases
Simultaneous control
Software Engineering/Programming and Operating Systems
Special Purpose and Application-Based Systems
Workloads
Simultaneous control
Data conversion
NoSQL
Hybrid cloud database
RDBMS
Native JSON
ISSN:2192-113X, 2192-113X
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
Bibliography:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:2192-113X
2192-113X
DOI:10.1186/s13677-022-00302-9