Marion E Brown

US Patent:

20180253474, Sep 6, 2018

Filed:

Mar 1, 2017

Appl. No.:

15/447003

Inventors:

- San Francisco CA, US
Marion A. Brown - Spring TX, US
Swati Yenneti - Shenandoah TX, US
Sujatha Kestur - Tomball TX, US
Gowri Dhandayudhapani - Irving TX, US

International Classification:

G06F 17/30

Abstract:

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.

US Patent:

20170286468, Oct 5, 2017

Filed:

Mar 31, 2016

Appl. No.:

15/086266

Inventors:

- San Francisco CA, US
Manuel Salgado - Spring TX, US
Marion A. Brown - Spring TX, US
Rajesh Yalamanchili - Conroe TX, US

International Classification:

G06F 17/30

Abstract:

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.

US Patent:

20170286504, Oct 5, 2017

Filed:

Mar 31, 2016

Appl. No.:

15/086534

Inventors:

- San Francisco CA, US
Manuel Salgado - Spring TX, US
Marion A. Brown - Spring TX, US
Rajesh Yalamanchili - Conroe TX, US

International Classification:

G06F 17/30

Abstract:

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.