Data warehousing
Data warehousing captures data from a variety of sources so it can be accessed and analyzed by business analysts, data scientists and other end users. One goal is to enhance data quality and consistency for analytics uses while improving business intelligence. Read how data warehousing provides these and other unique benefits to overall data management strategy.
Top Stories
-
News
20 Feb 2025
Cube semantic layer eases data access from Power BI, Excel
New integrations aim to better enable Microsoft users to directly access data in cloud data warehouses, which has been problematic given how different query languages interact. Continue Reading
-
News
06 Feb 2025
Databricks' acquisition of BladeBridge boosts data migration
The data and AI vendor's latest purchase adds AI-powered ETL capabilities aimed at making it easier for new customers to transport data from competing data storage platforms. Continue Reading
-
Answer
27 Oct 2017
Dimension tables vs. fact tables: What's the difference?
Fact tables and dimension tables are used together in star schemas to support data analytics applications. But they play different roles and hold different types of data. Continue Reading
-
Answer
17 May 2017
Operational data store vs. data warehouse: How do they differ?
Operational data stores and data warehouses both store operational data, but the similarities between them end there -- and they both have a role to play in analytics architectures. Continue Reading
-
Buyer's Guide
30 Mar 2016
A buyer's guide to selecting the best data warehouse product
With several deployment options and product choices, it's difficult to know where to start. This buyer's guide helps you choose the right data warehouse product for your company. Continue Reading
-
Feature
22 Mar 2016
Five factors to help select the right data warehouse product
How big is your company, and what resources does it have? What are your performance needs? Answering these questions and others can help you select the right data warehouse platform. Continue Reading
-
Feature
10 Mar 2016
A look inside the SAP IQ column-oriented database
The SAP IQ column-oriented database is designed for large data warehouses that require high scalability, rapid data loading and optimal query performance. Continue Reading
-
Feature
09 Mar 2016
Examining the Teradata Data Warehouse
With both relational and columnar options, the Teradata Active Enterprise Data Warehouse gives companies an efficient, scalable appliance they can deploy in-house or in the cloud. Continue Reading
-
Feature
24 Feb 2016
Evaluating the key features of data warehouse platforms
Choosing between the different types of data warehouse platforms can be simplified once you know which deployment option best meets your project requirements. Continue Reading
-
Feature
17 Feb 2016
What to expect from Oracle Exadata Database Machine
Oracle Exadata Database Machine combines hardware and software to enable analytics, batch, reporting and other tasks to run simultaneously within and across databases. Continue Reading
-
Feature
15 Feb 2016
Examining the IBM PureData System for Analytics appliance
Powered by Netezza technology, the IBM PureData System for Analytics data warehouse appliance enables users to execute complex queries and get results quickly. Continue Reading
-
Feature
16 Nov 2015
The benefits of deploying a data warehouse platform
Big data may be all the rage, but data warehouse platforms are still being utilized by companies of all sizes. Expert Craig S. Mullins takes a look at the technology. Continue Reading
-
Answer
11 Oct 2011
Key issues to consider when building a data warehouse
There are numerous issues, both technical and cultural, that organizations need to consider before building a data warehouse. Learn what they are from our data warehousing expert. Continue Reading
-
Answer
18 May 2011
Six tips for improving data warehouse performance
Get six expert tips for improving data warehouse performance. Learn how database engines, SSDs and MOLAP cubes can affect your data warehouse performance. Continue Reading
-
Feature
04 Feb 2010
Key benchmarks for measuring transaction processing performance
Find key benchmarks for measuring transaction processing performance at your company, and learn about XA two-phase commit and types of transaction processing. Continue Reading
-
Answer
10 Apr 2009
What are the most common system implementation mistakes?
Learn about some of the biggest mistakes in system implementation and why successful implementations are few and far between. Find out how to avoid these pitfalls with careful planning and more tips from our project management expert. Continue Reading
-
Answer
26 Jun 2008
How to evaluate data warehouse software in five steps
Get five steps to evaluating data warehouse software from a data warehouse expert. Continue Reading
-
News
10 Apr 2008
Why Are Data Warehouses Growing So Fast?
Richard Winter provides observations on the causes and effects of the explosion of digital information. Continue Reading
-
Answer
16 Mar 2006
Ralph Kimball vs. Bill Inmon approaches to data warehouse design
Learn about the debate between the Ralph Kimball and Bill Inmon approaches to data warehouse design. Continue Reading
-
News
06 Jan 2005
Data warehousing for government
Surprisingly, Data Warehouses have been slow to be adopted in the government circles. Continue Reading