Relational data stream management system

A relational data stream management system (RDSMS) is a distributed, in-memory data stream management system (DSMS) that is designed to use standards-compliant SQL queries to process unstructured and structured data streams in real-time.

Uses your system voice; voice and rate in settings.

Snapshot

≈ 2 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

A relational data stream management system (RDSMS) is a distributed, in-memory data stream management system (DSMS) that is designed to use standards-compliant SQL queries to process unstructured and structured data streams in real-time. Unlike SQL queries executed in a traditional RDBMS, which return a result and exit, SQL queries executed in a RDSMS do not exit, generating results continuously as new data become available.

Continuous SQL queries in a RDSMS use the SQL Window function to analyze, join and aggregate data streams over fixed or sliding windows. Windows can be specified as time-based or row-based.

SELECT STREAM FLOOR(WEATHERSTREAM.ROWTIME to SECOND) AS FLOOR_SECOND, MIN(TEMP) AS MIN_TEMP, MAX(TEMP) AS MAX_TEMP, AVG(TEMP) AS AVG_TEMP FROM WEATHERSTREAM GROUP BY FLOOR(WEATHERSTREAM.ROWTIME TO SECOND); RDSMS SQL queries also operate on data streams over time or row-based windows. The following example shows a second continuous SQL query using the WINDOW clause with a one-second duration.

The WINDOW clause changes the behavior of the query, to output a result for each new record as it arrives. Hence the output is a stream of incrementally updated results with zero result latency.

SELECT STREAM ROWTIME, MIN(TEMP) OVER W1 AS WMIN_TEMP, MAX(TEMP) OVER W1 AS WMAX_TEMP, AVG(TEMP) OVER W1 AS WAVG_TEMP FROM WEATHERSTREAM WINDOW W1 AS ( RANGE INTERVAL '1' SECOND PRECEDING ); IBM System S 1995 SQL Reunion: People, Projects, and Politics, by Paul McJones (ed.): transcript of a reunion meeting devoted to the personal history of relational databases, SQL System R.

Text derived from https://en.wikipedia.org/w/index.php?oldid=1025419070 under CC BY-SA 4.0; modifications have been made.

Provenance

snapshot enwiki-001025419070 · captured 2021-05-27 · not yet sealed in the ledger · verify the chain · version history

Cite this page as: encyclopegia.org, “Relational data stream management system”, snapshot enwiki-001025419070. https://encyclopegia.org/a/relational-data-stream-management-system

Sources cited in this revision

No external citation was extracted for this revision. That is a statement about the source, not a claim that none exists.