RE: [PHP-DB] Oracle -> MySQL Datawarehouse From: Andrew Hill (ahill <email protected>)
Date: 11/21/00

Hi Mark,

Try www.openlinksw.com/virtuoso

It's free for under 3 concurrent connections (which should be enough for the
db dump) works well with PHP, and we have several people using it with over
25gig stored.

Feel free to ask for any additional details off-list.

Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider

> -----Original Message-----
> From: Nold, Mark [mailto:Mark.Nold <email protected>]
> Sent: Monday, November 20, 2000 11:04 PM
> To: 'php-db <email protected>'
> Subject: [PHP-DB] Oracle -> MySQL Datawarehouse
>
>
> ------------------------------------------------------------------
> ----------
> -----------------
> Disclaimer: The information contained in this email is intended
> only for the
> use of the person(s) to whom it is addressed and may be confidential or
> contain legally privileged information. If you are not the intended
> recipient you are hereby notified that any perusal, use, distribution,
> copying or disclosure is strictly prohibited. If you have received this
> email in error please immediately advise us by return email at
> postmaster <email protected> and delete the email document without making a
> copy.
> ------------------------------------------------------------------
> ----------
> -----------------
> Hi people,
>
> We are think about using MySQL as a Datawarehouse for our Oracle DB.
>
> What we plan on doing is have a nightly job that updates tables in our DW.
>
> The production DB has 1000 tables and about 18Gb of data.
>
> The first step will be to simply duplicate the tables we plan on using on
> the DW box. Once this is finished we'll create some denormalised
> tables for
> easy joininig etc on the Dataware from the now refreshed tables
> or possibly
> core data.
>
> My questions are:
>
> 1. What is the most efficient way of getting the data from Oracle
> to MySQL?
> Dump whole tables then upload? Simply SELECT * FROM mytable and
> INSERT into
> the MySQL DB?
>
> 2. Can MySQL handle 6-9GB of Data?
>
> 3. Any ideas of the Oracle Data Dump file format? Maybe we could make a
> reader for this for the MySQL import...
>
> 4. Any similiar experiences?
>
>
> Thanks,
>
> mn
>
> Mark Nold
> markn <email protected>
> Senior Consultant
>
> Change is inevitable, except from vending machines.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>