Invention Grant
- Patent Title: Automated database modeling
-
Application No.: US17144906Application Date: 2021-01-08
-
Publication No.: US11886404B2Publication Date: 2024-01-30
- Inventor: Vicente Rubén Del Pino Ruiz , Hendrik Kleine , Harutyun Shahumyan
- Applicant: Optum Services (Ireland) Limited
- Applicant Address: IE Dublin
- Assignee: OPTUM SERVICES (IRELAND) LIMITED
- Current Assignee: OPTUM SERVICES (IRELAND) LIMITED
- Current Assignee Address: IE Dublin
- Agency: Shumaker & Sieffert, P.A.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/21 ; G06F16/2455

Abstract:
In general, this disclosure describes techniques for automatically restructuring a database to improve one or more parameters of the database. In some examples, a computing system is configured to extract a set of columns and merge the set of columns into a new table of a first new candidate model of the database; determine a table of the database based on a number of columns of that are involved in query “where” or “join” clauses; merge the table with one or more connected tables in a second new candidate model of the database, wherein the one or more connected tables are connected to the table by at least one of the “where” or “join” clauses; select a model of the database from among the candidate models based on one or more parameters; and use the selected model as the current model of the database.
Public/Granted literature
- US20220222229A1 AUTOMATED DATABASE MODELING Public/Granted day:2022-07-14
Information query