Even the SQLstream interface is standards compliant, having been written as a plug-in to the Eclipse IDE, the de facto standard Integrated Development Environment for enterprise software.
SQLstream is designed to appear familiar to those who already possess some SQL skills. SQLstream allows browsing through relational schemas, which provide a natural way of partitioning a name space of streams and their related metadata. SQLstream also supports standards-based hierarchical navigation of nested elements such as:
- Foreign data (per SQL:2003 standard)
- Streams
- Tables
- User-defined functions (to extend SQL and allow custom procedural logic)
- Data sources
- Data sinks
SQLstream allows the user to make changes 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 components of windows in Eclipse, along with the corresponding definitional and other metadata of the streams.
SQLstream's editor is syntax-directed: it highlights SQL keywords and supports integrated SQL validation. This validation helps flag SQL semantics errors at definition time, avoiding time-consuming debugging later on at execution time. Thus, SQLstream users can quickly deploy ad-hoc queries, applications and mash-ups to address new business requirements.
At SQLstream, we keep it simple, enabling every organization to capitalize on real-time, operational intelligence.
Have questions about your current project? Click here to ask a SQLstream expert.