Auto JSON: An Automatic Transformation Model for Converting Relational Database to Non-relational Documents

In recent days, the demand for dealing large set of distributed data obsoletes the relational database and its structured query language (SQL) solutions in practice and paves the way for novel solutions in the name of non-relational database as not-only SQL (NoSQL). The NoSQL offers dynamic, flexibl...

Full description

Saved in:
Bibliographic Details
Published in:International journal of advanced computer science & applications Vol. 14; no. 3
Main Authors: Revathi, K., Tamilselvi, T., Dhanwanth, Batini, Dhivya, M.
Format: Journal Article
Language:English
Published: West Yorkshire Science and Information (SAI) Organization Limited 2023
Subjects:
Algorithms
Data base management systems
Documents
Format
Industrial applications
Performance evaluation
Query languages
Relational data bases
Structured Query Language-SQL
Webs
ISSN:2158-107X, 2156-5570
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Abstract In recent days, the demand for dealing large set of distributed data obsoletes the relational database and its structured query language (SQL) solutions in practice and paves the way for novel solutions in the name of non-relational database as not-only SQL (NoSQL). The NoSQL offers dynamic, flexible, scalable, highly available, greater performance and near real-time access to the distributed nature of voluminous data used for current industrial applications. Apart from these giant features of NoSQL, the SQL is still found to be in operation because of its popularity and standard. This paper projected an algorithm to convert the relational documents of MySQL into any document oriented NoSQL databases automatically without destructing the existing relational database setup and installing the NoSQL from scratch in the core machines. Java Script Object Notation (JSON) is a human readable data interchange format, being used in web development. The characteristics of JSON widened its use cases from web development to database storage. The Mongo DB, one of the most popular document oriented NoSQL adapts JSON format for its storage. The proposed algorithm is built based on its schema definition and the performance is captured through evaluating it against a sample database from hospital management system. The findings are discussed with great interest of addressing the challenges and revealing the scope for improvement.
AbstractList In recent days, the demand for dealing large set of distributed data obsoletes the relational database and its structured query language (SQL) solutions in practice and paves the way for novel solutions in the name of non-relational database as not-only SQL (NoSQL). The NoSQL offers dynamic, flexible, scalable, highly available, greater performance and near real-time access to the distributed nature of voluminous data used for current industrial applications. Apart from these giant features of NoSQL, the SQL is still found to be in operation because of its popularity and standard. This paper projected an algorithm to convert the relational documents of MySQL into any document oriented NoSQL databases automatically without destructing the existing relational database setup and installing the NoSQL from scratch in the core machines. Java Script Object Notation (JSON) is a human readable data interchange format, being used in web development. The characteristics of JSON widened its use cases from web development to database storage. The Mongo DB, one of the most popular document oriented NoSQL adapts JSON format for its storage. The proposed algorithm is built based on its schema definition and the performance is captured through evaluating it against a sample database from hospital management system. The findings are discussed with great interest of addressing the challenges and revealing the scope for improvement.
Author Dhanwanth, Batini
Revathi, K.
Dhivya, M.
Tamilselvi, T.
Author_xml – sequence: 1
  givenname: K.
  surname: Revathi
  fullname: Revathi, K.
– sequence: 2
  givenname: T.
  surname: Tamilselvi
  fullname: Tamilselvi, T.
– sequence: 3
  givenname: Batini
  surname: Dhanwanth
  fullname: Dhanwanth, Batini
– sequence: 4
  givenname: M.
  surname: Dhivya
  fullname: Dhivya, M.
