Generating a data partitioning strategy for secure and efficient query processing
US11194838B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 23, 2019 |
| Grant date | Dec 7, 2021 |
| Priority date | — |
| Expiry date | Jul 20, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/23
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods, systems, and computer program products for generating a data partitioning strategy for secure and efficient query processing are provided herein. A computer-implemented method includes obtaining at least (i) a database schema associated with a database and (ii) a query workload associated with the database; and generating, based at least in part on the database schema and the query workload, a distributed database structure for the database that (i) stores a first set of columns of the database within a private cloud environment in a plaintext format and (ii) stores a second set of columns of the database in a public cloud environment, wherein the second set of columns is stored in either a plaintext format or an encrypted format based on whether the second set of columns comprises sensitive data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.