Patent ID: 11886404
Assignee: OPTUM SERVICES (IRELAND) LIMITED
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 13:
14. A computing system comprising processing circuitry and a storage system, the processing circuitry configured to:
store a set of one or more queries that characterize data to retrieve from a database comprising one or more tables;
perform a database-refinement process for restructuring the database, wherein the processing circuitry is configured to, as part of performing the database-refinement process:
perform a process to generate a first new candidate model of the database, wherein the processing circuitry is configured to, as part of performing the process to generate the first new candidate model of the database:
remove a target set of columns from a first table of a current model of the database; and
merge, in the first new candidate model of the database, the target set of columns into a new table of the database;

perform a process to generate a second new candidate model of the database, wherein the processing circuitry is configured to, as part of generating the second new candidate model of the database:
determine a second table of the current model of the database based on a number of columns of the second table that are involved in “where” or “join” clauses of the set of one or more queries; and
merge in the second new candidate model of the database, the second table with one or more connected tables of the database, wherein the one or more connected tables are connected to the second table by at least one of the “where” or the “join” clauses of the set of one or more queries;

select a restructured model of the database from among a set of restructured models of the database that includes the first new candidate model of the database and the second new candidate model of the database, wherein the restructured model of the database is selected based on relative performance of the restructured models of the database with respect to the set of one or more queries and with respect to amounts of duplicated data in the restructured models of the database; and
use the selected restructured model of the database as the current model of the database.