Streaming SQL & CEP

The most full-featured stream processing systems integrate database functionality by integrating streaming operations with the SQL programming language. One example of this is via a language called StreamSQL. StreamSQL (and other SQL derivatives) allow users to mix access to the non-persistent stream with access to the stored database which, by the way, can be massive. They also extend the SQL DML to allow updates to stored tables from tuples that appear on a stream. Thus, any part of the stream can be stored for further use. Here is a very simple example of how that might work.

INSERT INTO IBMTicks (Symbol, Date, Price)
SELECT Symbol, Date, Price FROM Ticks
WHERE Symbol = "IBM"

This query is registered with the system and operates continuously. It stores any new IBM tick that appears on the stream called Ticks into the table called IBMTicks.

Next page: CEP Clouds

 « Previous 1 | 2 | 3 | 4 | 5 | 6 ] 7  Next »