Datawarehouse is used to store?
-
historical data
-
operational data
-
both
-
none
Data warehouses are specifically designed to store historical data for long-term trend analysis and decision-making. They are optimized for read-heavy analytical queries, not the frequent read-write operations of operational databases. Operational data is stored in OLTP systems, while data warehouses archive the historical snapshots.
A data warehouse is used to store historical data — large volumes of integrated, time-variant data collected from multiple operational systems over time, used for reporting, trend analysis, and business intelligence rather than day-to-day transaction processing. Current/operational (transactional) data is instead handled by OLTP systems and operational databases, which are optimized for fast reads/writes of current records rather than long-term analytical storage. So "historical data" correctly distinguishes a data warehouse's purpose from an operational database's.