Infobright: We're the MySQL of open source data warehousing

April 20, 2009, 04:25 PM —  InfoWorld — 

Infobright on Monday unwrapped a new version of its open source data warehouse for analytics -- and shared its lofty expectations for the product.

"What MySQL did for databases, letting the low end of the market use a great database, we're concentrating on doing for data warehousing," said Susan Davis, Infobright's director of product management and marketing.

[ Microsoft recently released its first SQL Server '08 service pack. | Startup Kickfire this week shipped a MySQL-based appliance that delivers high-performance data warehousing out of the box. | InfoWorld's Test Center reviewed slacker databases that break all the old rules. ]

Indeed, a fistful of other upstart data warehouse providers, some open source but others proprietary, are stepping into the same space where the larger, relational database vendors have not yet fully tread.

Infobright's quest began in September o2008 when the company open-sourced its commercial column-oriented data warehouse. At the time it had eight customers but today has more than 50, including Royal Bank of Canada and Xerox, Davis added. Those customers reside largely in the telecom, mid-tier financial services, and marketing firm spaces. "We're really going into the area where MySQL is," Davis explained.

Infobright's software, in fact, is bundled with MySQL; Sun Microsystems, which owns MySQL, is an investor in Infobright. The latest version adds support for Sun's Solaris 10 operating system on x86 servers.

Version 3.1 also brings a new SQL framework now optimized for the company's knowledge grid, 100 new SQL commands, and a performance kick of 10 times for queries that rely on SQL functions, Davis said.

Victoria Eastwood, vice president of engineering at Infobright, explained that the column-oriented database is ripe for analytics because data gets collected into columns, then compressed. From there Infobright creates data packs and ultimately adds metadata about those data packs. "This gives us a map of the database," Eastwood added. "We have info on every column in there."

The software, available immediately, comes in two flavors: Infobright Community Edition (ICE) and Infobright Enterprise Edition (IEE). The former is a free download, while the latter carries a choice of annual support charges.

Sign up for ITworld's Daily newsletter
Follow ITworld on Twitter @IT_world

I like it!
Close

On Twitter now

open source

Powered by Twitter
You are logged in | Sign out
Sign in and post to Twitter

What are you thinking?

Cancel Tweet sent

On Twitter now

Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
peer-to-peer

jfruh
Apple syncing patent can't come soon enough

pasmith
New Twitter features borrow from 3rd party clients

Esther Schindler
Open Source Changes the Software Acquisition Process

mikelgan
How to set up continuous podcast play on the new iTunes

David Strom
Five important Windows 7 mobility features

sjvn
Guard your Wi-Fi for your own sake                        

Sandra Henry-Stocker
Grepping on Whole Words

 

Sidekick: The Good News & the Bad News
Either way you look at it Microsoft Data Center management did not follow standards or best practices in this failure. In which case it makes me wonder more about the outsourcing of corporate data much less personal data.
- mburton325

Join the conversation here

The Daily Tip

The Daily TipQuick, practical advice for IT pros. Made fresh daily.

Hot tips:

Want to cash in on your IT savvy? Send your tip to tips@itworld.com. If we post it, we'll send you a $25 Amazon e-gift card.

Newsletters

Subscribe to ITWORLD TODAY and receive the latest IT news and analysis.

I would like to receive offers via email from ITworld partners.
By clicking submit you agree to the terms and conditions outlined in ITworld's privacy policy.
Featured Sponsor

AISO founders envisioned a Web hosting company that was environmentally friendly. While the company employed energy-efficient innovations like solar panels, its infrastructure produced unacceptable power and cooling requirements. Find out how AISO leveraged AMD technology to overcome their challenge in this case study white paper.

In this whitepaper, Scalar explores the opportunity to change the landscape with respect to mission critical databases built around Oracle. Leveraging technologies such as Linux, high-end commodity processing power and Oracle RAC technology to architect, design, build and maintain database infrastructure that delivers maximum availability, reliability and performance at a fraction of traditional cost.

On a typical day, weather.com, the Web site for The Weather Channel in Atlanta, serves up between 15 million and 20 million page views. But in September 2004, when back-to-back hurricanes ransacked Florida, the peak traffic on one day more than tripled: over 70 million page views by more than 7 million unique visitors. Read the full success story now.

Marketplace