# US 2023/0066677 A1 · Sensitivity-based database processing and distributed storage

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

- Number: US 2023/0066677 A1
- Document ID: US20230066677A1
- Status: Published application
- Kind: A1
- Application number: 17/410,181
- Filed: 2021-08-24
- Published: 2023-03-02
- Earliest claimed: 2021-08-24
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Manish Anand Bhide; Prateek Goyal; Seema Nagar; Sougata Mukherjea; Kuntal Dey; Pramod Vadayadiyil Raveendran
- Web page: https://patentgrep.com/patent/US20230066677A1

## CPC

- G06F 16/284: {Relational databases}
- G06F 16/221: {Column-oriented storage; Management thereof}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F 16/24554: {Unary operations; Data partitioning operations}
- G06F 16/248: Presentation of query results
- G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A system and method is provided to selectively process and store tables of a relational database by calculating an overall data sensitivity score for each table based on predefined attribute rules; performing column-wise splitting of at least one of the tables into a first table and a second table based on the overall data sensitivity score of each table, thereby generating a total number of relational database tables; storing a first subset of the total number of relational database tables in a private cloud storage database in a distributed storage environment based on the overall data sensitivity scores of each of the total number of relational database tables; and storing a second subset of the total number of relational database tables in a public cloud storage database of the distributed storage environment based on the overall data sensitivity scores of each of the total number of relational database tables.

## Claims

### Claim 1

A method, comprising:
calculating, by a computing device in a distributed storage environment, an overall data sensitivity score, for each table of a relational database based on predefined attribute rules, which indicates an amount of private data;
performing, by the computing device, column-wise splitting of at least one of the tables of the relational database into a first table and a second table based on an overall data sensitivity score of the at least one of the tables of the relational database, thereby generating a total number of relational database tables;
storing, by the computing device, a first subset of the total number of relational database tables in a private cloud storage database in the distributed storage environment based on the overall data sensitivity scores of each of the total number of relational database tables; and
storing, by the computing device, a second subset of the total number of relational database tables in a public cloud storage database of the distributed storage environment based on the overall data sensitivity scores of each of the total number of relational database tables.

### Claim 2 (depends on 1)

The method of claim 1, further comprising dividing, by the computing device, the total number of relational database tables into the first subset of the total number of relational database tables and the second subset of the total number of relational database tables, wherein the first subset comprises tables having a higher overall sensitivity score than the tables of the second subset.

### Claim 3 (depends on 2)

The method of claim 2, further comprising: performing, by the computing device, the column-wise splitting of at least one of the tables of the relational database iteratively until a mean sensitivity score of the first subset of tables is greater than a first predetermined data processing threshold and a mean sensitivity score of the second subset of tables is less than a second predetermined data processing threshold.

### Claim 4 (depends on 1)

The method of claim 1, wherein the calculating an overall data sensitivity score for each table of the relational database comprises: assigning, by the computing device, a data sensitivity score to each column of each table of the relational database, wherein the overall data sensitivity score for each table is computed from the data sensitivity scores of the table's columns.

### Claim 5 (depends on 4)

The method of claim 4, wherein the overall data sensitivity score for each table is computed as a mean or a median of the data sensitivity scores of the table's columns.

### Claim 6 (depends on 4)

The method of claim 4, wherein the attribute rules assign different attribute weights to different attributes, and wherein the assigning the data sensitivity score to each column of each table of the relational database is based on the attribute weights.

### Claim 7 (depends on 1)

The method of claim 1, further comprising:
receiving, by the computing device, a query from a user;
determining, by the computing device, one or more stored tables of the relational database to access based on the query;
determining, by the computing device, a storage location of each of the one or more stored tables to access;
sending, by the computing device, a first query to the private cloud based on the query from the user and the determining the storage location of each of the one or more stored tables to access;
sending, by the computing device, a second query to the public cloud based on the query from the user and the determining the storage location of each of the one or more stored tables to access;
combining, by the computing device, query results received from the private cloud with query results received from the public cloud, thereby creating final query results; and
sending, by the computing device, the final query results to the user.

### Claim 8 (depends on 1)

The method of claim 1, wherein the computing device includes software provided as a service in a cloud environment.

### Claim 9

A computer program product comprising one or more computer readable storage media having program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
perform data normalization of a relational database, thereby producing a number of tables of the relational database;
calculate an overall sensitivity score for each of the tables of the relational database, wherein the overall data sensitivity score indicates an amount of private data;
determine whether the sensitivity score for each of the tables of the relational database meets or exceeds a table splitting threshold;
split, column-wise, any table of the relational database determined to have a sensitivity score that meets or exceeds the table splitting threshold into a first table and a second table, wherein the first table and the second table each include a primary key from the table being split, thereby generating a total number of relational database tables;
store a first subset of the total number of relational database tables in a private cloud storage database based on the overall data sensitivity scores of each of the total number of relational database tables; and
store a second subset of the total number of relational database tables in a public cloud storage database based on the overall data sensitivity scores of each of the total number of relational database tables, wherein the tables of the first subset of the total number of relational database tables have a higher overall sensitivity score than the tables of the second subset of the total number of relational database tables.

