Question: what are the main differences between an operational database and data warehouse?
Answer: Operational systems are designed to support high-volume transaction processing. Data warehousing systems are typically designed to support high-volume analytical processing (i.e., OLAP). Operational systems are usually concerned with current data. Data warehousing systems are usually concerned with historical data.