MySQL Database Analytics with InfiniDB from Calpont - Part 2

Wednesday Oct 28th 2009 by DatabaseJournal.com Staff
Share:

Part 1 of this article took you through some of the reasons why a column-oriented database based on MySQL can be compelling. We also examined the architecture of InfiniDB, which is an open source analytic, reporting, and read-intensive database, and how its modular design helps you scale both up and out. Now let’s kick the tires of the database so you can see these things in action.

[From MySQL AB]

In Part 1 of this article, I took you through some of the reasons why a column-oriented database based on MySQL can be compelling. We also examined the architecture of InfiniDB, which is an open source analytic, reporting, and read-intensive database, and how its modular design helps you scale both up and out. Now let’s kick the tires of the database so you can see these things in action.

First, let’s load some data into a basic database to work with. The below load and query tests were run on a small 32-bit Fedora Core 6 machine with 2GB of RAM, and 4 CPU’s (2.40GHz with 512KB cache).

The article continues at http://dev.mysql.com/tech-resources/articles/mysql_datawarehouse_calpont2.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved