Project StreamSQL Extends Familiar SQL-Based Gold Standard To Fuel Broad
Adoption Of Complex Event Processing (CEP) Applications
StreamBase Systems, Inc., provider of the industryâs fastest and most powerful real-time and historical complex event processing software, today announced the launch of Project StreamSQL, a broad industry initiative to catapult a SQL-based programming language as the standard for querying, processing, and analyzing streaming data. Created by experts from across the complex event processing community, the StreamSQL language enables enterprises to extend the familiar, easy-to-use SQL paradigm to real-time streaming data applications with a low-maintenance infrastructure that is flexible, scalable, and highly-available.
âThe rapid growth of the complex event processing marketplace suggests that the standardization of a programming language that processes and analyzes streams of real-time data would make sense,â said Philip Howard, Research Director at Bloor Research. âOne obvious approach to gaining greater interest in the CEP community would be standardization based on SQL Ã¢â¬â after all, it is widely used and popular. Acceptance of such a standard would facilitate adoption of CEP technology and enable enterprise developers familiar with current query languages to more easily build real-time streaming data applications.â
By applying âSQL on streamsâ, new, sophisticated real-time applications are being built to address a wide array of challenges in multiple industries. These applications include: financial transaction fraud detection and antimony laundering
compliance, monitoring Web-based adventure games to give players optimal gaming experiences, automated stock trading for increased investment profitability, clickstream and web site monitoring for optimizing real-time promotions and customer service, and much more.
âSQL has remained the most enduring standard querying language for stored data over three decades due to its combination of powerful data processing primitives, functionality, power, and relative ease-of-use,â said Dr. Mike Stonebraker, CTO and Founder of StreamBase. âYears of research and customer experience have
demonstrated that extending SQL to process streams is the right approach for real-time data.â Analysts estimate millions of relational database servers are running SQL today, with tens of thousands of SQL-skilled database programmers. In fact, many core principles for querying stored data can be applied to streaming data by
extending the existing familiar paradigm of SQL.
The specification for StreamSQL, which adds time or event-based windows to standard SQL, was created by a team representing the leading stream processing research programs in the United StatesÃ¢â¬âincluding data management experts from the Massachusetts Institute of Technology (MIT), and Brown, Brandeis, and Stanford Universities. Based on historical precedents in the computing industry, emergence of a standard programming language is expected to facilitate broad adoption of CEP technology and enable enterprise developers familiar with current query languages to more easily build real-time streaming data applications. In a manner similar to the widespread standardization of other programming languages including C++ (launched by AT&T) and Java (brought to the public domain by Sun Microsystems), StreamBase is playing a key role with other global systems software companies to commercialize a SQL-based standard for CEP. As part of StreamBaseâs commitment to drive this standardization and continue its efforts to offer the industryâs largest CEP developer community, Project StreamSQL includes a variety of initiatives:
Ã¢â¬Â¢ Developer CEP Resources Ã¢â¬â StreamBase has launched StreamSQL.org, which features a blog written by leading CEP technologists, along with programming resources, and soon-tolaunch forums and discussion groups. In addition, StreamBase has also created a Developer Zone, offering open access to the StreamBase Developer Edition software, which features StreamSQL, full documentation, and sample applications. And, to further evangelize the benefits of CEP, StreamBase launched the industryâs first developer contest, âThe Quest for the Da Vinci Coder,â with a current challenge to build the most creative and
impactful CEP application with StreamSQL. A grand prize of $10,000 will go to the best application.
Ã¢â¬Â¢ In-Depth SQL on Streams Workshops Ã¢â¬â To further infuse the adoption of a âSQL on streamsâ standard for CEP, StreamBase provides multi-city, instructor-led training called the âInside StreamSQL Workshop.â This is an interactive, hands-on course for application developers to learn StreamSQL and build high-performance real-time applications. Typically, developers who are familiar with SQL learn StreamSQL within four to six hours. Current workshops are scheduled for September 12th -13th and October 10th Ã¢â¬â 11th in New York City, and October 17th Ã¢â¬â 18th in Dulles, Virginia.
Ã¢â¬Â¢ Open-Community Training & Certification Ã¢â¬â Soon, developers will be able to achieve certification for StreamSQL to further validate their expertise in creating enterprise-class, real-time streaming data applications. In addition, StreamBase will also implement web-based training and StreamSQL workshops at various client and partner offices around the world to further increase adoption and support.
âIn 10 years, more applications will be built to leverage real-time data versus querying stored data Ã¢â¬â and a standard programming language to support this next-generation computing infrastructure is emerging now,â said Barry Morris, Chairman and CEO of StreamBase. âAs we continue to see an explosion around new business challenges that arise from managing real-time data, the right infrastructure to support these high-performance, high-volume applications will fuel the widespread market growth of complex event processing. StreamSQL will
be the ubiquitous programming language for building these real-time streaming data applications, making StreamBase Ã¢â¬Ëthe Oracle of streaming data.ââ