Institutional Repository of Vilnius University
SQL priemonės duomenų slaptumui užtikrinti reliacinėse duomenų bazių valdymo sistemose /
Abstract
dc:descriptionThis paper focuses on the methods of the data secrecy using SQL methods in relational database management systems (RDBMS). At the beginning, data secrecy, its features in relational databases and the goal of the secrecy assurance method are defined. The problem that data secrecy assurance methods vary between different databases and some RDBMS’s may lack some methods is covered. The focus is put on the table column encryption method which does not exist in some RDBMS’s. Many implementations of this method can be found, therefore some alternatives are covered and the decision of the chosen one are reasoned. This results in a methodology which defines the implementation of the method in any RDBMS and in any database schema. Features of the methodology are found through experiments, which can be repeated again to forecast exact features on another device. The main focus is on performance - how using the methodology affects the performance of simple SQL queries. One case is when a table has a fixed number of encrypted columns and different encryption algorithms are used and another case is when the same encryption algorithm is used on a table with a different number of encrypted columns. A dependency function is found in the results between the total SQL query execution time and the number of encrypted columns or used encryption algorithms.
Degree
thesis:*- Grantor dc:publisher
- Institutional Repository of Vilnius University
- Year dc:date
- 2020
Author and committee
dc:creator, dc:contributor.*- Author dc:creator
-
- Šapalas, Martynas,
- Contributors dc:contributor
-
- Baronas, Romas
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:ELABAETD81706080&prefLang=en_US