Show simple item record

dc.contributor.authorAl Mahruqi, Rahmaen
dc.date.accessioned2020-01-31T20:26:32Z
dc.date.available2020-01-31T20:26:32Z
dc.identifier.urihttp://hdl.handle.net/1974/27587
dc.description.abstractIn 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.en
dc.language.isoengen
dc.relation.ispartofseriesCanadian thesesen
dc.rightsCC0 1.0 Universalen
dc.rightsQueen's University's Thesis/Dissertation Non-Exclusive License for Deposit to QSpace and Library and Archives Canadaen
dc.rightsProQuest PhD and Master's Theses International Dissemination Agreementen
dc.rightsIntellectual Property Guidelines at Queen's Universityen
dc.rightsCopying and Preserving Your Thesisen
dc.rightsThis 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.en
dc.rights.urihttp://creativecommons.org/publicdomain/zero/1.0/
dc.subjectSQLen
dc.subjectNoSQLen
dc.subjectWeb Applicationen
dc.subjectMigrationen
dc.subjectBig Dataen
dc.subjectMySQLen
dc.subjectDatabasesen
dc.titleMigrating web Applications from SQL to NoSQL Databasesen
dc.typethesisen
dc.description.degreePhDen
dc.contributor.supervisorDean, Thomas R.en
dc.contributor.supervisorAlalfi, Manar H.en
dc.contributor.departmentComputingen
dc.degree.grantorQueen's University at Kingstonen


Files in this item

Thumbnail
Thumbnail

This item appears in the following Collection(s)

Show simple item record

CC0 1.0 Universal
Except where otherwise noted, this item's license is described as CC0 1.0 Universal