US 2015/0089574 A1 · Columnar Table Data Protection

Abstract

Shuffling data stored in columnar tables improves data storage security, particularly when used in conjunction with other security operations, such as tokenization and cryptography. A data table is accessed, and pointer values of at least one column of the accessed table are shuffled, generating a protected table. An index table mapping index values to the shuffled pointer values is generated, allowing a user with access to both the protected table and the index table to generate the original table. Without both tables, users are only able to see either the shuffled data or the index values. Example shuffling methods include, but are not limited to, random shuffling, grouped shuffling, sorting by column value, and sorting by index value.

Claims20

Dependent claims

A computer-implemented method for protecting columnar data tables comprising:

accessing a data table, the data table comprising at least a first column and a second column, each row of the data table including a pointer value associated with the first column and a corresponding data value associated with the second column;
generating an index table mapping, for each row of the data table, a different index value in a set of index values to the pointer value associated with the first column included in the row;
generating a protected table comprising a third column and a fourth column, the third column comprising the pointer values of the first column re-ordered by a shuffle operation such that at least one pointer value corresponds to a data value in the fourth column different than the data value of the second column to which the same pointer value in the first column corresponds;
and
storing the protected table and the index table in one or more non-transitory storage mediums.

2 more elements

Dependencies are inferred from the claim text.

Columnar Table Data Protection

Life of this patent

Columnar Table Data Protection

Life of this patent

Abstract

Claims20