Migrating web Applications from SQL to NoSQL Databases
Loading...
Authors
Al Mahruqi, Rahma
Date
Type
thesis
Language
eng
Keyword
SQL , NoSQL , Web Application , Migration , Big Data , MySQL , Databases
Alternative Title
Abstract
In the Big Data era, data is emerging dramatically and the structure of data is becoming increasingly flexible. Non-Relational databases, such as the NoSQL class of Databases, are playing a major role as an enabler technology to manipulate such data. Non-Relational databases, have overcome many of the limitations of the relational databases especially those that relate to enable systems to scale up to serve more customers producing terabytes of data. More businesses are willing to migrate their legacy relational database systems to ones that use NoSQL Databases.
In this thesis, we present a semi-automated approach to migrate highly dynamic SQL-based web applications to ones that use document-oriented NoSQL databases such as MongoDB using source analysis and transformation techniques. We outline a set of source transformation steps that can be used to migrate existing web applications database from SQL one to document-oriented NoSQL database. We demonstrate our semi-automated framework on the analysis and migration of three existing web applications to extract, classify, translate, migrate and optimize the queries and migrate the PHP code to interact with the migrated database.
There are two parts to this approach; the migration of schema and data, and the migration of the actual application code with embedded queries. Our approach provides contributions to the second part, migrating and optimizing the embedded SQL queries to interact with the new database system and changing the application code to use the translated queries.
Description
Citation
Publisher
License
CC0 1.0 Universal
Queen's University's Thesis/Dissertation Non-Exclusive License for Deposit to QSpace and Library and Archives Canada
ProQuest PhD and Master's Theses International Dissemination Agreement
Intellectual Property Guidelines at Queen's University
Copying and Preserving Your Thesis
This publication is made available by the authority of the copyright owner solely for the purpose of private study and research and may not be copied or reproduced except as permitted by the copyright laws without written authority from the copyright owner.
Queen's University's Thesis/Dissertation Non-Exclusive License for Deposit to QSpace and Library and Archives Canada
ProQuest PhD and Master's Theses International Dissemination Agreement
Intellectual Property Guidelines at Queen's University
Copying and Preserving Your Thesis
This publication is made available by the authority of the copyright owner solely for the purpose of private study and research and may not be copied or reproduced except as permitted by the copyright laws without written authority from the copyright owner.