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...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:International journal of advanced computer science & applications Ročník 14; číslo 3
Hlavní autoři: Revathi, K., Tamilselvi, T., Dhanwanth, Batini, Dhivya, M.
Médium: Journal Article
Jazyk:angličtina
Vydáno: West Yorkshire Science and Information (SAI) Organization Limited 2023
Témata:
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
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
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
Technology Collection
ProQuest One Community College
ProQuest Central Korea
ProQuest Central Student
ProQuest Research Library
SciTech Premium Collection
ProQuest Computer Science Collection
Computer Science Database
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: 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: 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: 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/eLvHCXMwpV1NT9wwEB0By6GXUqAVtHTlQ6-GJE7shEsVlkV8lBCxW2nbS-Q4NkKtEtjN9vfXk3VauHDhEskayY4845mxPX4P4IsxZaIYAt1yFdGQM58mQclooJlivIxYucKZ_SayLJ7NktwduC1cWWXvEztHXTUKz8iPELUlwFeh_OvDI0XWKLxddRQa6zBAlASkbsijn__OWDwb_HmHxGmFiGIqZu71nE0bkqOLy3Q0SQ-RQPwQNxpMiOfR6blz7iLO2dZr__UdvHW5JklXxrENa7rega2ex4G4Zb0Lv9Jl25DLyU12TNKaYKsDciXTJ1ltUxPkTftNbJuMsFYd8QfuSF9NZwc6la3EqEhsb1lT0_kTUaOW3WO69_D9bDwdnVNHwkCV3bC2NLQRzmgTeErFVal8v4qt1pNARYZHOilLVVmnFyamCiub3HAZelrGvmKBHTH2DPsAG3VT6z0gofG4UVJrgbfI1kqkV0pfGOsGZCiM3AfaT37xsMLaKHCPgsoqVsoqUFmFU9Y-HPTTX7iVtyj-z_3Hl8Wf4A121lXh8APYaOdL_Rk21Z_2fjEfwuBknOW3Q1i_EtR-r4ObYWdcVpJfXOc__gKF1tX-
linkProvider ProQuest
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMw1V1LT9wwEB7xkuilvFUopT7A0ZDE2ThBqlC0FLHsEpBYpL0F27ERAiWwmy3qn-pvxJNHCxduHHq0LDly5vM87JlvAHaNkZFiSHQbqA71A-bSyJOMepopFsgOkzXP7IAnSTgaRZcz8KethcG0ylYnVoo6KxTekR8ga4uHVaHB0eMTxa5R-LrattCoYdHXv59tyDb50Tu28t3zvJOfw-4pbboKUGUjsJL6VmUbbTxHqTCTynWz0G4j8lTHBB0dSakye4r9yGR-Zq11IHxHi9BVzBNShI5hdt1ZmPdZyPFc9Tn9e6fjWGcjqJg_rSFF1lQ-aqr1rJsSHfTO4u5VvI8Ny_cxsGGcv7WGb41BZeFOlv63f7MMnxtfmsQ1-FdgRuersNT2qSCN2lqD-3haFuTs6iI5JHFOcFQR1ZLhK6-9yAn2hXsgdky6mIuP_Aq3pM0WtB86FqVAq0_sakmR0_GrqUJNq2LBdbj-kC1vwFxe5PoLEN84gVFCa46v5PYUCEcKlxur5oTPjdgE2go7fay5RFKMwRAcaQ2OFMGRNuDYhO1W3GmjWSbpP1lvvT_9HRZPh-eDdNBL-l_hEy5cXx1tw1w5nupvsKB-lXeT8U4FYgI3H42MF2vQMJE
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