Mckesson Corporation

Keith Hoyle

Marion A Brown

Manuel Salgado

Rajesh Yalamanchili

Swati Yenneti

Sujatha Kestur

Gowri Dhandayudhapani

Embodiments are disclosed for improved data modeling in a relational database management system. In the context of a method, an example embodiment includes ingesting, by data ingestion circuitry and using a set of standardized plumbing fields comprising descriptive fields including at least a stage table primary key field, a source primary key field, and a source attribute field, one or more records into one or more stage tables in a staging layer. This example embodiment further includes generating, by data modeling circuitry and using the one or more stage tables in the staging layer, a data integration layer for modeling data represented by the data ingested into the one or more stage tables in the staging layer. Corresponding apparatuses and computer program products are also provided.

Methods and apparatuses for improved data ingestion using standardized plumbing fields

Embodiments are disclosed for automated performance tuning of a data modeling platform. An example method includes ingesting, using a tuning template, a set of records from one or more data sources into one or more stage tables in a staging layer of the data modeling platform. This example method further includes generating, using the one or more stage tables, a data integration layer of the data modeling platform for modeling data represented by the set of records ingested into the one or more stage tables. This example method further includes estimating an anticipated performance of the data modeling platform and generating an optimized tuning template based on the estimated anticipated performance. Finally, this example method further includes automatically executing a performance tuning operation on the data modeling platform. Corresponding apparatuses and computer program products are also provided.

Methods and apparatuses for automated performance tuning of a data modeling platform

Embodiments are disclosed for improved data modeling in a relational database management system. In the context of a method, an example embodiment includes ingesting, by data ingestion circuitry, one or more records into one or more stage tables in a staging layer. This example embodiment further includes generating, by data modeling circuitry, a data alignment table defining a unique set of data fields, and generating, by the data modeling circuitry and using the one or more stage tables and the data alignment table, a key mapping table identifying correspondences between data fields in the one or more stage tables and data fields in the data alignment table. Corresponding apparatuses and computer program products are also provided.

Methods and apparatuses for improved data modeling using a relational database management system

Embodiments are disclosed for utilizing an efficient database architecture while facilitating query flexibility. An example method includes generating, by data modeling circuitry of a database system, a database comprising a set of dimension tables and a hybrid fact table, wherein each hybrid fact table record identifies corresponding records in the set of dimension tables that specify (i) current values of the one or more attributes corresponding to the hybrid fact table record and (ii) records comprising historical values of the one or more attributes corresponding to the hybrid fact table record that were current at the time of creation of the hybrid fact table record. The example method further includes receiving a query, and generating and transmitting a response to the received query. Corresponding apparatuses and computer program products are also provided.

Growing community of inventors

Montgomery, TX, United States of America

Keith Hoyle