SQLstream s-Server uses relational streaming to enable efficient, continuous processing of real-time, dynamic data, while concurrently generating operational business intelligence from the flowing data streams. SQLstream s-Server offers massively scaleable stream processing, utilizing a distributed architecture that supports parallel stream processing.
SQLstream s-Studio is a standards compliant Eclipse module for stream monitoring, administration and an Integrated Development Environment for building streaming SQL applications. SQLstream s-Studio supports updates to live applications, adding new queries as needed or changing existing queries or views. Messages that correspond to selected streams, or to queries over streams, can be browsed in real-time through multiple tabbed windows. SQLstream s-Studio is supported on both Linux and Windows environments.
SQLstream s-Server includes a comprehensive set of adapters, drivers and plug-ins. Our objective is to give customers the very best “out of the box” experience while reducing integration costs to a minimum. SQLstream adapters generate new input data streams from external data sources, new output data streams from internal data sources and transform streams using non-SQL programming modules and logic. Adapters are packaged as plug-ins that can be dynamically loaded and extended.
A streaming SQL query is a continuous, standing query that executes over streaming data. Data streams are processed using familiar SQL relational operators augmented to handle time sensitive data. Streaming queries are similar to database queries in how they analyze data; they differ by operating continuously on data as they arrive and by updating results in real-time. Streaming queries can also be event-driven and can aggregate over rolling or periodic time windows. Streaming SQL queries process dynamic, flowing data, in contrast to traditional RDBMSs, which process static, stored data with repeated single-shot queries.