University of North Florida. School of Computing
Extracting a Relational Database Schema from a Document Database
Abstract
dc:description.abstractAs NoSQL databases become increasingly used, more methodologies emerge for migrating from relational databases to NoSQL databases. Meanwhile, there is a lack of methodologies that assist in migration in the opposite direction, from NoSQL to relational. As software is being iterated upon, use cases may change. A system which was originally developed with a NoSQL database may accrue needs which require Atomic, Consistency, Isolation, and Durability (ACID) features that NoSQL systems lack, such as consistency across nodes or consistency across re-used domain objects. Shifting requirements could result in the system being changed to utilize a relational database. While there are some tools available to transfer data between an existing document database and existing relational database, there has been no work for automatically generating the relational database based upon the data already in the NoSQL system. Not taking the existing data into account can lead to inconsistencies during data migration. This thesis describes a methodology to automatically generate a relational database schema from the implicit schema of a document database. This thesis also includes details of how the methodology is implemented, and what could be enhanced in future works.
Degree
thesis:*- Name thesis:degree_name
- Master of Science in Computer and Information Sciences (MS)
- Discipline thesis:degree_discipline
- Computing
- Grantor
- University of North Florida. School of Computing
- Date dc:date.issued
- Spring
Author and committee
dc:creator, dc:contributor.*- Authors dc:creator
-
- Wheeler, Jared Thomas
- Wheeler, Jared, 1992-
- Advisors dc:contributor.advisor
-
- Seyed-Abbassi, Behrooz
- Martin, Ken
- Eggen, Roger
- Contributors dc:contributor
-
- Dr. Behrooz Seyed-Abbassi
- Dr. Ken Martin
- Dr. Roger Eggen
Subjects
dc:subject × 5- Thesis; University of North Florida; UNF; Dissertations
- Academic -- UNF -- Master of Science in Computer and Information Sciences; Dissertations
- Academic -- UNF -- Computing; SQL; Relational Database; Document Database; NoSQL; MongoDB; Database
- Databases and Information Systems
- Relational databases; Non-relational databases; Database management; Data transmission systems; Metadata
Rights
dc:rightsIdentifiers
dc:identifier.*- Repository record dc:identifier
- https://digitalcommons.unf.edu/etd/730