A small discussion on why I used In-Memory Databases as the underlying Data tier for StreamCruncher - Marco's Blog.

SC 1.0.1 Beta is out! The first minor release after the One-Oh Beta release of StreamCruncher.

This release includes a demonstration of a Co-related Sub-Query with Partitions and pre-Filters - an interesting SLA failure alert. I was pleasantly surprised to see all 5 DBs support co-related Sub-Queries. Of course, I never really doublted Oracle TimesTen and MySQL.

Ah well, in the next few weeks I hope to get a few real world examples together and present it as an article, maybe. It's quite hard to make people understand the benefits of Event Processing. The whole concept is still mostly academic with a few companies making some very high-end Stacks. It's not widespread yet. "Yet" - the operative word.

Hello,
I'm pleased to announce the initial availability (1.0 Beta) of StreamCruncher - http://www.streamcruncher.com, a lightweight Event Processing Kernel.

It's a multi-threaded Java program that provides an extention to the SQL language with Event processing constructs. It supports Sliding Windows, Time based Windows, Partitions and Aggregates. It also provides a feature similar to Materialized Views. Joins and Sub- queries are also supported to allow Event Co-relation.

StreamCruncher requires a Database underneath, to do the heavy-lifting. Several Databases (5 DBs) are supported. In-Memory Databases like - MySQL with Memory/Heap Engine, Oracle TimesTen and H2 are favored. It also supports Derby and Firebird, although with slight modifications to the Page Cache and Disk Flush settings etc to make them run faster.

It is Free, with a commercial-friendly License.

I hope you'll give it a shot. I'd love to hear your feedback.

Mmmmmmmm...one full year. Weekends, weekdays, late nights, holidays - oh man! Why would anyone do it? Well, why do people spend hours and hours at the Gym, sculpting their bodies? Back breaking work, but the sense of accomplishment you get at the end of it is something one can only understand if one goes through it, first hand.