CPC G06F 16/283 (2019.01) [G06F 16/219 (2019.01); G06F 16/2455 (2019.01); G06F 16/27 (2019.01)] | 19 Claims |
1. A method for retrieving and using data stored in a data warehouse, comprising:
receiving, at a computing device, a query for information directed to a plurality of fact tables, wherein each said fact table comprises sets of source data that are arranged so as to be respectively associated with a plurality of first publication identifiers, and the source data is associated with one or more unique resource names that are different than the plurality of first publication identifiers;
obtaining, by the computing device, second publication identifiers from a publication table in response to the query, wherein the publication table is separate from the plurality of fact tables and the second publication identifiers are arranged in the publication table so as to be respectively associated with the unique resource names and version values, wherein each said version value references a version of at least a portion of the source data at a respective last modified time; and
obtaining, by the computing device, at least one of the sets of source data from each said fact table of the plurality of fact tables that is associated with a first publication identifier of the plurality of first publication identifiers which matches one of the second publication identifiers.
|