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

    Tuesday, February 10th, 2009

    Leena Rao currently works as a writer for TechCrunch. She recently finished graduate school at the Medill School of Journalism at Northwestern University, where she studied business journalism and videography. From 2004 to 2007, she helped lead Congresswoman Carloyn Maloney’s community outreach and relations efforts in New York City. She graduated from Columbia University in 2003, where she was... → Learn More

    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.

    Sponsored Ads

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

    1. Milo says:

      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.

    2. Mark says:

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

    3. 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.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Connecting to %s

    Sponsored Ads

    Sponsored Ads

    Upcoming Events

    E3 2012

    Los Angeles, CA

    Disrupt SF 2012

    San Francisco, CA