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

Opinion 16 Mar 2023
Data lakes: Key to the modern data management platform

Data lakes influence the modern data management platform at all levels. Organizations can gain faster insights, save costs, improve governance and boost self-service data access. Continue Reading
News 06 Mar 2023
New high-volume agent connectors highlight Fivetran update

The data ingestion specialist's latest platform update focuses on enabling users to ingest high volumes of data to fuel real-time analysis and adds a new private deployment option. Continue Reading

Feature 01 Feb 2019

Cloud data warehouse makes inroads as users spurn admin tasks

Overlooked in the run-up to Hadoop, data warehouses have found new life off premises. Cloud-based data warehouses find favor with teams that want to reduce warehouse administration. Continue Reading
News 22 Jan 2019

New Teradata CEO pursues cloud-based architecture

Cloud architecture, analytics and AI data processing are top innovation priorities for new Teradata CEO Oliver Ratzesberger. He talks about his goals in this Q&A. Continue Reading
News 30 Nov 2018

Amazon Timestream, QLDB aim to grab more DBMS users for AWS

Built-for-purpose databases target general ones, especially in the cloud. At re:Invent 2018, AWS added time-series and transaction ledger databases to expand its line. Continue Reading
Tip 06 Jul 2018

When to choose an S3 big data environment over HDFS storage

Selecting a storage service for big data in the cloud can be challenging. Expert David Loshin explains usage patterns that could lead organizations to Amazon Simple Storage Service. 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