Skip navigation links

MySQL Forums :: Data Warehouse :: MySQL in the BI/DW space


Advanced Search

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
MySQL in the BI/DW space 4038 Peter Nolan 05/20/2005 11:17AM
Re: MySQL in the BI/DW space 3704 Harrison Fisk 05/20/2005 07:12PM
Re: MySQL in the BI/DW space 3667 Peter Nolan 05/23/2005 03:58AM
Re: MySQL in the BI/DW space 2627 Edwin DeSouza 05/23/2005 06:40PM
Re: MySQL in the BI/DW space 2670 Peter Nolan 05/24/2005 02:44AM
Re: MySQL in the BI/DW space 2554 Edwin DeSouza 05/23/2005 06:42PM
Re: MySQL in the BI/DW space 2673 Harrison Fisk 05/24/2005 06:31PM
Re: MySQL in the BI/DW space 2581 Peter Nolan 05/25/2005 01:40AM
Re: MySQL in the BI/DW space 2614 Harrison Fisk 05/25/2005 01:26PM
Re: MySQL in the BI/DW space 2486 Peter Nolan 05/28/2005 04:16AM
Re: MySQL in the BI/DW space 3879 BI Explorer 11/13/2005 01:04PM
Re: MySQL in the BI/DW space 2600 mark 01/12/2006 12:09AM
Re: MySQL in the BI/DW space 2669 Mark Callaghan 06/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.