US 12,242,518 B2
Enhanced processing of large data volumes from inside relational databases
Idilio Moncivais-Pinedo, Broomfield, CO (US)
Assigned to Level 3 Communications, LLC, Denver, CO (US)
Filed by Level 3 Communications, LLC, Broomfield, CO (US)
Filed on Oct. 24, 2023, as Appl. No. 18/493,295.
Claims priority of provisional application 63/380,887, filed on Oct. 25, 2022.
Prior Publication US 2024/0134889 A1, Apr. 25, 2024
Prior Publication US 2024/0232235 A9, Jul. 11, 2024
Int. Cl. G06F 16/28 (2019.01); G06F 16/2458 (2019.01)
CPC G06F 16/288 (2019.01) 14 Claims
OG exemplary drawing
 
1. A method for analyzing data stored in a relational database, the method comprising:
installing a structured query language (SQL) server application on a host server;
installing statistical analysis modules on the host server;
executing the statistical analysis modules within a relational database of the SQL server application to analyze data stored in the relational database;
generating outputs based on the execution of the statistical analysis modules within the relational database;
generating a data mart in the SQL server application, the data mart comprising financial data, wherein the data comprises the financial data;
generating a conceptual data model comprising independent specifications of the financial data;
generating, based on the conceptual data model, a logical data model indicative of structures of the financial data to be implemented in the relational database; and
generating, based on the logical data model, a physical data model in which the financial data are organized into tables, wherein generating the data mart is based on the tables.