Institutional Repository of Vilnius University
Heterogeninių dokumentų duomenų apjungimas /
Abstract
dc:descriptionAs the amount of data increases, number of challenges regarding data storage keep rising as well. Nowadays, it is a common thing to save diverse data using different types of databases. However, combination of this data remains an important issue. In this paper, I propose a solution that enables data combination from different databases with a usage of one SQL query. Implementation of the solution is done using virtualization technology, as the main component in the first virtual machine is able to process data from four different databases, that are located in other virtual machines. Most of the work is being done by a Python script. The mentioned script is able to divide the main query into smaller ones, that are being used for data collection in the appropriate SQL and NoSQL databases. Proposed solution could be used while working with PostgreSQL, MySQL, MongoDB and Redis database systems. To make sure that the created component is effective and works as intended, number of documented tests were done, whose results also provided information on pros and cons of the selected database systems.
Degree
thesis:*- Grantor dc:publisher
- Institutional Repository of Vilnius University
- Year dc:date
- 2020
Author and committee
dc:creator, dc:contributor.*- Author dc:creator
-
- Jodikaitis, Karolis,
- Contributors dc:contributor
-
- Brilingaitė, Agnė
Rights
dc:rights- Statement dc:rights
-
- info:eu-repo/semantics/openAccess
- Language dc:language
- lit
Identifiers
dc:identifier.*- Repository record dc:identifier
- https://repository.vu.lt/VU:ELABAETD81806437&prefLang=en_US