MySQL Forums
Forum List  »  Data Warehouse

Re: MySQL data warehouse? Newbie
Posted by: Rick James
Date: July 03, 2010 09:15PM

"real-time synchronization between the data warehouse and the operational MySQL DB" -- Eh? What does this mean?

InfoBright is a good option for ad hoc, multi-dimensional queries. I don't understand the "synchronize" issue.

The other thing that can save the day is manually building "summary tables", then doing the queries against it.

It is rare for a data warehouse to really need the data in the Fact table. BI usually only needs to work with summaries.

With 5 dimensions, it might be good to have several summary tables.

SHOW CREATE TABLE, plus show us some of the SELECTs, and the queries that "synchronize" the databases. Something concrete may be a better way to discuss this task.

What language(s) are you willing to code in? You will probably have to write code, not just expect something off-the-shelf to do all the work. Perl is a good candidate.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL data warehouse? Newbie
4600
July 03, 2010 09:15PM
4842
August 30, 2010 04:56AM


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.