Re: Business Intelligence + mysql
Posted by: Rick James
Date: August 07, 2012 08:47PM

> network monitoring system
Does this imply millions of records per day? Of so, OLTP is not the right model -- Data Warehousing is more to the point.

In that case, I recommend "summary tables".

Would you like to show us your schema, and provide estimates of the number of rows for each table.

Again, if the tables are large, and you will need to purge "old" data, then consider PARTITIONing by day or week.

Options: ReplyQuote


Subject
Written By
Posted
August 07, 2012 12:50AM
Re: Business Intelligence + mysql
August 07, 2012 08:47PM


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.