The streaming queries and flash back queries techology is at least 10 years old: https://docs.oracle.com/en/database/oracle/oracle-database/1...
As far as I remember oracle 10 introduced that. In Oracle 11 it actually started working good.
Re:The Query Your Database Can’t Answer
by clusterhacks on Friday June 04, 2021 @12:46PM
(#27395558)
Aurora was developed in 2002 so pushing 20 years (publications at http://cs.brown.edu/research/aurora/).
Re:The Query Your Database Can’t Answer
by sam_lowry_ on Friday June 04, 2021 @01:49PM
(#27396490)
I used Lucene percolator queries 8 years ago, and it probably wasn't that new at that time.
Some years ago, Microsoft was working on that. The idea was that you'd submit a query, and when the results of it changed, you'd get a notification. The goal was to have a large system where millions of such outstanding queries could be pending.
What this really means is a database of queries, which is queried when there's a data update to see who needs to be informed.
Anyone know how that Microsoft project came out?