I was lucky to learn from a failure of analytics (kind of reporting) feature which was built directly on operational database. My notes on this bliki: ReportingDatabaseA reporting database takes data from an operational database, reorganizing it to better support reporting.Martin Fowlermartinfowler.comSome