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


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 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

Options: ReplyQuote

Subject Views Written By Posted
MySQL in the BI/DW space 4433 Peter Nolan 05/20/2005 11:17AM
Re: MySQL in the BI/DW space 4017 Harrison Fisk 05/20/2005 07:12PM
Re: MySQL in the BI/DW space 3923 Peter Nolan 05/23/2005 03:58AM
Re: MySQL in the BI/DW space 2927 Edwin DeSouza 05/23/2005 06:40PM
Re: MySQL in the BI/DW space 3013 Peter Nolan 05/24/2005 02:44AM
Re: MySQL in the BI/DW space 2820 Edwin DeSouza 05/23/2005 06:42PM
Re: MySQL in the BI/DW space 2937 Harrison Fisk 05/24/2005 06:31PM
Re: MySQL in the BI/DW space 2789 Peter Nolan 05/25/2005 01:40AM
Re: MySQL in the BI/DW space 2922 Harrison Fisk 05/25/2005 01:26PM
Re: MySQL in the BI/DW space 2758 Peter Nolan 05/28/2005 04:16AM
Re: MySQL in the BI/DW space 4152 BI Explorer 11/13/2005 01:04PM
Re: MySQL in the BI/DW space 2881 mark 01/12/2006 12:09AM
Re: MySQL in the BI/DW space 2908 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.