Join operations for continuous queries over archived views

摘要

A continuous query may be received, the continuous query being identified based at least in part on an archived view. The archived view may be created and/or identified based at least in part on a join query related to two or more archived relations associated with an application, at least one of the two or more archived relations being identified as a dimension relation. A query plan for the continuous query may be generated. A join operator in the query plan may be identified based at least in part on the dimension relation. A state of an operator corresponding to the dimension relation may be initialized. It may be identified if the state of the operator identifies an event that detects a change to the dimension relation. The continuous query may be re-started based at least in part on the event that detects the change to the dimension relation.

主权项

1. A computer-implemented method, comprising:
receiving, by a computer system configured to execute computer-executable instructions, a continuous query, the continuous query identifying an archived view, the archived view identifying a join operation between a fact relation and a dimension relation; generating a query plan for the continuous query; initializing a state of an operator in the query plan corresponding to the dimension relation; identifying if the state of the operator identifies an event that detects a change to the dimension relation; re-starting the continuous query based at least in part on the event that detects the change to the dimension relation; identifying a view root operator in the archived view; constructing an archiver query for the operator, the operator topologically preceding the view root operator; executing the archiver query to obtain a result set of data records related to an application; and generating a snapshot output of one or more data values related to the application based at least in part on the result set of data records related to the application.