# US 2010/0250958 A1 · Encrypted data management in database management systems

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2010/0250958 A1
- Document ID: US20100250958A1
- Status: Published application
- Kind: A1
- Application number: 11/647,067
- Filed: 2006-12-28
- Published: 2010-09-30
- Earliest claimed: 2006-12-28
- Assignees: Teradata US, Inc.
- Inventors: James L. Browning
- Web page: https://patentgrep.com/patent/US20100250958A1

## CPC

- G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries}
- G06F 21/602: {Providing cryptographic facilities or services}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### Claim 1

A method comprising:
maintaining a database table in a database management system designated as an encrypted table;
caching data to be stored into the database table and other database tables;
determining if the cached data is to be written to an encrypted table;
encrypting the data to be written to encrypted database tables; and
writing the encrypted data to storage locations of appropriate tables.

### Claim 2 (depends on 1)

The method of claim 1, wherein the database table is stored in one or more data blocks of one or more cylinders.

### Claim 3 (depends on 2)

The method of claim 2, wherein an index of a cylinder includes the encrypted table designation of the database table.

### Claim 4 (depends on 3)

The method of claim 3, wherein the cylinder index further includes an encryption key identifier.

### Claim 5

A method comprising:
receiving a database query of at least one encrypted data item;
reading table properties data of one or more tables within which the requested data is stored to determine if the data is stored in one or more encrypted tables;
retrieving and decrypting the requested data from at least one encrypted database table;
loading the data into the cache; and
performing the query against the data loaded into the cache.

### Claim 6 (depends on 5)

The method of claim 5, further comprising:
determining if the queried data is present in a cache before the reading of the table properties data, the retrieving and decrypting, and the loading of the cache; and
performing the query against the data already loaded into the cache.

### Claim 7 (depends on 5)

The method of claim 5, wherein:
tables are stored in one or more data blocks of one or more cylinders; and
the table properties data is stored in a cylinder index each cylinder and identifies encrypted data blocks holding all or a portion of an encrypted database table.

### Claim 8 (depends on 7)

The method of claim 7, wherein a cylinder stores encrypted and unencrypted data blocks.

### Claim 9 (depends on 7)

The method of claim 7, wherein a cylinder index identifying a data block as encrypted further includes a reference to an encryption key identifier.

### Claim 10 (depends on 9)

The method of claim 9, wherein the encryption key identifier references a 128-bit advanced encryption standard encryption key.

### Claim 11

A system comprising:
a database management system including:
a cache; and
a file system operative to:
read data in the cache and identify a table to which the data is to be stored;
determine if a table to which data is to be stored is an encrypted table and an encryption key of each encrypted table;
encrypt the data to be stored to an encrypted table according to the encryption key referenced by an encryption key identifier of each respective encrypted table; and
store the encrypted data in the table.

### Claim 12 (depends on 11)

The system of claim 11, wherein the file system is further operative to:
receive a database query;
if the data is not held in the cache, identifying one or more tables in the storage device holding the requested data;
reading index data of storage locations where the one or more tables are stored in a storage device to determine which of the one or more tables are encrypted and an encryption key referenced by an encryption key identifier to use in decrypting each encrypted table;
reading the tables out into the cache, wherein the data stored in encrypted tables is decrypted before it is read out into the cache; and
service the query from the data in the cache.

### Claim 13 (depends on 11)

The system of claim 11, wherein the encryption key referenced by an encryption key identifier of at least one encrypted table is a 128-bit advanced encryption standard encryption key.

### Claim 14 (depends on 11)

The system of claim 11, wherein:
the file system manages data stored in the database by storing a table in one or more blocks of one or more cylinders; and
a cylinder holds encrypted data blocks and unencrypted data blocks.

### Claim 15 (depends on 12)

The system of claim 12, wherein all data in the cache is clear text.

### Claim 16

A machine-readable medium, with instructions, which when processed by a machine, cause the machine to:
maintain a database table in a database management system designated as an encrypted table;
cache data to be stored into the database table and other database tables;
determine if the cached data is to be written to an encrypted table;
encrypt the data to be written to encrypted database tables; and
write the encrypted data and unencrypted data to storage locations of appropriate tables.

### Claim 17 (depends on 16)

The machine-readable medium of claim 16, wherein the database table is stored in one or more data blocks of one or more cylinders.

### Claim 18 (depends on 17)

The machine-readable medium of claim 17, wherein an index of a cylinder includes the encrypted table designation of the database table.

### Claim 19 (depends on 18)

The machine-readable medium of claim 18, wherein the cylinder index further includes an encryption key identifier.

### Claim 20 (depends on 16)

The machine-readable medium of claim 16, with further instructions, which when processed, further causes the machine to:
receive a database query of at least one encrypted data item;
read table properties data of one or more tables within which the requested data is stored to determine if the data is stored in one or more encrypted tables;
retrieve and decrypt the requested data from at least one encrypted database table;
load the data into the cache; and
perform the query against the data loaded into the cache.

### Claim 21 (depends on 20)

The machine-readable medium of claim 20, with further instructions, which when processed, further causes the machine to:
determine if the queried data is present in a cache before the reading of the table properties data, the retrieving and decrypting, and the loading of the cache; and
perform the query against the data already loaded into the cache.

### Claim 22 (depends on 20)

The machine-readable medium of claim 20, wherein:
tables are stored in one or more data blocks of one or more cylinders; and
the table properties data is stored in a cylinder index each cylinder and identifies encrypted data blocks holding all or a portion of an encrypted database table.

### Claim 23 (depends on 22)

The machine-readable medium of claim 22, wherein a cylinder stores encrypted and unencrypted data blocks.

### Claim 24 (depends on 22)

The machine-readable medium of claim 22, wherein a cylinder index identifying a data block as encrypted further includes a reference to an encryption key identifier.

### Claim 25 (depends on 24)

The machine-readable medium of claim 24, wherein the encryption key referenced by an encryption key identifier is a 128-bit advanced encryption standard encryption key.
