SQLstream's Live Data Integration Could Be A Boon For Businesses

Next Story

Visual Voicemail for BlackBerry is in the system

In the current state of the economy, the phrase “time is money” has taken on an even more powerful meaning to the enterprise world. SQLstream’s new 2.0 technology allows companies to reduce the time required to turn data into readable information by capturing and reading the data in live streams (using SQL language) versus batch-techniques of data processing, which is reading and interpreting in chunks after it hits databases.

Real-time analytics of data can be useful to enterprises and their consumer bases in a variety of ways. One example of where SQLStream’s technology could save businesses money and time is in cases of fraudulent purchases on credit or debit cards. If a bank receives real-time data indicating the fraudulent use of a consumer’s account, the bank can stop use of the account immediately (perhaps preventing additional fraudulent charges that the bank will have to incur the cost of), instead of having the data processed overnight and then taking action. In another example, an advertiser could see real-time clickstream data and possibly change advertisements based on popularity on certain websites. SQLstream’s software even is able to filter real time Twitter tweets (but according to SQLstream, Twitter currently only makes 20 tweets per minute public to vendors, accounting for roughly one to two percent of overall tweets).

For enterprises, the ability to be flexible in a dynamic and ever-changing business intelligence environment is an advantage. SQLstream, whose SaaS software is built on an open-source and open standard platform, hopes the use of standard and common SQL language in its software will help businesses and IT companies leverage its existing IT talent familiar with SQL.

But real-time data integration may have its drawbacks. Data quality produced in streams can be poor. With the batch integration techniques, there is time to cleanse and correct data before it is finally read and processed. And while immediate data streaming may be useful for some enterprises, not all businesses need real-time data integration or will be able to manage the constant stream of data.

Regardless of the disadvantages, big companies such as IBM and Oracle and small start-ups such as SQLstream are seeing the definite potential for real-time data integration technologies in the enterprise space.

  • http://www.techticles.com Milo

    What’s the value in this? So many products from Collaboration platforms, business intelligence, enterprise integration are deeply embedded in the enterprise already.

    When does using this technology fit? A whole lot of migration, learning curve, redirection. It’s going to be an uphill enterprise battle.

  • Mark

    Er, this is just Complex Event Programming. People like Streambase, Apama etc already offer a SQL-like language with time-based functions.

  • http://www.bandb.blogspot.com/ Richard Taylor

    There have been, and continue to be many start-ups in the space of streaming databases. An early one CeleQuest was bought Cognos a few years ago. iSpheres came and went. Still going are Coral8, Truviso and SQLstream. These are all Bay area start-ups that we have hosted at SDForum Business Intelligence SIG meetings. SQLstream stands out by making the broadest claims as to what a streaming database can do.

blog comments powered by Disqus