Patent · US Active

Processing analytical queries over encrypted data using dynamical decryption

US10733321B2 · kind B2 · utility

2Cited by

5References

11Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Felix Beier · Haigerloch, DE
Peter Bendel · Holzgerlingen, DE
Nicole Ying Finnie · Eppelheim, DE
Namik Hrle · Eppelheim, DE

Key dates

Filing date	May 7, 2019
Grant date	Aug 4, 2020
Priority date	—
Expiry date	May 7, 2039

Classification

Technology area (CPC H)Electricity
CPC primaryH04L9/008
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Aspects of the invention include processing queries in a database system having a first database engine and a second database engine. A first instance of a first table is stored in the first database engine in plaintext. At one predefined column of the first table is encrypted, resulting in a set of encrypted columns, using a cascade encryption scheme that includes a set of ordered encryption methods. A subset of the set of columns is stored in a second instance of the first table in the second database engine. An encryption method of the cascade encryption scheme that allows a query operation of a received query on data encrypted with the identified encryption method is identified. The identified encryption method is used to rewrite the query, and the rewritten query is executed using the second instance of the first table.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.