Invention Grant
- Patent Title: Encrypted data management in database management systems
- Patent Title (中): 数据库管理系统中的加密数据管理
-
Application No.: US11647067Application Date: 2006-12-28
-
Publication No.: US08639948B2Publication Date: 2014-01-28
- Inventor: James L. Browning
- Applicant: James L. Browning
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agency: Schwegmon, Lundberg & Woessner, P.A.
- Main IPC: G06F12/14
- IPC: G06F12/14

Abstract:
The subject matter herein relates to database management systems and, more particularly, encrypted data management in database management systems. Various embodiments provide systems, methods, and software to maintain database tables, some of which are encrypted. Some embodiments include holding clear text in cache and servicing queries from the cache. When a query is received, a file system of the database management system determines if a table holding data to service the query is encrypted. If the table is encrypted, the file system decrypts the data and writes the data to the cache as clear text. Some embodiments, when writing clear text to a table from the cache, determine if the table to which the data is to be written is an encrypted table. If the table is encrypted, the file system encrypts the clear text and stores the cipher text to the encrypted table.
Public/Granted literature
- US20100250958A1 Encrypted data management in database management systems Public/Granted day:2010-09-30
Information query