Although I’m very late in posting about our very first Los Angeles MySQL meetup with Carl Gelbart presenting the Infobright Storage Engine for MySQL, now that I have the blog up at WordPress, I wanted to at least mention it.
It was quite interesting to hear about this column-based storage engine. Essentially, each column is indexed which allows for very fast batch processing of massive datasets. This allows for speedy data mining.
There are statistics kept for each column which makes finding data fast in certain situations. I wish I had the slides or at least a link to them somewhere, but alas they don’t seem to be published.