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

Zhang, Lei; Pang, Ke; Xu, Jiangtao; Niu, Bingxin

doi:10.1186/s13677-022-00302-9

Cited by 2 publications

(2 citation statements)

References 10 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The efficiency and the limitation of the proposed algorithm are dissected in detail. The experimental result reflected the expected solutions that have been actually faced at the time of previous works [14,16] where the data of SQL and JSON format were actually required. This work also lays the foundation for the possible reduction of the duplicate fields in the JSON file format.…”

Section: Discussionsupporting

confidence: 63%

See 1 more Smart Citation

A Bi-Directional Engine for Transformation of Big Data Between NoSQL and SQL Data

Samanta,

Chaki

2023

Preprint

View full text Add to dashboard Cite

Big Data emerges as a solution with the continual and massive growth of different types of data streams at high speed. The customized storage and retrieval of data has indeed become a challenge. Over the last few decades, users of all levels had been more conversant with the relational model and SQL (Structured Query Language). However, several limitations of the relational model has been observed and discussed in the existing literature. As of day, a significant number of the applications are cloud-based or web-based. These handle either structured data (SD), semi-structured data (SSD), or completely unstructured data (USD). The volume of the transactions might even be at the petabytes level. NoSQL have drawn considerable attention for successfully handling massive volumes of heterogeneous data efficiently and irrespective of the type of data. It often requires the conversion of unstructured data into a structured format for possible data analysis, etc. This aims to transform the unstructured data stored in JSON format in the MongoDB data model to SQL structured table data format and vice-versa. The primary rigor of this research work is towards designing an interface facility to change the unstructured data into a structured format for its proper re-usability and simplicity. The focus is to design and develop a bi-directional transformation engine that can simplify the complex data in JSON structure to convert the simplified table structure keeping the normalization features and also to transform the data from normalized SQL format to single collection data of JSON format. Therefore, the proposed bi-directional transformation engine will be an interface between the SQL and NoSQL data model. The algorithms are evaluated using appropriate data. The broader vision of this work is to remove the structural differences between unstructured and structured data in respect of its reuse.

show abstract

Section: Discussionsupporting

confidence: 63%

“…L. Zhang et al proposed a data conversion model, "XYJSON," to reduce the complexity of query language in NoSQL rather than SQL. A control program is proposed to convert the RDBMS to the corresponding JSON data model, and the performance of "XYJSON" is compared with the traditional data model [14].…”

Section: Literature Reviewmentioning

confidence: 99%