BookMark eNpNkN1LwzAUxYNMcM79Bz4EfO7Md1vfSv3amBu4Cb6FNE1ks0tm0gr-93abD96Xew_ncDn8LsHAeWcAuMZoghkX-e10VpSrYkIQoROEGaJpegaGBHORcJ6iwfHOEozS9wswjnGL-qE5ERkdgs-iaz2crZaLO1g4eFA71W40XAflovXhoLyDL742Dew1LL37NqHduA_4apqjqxp4r1pVqWhg_23hXRL-WV53O-PaeAXOrWqiGf_tEXh7fFiXz8l8-TQti3miScrahFFBrLEEaZ3Vlca4zozWOdHcCm7yqtI1wTnLbc1qRnOhGDIqw5qSvkGGLB2Bm9PfffBfnYmt3Pou9FWiJBlKCSGIiz7FTikdfIzBWLkPm50KPxIjeSQrT2Tlgaz8I0t_Aa3Rbys
ContentType Journal Article
Copyright 2023. This work is licensed under http://creativecommons.org/licenses/by/4.0/ (the “License”). Notwithstanding the ProQuest Terms and Conditions, you may use this content in accordance with the terms of the License.
Copyright_xml – notice: 2023. This work is licensed under http://creativecommons.org/licenses/by/4.0/ (the “License”). Notwithstanding the ProQuest Terms and Conditions, you may use this content in accordance with the terms of the License.
DBID AAYXX
CITATION
3V.
7XB
8FE
8FG
8FK
8G5
ABUWG
AFKRA
ARAPS
AZQEC
BENPR
BGLVJ
CCPQU
DWQXO
GNUQQ
GUQSH
HCIFZ
JQ2
K7-
M2O
MBDVC
P5Z
P62
PHGZM
PHGZT
PIMPY
PKEHL
PQEST
PQGLB
PQQKQ
PQUKI
PRINS
Q9U
DOI 10.14569/IJACSA.2023.0140377
DatabaseName CrossRef
ProQuest Central (Corporate)
ProQuest Central (purchase pre-March 2016)
ProQuest SciTech Collection
ProQuest Technology Collection
ProQuest Central (Alumni) (purchase pre-March 2016)
Research Library (Alumni)
ProQuest Central (Alumni)
ProQuest Central UK/Ireland
Advanced Technologies & Computer Science Collection
ProQuest Central Essentials
ProQuest Central
ProQuest Technology Collection
ProQuest One
ProQuest Central Korea
ProQuest Central Student
ProQuest Research Library
SciTech Collection (ProQuest)
ProQuest Computer Science Collection
Computer Science Database (ProQuest)
Research Library
Research Library (Corporate)
Advanced Technologies & Aerospace Database
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Central Premium
ProQuest One Academic (New)
Publicly Available Content Database
ProQuest One Academic Middle East (New)
ProQuest One Academic Eastern Edition (DO NOT USE)
ProQuest One Applied & Life Sciences
ProQuest One Academic (retired)
ProQuest One Academic UKI Edition
ProQuest Central China
ProQuest Central Basic
DatabaseTitle CrossRef
Publicly Available Content Database
Research Library Prep
Computer Science Database
ProQuest Central Student
Technology Collection
ProQuest One Academic Middle East (New)
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Central Essentials
ProQuest Computer Science Collection
ProQuest Central (Alumni Edition)
SciTech Premium Collection
ProQuest One Community College
Research Library (Alumni Edition)
ProQuest Central China
ProQuest Central
ProQuest One Applied & Life Sciences
ProQuest Central Korea
ProQuest Research Library
ProQuest Central (New)
Advanced Technologies & Aerospace Collection
ProQuest Central Basic
ProQuest One Academic Eastern Edition
ProQuest Technology Collection
ProQuest SciTech Collection
Advanced Technologies & Aerospace Database
ProQuest One Academic UKI Edition
ProQuest One Academic
ProQuest One Academic (New)
ProQuest Central (Alumni)
DatabaseTitleList Publicly Available Content Database
Database_xml – sequence: 1
  dbid: PIMPY
  name: ProQuest Publicly Available Content Database
  url: http://search.proquest.com/publiccontent
  sourceTypes: Aggregation Database
DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISSN 2156-5570
ExternalDocumentID 10_14569_IJACSA_2023_0140377
GroupedDBID .DC
5VS
8G5
AAYXX
ABUWG
ADMLS
AFFHD
AFKRA
ALMA_UNASSIGNED_HOLDINGS
ARAPS
AZQEC
BENPR
BGLVJ
CCPQU
CITATION
DWQXO
EBS
EJD
GNUQQ
GUQSH
HCIFZ
K7-
KQ8
M2O
OK1
PHGZM
PHGZT
PIMPY
PQGLB
RNS
3V.
7XB
8FE
8FG
8FK
JQ2
MBDVC
P62
PKEHL
PQEST
PQQKQ
PQUKI
PRINS
Q9U
ID FETCH-LOGICAL-c274t-4362fef20cc8dbc11d8ecc92c5f65e9bbcd21949fd4d4396a40ea81c32aba80f3
IEDL.DBID P5Z
ISICitedReferencesCount 0
ISICitedReferencesURI http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000988716500001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
ISSN 2158-107X
IngestDate Sun Nov 09 08:01:42 EST 2025
Sat Nov 29 02:26:11 EST 2025
IsDoiOpenAccess true
IsOpenAccess true
IsPeerReviewed false
IsScholarly true
Issue 3
Language English
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c274t-4362fef20cc8dbc11d8ecc92c5f65e9bbcd21949fd4d4396a40ea81c32aba80f3
Notes ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
OpenAccessLink https://www.proquest.com/docview/2807222056?pq-origsite=%requestingapplication%
PQID 2807222056
PQPubID 5444811
ParticipantIDs proquest_journals_2807222056
crossref_primary_10_14569_IJACSA_2023_0140377
PublicationCentury 2000
PublicationDate 2023-00-00
PublicationDateYYYYMMDD 2023-01-01
PublicationDate_xml – year: 2023
  text: 2023-00-00
