StreamSQL

StreamSQL is a query language that extends <a href="/facts/SQL/UjQLJcYm">SQL</a> with the ability to process real-time <a href="/facts/Data_stream/57yDhBCd">data streams</a>. SQL is primarily intended for manipulating <a href="/facts/Relation_(database)/Sj67AUyD">relations</a> (also known as tables), which are finite <a href="/facts/Multiset/bPFJGMDo">bags</a> of <a href="/facts/Tuple/BI1HIxL8">tuples</a> (rows). StreamSQL adds the ability to manipulate streams, which are infinite sequences of tuples that are not all available at the same time. Because streams are infinite, operations over streams must be <a href="/facts/Monotonic/MjQK0YL2">monotonic</a>. 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 <a href="/facts/Data_Stream_Management_System/F8tLdJEt">Data Stream Management System</a> (DSMS), for applications including market data analytics, <a href="/facts/Network_monitoring/dt0cvIqS">network monitoring</a>, surveillance, e-fraud detection and prevention, <a href="/facts/Clickstream/D9hs15tH">clickstream</a> analytics and real-time compliance (<a href="/facts/Anti-money_laundering/98Gw3mgx">anti-money laundering</a>, <a href="/facts/RegNMS/ku5DC4DJ">RegNMS</a>, <a href="/facts/MiFID/GxSK4P3v">MiFID</a>).
Other streaming and continuous variants of SQL include <a href="https://streamsql.io">StreamSQL.io</a>, <a href="https://www.confluent.io/blog/ksql-open-source-streaming-sql-for-apache-kafka/">Kafka KSQL</a>, <a href="https://eventador.io/blog/introducing-sqlstreambuilder/">SQLStreamBuilder</a>, <a href="https://wso2.com/analytics">WSO2 Stream Processor</a>, <a href="https://web.archive.org/web/20080218012118/http://www.sqlstream.com/">SQLStreams</a>[usurped], <a href="https://ieeexplore.ieee.org/document/7530060/">SamzaSQL</a>, and <a href="https://storm.apache.org/releases/2.1.0/storm-sql.html">Storm SQL</a>.

StreamSQL open-in-new

StreamSQL