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

Claim 0:
1. A method comprising:
storing, by a computing system, a set of one or more queries that characterize data to retrieve from a database comprising one or more tables;
performing, by the computing system, a database-refinement process for restructuring the database, wherein the database-refinement process comprises:
performing, by the computing system, a process to generate a first new candidate model of the database, wherein the process to generate the first new candidate model of the database comprises:
removing, by the computing system, a target set of columns from a first table of a current model of the database; and
merging, by the computing system, in the first new candidate model of the database, the target set of columns into a new table of the database;

performing, by the computing system, a process to generate a second new candidate model of the database, wherein generating the second new candidate model of the database comprises:
determining, by the computing system, 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
merging, by the computing system, 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 at by least one of the “where” or the “join” clauses of the set of one or more queries;

selecting, by the computing system, 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
using, by the computing system, the selected restructured model of the database as the current model of the database.