Hi Experts,



My system stores events into a large table.  I would like to apply some
rules on that table and possibly take action if the rules were satisfied.
For example if a certain event arrives 2 times in 60 seconds then perform an
action.  What is the best way to apply rules to data in the database?  If it
cannot be done with the database itself a recommendation of a third party
tool will be great.  However please not that I cannot use any GUI.  I need
to declare the rules and get the result of the rule into my application
which can be in C++ or C#



Thanks for all the help,

Avi

Have you looked at streaming databases?  Google up BitStream.

You could use triggers in SQL but if you need to invoke external code
against the database then it's better to put this in a middle-tier
application. In your middle-tier code, poll the table regularly for the
changes based on a date-time stamp column.

Sorry for the dumb question, but...
Small letter and numeric number in Tabel field
Grouping Data By Weeks
View of Joined Tables
No Cursor
replication with java
Distinct list
If Update AND If Delete sections in one trigger?
Find Like Records with similar field data
need help to excute bcp statement