{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,2]],"date-time":"2025-11-02T05:20:43Z","timestamp":1762060843718,"version":"build-2065373602"},"reference-count":19,"publisher":"Springer Science and Business Media LLC","issue":"1","license":[{"start":{"date-parts":[[2022,8,3]],"date-time":"2022-08-03T00:00:00Z","timestamp":1659484800000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2022,8,3]],"date-time":"2022-08-03T00:00:00Z","timestamp":1659484800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"DOI":"10.13039\/501100019065","name":"Tianjin Science and Technology Plan project","doi-asserted-by":"crossref","award":["20YDTPJC00890","20YDTPJC00890"],"award-info":[{"award-number":["20YDTPJC00890","20YDTPJC00890"]}],"id":[{"id":"10.13039\/501100019065","id-type":"DOI","asserted-by":"crossref"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["J Cloud Comp"],"published-print":{"date-parts":[[2022,12]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>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.<\/jats:p>","DOI":"10.1186\/s13677-022-00302-9","type":"journal-article","created":{"date-parts":[[2022,8,3]],"date-time":"2022-08-03T12:04:39Z","timestamp":1659528279000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["JSON-based control model for SQL and NoSQL data conversion in hybrid cloud database"],"prefix":"10.1186","volume":"11","author":[{"given":"Lei","family":"Zhang","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ke","family":"Pang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jiangtao","family":"Xu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bingxin","family":"Niu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2022,8,3]]},"reference":[{"issue":"12","key":"302_CR1","doi-asserted-by":"publisher","first-page":"3059","DOI":"10.14778\/3415478.3415534","volume":"13","author":"ZH Liu","year":"2020","unstructured":"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\u20133071. https:\/\/doi.org\/10.14778\/3415478.3415534","journal-title":"In: Proceedings of the VLDB Endowment"},{"key":"302_CR2","volume-title":"In: Proceedings of the 2019 ACM Southeast Conference, New York","author":"R Bahta","year":"2019","unstructured":"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"},{"key":"302_CR3","unstructured":"Oracle JSON support. (2021). https:\/\/docs.oracle.com\/en\/database\/other-databases\/nosql-database\/20.3\/admin\/index.html. Accessed on 15 Apr 2021"},{"key":"302_CR4","unstructured":"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"},{"key":"302_CR5","unstructured":"MySQL JSON DataType. https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/json.html. Accessed on 10 Apr 2021"},{"key":"302_CR6","unstructured":"PostgreSQL JSON Types. (2021). https:\/\/www.postgresql.org\/docs\/13\/datatype-json.html. Accessed on 25 May 2021"},{"key":"302_CR7","unstructured":"Teradata Database JSON Data Type. (2021). https:\/\/docs.teradata.com\/r\/C8cVEJ54PO4~YXWXeXGvsA\/root. Accessed on 20 May 2021"},{"key":"302_CR8","doi-asserted-by":"publisher","first-page":"14","DOI":"10.5120\/ijca2017914389","volume":"168","author":"D Petkovi\u0107","year":"2017","unstructured":"Petkovi\u0107 D (2017) JSON integration in relational database systems. Int J Comput Appl 168:14\u201319. https:\/\/doi.org\/10.5120\/ijca2017914389","journal-title":"Int J Comput Appl"},{"key":"302_CR9","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595628","volume-title":"JSON data management: Supporting schema-less development in RDBMS. In: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, Utah","author":"ZH Liu","year":"2014","unstructured":"Liu ZH, Hammerschmidt B, McMahon D (2014) JSON data management: Supporting schema-less development in RDBMS. In: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, Utah. https:\/\/doi.org\/10.1145\/2588555.2595628"},{"key":"302_CR10","first-page":"1","volume-title":"Enabling JSON document stores in relational systems, WebDB, New York","author":"C Chasseur","year":"2013","unstructured":"Chasseur C, Li Y, Patel JM (2013) Enabling JSON document stores in relational systems, WebDB, New York. pp 1\u20136"},{"key":"302_CR11","doi-asserted-by":"publisher","unstructured":"Petkovi\u0107 D (2020) Non-native techniques for storing JSON documents into relational tables. In: Proceedings of the 22nd International Conference on Information Integration and Web-Based Applications & Services, New York. https:\/\/doi.org\/10.1145\/3428757.3429103","DOI":"10.1145\/3428757.3429103"},{"key":"302_CR12","doi-asserted-by":"publisher","DOI":"10.7494\/csci.2018.19.1.2505","author":"M Piech","year":"2018","unstructured":"Piech M, Marcjan R (2018) A new approach to storing dynamic data in relational databases using JSON. Comput Sci. https:\/\/doi.org\/10.7494\/csci.2018.19.1.2505","journal-title":"Comput Sci"},{"key":"302_CR13","unstructured":"json-schema.org: The home of json schema. (2021). http:\/\/json-schema.org\/. Accessed on 20 May 2021"},{"key":"302_CR14","first-page":"1","volume-title":"The JavaScript Object Notation (JSON), Data Interchange Format","author":"T Bray","year":"2014","unstructured":"Bray T (2014) The JavaScript Object Notation (JSON), Data Interchange Format. p 1"},{"key":"302_CR15","unstructured":"ECMA. The JSON Data Interchange Format. (2021). http:\/\/www.ecma-international.org\/publications\/standards\/Ecma-404.htm. Accessed on 10 Aug 2021"},{"key":"302_CR16","doi-asserted-by":"publisher","unstructured":"Pezoa F, Reutter JL, Suarez F, Ugarte M, Vrgo\u010d D (2016) Foundations of JSON schema. In: Proceedings of the 25th International Conference on World Wide Web, Republic and Canton of Geneva, CHE. https:\/\/doi.org\/10.1145\/2872427.2883029","DOI":"10.1145\/2872427.2883029"},{"key":"302_CR17","doi-asserted-by":"publisher","first-page":"101478","DOI":"10.1145\/3034786.3056120","volume":"89","author":"P Bourhis","year":"2017","unstructured":"Bourhis P, Reutter JL, Vrgo\u010d D, Json VD (2017) Data model and query languages. Inf Syst 89:101478. https:\/\/doi.org\/10.1145\/3034786.3056120","journal-title":"Inf Syst"},{"key":"302_CR18","unstructured":"MongoDB Inc, The MongoDB4.4 manual. (2021). https:\/\/docs.mongodb.org\/manual\/. Accessed on 20 May 2021"},{"key":"302_CR19","doi-asserted-by":"publisher","unstructured":"Lanthaler M, G\u00fctl C (2012) On using JSON-LD to create evolvable RESTful services. In: Proceedings of the Third International Workshop on RESTful Design, New York. https:\/\/doi.org\/10.1145\/2307819.2307827","DOI":"10.1145\/2307819.2307827"}],"container-title":["Journal of Cloud Computing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1186\/s13677-022-00302-9.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1186\/s13677-022-00302-9\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1186\/s13677-022-00302-9.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,8,3]],"date-time":"2022-08-03T12:06:15Z","timestamp":1659528375000},"score":1,"resource":{"primary":{"URL":"https:\/\/journalofcloudcomputing.springeropen.com\/articles\/10.1186\/s13677-022-00302-9"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,8,3]]},"references-count":19,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2022,12]]}},"alternative-id":["302"],"URL":"https:\/\/doi.org\/10.1186\/s13677-022-00302-9","relation":{},"ISSN":["2192-113X"],"issn-type":[{"type":"electronic","value":"2192-113X"}],"subject":[],"published":{"date-parts":[[2022,8,3]]},"assertion":[{"value":"10 May 2022","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"26 July 2022","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"3 August 2022","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors have no competing interests to declare.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Competing interests"}}],"article-number":"23"}}