McKesson Corporation
Methods and apparatuses for improved database design

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.