×

Hybrid push/pull execution of continuous SQL queries

  • US 8,392,402 B2
  • Filed: 12/03/2008
  • Issued: 03/05/2013
  • Est. Priority Date: 12/03/2008
  • Status: Expired due to Fees
First Claim
Patent Images

1. 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 from the stream input and a state machine, wherein building stream plans comprises splitting the original query into a push sub-query and a pull sub-query, and wherein the pull sub-query represents a portion of the original query from the stream input and the push sub-query represents a remaining portion of the original query from the stream input;

    replicating the stream input, wherein replicating the stream input comprises copying the stream input to produce a set of input streams, wherein one of the set of input streams is directed to a database and one of the set of input streams is directed to the state machine;

    responsive to a push sub-query trigger, determining whether a pattern of the push sub-query matches an event in the one of the set of input streams directed to the state machine to form a pattern match and creating the push sub-query trigger in response to the pattern match, wherein the pattern match causes submitting of the pull sub-query to execute against accumulated data in the database to produce a result; and

    sending the result to a requestor.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×