{"id":31,"date":"2003-12-07T00:00:00","date_gmt":"2003-12-07T00:00:00","guid":{"rendered":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/2003\/12\/07\/how-to-use-encryption-on-database-contents\/"},"modified":"2021-12-30T11:36:20","modified_gmt":"2021-12-30T11:36:20","slug":"how-to-use-encryption-on-database-contents","status":"publish","type":"post","link":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/2003\/12\/07\/how-to-use-encryption-on-database-contents\/","title":{"rendered":"How To Use Encryption On Database Contents"},"content":{"rendered":"<p>Are data-privacy regulations and dreams about stolen employee data keeping you up at night?  With the Health Insurance Portability and Accountability Act (HIPAA) now a reality, though, the stakes are higher than ever when it comes to compromised customer and employee data, and many organizations are taking a second look at encrypting their databases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It may be time to protect your data where it lives&#8211;in your database.<\/p>\n<p>But you can&#8217;t encrypt everything in your database.  Indexed fields, for example, can&#8217;t be encrypted because your database-management software will sort the encrypted strings in hexadecimal values, which won&#8217;t match the real, unencrypted form.  So your index, which is supposed to speed access to the data by preordering it, won&#8217;t work.  Even if you could relate the encrypted index field to the original data, the collation order wouldn&#8217;t match.<\/p>\n<p>Until databases support encryption natively, encrypted indices will be a problem.  Remember that any indices generated from encrypted fields won&#8217;t be valid, either.  And because these fields don&#8217;t relate to the actual data, it&#8217;ll be harder for the database administrator and developer to debug problems.  <\/p>\n<p>Database software, such as Sybase&#8217;s, lets you create encrypted databases.<\/p>\n<p>Ingrian Networks&#8217; DataSecure Platform, which lets you encrypt certain fields before you enter them in the database and automatically decrypts them on the way out, has been around for a couple of years.<\/p>\n<p>Bottom line: When building your disk capacity for database encryption, anticipate that your data will triple or quadruple in size.<\/p>\n<p>More info: [url=http:\/\/www.securitypipeline.com\/story\/showArticle.jhtml?articleID=16600160]http:\/\/www.securitypipeline.com\/story\/showArticle.jhtml?articleID=16600160[\/url]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-31","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":1,"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":2518,"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/31\/revisions\/2518"}],"wp:attachment":[{"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cybersecurityinstitute.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}