Transformation of Relational Data to Document Models of NoSQL Databases
| Thesis title in Czech: | Transformace relačních dat do dokumentových modelů NoSQL databází |
|---|---|
| Thesis title in English: | Transformation of Relational Data to Document Models of NoSQL Databases |
| Academic year of topic announcement: | 2018/2019 |
| Thesis type: | diploma thesis |
| Thesis language: | angličtina |
| Department: | Department of Software Engineering (32-KSI) |
| Supervisor: | RNDr. Martin Svoboda, Ph.D. |
| Author: | hidden - assigned and confirmed by the Study Dept. |
| Date of registration: | 30.10.2018 |
| Date of assignment: | 31.10.2018 |
| Confirmed by Study dept. on: | 25.04.2019 |
| Guidelines |
| NoSQL databases represent a modern concept of storing, maintaining and querying of data, especially data that conforms to widely accepted although not precisely defined characteristics of Big Data such as high volume, velocity or variety. Unfortunately, the majority of contemporary systems and data they contain are based on the traditional relational model, even though non-relational models provided by, for example, graph databases or document databases could often be a better fit when considering the real nature of the data as well as queries. Therefore it makes sense to deal with approaches allowing us to migrate and transform relational data into other models, possibly also taking into account various integrity constraints or other schema constructs.
The goal of this thesis is to analyze existing approaches dealing with transformations of relational data to different non-relational logical models used within NoSQL databases, focusing especially on their JSON document models. Mutually compare them, discuss their limitations, identify their advantages and disadvantages. The core of the work should be a proposal and prototype implementation of own approach, which will then be experimentally evaluated in order to demonstrate its properties and usability. |
| References |
| Scavuzzo, M., Di Nitto, E., Ceri, S.: Interoperable Data Migration between NoSQL Columnar Databases. Enterprise Distributed Object Computing Conference Workshops and Demonstrations (EDOCW), (pp. 154-162). IEEE, 2014.
Scherzinger, S., Klettke, M., Störl, U.: Managing Schema Evolution in NoSQL Data Stores. arXiv preprint arXiv:1308.0514. 2013. Lee, C. H., Zheng, Y. L.: SQL-to-NoSQL Schema Denormalization and Migration: A Study on Content Management Systems. 2015 IEEE International Conference on Systems, Man, and Cybernetics (SMC), (pp. 2022-2026). IEEE, 2015. Walek, B., Klimes, C.: Data Migration between Document-Oriented and Relational Databases. World Academy of Science, Engineering and Technology, 6. 2012. Hanine, M., Bendarag, A., Boutkhoum, O.: Data Migration Methodology from Relational to NoSQL Databases. World Academy of Science, Engineering and Technology, International Journal of Computer, Electrical, Automation, Control and Information Engineering, 9(12), 2369-2373. 2016 Alam, F.: Data Migration: Relational RDBMS to Non-Relational NoSQL. Master's thesis, 2010. <https://digital.library.ryerson.ca/islandora/object/RULA:4149/datastream/OBJ/view> |