MySQL Forums
Forum List  »  Data Warehouse

Re: MySQL in the BI/DW space
Posted by: Harrison Fisk
Date: May 20, 2005 07:12PM

Hi,

MySQL is definitely starting to grow quite a bit in the DW/BI market. It does have some presence already, but I suspect it will continue to grow in the future as well. An example of an existing DW is Cox Communications, read http://www.mysql.com/it-resources/case-studies/mysql-cox-casestudy.pdf for more info. MySQL AB actually offers a training course designed about DW aspects now as well.

One thing that has been an issue, and finally is starting to fall into place, is external vendor support. Many people are very big on using the market leading tools for ETL, BI, etc... (of course with good reason). As more vendors, such as Business Objects and others, start supporting MySQL, you will see many more users for this reason.

MySQL does have some aspects which are very well suited to DW applications. One big thing is the MyISAM storage engine. This is a non-transactional storage type designed for data warehousing/heavy read/bulk loading type applications. It is extremely fast for loading in huge amounts of data and building large indexes. Also other things such as MERGE tables (similar to partitioning, since native partitioning won't be here till MySQL 5.1), work very well in DW applications.

As for the forum itself, it is quite new, having only been around for a few months. I'm sure that the number of posts will increase as word spreads about them.

As for features, what types of things would you like to see in a database for DW? Obviously MySQL doesn't have nearly the gigantic feature set as traditional vendors, such as Oracle or DB2, so I am curious what other specific things you are looking for in a DW database.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5214
May 20, 2005 11:17AM
Re: MySQL in the BI/DW space
4360
May 20, 2005 07:12PM
4651
May 23, 2005 03:58AM
3129
May 23, 2005 06:40PM
3264
May 24, 2005 02:44AM
2976
May 23, 2005 06:42PM
3177
May 24, 2005 06:31PM
3035
May 25, 2005 01:40AM
3155
May 25, 2005 01:26PM
2918
May 28, 2005 04:16AM
4437
November 13, 2005 01:04PM
3166
January 12, 2006 12:09AM
3128
June 29, 2006 11:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.