StreamSQL
Jump to navigation
Jump to search
A StreamSQL is a stream data query language that is a SQL language.
- See: MiFID, SQL, Data Stream, Storm SQL, Monotonic, Apache Calcite.
References
2018
- (Wikipedia, 2018) ⇒ https://en.wikipedia.org/wiki/StreamSQL Retrieved:2018-2-1.
- 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). 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 monotonic. 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 algorithmic trading, market data analytics, network monitoring, surveillance, e-fraud detection and prevention, clickstream analytics and real-time compliance (anti-money laundering, RegNMS, MiFID).
New Generation of Stream Processing Engines has added support for Stream SQL (a.k.a. Streaming SQL). Among the examples are Kafka KSQL, WSO2 Stream Processor, SQLStreams, [SamzaSQL http://ieeexplore.ieee.org/document/7530060/], and Storm SQL.
- 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). 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 monotonic. Queries over streams are generally "continuous", executing for long periods of time and returning incremental results.