April 20, 2009

Infobright update

For the past couple of quarters, Infobright has been MySQL’s partner of choice for larger data warehousing applications. Infobright’s stated business metrics, and I quote, include:

  • > 50 Customers in 7 Countries

  • > 25 Partners on 4 continents

  • A vibrant open source community

    • +1 million visitors

    • Approaching 10,000 downloads

    • 2,000 active community participants

These may be compared with analogous metrics Infobright offered in February.

Infobright has also made or promised a variety of technological enhancements. Ones that are either shipping now or promised soon include:

Infobright is also previewing what it calls SSA (Simplified Scalability Architecture), which it plans to ship late this year. The essence of Infobright SSA is scale-out beyond a single server. Data access will still be shared-everything. Infobright stresses that performance is generally not disk-bound and — which sounds odd — not affected by the size of the database. Hence it doesn’t see any reason for a shared-nothing configuration.

If ACID compliance is on the roadmap, I missed it. (Edit: See the comments below — Infobright now boasts ACID compliance.) I know of at least one case in which Sun/MySQL suggested using a combination of the Infobright and MyISAM engines for an update-heavy data warehousing environment, but that configuration isn’t going to give ACID compliance either.

Comments

6 Responses to “Infobright update”

  1. Calpont update — you read it here first! | DBMS2 -- DataBase Management System Services on April 20th, 2009 3:05 am

    [...] to offer a MySQL storage engine for analytic database processing. Thus, Calpont will compete with Infobright, Kickfire, and perhaps [...]

  2. MySQL storage engine round-up, with Oracle-related thoughts | DBMS2 -- DataBase Management System Services on April 20th, 2009 9:39 am

    [...] Infobright is the most established of the rest. At the moment I’m not recommending it for most industrial-strength uses unless the user is particularly cash-constrained. But I wouldn’t be surprised if that changed soon.  A cheap, fast, simple columnar analytic DBMS has a place in the world. [...]

  3. Victoria Eastwood on April 20th, 2009 3:11 pm

    Hi Curt,

    It was nice to talk with you last week. Our apologies for not updating you on ACID compliance. We have made a number of changes in this area and now pass ACID compliance, using the TPC-H tests as a guideline. As you suggest, we should have included that in the release and briefing.

    Regarding SQL 2003 standard support, MySQL supports very few of these newer additions including even some from SQL-99. We would need to extend MySQL ourselves to add support and we haven’t seen a market demand yet to schedule the extra work.

    Cheers

  4. Justin Swanhart on May 18th, 2009 2:24 pm

    ACID stands for:

    Atomicity
    Consistency
    Integrity
    Durability

    Please explain how Infobright accomplishes all of these tasks w/out any transactional logging that I’m aware of?

    For instance, how can they claim to support the ‘I’ in acid w/out supporting FOREIGN KEY CONSTRAINTS and UNIQUE KEY CONSTRAINTS, which form the basis of integrity checking?

    Since they don’t support the concept of transactions, how can I load into two tables atomically and ensure rows do not end up in either of the tables (ie, both loads are rolled back) if an error happens on either load? This is the ‘A’ in ACID.

    I imagine that the ‘C’ and ‘D’ portions are handled well, at least in the case of the database crashing while loading a single table, since a column store has an easily identified HWM (high water mark) for the columns. I’m not sure how they can guarantee this across multiple tables w/out transactional logging which I’m not aware of.

  5. Infobright metrics | DBMS2 -- DataBase Management System Services on July 8th, 2009 1:41 pm

    [...] posted about Infobright, and included some company-supplied metrics. Most looked familiar from a post I did in April, but Infobright’s latest figure for # of paying customers seems to be “>60″, [...]

  6. Calpont’s InfiniDB | DBMS2 -- DataBase Management System Services on November 7th, 2009 9:35 pm

    [...] One thing free InfiniDB has that Infobright only offers in its Enterprise Edition is ACID-compliant Insert/Update/Delete. (Note: I wish people would stop saying that Infobright Enterprise Edition isn’t ACID-compliant, since that point was cleared up a while ago.) [...]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.