Protection of Data Stored in Transparent Database System using Encryption

Abstract

In transparent database data are stored at different severs which is easily visible and accessible to every user. End users usually access information through applications that intermediate between the user and the database. These applications provide interface to access the database system i.e. transparent to end users. This is expected and even logical aspect of the nature of most database management systems (DBMS). There is always possibility of data loss and data theft by an unauthorized user. Now-a-days research on Distributed database management system (DDBMS) found to best match to handling the transparent type database storage and processing rules via communication links. In this paper, we have introduced a method of encrypting the transparent database files and data. The prime purpose here is to prevent an unauthorized access to the data by restoring the files from another server. These physical files include the database file (.mdf), the transaction log file (.ldf) and the backup files (.bak).

New Solution Implementation to Protect Encryption Keys Inside the Database Management System

“…Indeed, many solutions have been developed in order to resolve this problem. For instance, the keys protection solutions implemented at DBMSs such as Oracle, Ms SQL Server and My SQL are mainly based on the use of "Wallets", Hardware Security Module (HSM) and "Security server" [11][12][13][14]. In fact, each one of these solutions has advantages and major limits, as have already explained in more detail in our previous work [8,15].…”