Skip navigation links

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 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
MySQL in the BI/DW space 4016 Peter Nolan 05/20/2005 11:17AM
Re: MySQL in the BI/DW space 3688 Harrison Fisk 05/20/2005 07:12PM
Re: MySQL in the BI/DW space 3647 Peter Nolan 05/23/2005 03:58AM
Re: MySQL in the BI/DW space 2607 Edwin DeSouza 05/23/2005 06:40PM
Re: MySQL in the BI/DW space 2651 Peter Nolan 05/24/2005 02:44AM
Re: MySQL in the BI/DW space 2542 Edwin DeSouza 05/23/2005 06:42PM
Re: MySQL in the BI/DW space 2660 Harrison Fisk 05/24/2005 06:31PM
Re: MySQL in the BI/DW space 2568 Peter Nolan 05/25/2005 01:40AM
Re: MySQL in the BI/DW space 2593 Harrison Fisk 05/25/2005 01:26PM
Re: MySQL in the BI/DW space 2477 Peter Nolan 05/28/2005 04:16AM
Re: MySQL in the BI/DW space 3865 BI Explorer 11/13/2005 01:04PM
Re: MySQL in the BI/DW space 2587 mark 01/12/2006 12:09AM
Re: MySQL in the BI/DW space 2657 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.