ENCRYPTED INFORMATION RETRIEVAL IN SQL AND NOSQL DATABASES

Abstract

The objective ofthis project is to develop a security system that helps to prevent data from theft or hackers in order to maintain confidentiality and integrity. This report tells about the system and its components and how it works. Different cryptographic algorithms are used in Java language like OPE, AES and Unstructured (NoSQL) and (SQL) Databases are used like MongoDB and XAMPP (MySQL)for storing records. The system first prompt user to input data which is in plain text form then the data will be encrypted according to the algorithm which fits best for the data and then it will be stored in the database. When the user requests for the data, the request is then sent to the system, the query is then performed on the encrypted information according to the users request and then sent to the system where it decrypts and then delivered to the user. This system is very useful as there is processing of query on the encrypted data and it helps to maintain the confidentiality and integrity of data because if someone hacks the database then he/she will only have the encrypted information which is not useful for him/her because he/she doesn't know what this information is all about because all of the information is in encrypted and without the key no one can decrypt it