MySQL Forums
Forum List  »  Data Warehouse

Re: MySQL in the BI/DW space
Posted by: Peter Nolan
Date: May 24, 2005 02:44AM

Hi Edwin,
as I mentioned, we are just looking into supporting MySQL with our ETL software.....it looks promising as the references seem to be in the types of companies we have as clients. The USD100M-500M revenue range.

Most of our clients are SQL Server, a few are Oracle. Mostly they buy our software because it does what they need at 5% of the price of a vendor ETL tool......it's a compelling arguement.. :-) Mostly they are 'software price sensitive'.

With the price of SQL Server being lifted a while back we've had a few clients ask us about MySQL.

You know how it is. The next upgrade comes along for growing processing and the cost of extra CPU licences are starting to look 'expensive'. Price sensitive clients start 'looking around' and they always find MySQL.

When our clients ask us about MySQL our position has been 'not supported'.

So, I can't say that I have a case at hand that requires partitioning.

However, I have implemented many, many large ODSs and DWs and we always partition the data one way or another. My largest to date has been for a client with 18M customers catching records at a rate of 120M a day. I first built 'partitioned' DW models in 1991 in DB2/MVS.

In dimensional models we always partition the fact tables over time. It's just necessary when dealing with large volumes of data. Whether it is implemented at the database level or not, it still needs to be done. The only major BI database I know that does not need partitioning is Sybase IQ.

I guess it helps you to know that if MySQL is going to play in the larger DW space it will either need to support partitioning or do something radically different like the Sybase IQ 'IQ Store'...

Best Regards
Peter Nolan
www.peternolan.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5214
May 20, 2005 11:17AM
4361
May 20, 2005 07:12PM
4652
May 23, 2005 03:58AM
3130
May 23, 2005 06:40PM
Re: MySQL in the BI/DW space
3264
May 24, 2005 02:44AM
2977
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.