Data warehousing is a technology that aggregates structured data from one or more sources so that it can be compared and analyzed for greater business intelligence.

What do I need to know about data warehousing?

Data warehouses are typically used to correlate broad business data to provide greater executive insight into corporate performance.

What are data warehouses used for?

Many types of business data are analyzed via data warehouses. The need for a data warehouse often becomes evident when analytic requirements run afoul of the ongoing performance of operational databases. Running a complex query on a database requires the database to enter a temporary fixed state. This is often untenable for transactional databases. A data warehouse is employed to do the analytic work, leaving the transactional database free to focus on transactions.

The other benefits of a data warehouse are the ability to analyze data from multiple sources and to negotiate differences in storage schema using the ETL process.

Learn more about the benefits of a data warehouse.

Related Products & Solutions

Data Integration

Data integration tools and solutions can help you bring your disparate data together with a unified view for better analysis and business insights.

Analytics, AI & Data Warehouse and Lake

Discover the value of a cloud analytics platform that delivers automated, intelligent, cloud-native data integration, data quality, and metadata management.