UPDATE query over encrypted data

Data is a critical asset for every organization. Data of organizations are normally stored in database, therefore, database security is important. Encryption is one of the strong security layers in database security, but SQL has a limitation that its queries cannot be run directly on encrypted data. When some update is needed in an encrypted column of table so the entire column needs to be decrypted before updation process, this degrades system performance. This paper proposes a new technique to update value directly although the conditioned column is in encrypted form. It does not need to decrypt the entire conditioned column for update process. This improves system performance.