StreamSQL is a query language that extends SQL with the ability to process real-time data streams.
SQL is primarily intended for manipulating relations (also known as tables), which are finite bags of tuples (rows).
Queries over streams are generally "continuous", executing for long periods of time and returning incremental results.
The StreamSQL language is typically used in the context of a Data Stream Management System (DSMS), for applications including market data analytics, network monitoring, surveillance, e-fraud detection and prevention, clickstream analytics and real-time compliance (anti-money laundering, RegNMS, MiFID).
Led by Michael Stonebraker, a team of 30 professors and students on project Aurora worked collaboratively from 2001 through 2003 to develop the core principles behind StreamSQL.