Hybrid Push/Pull Execution of Continuous SQL Queries
AssigneeInternational Business Machines Corporation
InventorsGeorge Andrei Mihaila, Ioana Roxana Stanoi
Life of this patent
Estimating the term…
Abstract
Illustrative embodiments provide a computer-implemented method for hybrid push/pull of continuous structured query language queries. The computer-implemented method receives stream input, wherein the stream input comprises events of interest, builds and a state machine and stream plans, based on an original query, and replicates the stream input. Responsive to a push sub-query trigger, the computer-implemented method submits a pull sub-query to the database to produce a result, and sends the result to a requester.
Claims20
A computer-implemented method for hybrid push/pull of continuous structured query language queries, the computer-implemented method comprising:
- receiving stream input, wherein the stream input comprises events of interest;
- building stream plans based on an original query and a state machine;
- replicating the stream input;
- responsive to a push sub-query trigger, submitting a pull sub-query to a database to produce a result;
- and
- sending the result to a requester.
A data processing system for hybrid push/pull of continuous structured query language queries, the data processing system comprising:
- a bus;
- a memory connected to the bus, wherein the memory comprises computer executable instructions;
- a communication unit connected to the bus;
- a database connected to the bus;
- a processor unit connected to the bus, wherein the processor unit executes the computer executable instructions to direct the data processing system to:
- receive stream input, wherein the stream input contains events of interest;
- build stream plans based on an original query and a state machine;
- replicate the stream input;
- responsive to a push sub-query trigger, submit a pull sub-query to the database to produce a result;
- and
- send the result to a requester.
A computer-program product for hybrid push/pull of continuous structured query language queries, the computer program product comprising:
- a computer usable medium having computer executable instructions stored thereon, the computer executable instructions comprising:
- computer executable instructions for receiving stream input, wherein the stream input comprises events of interest;
- computer executable instructions for building stream plans based on an original query and a state machine;
- computer executable instructions for replicating the stream input;
- computer executable instructions responsive to a push sub-query trigger, for submitting a pull sub-query to a database to produce a result;
- and
- computer executable instructions for sending the result to a requester.
Dependencies are inferred from the claim text.