JOIN OPERATIONS FOR CONTINUOUS QUERIES OVER ARCHIVED VIEWS
First Claim
1. A computer-implemented method, comprising:
- receiving, by a computer system configured to execute computer-executable instructions, a continuous query, a continuous query, the continuous query being identified based at least in part on an archived view;
creating the archived view, the archived view being 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;
generating a query plan for the continuous query;
identifying a join operator in the query plan, the join operator being identified based at least in part on the dimension relation;
initializing a state of an operator corresponding to the dimension relation;
identifying if the state of the operator identifies an event that detects a change to the dimension relation; and
re-starting the continuous query based at least in part on the event that detects the change to the dimension relation.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
114 Citations
20 Claims
-
1. A computer-implemented method, comprising:
-
receiving, by a computer system configured to execute computer-executable instructions, a continuous query, a continuous query, the continuous query being identified based at least in part on an archived view; creating the archived view, the archived view being 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; generating a query plan for the continuous query; identifying a join operator in the query plan, the join operator being identified based at least in part on the dimension relation; initializing a state of an operator corresponding to the dimension relation; identifying if the state of the operator identifies an event that detects a change to the dimension relation; and re-starting the continuous query based at least in part on the event that detects the change to the dimension relation. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer-readable storage medium storing computer-executable instructions that, when executed by one or more computer systems, configure the one or more computer systems to perform at least:
-
instructions that cause the one or more processors to create an archived view, the archived view being 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; instructions that cause the one or more processors to identify a join operator in the join query defining the archived view, the join operator being identified based at least in part on the dimension relation; instructions that cause the one or more processors to initialize a state of an operator corresponding to the dimension relation; instructions that cause the one or more processors to identify if the state of the operator identifies an event that detects a change to the dimension relation; and instructions that cause the one or more processors to re-start the continuous query based at least in part on the event that detects the change to the dimension relation. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15)
-
-
16. A system, comprising:
-
a memory storing a plurality of instructions; and a processor configured to access the memory, wherein the processor is further configured to execute the plurality of instructions to at least; receive a continuous query, the continuous query being identified based at least in part on the archived view; create the archived view, the archived view being 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; generate a query plan for the continuous query; identify a join operator in the query plan, the join operator being identified based at least in part on the dimension relation; initialize a state of an operator corresponding to the dimension relation; identify if the state of the operator identifies an event that detects a change to the dimension relation; and re-start the continuous query based at least in part on the event that detects the change to the dimension table. - View Dependent Claims (17, 18, 19, 20)
-
Specification