Enhancing Relational Database Security by Metadata Segregation
| Autor: | Pavol Zavarsky, Devanshu Trivedi, Sergey Butakov |
|---|---|
| Rok vydání: | 2016 |
| Předmět: |
021110 strategic
defence & security studies Database Computer science Relational database 0211 other engineering and technologies 020206 networking & telecommunications 02 engineering and technology Information security computer.software_genre Computer security Database design Security controls Transparent Data Encryption Oracle Metadata Data access Relational database management system 0202 electrical engineering electronic engineering information engineering Relational model General Earth and Planetary Sciences Data architecture Referential integrity computer General Environmental Science Foreign key |
| Zdroj: | FNC/MobiSPC |
| ISSN: | 1877-0509 |
| DOI: | 10.1016/j.procs.2016.08.070 |
| Popis: | Although many prominent Relational Database Management Systems provides inbuilt security controls and mechanisms, the information resided in the data-store are at great risk. This research aims to reduce the risk of unauthorized data access by providing an extra layer of security. This research proposes a novel method for incorporating information security while designing the relational database by segregating the information on the basis of its sensitivity level and creating referential integrity constraints dynamically at run time. Different techniques to identify and quantify sensitive attributes and restructuring database architecture have been discussed for the proposed approach. The primary keys of the restructured tables and most critical information attributes were secured using Transparent Data Encryption utility provided by Oracle 11 g to prohibit illegitimate use of information. The performance of the proposed architecture was evaluated with 1,000,000 records which shows that by increasing the number of records, the response time of Select statement increased dramatically whereas it increased gradually for Insert, Update and Delete operations. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|