On November 19th, the Los Angeles MySQL Meetup Group will meet for the first time. Infobright will be presenting their approach to analytic data warehousing. If you’re in the El Segundo area, please do join us.

Open-Xchange raises Series B funding. The FSF enables Wikimedia’s potential move to the Creative Commons Attribution-ShareAlike 3.0 license. The “Bilski” decision and software patents. Mindtouch reports revenue growth. And more.

Press releases
Open-Xchange Closes Series B Venture Funding of $9 Million Open-Xchange

OASIS Members Form Committee to Advance Interoperability and Conformance of OpenDocument Format (ODF) Applications OASIS

FSF Releases New Version of GNU Free Documentation License Free Software Foundation

Federal Court Issues “Bilski” Decision Software Freedom …

Yesterday, we concluded our third annual “MySQL Kundenkonferenz” in Munich. We had a record number [1] of participants, 255 on the re-count including hosts. I had the pleasure to deliver the welcome speech and to moderate the event. Personally, I thoroughly enjoyed the day and it was my distinct impression that the expectations of the participants were more than met.

The external setting of the conference was Hilton Munich City on Rosenheimerstraße, close to Munich’s culture centre Gasteig — and just one S-Bahn stop away from home for me. Excellent facilities.

The start was delayed slightly due to our high-latency registration process, which prompts us to go …

First, a retraction, it turns out that the performance problem with datatimes in the previous article wasn’t due to high cardinality (I speculated too much here), but due to a type conversion issue.  From a helpful comment from Victoria Eastwood of Infobright (a good sign for a startup), the Infobright engine considered ‘2001-01-01’ to be a date, not a datetime, and it couldn’t do a conversion to a datetime.  Instead it pushed the date filtering logic from the Infobright engine to MySQL.  Effectively, the slow queries were a table scan.   The solution is to add the 00:00:00 to the dates to make them datetimes.  

With that in mind, here are some much better numbers for Infobright.   For Infobright this query took 0.05 seconds. 

1) Select sum(unit) from Sale where purchaseDate >= '2001-04-01 00:00:00' and purchaseDate < '2001-05-01 00:00:00'

This compares very …

Last week, Infobright announced it had open sourced its data warehousing software code. This is good news for the growing number of organizations looking to use MySQL as a data warehousing platform. According to IDC, MySQL is already the third-most deployed database for data warehousing and Infobright’s move will give users yet another reason to seriously consider MySQL for this application.

For those of you not familiar with the Infobright offering, it is essentially a column-oriented data store for data warehousing. While the column-oriented approach is not exclusive to Infobright (Kickfire’s MySQL storage engine is also column-oriented, as are some other non-MySQL data warehousing solutions on the market) Infobright does have some unique technology that Lou Agosta recently described as follows in his post on Trends in Data Warehousing for the Second Half of 2008: …

With open source software I can install reasonably complete software and try it with my data. This way I get to see how it works in a realistic setting without having to rely on benchmarks and hoping they are a good match for my environment. And I get to do this without having to deal with commercial software sales people.

So I glad to hear the Infobright had gone open source as I have been wanting test a column based database for a while. I was even happier that it was a MySQL based engine as I would already know many of the commands. I decided to run some of the same tests I had run when comparing InnoDB and MyISAM for reporting (http://dbscience.blogspot.com/2008/08/innodb-suitability-for-reporting.html ).  InnoDB performed better than MyISAM in my reporting tests so I’m going to compare Infobright to InnoDB.

The …

I've mentioned Infobright before as an interesting solution to getting more performance to BI analytics solutions. Today's news are interesting: Sun invests in the company, and the baseline product is open sourced. Too busy to write more about it today, but I'm certainly watching this one closely.

Until this week Infobright’s claim to open source fame was its partnership with MySQL that enabled its analytical data warehousing software to act as a storage engine for the open source database.

However, the company is now taking the open source route itself by releasing the code behind its Infobright data warehouse (formerly Brighthouse) as Infobright Community Edition.

Earlier this month the company announced that it was moving to a subscription model for the commercial version of the product, Infobright Enterprise Edition, which comes with “enhanced features, services and support, warranty” amongst other things.

The company has also announced a $10m Series C investment …

Last week saw MySQL User Conference 2008 in Santa Clara, but I was not able to make time for it this year either. However, in the wake of Sun's acquisition of MySQL, it was very interesting to follow what was going on. A few things that caught my attention:

MySQL 5.1 is nearing General Availability and an interesting storage engine plugin ecosystem starts to emerge. It's this latter, but related event that I see as the first real sign of validation for MySQL's long-ago chosen path of pluggable storage systems instead of focused effort on making one good general-use engine.

Oracle/Innobase announced InnoDB Plugin for MySQL 5.1, which much-awaited features which promise a great deal of help for daily management headaches. More than that, InnoDB Plugin's release under …

I’ll be following closely the progression of Storage Engines available in the MySQL Database server, well soon to be available when 5.1 gets to GA (hopefully by end of Q2 which is what we have been told). Tick, Tick, time is running out.

PrimeBase XT (PBXT) and Blob Streaming is obviously my clear focus, actually now working for PrimeBase Technologies, the company which I want to note for people is an Open Source company, committed at providing an open source alternative to the other commercial players. You also have at the MySQL Conference talks on the the existing InnoDB from Innobase (a subsidiary of market RDBMS leader Oracle). There is a …