{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,31]],"date-time":"2026-01-31T18:09:31Z","timestamp":1769882971093,"version":"3.49.0"},"reference-count":32,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2022,3,3]],"date-time":"2022-03-03T00:00:00Z","timestamp":1646265600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2022,3,3]],"date-time":"2022-03-03T00:00:00Z","timestamp":1646265600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"DOI":"10.13039\/501100012190","name":"Ministry of Science and Higher Education of the Russian Federation","doi-asserted-by":"crossref","award":["075-15-2020-933"],"award-info":[{"award-number":["075-15-2020-933"]}],"id":[{"id":"10.13039\/501100012190","id-type":"DOI","asserted-by":"crossref"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Data Sci. Eng."],"published-print":{"date-parts":[[2022,6]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>The problem of transferring data from a database of one type to a database of another type is relevant today due to the increase in data volumes and the complexity of tasks solved in various fields of human activity. The existing databases are less and less satisfying the needs of users. New types of databases appear that are more suitable for solving large-scale problems. This article proposes an algorithm for solving the problem of optimizing the document structure of a database based on metadata about the structure of a distributed relational database from which data are transferred. The approach also takes into account information about the structure of the priority database queries. The priority of database queries is user-defined. The system of automatic translation of the database, taking into account these metadata, allows the user to create a distributed document database that is optimal in two parameters: in terms of the volume of stored data and in terms of the execution time of priority database queries.<\/jats:p>","DOI":"10.1007\/s41019-022-00181-9","type":"journal-article","created":{"date-parts":[[2022,3,3]],"date-time":"2022-03-03T14:04:35Z","timestamp":1646316275000},"page":"136-155","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":9,"title":["Translating a Distributed Relational Database to a Document Database"],"prefix":"10.1007","volume":"7","author":[{"given":"Muon","family":"Ha","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0001-7140-1686","authenticated-orcid":false,"given":"Yulia","family":"Shichkina","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2022,3,3]]},"reference":[{"issue":"2","key":"181_CR1","doi-asserted-by":"publisher","first-page":"45","DOI":"10.3390\/computation8020045","volume":"8","author":"M Ha","year":"2020","unstructured":"Ha M, Shichkina Y (2020) Creating collections without embedded documents for document databases taking into account the queries. Computation 8(2):45. https:\/\/doi.org\/10.3390\/computation8020045","journal-title":"Computation"},{"key":"181_CR2","doi-asserted-by":"publisher","first-page":"131","DOI":"10.1016\/j.procs.2019.02.026","volume":"150","author":"Y Shichkina","year":"2015","unstructured":"Shichkina Y (2015) Approaches to speed up data processing in relational databases. Procedia Comput Sci 150:131\u2013139","journal-title":"Procedia Comput Sci"},{"key":"181_CR3","doi-asserted-by":"publisher","unstructured":"Shichkina Y,\u00a0Kupriyanov M,\u00a0Al-Mardi M (2016) Optimization algorithm for an information graph for an amount of communications, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 9870 LNCS, c. 50-62, ISSN:\u00a003029743\u00a0ISBN:\u00a0978-331946300-1, https:\/\/doi.org\/10.1007\/978-3-319-46301-8_5","DOI":"10.1007\/978-3-319-46301-8_5"},{"key":"181_CR4","doi-asserted-by":"publisher","unstructured":"Karnitis G, Arnicans G (2015) Migration of relational database to document-oriented database: structure denormalization and data transformation. In: 2015 7th international conference on computational intelligence, communication systems and networks, Riga, Latvia, pp. 113\u2013118 https:\/\/doi.org\/10.1109\/CICSyN.2015.30","DOI":"10.1109\/CICSyN.2015.30"},{"key":"181_CR5","doi-asserted-by":"publisher","unstructured":"Toufik F, Bahaj M (2019) Model transformation from object relational database to nosql document database. In: Proceedings of the 2nd international conference on networking, information systems & security (niss19). Association for computing machinery, New York, NY, USA, Article 49, pp. 1\u20135 https:\/\/doi.org\/10.1145\/3320326.3320381","DOI":"10.1145\/3320326.3320381"},{"key":"181_CR6","unstructured":"Al Mahruqi RS, Alalfi MH, Dean TR (2019) A semi-automated framework for migrating web applications from SQL to document oriented NoSQL database. In: Proceedings of the 29th annual international conference on computer science and software engineering (CASCON '19). IBM Corp., USA, pp. 44\u201353"},{"key":"181_CR7","doi-asserted-by":"crossref","unstructured":"Stanescu L, Brezovan M, Burdescu DD (2016) Automatic mapping of MySQL databases to NoSQL MongoDB. In: 2016 FedCSIS, pp. 837\u2013840","DOI":"10.15439\/2016F45"},{"key":"181_CR8","doi-asserted-by":"crossref","unstructured":"Zhao G, Lin Q, Li L, Li Z (2014) Schema conversion model of SQL database to NoSQL. In: 2014 Ninth 3PGCIC, pp. 355\u2013362","DOI":"10.1109\/3PGCIC.2014.137"},{"key":"181_CR9","doi-asserted-by":"crossref","unstructured":"Freitas MC, Souza DY, Salgado AC (2016) Conceptual mappings to convert relational into NoSQL databases. In: Proceedings of the 18th ICEIS","DOI":"10.5220\/0005836301740181"},{"key":"181_CR10","doi-asserted-by":"crossref","unstructured":"Karnitis G, Arnicans G (2015) Migration of relational database to document-oriented database: structure denormalization and data transformation. In: 2015 7th ICCICSN, pp. 113\u2013118","DOI":"10.1109\/CICSyN.2015.30"},{"key":"181_CR11","doi-asserted-by":"crossref","unstructured":"Jia T, Zhao X, Wang Z, Gong D, Ding G (2016) Model transformation and data migration from relational database to MongoDB. In: IEEE BigData, pp. 60\u201367","DOI":"10.1109\/BigDataCongress.2016.16"},{"issue":"2","key":"181_CR12","first-page":"229","volume":"13","author":"V Varga","year":"2016","unstructured":"Varga V, J\u00e1nosi-Rancz KT, K\u00e1lm\u00e1n B (2016) Conceptual design of document NoSQL database with formal concept analysis. Acta Polytech Hung 13(2):229\u2013248","journal-title":"Acta Polytech Hung"},{"issue":"11","key":"181_CR13","first-page":"32","volume":"13","author":"NF Shaikh","year":"2017","unstructured":"Shaikh NF (2017) Data migration from SQL To Mongodb. Int J Eng Res Dev 13(11):32\u201336","journal-title":"Int J Eng Res Dev"},{"key":"181_CR14","doi-asserted-by":"publisher","unstructured":"Kim HJ, Ko EJ, Jeon YH, Lee KH (2018) Migration from RDBMS to column-oriented NoSQL: lessons learned and open problems. In: Lee W, Choi W, Jung S, Song M (Eds.), Proceedings of the 7th International Conference on Emerging Databases. Lecture Notes in Electrical Engineering, vol 461. Springer, Singapore. https:\/\/doi.org\/10.1007\/978-981-10-6520-0_3, https:\/\/link.springer.com\/chapter\/10.1007\/978-981-10-6520-0_3#citeas","DOI":"10.1007\/978-981-10-6520-0_3"},{"key":"181_CR15","doi-asserted-by":"publisher","unstructured":"Lawrence R (2014) Integration and virtualization of relational SQL and NoSQL systems including MySQL and MongoDB. In:\u00a02014 international conference on computational science and computational intelligence, Las Vegas, NV, USA, 2014, pp. 285\u2013290 https:\/\/doi.org\/10.1109\/CSCI.2014.56","DOI":"10.1109\/CSCI.2014.56"},{"key":"181_CR16","doi-asserted-by":"crossref","unstructured":"Hsu MJC, Hsu CH, Chen SC, Chung YC (2014) Correlation aware technique for SQL to NoSQL transformation. In: 7th international conference on ubi-media computing and workshops (UMEDIA). IEEE Press, Ulaanbaatar, pp. 43\u201346","DOI":"10.1109\/U-MEDIA.2014.27"},{"key":"181_CR17","doi-asserted-by":"publisher","unstructured":"Zhang H, Wang Y, Han J (2011) Middleware design for integrating relational database and NOSQL based on data dictionary. In: Proceedings 2011 international conference on transportation, mechanical, and electrical engineering (TMEE), Changchun, China, pp. 1469\u20131472 https:\/\/doi.org\/10.1109\/TMEE.2011.6199485","DOI":"10.1109\/TMEE.2011.6199485"},{"key":"181_CR18","doi-asserted-by":"publisher","unstructured":"Ma K, Abraham A (2013) Toward lightweight transparent data middleware in support of document stores. In: 2013 third world congress on information and communication technologies (WICT 2013), Hanoi, Vietnam, 2013, pp. 253\u2013257 https:\/\/doi.org\/10.1109\/WICT.2013.7113144","DOI":"10.1109\/WICT.2013.7113144"},{"key":"181_CR19","volume-title":"Trends and advances in information systems and technologies. WorldCIST\u201918 2018. Advances in intelligent systems and computing","author":"J Adriana","year":"2018","unstructured":"Adriana J, Holanda M (2018) NoSQL2: SQL to NoSQL databases. In: Rocha \u00c1, Adeli H, Reis L, Costanzo S (eds) Trends and advances in information systems and technologies. WorldCIST\u201918 2018. Advances in intelligent systems and computing, vol 746. Springer, Cham"},{"key":"181_CR20","unstructured":"QueryMongo. Query mongo: Mysql to mongodb query translator, 2019. URL http:\/\/www.querymongo.com."},{"key":"181_CR21","unstructured":"Russell V (2016) sql-to-mongo-db-query-converter URL https:\/\/github.com\/vincentrussell\/sql-to-mongo-db-query-converter."},{"key":"181_CR22","unstructured":"Reddy R (2015) Mongodb translator - teiid 9.0 (draft), URL https:\/\/docs.jboss.org\/author\/display\/TEIID\/MongoDB+Translator"},{"issue":"4","key":"181_CR23","doi-asserted-by":"publisher","first-page":"602","DOI":"10.1145\/319628.319650","volume":"6","author":"PA Bernstein","year":"1981","unstructured":"Bernstein PA, Goodman N, Wong E, Reeve CL, Rothnie JB (1981) Query processing in a system for distributed databases (SDD-1). ACM Trans Database Syst 6(4):602\u2013625. https:\/\/doi.org\/10.1145\/319628.319650","journal-title":"ACM Trans Database Syst"},{"key":"181_CR24","doi-asserted-by":"publisher","DOI":"10.1111\/cgf.12619","author":"D Moritz","year":"2015","unstructured":"Moritz D, Halperin D, Howe B, Heer J (2015) Perfopticon: visual query analysis for distributed databases. Comput Graph Forum. https:\/\/doi.org\/10.1111\/cgf.12619","journal-title":"Comput Graph Forum"},{"key":"181_CR25","doi-asserted-by":"publisher","DOI":"10.1088\/1755-1315\/234\/1\/012080","volume":"234","author":"J Dai","year":"2019","unstructured":"Dai J (2019) SQL to NoSQL: what to do and How. IOP Conf Ser Earth Environ Sci 234:012080. https:\/\/doi.org\/10.1088\/1755-1315\/234\/1\/012080","journal-title":"IOP Conf Ser Earth Environ Sci"},{"key":"181_CR26","doi-asserted-by":"crossref","unstructured":"Wu S, Li F, Mehrotra S, et al. (2011) Query optimization for massively parallel data processing. In: 2nd ACM symposium on cloud computing. ACM, p. 12","DOI":"10.1145\/2038916.2038928"},{"key":"181_CR27","doi-asserted-by":"crossref","unstructured":"Xu Y, Hu S (2013) QMapper: a tool for SQL optimization on hive using query rewriting. In: 28th international conference on world wide web companion. pp. 211\u2013212","DOI":"10.1145\/2487788.2487896"},{"key":"181_CR28","doi-asserted-by":"crossref","unstructured":"Lee C, Zheng Y (2015) Automatic SQL-to-NoSQL schema transformation over the MySQL and HBase databases. In: IEEE international conference on consumer electronics-Taiwan, pp. 426\u2013427","DOI":"10.1109\/ICCE-TW.2015.7216979"},{"key":"181_CR29","unstructured":"https:\/\/neo4j.com\/developer\/guide-importing-data-and-etl\/"},{"key":"181_CR30","doi-asserted-by":"crossref","unstructured":"Park Y, Shankar M, Park B-H, Ghosh J (2014) Graph databases for large-scale healthcare systems: A framework for efficient data management and data services. In: IEEE 30th international conference on data engineering workshops. Chicago, IL, USA, pp. 12\u201319","DOI":"10.1109\/ICDEW.2014.6818295"},{"key":"181_CR31","doi-asserted-by":"crossref","unstructured":"De Virgilio R, Maccioni A, Torlone R (2013) Converting relational to graph databases. In: First international workshop on graph data management experiences and Systems. ACM","DOI":"10.1145\/2484425.2484426"},{"key":"181_CR32","doi-asserted-by":"publisher","unstructured":"Ha VM, Shichkina YA, Kostichev SV (2019) Determining the composition of collections for key-document databases based on a given set of object properties and database queries. Computer Tools in Education, no. 3, pp. 15\u201328. https:\/\/doi.org\/10.32603\/2071-2340-2019-3-15-28(in Russian)","DOI":"10.32603\/2071-2340-2019-3-15-28"}],"container-title":["Data Science and Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s41019-022-00181-9.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s41019-022-00181-9\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s41019-022-00181-9.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,12]],"date-time":"2022-05-12T17:10:38Z","timestamp":1652375438000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s41019-022-00181-9"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,3,3]]},"references-count":32,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2022,6]]}},"alternative-id":["181"],"URL":"https:\/\/doi.org\/10.1007\/s41019-022-00181-9","relation":{},"ISSN":["2364-1185","2364-1541"],"issn-type":[{"value":"2364-1185","type":"print"},{"value":"2364-1541","type":"electronic"}],"subject":[],"published":{"date-parts":[[2022,3,3]]},"assertion":[{"value":"3 March 2021","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"17 January 2022","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"4 February 2022","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"3 March 2022","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors declare that they have no known competing financial interests or personal relationships that could have appeared to influence the work reported in this paper.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Conflict of interest"}}]}}