Abstract: A facility for efficiently storing and querying snapshot measures from a relational data warehouse is provided. The facility allows for the efficient query of measures at any given point in time by efficiently modeling snapshot measures. In one technique, the facility stores periodic snapshots of a metric at longer time intervals, and computes intermediate snapshots of the metric as necessary in between these time intervals. Under this technique, the facility can compute an intermediate snapshot measure of a metric for any specified time by determining the last snapshot measure of the metric from the most recent periodic snapshot, and adding to the last snapshot measure the value of the changes to the metric that happened since the time of the most recent periodic snapshot and the specified time.