PublicationDecade 2020
PublicationPlace West Yorkshire
PublicationPlace_xml – name: West Yorkshire
PublicationTitle International journal of advanced computer science & applications
PublicationYear 2023
Publisher Science and Information (SAI) Organization Limited
Publisher_xml – name: Science and Information (SAI) Organization Limited
SSID ssj0000392683
Score 2.2055004
Snippet In recent days, the demand for dealing large set of distributed data obsoletes the relational database and its structured query language (SQL) solutions in...
SourceID proquest
crossref
SourceType Aggregation Database
Index Database
SubjectTerms Algorithms
Data base management systems
Documents
Format
Industrial applications
Performance evaluation
Query languages
Relational data bases
Structured Query Language-SQL
Webs
Title Auto JSON: An Automatic Transformation Model for Converting Relational Database to Non-relational Documents
URI https://www.proquest.com/docview/2807222056
Volume 14
WOSCitedRecordID wos000988716500001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVPQU
  databaseName: Advanced Technologies & Aerospace Database
  customDbUrl:
  eissn: 2156-5570
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000392683
  issn: 2158-107X
  databaseCode: P5Z
  dateStart: 20100101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/hightechjournals
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Computer Science Database
  customDbUrl:
  eissn: 2156-5570
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000392683
  issn: 2158-107X
  databaseCode: K7-
  dateStart: 20100101
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/compscijour
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Central
  customDbUrl:
  eissn: 2156-5570
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000392683
  issn: 2158-107X
  databaseCode: BENPR
  dateStart: 20100101
  isFulltext: true
  titleUrlDefault: https://www.proquest.com/central
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Publicly Available Content Database
  customDbUrl:
  eissn: 2156-5570
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000392683
  issn: 2158-107X
  databaseCode: PIMPY
  dateStart: 20100101
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/publiccontent
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Research Library
  customDbUrl:
  eissn: 2156-5570
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000392683
  issn: 2158-107X
  databaseCode: M2O
  dateStart: 20100101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/pqrl
  providerName: ProQuest
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwpV3JTsMwEB2xHbiwI8pS-cDVkK11wgWFAmINEZsKl8ixE4RACbQp389M6rBcuHCJZI3kRB57tozfA9jWBEruypQLJVzu5dLhUtoBD1KtApti1rrb_f5CRJHf7wexKbgNTVtlYxNrQ61LRTXyXUJtcehWaHf_7Z0TaxT9XTUUGpMwTSgJRN0Qdx6_aiwWOv9ujcSJQkIxFX1zew7DhmD39Czs3YQ7RCC-Q4mGK8Rv7_TbONce53j-v9-6AHMm1mTheHMswkRWLMF8w-PAzLFehpdwVJXs7OYq2mNhwWhUA7my2x9RbVkw4k17ZThmPepVJ_yBJ9Z00-GLDmUlySsynC0qCz74ISrVqL5MtwJ3x0e3vRNuSBi4woS14h56uDzLHUspX6fKtrWPWg8c1cm7nSxIU6XR6HlBrj2NwU1XelYmfVu5Dr7Rt3J3FaaKssjWgGFqJkRHSk9b0lNo3pQUArNY3C4qTZ2sBbxZ_ORtjLWRUI5CykrGykpIWYlRVgs2m-VPzMkbJt9rv_63eANmabJxOWUTpqrBKNuCGfVRPQ8HbZg-OIri6zZMnguOz0vnql1vLpTEp5fxwydI9NU_
linkProvider ProQuest
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMw1V1Lb9NAEB6VFoleaHmJQqB7KMdN7LXjtZEQshKqpAkGKQHlZta7Nqpa2SVxqPqn-I3M-FGaS285cFyttKv1fDuP9cw3ACeGSMkdlXCppcPdTAmulB3wIDE6sMlnrbLdv09lFPmLRfB1B_60tTCUVtnqxEpRm0LTG3mPWFsEVYV6H69-ceoaRX9X2xYaNSwm6c01hmyrD-MhyvedEKef5oMRb7oKcI0RWMldVNlZmglLa98k2raNj8cIhO5nXj8NkkQbvMVukBnXoLX2lGulyre1I1SifCtzcN0HsOc6vqR7NZH89k3HQmfDq5g_0ZASa6pcNNV66KYEvfFZOJiFXWpY3qXAxpFy0xpuGoPKwp0e_G_f5hAeN740C2vwP4GdNH8KB22fCtaorWdwEa7Lgp3NvkTvWZgzGlVEtWx-x2svckZ94S4ZjtmAcvGJX-Ena7MFcaOhKhVZfYarRUXOl3emCr2uigWfw7etHPkF7OZFnr4EhqGnlH2lXGMpV6P61kpKjNLxOugkEekR8FbY8VXNJRJTDEbgiGtwxASOuAHHEXRacceNZlnF_2T96v7pY3g0mn-extNxNHkN-7Rw_XTUgd1yuU7fwEP9uzxfLd9WIGbwY9vI-AsYOi_a
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Auto+JSON%3A+An+Automatic+Transformation+Model+for+Converting+Relational+Database+to+Non-relational+Documents&rft.jtitle=International+journal+of+advanced+computer+science+%26+applications&rft.au=Revathi%2C+K.&rft.au=Tamilselvi%2C+T.&rft.au=Dhanwanth%2C+Batini&rft.au=Dhivya%2C+M.&rft.date=2023&rft.issn=2158-107X&rft.eissn=2156-5570&rft.volume=14&rft.issue=3&rft_id=info:doi/10.14569%2FIJACSA.2023.0140377&rft.externalDBID=n%2Fa&rft.externalDocID=10_14569_IJACSA_2023_0140377
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=2158-107X&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=2158-107X&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=2158-107X&client=summon