A Model for Migrating Relational Database to NoSQL Database






Research Topics
FAQ
Publication Ethics
Copyright Infragmentation

Version
Download 122
File Size 678.87 KB
File Count 1
Create Date 09/08/2023
Last Updated 09/08/2023

Download

Description

A Model for Migrating Relational Database to NoSQL Database

Pradeep Shiriyannavar

Department of MCA

Dayananda Sagar College of Engineering Kumaraswamy layout, Bangalore, India.

Dr. Srinivasan V ,Asst professor

Department of MCA

Dayananda Sagar College of Engineering Kumaraswamy layout, Bangalore, India.

1 Abstract:

Relational Database Management Systems (RDBMS) is widely used to store the Data and Information. As we already know RDBMS can store the data in the form of table but if we want to know the complex data relationships and interconnected information, we have to convert the relational database to graph database. Professionals working with airline databases will be able to quickly query highly connected data thanks to graph databases' ability to quickly uncover and manage new and beneficial associations. Relational databases use expensive huge joins to query related data, whereas graph data-stores contain direct references to their neighboring nodes. In order to handle the enormous quantity of airline data being created at a very high pace, scalability was therefore greatly needed. Additionally, the majority of airline data is semi- or un-structured, necessitating a schema-less database.

In this paper a methodology to issues that occurs while converting an Airline relational to a graph database. By utilizing the source's restrictions and schema. Conjunctive SQL searches over the source are supported by the method and converted into graphs. procedures that traverse the target. To demonstrate the viability of the solution and the effectiveness of query response across the target database, the experimental outcomes are shown. Nodes are mapped to tuples, while edges are mapped to foreign keys.

Constraints were maintained during the change. In order to build the suggested solution, SQL2Neo, popular graph database Neo4j and MySQL as relational databases were both used.

Index Terms—Database migration, Graph, data, attributes, Relationships, tables.

Previous

Resume Screening using Machine Learning

Next

Cryptoverse – A Multi-Asset Platform with Crypto Swapping Technique using Blockchain

What is DOI

DOI:

A DOI will help Author(s) easily locate a document from your citation. Think of it like a Social Security number for the article you're citing — it will always refer to that article, and only that one. While a web address (URL) might change, the DOI will never change.

Where can i find DOI:

In IJSREM journal articles, the DOI will be printed with the article itself, usually on the footer of the page
If the DOI isn't included in the article, look it up on the website CrossRef.org (use the "Search Metadata" option) to check for an assigned DOI.

Benefits:

Allows for a quick and precise search.
Article can always be located.
Persistent link to its location on the Internet.
Easier identification of published articles even if the metadata URL is changed.
Aid in citation tracking, ensuring a researcher has accurate metrics on how and where their research outputs are being used or referenced.

Site Map

Terms and Conditions

Copyright Infragmentation

Publication Ethics

Editorial Board

Processing Fee's

Call for Papers

Publication Procedure

Research Topics

Frequently Asked Questions

What type of papers does International Journal of Scientific Research in Engineering and Management (IJSREM) publish?

Research Paper, Survey Paper, Informative Article, Case Studies, Review Papers, Comparative Studies

How long does it take for an accepted paper to be actually published?

Approximate will inform within 24 hours via email and sms.

What is the procedure to submit my paper?

Please Submit your Research Paper here Submit Research Paper Online - IJSREM

What is a Paper ID?

Paper ID is an Unique Identification Code provided to your submitted Manuscript. You should always mention the Paper ID during any communication with us.

How long my published paper will stay online?

Lifetime.

May I submit more than one article?

We will accept multiple submissions across multiple communities, as long as the author joins each community.

Why IJSREM?

IJSREM is one of the world's leading and fastest-growing research publications with the paramount objective of discovering advances by publishing insightful, double-blind, peer-reviewed scientific journals.

Publication Time Period

The Submitted Article/Paper will accept within 12-24 Hours, and it can publish within 24 Hours

Publication Procedure

Manuscript Submission - Check Manuscript Plagiarism - Send for Editorial Review - Final Decission to Author - Payment of Publication Fee - Re-screening - Final Publication

Processing Fee's

For Management, Hosting & Office Expenditure IJSREM Journal may charge some amount to publish the paper.

To Publish a Paper ₹: 800/- INR (without DOI)

₹:1000/- INR (with DOI)

To the extent possible under, Indospace Publications has waived all copyright and related or neighboring rights to Journal. This work is published from India.

Disclaimar Privacy Policy Terms and Conditions

Copyright © 2023. All Rights Reserved