### Claim 10 (depends on 9)

The computer program product of claim 9, wherein the program instructions are further executable to:
calculate an overall sensitivity score for each of the first table and the second table; and
divide the total number of relational database tables into the first subset of the total number of relational database tables and the second subset of the total number of relational database tables based on the overall sensitivity scores of each of the total number of relational database tables.

### Claim 11 (depends on 10)

The computer program product of claim 10, wherein the program instructions are further executable to: perform the column-wise splitting of at least one of the tables of the relational database, and the calculating an overall sensitivity score for each of the tables of the relational database, iteratively until a mean sensitivity score of the first subset of tables is greater than a first predetermined data processing threshold and a mean sensitivity score of the second subset of tables is less than a second predetermined data processing threshold.

### Claim 12 (depends on 9)

The computer program product of claim 9, wherein the calculating an overall sensitivity score for each of the tables of the relational database comprises: assigning a data sensitivity score to each column of each table of the relational database, wherein the overall data sensitivity score for each table is computed from the data sensitivity scores of the table's columns.

### Claim 13 (depends on 12)

The computer program product of claim 12, wherein the overall data sensitivity score for each table is computed as a mean or a median of the data sensitivity scores of the table's columns.

### Claim 14 (depends on 12)

The computer program product of claim 12, wherein the attribute rules assign different attribute weights to different attributes, and wherein the assigning the data sensitivity score to each column of each table of the relational database is based on the attribute weights.

### Claim 15 (depends on 9)

The computer program product of claim 9, wherein the program instructions are further executable to:
receive a query from a user;
determine one or more stored tables of the relational database to access based on the query;
determine a storage location of each of the one or more stored tables to access;
send a first query to the private cloud based on the query from the user and the determining the storage location of each of the one or more stored tables to access;
send a second query to the public cloud based on the query from the user and the determining the storage location of each of the one or more stored tables to access;
combine query results received from the private cloud with query results received from the public cloud, thereby creating final query results; and
send the final query results to the user.

### Claim 16

A system comprising:
a processor, a computer readable memory, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
perform data normalization of a relational database, thereby producing a number of tables of the relational database;
calculate an overall sensitivity score for each of the tables of the relational database wherein the overall data sensitivity score indicates an amount of private data;
determine whether the sensitivity score for each of the tables of the relational database meets or exceeds a table splitting threshold;
split, column-wise, any table of the relational database determined to have a sensitivity score that meets or exceeds the table splitting threshold into two tables, each of the two tables including a primary key from the table being split, thereby generating a total number of relational database tables;
calculate an overall sensitivity score for each of the total number of relational database tables;
divide the total number of relational database tables into a first subset of the total number of relational database tables and a second subset of the total number of relational database tables based on the overall sensitivity scores of each of the total number of relational database tables;
store the first subset of the total number of relational database tables in a private cloud storage database; and
store the second subset of the total number of relational database tables in a public cloud storage database, wherein the tables of the first subset of the total number of relational database tables have a higher overall sensitivity score than the tables of the second subset of the total number of relational database tables.

### Claim 17 (depends on 16)

The system of claim 16, wherein the program instructions are further executable to: perform the column-wise splitting of at least one of the tables of the relational database, and the calculating an overall sensitivity score for each of the tables of the relational database, iteratively until a mean sensitivity score of the first subset of tables is greater than a first predetermined data processing threshold and a mean sensitivity score of the second subset of tables is less than a second predetermined data processing threshold.

### Claim 18 (depends on 16)

The system of claim 16, wherein the calculating an overall sensitivity score for each of the tables of the relational database comprises: assigning a data sensitivity score to each column of each table of the relational database, wherein the overall data sensitivity score for each table is computed as a mean or a median of the data sensitivity scores of the table's columns.

### Claim 19 (depends on 18)

The system of claim 18, wherein the attribute rules assign different attribute weights to different attributes, and wherein the assigning the data sensitivity score to each column of each table of the relational database is based on the attribute weights.

### Claim 20 (depends on 16)

The system of claim 16, wherein the program instructions are further executable to:
receive a query from a user;
determine one or more stored tables of the relational database to access based on the query;
determine a storage location of each of the one or more stored tables to access;
send a first query to the private cloud based on the query from the user and the determining the storage location of each of the one or more stored tables to access;
send a second query to the public cloud based on the query from the user and the determining the storage location of each of the one or more stored tables to access;
combine query results received from the private cloud with query results received from the public cloud, thereby creating final query results; and
send the final query results to the user.
