Table scan technique for querying over an encrypted database

The growth of data and the increase in the size of databases have led to difficulties for administrators in maintaining the confidentiality of data and protecting them from outside attackers. Encryption is necessary in protecting data in databases, but it has caused another problem in processing the required encrypted data and retrieving them from databases. In traditional encryption methods, the entire or a part of the database is retrieved and decrypted to detect user-requested data. This process is time consuming and does not prevent exposure by the administrator or external attacker.s This work recommends a technique to address the drawbacks of traditional methods for encrypted database systems. The technique processes structural query language (SQL) queries over encrypted data in a remote database without decrypting all of the data, and data decryption is performed only at the proxy site. This technique is a new means of querying using the table scan mechanism by uses two steps, Distribution the encrypted tables and Generate indexes fields. This method is used when the number of the matching records is a large into the total number of records or when the table is small