{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:36:39Z","timestamp":1781109399766,"version":"3.54.1"},"reference-count":31,"publisher":"Wiley","license":[{"start":{"date-parts":[[2020,7,1]],"date-time":"2020-07-01T00:00:00Z","timestamp":1593561600000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100012639","name":"Prince Sultan University","doi-asserted-by":"publisher","id":[{"id":"10.13039\/501100012639","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Scientific Programming"],"published-print":{"date-parts":[[2020,7,1]]},"abstract":"<jats:p>Recently, the use of NoSQL databases has grown to manage unstructured data for applications to ensure performance and scalability. However, many organizations prefer to transfer data from an operational NoSQL database to a SQL-based relational database for using existing tools for business intelligence, analytics, decision making, and reporting. The existing methods of NoSQL to relational database transformation require manual schema mapping, which requires domain expertise and consumes noticeable time. Therefore, an efficient and automatic method is needed to transform an unstructured NoSQL database into a structured database. In this paper, we proposed and evaluated an efficient method to transform a NoSQL database into a relational database automatically. In our experimental evaluation, we used MongoDB as a NoSQL database, and MySQL and PostgreSQL as relational databases to perform transformation tasks for different dataset sizes. We observed excellent performance, compared to the existing state-of-the-art methods, in transforming data from a NoSQL database into a relational database.<\/jats:p>","DOI":"10.1155\/2020\/8813350","type":"journal-article","created":{"date-parts":[[2020,7,1]],"date-time":"2020-07-01T23:37:57Z","timestamp":1593646677000},"page":"1-13","source":"Crossref","is-referenced-by-count":13,"title":["Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping"],"prefix":"10.1155","volume":"2020","author":[{"given":"Zain","family":"Aftab","sequence":"first","affiliation":[{"name":"Punjab University College of Information Technology (PUCIT), University of the Punjab, Lahore, Pakistan"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-1612-8549","authenticated-orcid":true,"given":"Waheed","family":"Iqbal","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology (PUCIT), University of the Punjab, Lahore, Pakistan"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Khaled Mohamad","family":"Almustafa","sequence":"additional","affiliation":[{"name":"College of Computer and Information Sciences, Prince Sultan University Riyadh, 11586 Riyadh, Saudi Arabia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Faisal","family":"Bukhari","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology (PUCIT), University of the Punjab, Lahore, Pakistan"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3151-558X","authenticated-orcid":true,"given":"Muhammad","family":"Abdullah","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology (PUCIT), University of the Punjab, Lahore, Pakistan"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"311","reference":[{"issue":"7","key":"1","first-page":"1645","volume":"13","year":"2017","journal-title":"International Journal of Computational Intelligence Research"},{"key":"2","doi-asserted-by":"publisher","DOI":"10.1108\/17440081311316398"},{"key":"3","doi-asserted-by":"publisher","DOI":"10.5120\/11365-6602"},{"key":"4","year":"2014"},{"key":"5","year":"2013"},{"key":"6","doi-asserted-by":"publisher","DOI":"10.1016\/j.procs.2017.01.080"},{"key":"7","doi-asserted-by":"publisher","DOI":"10.1145\/1721654.1721659"},{"key":"9","doi-asserted-by":"publisher","DOI":"10.1016\/j.future.2015.05.003"},{"key":"11","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2009070101"},{"key":"12","volume-title":"Extraction, transformation, and loading","year":"2018"},{"key":"13","doi-asserted-by":"publisher","DOI":"10.1109\/mc.2015.76"},{"key":"17","year":"2010"},{"key":"18","doi-asserted-by":"publisher","DOI":"10.1109\/mc.2010.58"},{"key":"19","doi-asserted-by":"publisher","DOI":"10.1016\/j.future.2016.02.002"},{"key":"20","first-page":"315","volume-title":"Storage size estimation for schemaless big data applications: a JSON-based overview","year":"2018"},{"key":"21","doi-asserted-by":"publisher","DOI":"10.1016\/j.diin.2016.03.003"},{"key":"23","doi-asserted-by":"publisher","DOI":"10.1016\/j.csi.2016.10.003"},{"key":"25","year":"2016"},{"key":"26","volume-title":"Discovering implicit schemas in JSON data","year":"2013"},{"key":"28","doi-asserted-by":"publisher","DOI":"10.1109\/mc.2012.54"},{"key":"29","doi-asserted-by":"publisher","DOI":"10.1109\/mc.2012.37"},{"key":"34","doi-asserted-by":"publisher","DOI":"10.5120\/623-887"},{"key":"36","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2011.03.003"},{"key":"38","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2019.03.006"},{"key":"39","year":"2010"},{"key":"40","doi-asserted-by":"publisher","DOI":"10.1109\/access.2019.2916912"},{"key":"42","first-page":"410","volume-title":"Transformation of data warehouse schema to NoSQL graph data base","year":"2018"},{"issue":"12","key":"43","first-page":"2369","volume":"9","year":"2016","journal-title":"International Journal of Computer, Electrical, Automation, Control and Information Engineering"},{"key":"44","first-page":"40","volume-title":"ETL based framework for NoSQL warehousing","year":"2017"},{"issue":"5","key":"45","first-page":"229","volume":"10","year":"2013","journal-title":"International Journal of Computer Science Issues (IJCSI)"},{"key":"50","doi-asserted-by":"publisher","DOI":"10.1007\/s10586-019-02929-x"}],"container-title":["Scientific Programming"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/downloads.hindawi.com\/journals\/sp\/2020\/8813350.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/downloads.hindawi.com\/journals\/sp\/2020\/8813350.xml","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/downloads.hindawi.com\/journals\/sp\/2020\/8813350.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,9,14]],"date-time":"2020-09-14T23:32:59Z","timestamp":1600126379000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.hindawi.com\/journals\/sp\/2020\/8813350\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,7,1]]},"references-count":31,"alternative-id":["8813350","8813350"],"URL":"https:\/\/doi.org\/10.1155\/2020\/8813350","relation":{},"ISSN":["1058-9244","1875-919X"],"issn-type":[{"value":"1058-9244","type":"print"},{"value":"1875-919X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020,7,1]]}}}