Semi-Automated Strategy for Efficient Migration from SQL to NoSQL

As more applications are migrated to NoSQL databases, they often rely on general guidelines to select appropriate schemas, but these methods do not fully address the unique challenges posed by NoSQL systems. Traditional relational database schema optimization techniques are not directly applicable t...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:International Journal of Scientific Research in Computer Science, Engineering and Information Technology Jg. 11; H. 4; S. 244 - 255
Hauptverfasser: Amit Kanojia, S. Tanwani
Format: Journal Article
Sprache:Englisch
Veröffentlicht: 27.07.2025
ISSN:2456-3307, 2456-3307
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:As more applications are migrated to NoSQL databases, they often rely on general guidelines to select appropriate schemas, but these methods do not fully address the unique challenges posed by NoSQL systems. Traditional relational database schema optimization techniques are not directly applicable to NoSQL environments, leading to inefficiencies in schema design. This paper introduces an approach for designing optimal database schemas specifically tailored for NoSQL databases like MongoDB. We propose a semi-automated schema model to recommend schemas and query plans based on Metadata SQL query information. The model captures Meta data information of SQL database and used as a suggestive measure to design NoSQL database. The key parameters captured are primary key, foreign key, table size and cardinality. The decision is made based on these parameters and manual interventions of frequently executed SQL queries indicating joins. This approach aims to simplify the development process, enhance database performance and scalability through our proposed model. To evaluate the impact of proposed model three benchmark workloads were implemented using the Yahoo! Cloud Serving Benchmark (YCSB) framework, especially focused on eliminating joins.
ISSN:2456-3307
2456-3307
DOI:10.32628/CSEIT2511162