US 11,755,621 B2
Systems and methods for atomic publication of distributed writes to a distributed data warehouse
Benson Tucker, Pittsburgh, PA (US)
Assigned to ARGO AI, LLC, Pittsburgh, PA (US)
Filed by Argo AI, LLC, Pittsburgh, PA (US)
Filed on May 10, 2021, as Appl. No. 17/315,460.
Prior Publication US 2022/0358144 A1, Nov. 10, 2022
Int. Cl. G06F 16/28 (2019.01); G06F 16/2455 (2019.01); G06F 16/27 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/283 (2019.01) [G06F 16/219 (2019.01); G06F 16/2455 (2019.01); G06F 16/27 (2019.01)] 19 Claims
OG exemplary drawing
 
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.