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

Advanced Search

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

Subject Views Written By Posted
MySQL in the BI/DW space 4430 Peter Nolan 05/20/2005 11:17AM
Re: MySQL in the BI/DW space 4016 Harrison Fisk 05/20/2005 07:12PM
Re: MySQL in the BI/DW space 3921 Peter Nolan 05/23/2005 03:58AM
Re: MySQL in the BI/DW space 2924 Edwin DeSouza 05/23/2005 06:40PM
Re: MySQL in the BI/DW space 3010 Peter Nolan 05/24/2005 02:44AM
Re: MySQL in the BI/DW space 2819 Edwin DeSouza 05/23/2005 06:42PM
Re: MySQL in the BI/DW space 2935 Harrison Fisk 05/24/2005 06:31PM
Re: MySQL in the BI/DW space 2787 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 2907 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.