50-51 / 568
Databases Migration from RDBMS to
NoSQL – Part 1 Data Migration
Main Objective
Building an automated data migration system for databases, from a traditional RDBMS
(MySQL) to a NoSQL Database (Neo4j).
How to achieve it
1 - Design and Develop Migration Process Algorithm:
•
Schema and data retrieval.
•
Key and relationship analysis.
•
Node creation.
•
Relationship creation.
Yoni Maymon, Kosta Lazarev
Advisor: Dr Deganit Armon
Software Engineering
2 – Wrap it nicely inside a web server:
•
Deploy algorithm on WAMP platform
•
Design and Develop connection modules to a different DB
•
Build an API to provide access to the algorithm
•
Allow interface with Part 2 of this project to retrieve analyzed data
3 – Provide an easy to use web application for the client:
•
User friendly GUI
•
Login / Registration
•
Starting Migrations
•
Testing DB connections
•
Watching ongoing migrations
•
Supply migration statistics when it’s done
In recent years, vast amounts of data are collected
and stored.
Storing data in RDBMS is getting obsolete as the
amount of data grows.
What we have to offer is an automated tool to
perform a full database migration from an RDBMS to
a new NoSQL database.
DB migration process
Query
Translation