Back to search

Institutional Repository of Vilnius University

SQL priemonės duomenų slaptumui užtikrinti reliacinėse duomenų bazių valdymo sistemose /

Abstract

dc:description

This 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.*

Chain of custody

source
Harvested from
Vilnius University
Base URL
epublications.vu.lt/oai
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Šapalas, Martynas,. SQL priemonės duomenų slaptumui užtikrinti reliacinėse duomenų bazių valdymo sistemose /. Institutional Repository of Vilnius University, 2020. https://repository.vu.lt/VU:ELABAETD81706080&prefLang=en_US