is it possible to persist incoming events?

[Ron]

Hi,

Since streamcruncher has an underlying database, is it possible to
have the events that are processed be permenantly stored into the db?
Also, if there was data in the db, could it be queried concurrently
with incoming events? In other words could one query reference
incoming events, and stored events too?

Regards,

Ron

[Ashwin]

Hi Ron, Events aren't always put into the Database. StreamCruncher
puts Events into the Database only when there is a join across another
Event Stream or a regular Database Table (Master/Reference data
examples). Even so, such Events remain in the DB Tables as long as
they remain in the Windows. And, these tables are dynamically created,
with strange looking names. They are not meant to be used by anyone
other than the Kernel. In most cases, Events don't go through the DB
to reduce latency.

So, to answer your question, no Events are not "persisted" in the DB.
They have to be stored manually by the user.

Queries can refer to regular Database Tables and perform lookups/joins
with them. Look for the "Restock alert" example for details.

I hope I've answered your questions.

Ashwin.