Migration of Relational Database to NoSQL Document-Oriented Database

With the increasing popularity of NoSQL document-oriented databases, there is a need to migrate from relational databases to NoSQL document-oriented databases. One of the main advantages of document-oriented databases is their ability to perform embedding and referencing. Stanescu et al. conducted r...

Full description

Saved in:
Bibliographic Details
Published in:Proceedings of ... International Conference on Data and Software Engineering (ICoDSE) (Online) pp. 180 - 185
Main Authors: Tandya, Wilson, Azizah, Fazat Nur
Format: Conference Proceeding
Language:English
Published: IEEE 07.09.2023
Subjects:
Adaptation models
algorithm
Metadata
migration
NoSQL
NoSQL databases
Performance evaluation
relational
Relational databases
Software algorithms
Software engineering
workload
ISSN:2640-0227
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Abstract With the increasing popularity of NoSQL document-oriented databases, there is a need to migrate from relational databases to NoSQL document-oriented databases. One of the main advantages of document-oriented databases is their ability to perform embedding and referencing. Stanescu et al. conducted research on a migration algorithm from MySQL relational databases to MongoDB NoSQL databases, utilizing relational database metadata. However, the algorithm developed only relies on whether tables have foreign keys and/or are referenced by other tables, which can lead to suboptimal mapping of the migration outcome model. Considering that a database migration is only performed on a database that has been or is currently in use, the workload information concept used in the research by Lima and Mello can be adapted to apply a better data mapping model. This paper aims to develop a migration algorithm by leveraging workload information to determine the use of embedding and referencing. The algorithm consists of two parts: a schema conversion algorithm that produces a schema for the NoSQL document-oriented database, and a data mapping algorithm that generates JSON files. Additionally, the developed algorithm incorporates a table evaluation sequence to complement the existing migration algorithm. The performance evaluation shows that, in general, the modified algorithm provides better performance than Stanescu et al.'s algorithm. However, this is not the case for scenarios involving high-frequency access to read embedded documents.
AbstractList With the increasing popularity of NoSQL document-oriented databases, there is a need to migrate from relational databases to NoSQL document-oriented databases. One of the main advantages of document-oriented databases is their ability to perform embedding and referencing. Stanescu et al. conducted research on a migration algorithm from MySQL relational databases to MongoDB NoSQL databases, utilizing relational database metadata. However, the algorithm developed only relies on whether tables have foreign keys and/or are referenced by other tables, which can lead to suboptimal mapping of the migration outcome model. Considering that a database migration is only performed on a database that has been or is currently in use, the workload information concept used in the research by Lima and Mello can be adapted to apply a better data mapping model. This paper aims to develop a migration algorithm by leveraging workload information to determine the use of embedding and referencing. The algorithm consists of two parts: a schema conversion algorithm that produces a schema for the NoSQL document-oriented database, and a data mapping algorithm that generates JSON files. Additionally, the developed algorithm incorporates a table evaluation sequence to complement the existing migration algorithm. The performance evaluation shows that, in general, the modified algorithm provides better performance than Stanescu et al.'s algorithm. However, this is not the case for scenarios involving high-frequency access to read embedded documents.
Author Azizah, Fazat Nur
Tandya, Wilson
Author_xml – sequence: 1
  givenname: Wilson
  surname: Tandya
  fullname: Tandya, Wilson
  email: 13519209@std.stei.itb.ac.id
  organization: School of Electrical Engineering and Informatics, Institut Teknologi Bandung,Bandung,Indonesia
– sequence: 2
  givenname: Fazat Nur
  surname: Azizah
  fullname: Azizah, Fazat Nur
  email: fazat@itb.ac.id
  organization: School of Electrical Engineering and Informatics, Institut Teknologi Bandung,Bandung,Indonesia
BookMark eNo9j81OhDAURqvRxHHkDVzUBwDvvW1puzQw6iToREfXkwKtwTDUAC58e41_q_MtTr7knLKjIQ6esQuEDBHs5bqI5XalrBIyIyCRIZBFZeQBS6y2RigQBoWhQ7agXEIKRPqEJdP0CgACLQDlC1bedS-jm7s48Bj4o--_t-t56WZXu8nzOfL7uH2oeBmb970f5nQzdl_w7b9zxo6D6yef_HLJnq9XT8VtWm1u1sVVlXaIdk7bYJSV5FxoaomONKnc5A22olUu1L5pUXsbgvASDbbaOKhtTlabADKnRizZ-c9v573fvY3d3o0fu79w8QnpJ08W
ContentType Conference Proceeding
DBID 6IE
6IL
CBEJK
RIE
RIL
DOI 10.1109/ICoDSE59534.2023.10291584
DatabaseName IEEE Electronic Library (IEL) Conference Proceedings
IEEE Xplore POP ALL
IEEE Xplore All Conference Proceedings
IEEE Electronic Library (IEL)
IEEE Proceedings Order Plans (POP All) 1998-Present
DatabaseTitleList
Database_xml – sequence: 1
  dbid: RIE
  name: IEEE/IET Electronic Library
  url: https://ieeexplore.ieee.org/
  sourceTypes: Publisher
DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISBN 9798350381382
EISSN 2640-0227
EndPage 185
ExternalDocumentID 10291584
Genre orig-research
GroupedDBID 6IE
6IF
6IL
6IN
AAJGR
AAWTH
ABLEC
ADZIZ
ALMA_UNASSIGNED_HOLDINGS
BEFXN
BFFAM
BGNUA
BKEBE
BPEOZ
CBEJK
CHZPO
IEGSK
OCL
RIE
RIL
ID FETCH-LOGICAL-i119t-df85942aafcb41a2725686c1d3d5afbecd17e9ff3e4181d78a0b962978f0462c3
IEDL.DBID RIE
IngestDate Wed Aug 27 02:34:16 EDT 2025
IsPeerReviewed false
IsScholarly false
Language English
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-i119t-df85942aafcb41a2725686c1d3d5afbecd17e9ff3e4181d78a0b962978f0462c3
PageCount 6
ParticipantIDs ieee_primary_10291584
PublicationCentury 2000
PublicationDate 2023-Sept.-7
PublicationDateYYYYMMDD 2023-09-07
PublicationDate_xml – month: 09
  year: 2023
  text: 2023-Sept.-7
  day: 07
PublicationDecade 2020
PublicationTitle Proceedings of ... International Conference on Data and Software Engineering (ICoDSE) (Online)
PublicationTitleAbbrev ICODSE
PublicationYear 2023
Publisher IEEE
Publisher_xml – name: IEEE
SSID ssj0003190026
Score 1.8436334
Snippet With the increasing popularity of NoSQL document-oriented databases, there is a need to migrate from relational databases to NoSQL document-oriented databases....
SourceID ieee
SourceType Publisher
StartPage 180
SubjectTerms Adaptation models
algorithm
Metadata
migration
NoSQL
NoSQL databases
Performance evaluation
relational
Relational databases
Software algorithms
Software engineering
workload
Title Migration of Relational Database to NoSQL Document-Oriented Database
URI https://ieeexplore.ieee.org/document/10291584
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV1LSwMxEB5sEfFUHxXfRPC61WQ3m-TcbVGoa6UqvZU8pSBdqVt_v8l2t-LBg7cQEhJmMnzJZL4ZgGsqHFNCBYoy01GSWh6CAJJIGyuJjIkhVTGY1xHLcz6dinFNVq-4MNbaKvjM9kKz-ss3hV4FV5m3cCKwR8wWtBhL12StjUPFn6XwoNiBqzqP5s19v8gmAypoHJwnJO41839VUqmAZNj55xb2oPtDyUPjDdjsw5ZdHECnqcmAahM9hOxh_rZWKiocakLd5DvKZCkDZKGyQHkxeRqhrF4tegy5jv3NczOmCy_DwXP_LqorJURzjEUZGcepSIiUTqsES8L8RYanGpvYUOm8mgxmVjgX28QjumFc3iqREv-CdIGcquMjaC-KhT0GJIkVXBOOqVVJrKVHL04N0cpJRZVNT6AbpDL7WCfDmDUCOf2j_wx2g-yrsCx2Du1yubIXsK2_yvnn8rJS4TdmbJyC
linkProvider IEEE
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV1LTwIxEJ4oGvWED4xva-J1ke22bHtmIRCXFQMabqTbhyExrMHF32-77GI8ePDWNE3bzLT5OtP5ZgDuKTdhylNHUQ6lR9qauSAA4kmlBRYBVrgoBvMah0nCplM-KsnqBRdGa10En-mmaxZ_-SqTK-cqszccc98i5jbsUEJwa03X2rhU7GlyJsUe3JWZNB8GnSwadymngXOf4KBZzfCrlkoBJb36PzdxCI0fUh4abeDmCLb04hjqVVUGVF7SE4iG87e1WlFmUBXsJt5RJHLhQAvlGUqy8XOMonI178llO7Zvz82YBrz0upNO3ytrJXhz3-e5pwyjnGAhjEyJL3BonzKsLX0VKCqMVZTyQ82NCTSxmK5CJlopb2NrQxpHT5XBKdQW2UKfARJYcyYx86lOSSCFxS9GFZapESlNdfscGk4qs491OoxZJZCLP_pvYb8_GcazeJA8XsKB00MRpBVeQS1frvQ17MqvfP65vCnU-Q26l5_J
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%3Abook&rft.genre=proceeding&rft.title=Proceedings+of+...+International+Conference+on+Data+and+Software+Engineering+%28ICoDSE%29+%28Online%29&rft.atitle=Migration+of+Relational+Database+to+NoSQL+Document-Oriented+Database&rft.au=Tandya%2C+Wilson&rft.au=Azizah%2C+Fazat+Nur&rft.date=2023-09-07&rft.pub=IEEE&rft.eissn=2640-0227&rft.spage=180&rft.epage=185&rft_id=info:doi/10.1109%2FICoDSE59534.2023.10291584&rft.externalDocID=10291584