Migrating web Applications from SQL to NoSQL Databases
Al Mahruqi, Rahma
MetadataShow full item record
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.
URI for this recordhttp://hdl.handle.net/1974/27587
Request an alternative formatIf you require this document in an alternate, accessible format, please contact the Queen's Adaptive Technology Centre
The following license files are associated with this item: