Data Warehousing Support
Relational databases that support data warehousing are optimized to support decision support applications in all the forms listed below and more.
The data in the warehouse is stored in the form of multiple normalized tables that model your enterprise. The decision support applications that explore these data often perform full file scans of multiple large tables, making them processing intensive. Because processing time is directly related to data volume, the responsiveness of the system is heavily affected by the size of the underlying database.