Methods and apparatuses for improved database design
AssigneeMcKesson Corporation
InventorsKeith Hoyle, Marion A. Brown, Swati Yenneti, Sujatha Kestur, Gowri Dhandayudhapani
Life of this patent
Estimating the term…
Loading patent…
AssigneeMcKesson Corporation
InventorsKeith Hoyle, Marion A. Brown, Swati Yenneti, Sujatha Kestur, Gowri Dhandayudhapani
Estimating the term…
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.
A method for utilizing an efficient database architecture while facilitating query flexibility, the method comprising:
A database system providing an efficient database architecture facilitating query flexibility, the database system comprising:
A computer program product comprising at least one non-transitory computer-readable storage medium for utilizing an efficient database architecture while facilitating query flexibility, the at least one non-transitory computer-readable storage medium storing computer-executable instructions that, when executed, cause an apparatus to:
Dependencies are inferred from the claim text.