Question: what are the differences between the three main types of data warehouse usage?
Answer: Operational databases support concurrent processing of multiple transactions. ... An operational database query allows to read and modify operations, while an OLAP query needs only read only access of stored data. An operational database maintains current data. On the other hand, a data warehouse maintains historical data.