MySQL Forums
Forum List  »  Data Warehouse

Re: Which data warehouse for MySQL can run on Solaris 10?
Posted by: Rick James
Date: September 18, 2010 04:34PM

"Which data warehouse"? Data warehousing is a generic term for a style of database schema design. Every implementation is different.

MySQL is a moderately good basis for data wherehousing.

If you mean "Which ENGINE", then here are some criteria to consider:
InnoDB is the bulkiest (2x-3x bigger on disk than MyISAM), but recovers from crashes more gracefully.
MyISAM is basic, but adequate.
InfoBright (3rd party plugin) is a "column" database; excellent compression (10x smaller); excellent for ad hoc queries.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Which data warehouse for MySQL can run on Solaris 10?
2944
September 18, 2010 04:34PM


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.