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

Options: ReplyQuote

Written By
May 20, 2005 11:17AM
May 20, 2005 07:12PM
May 23, 2005 03:58AM
May 23, 2005 06:40PM
Re: MySQL in the BI/DW space
May 24, 2005 02:44AM
May 23, 2005 06:42PM
May 24, 2005 06:31PM
May 25, 2005 01:40AM
May 25, 2005 01:26PM
May 28, 2005 04:16AM
November 13, 2005 01:04PM
January 12, 2006 12:09AM
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.