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.

August 24, 2022 24 Aug'22
New SAS, SingleStore integration boosts speed, efficiency

The integration between the longtime data and analytics vendor and the upstart database vendor enables users to work with data in-database, which increases speed-to-insight.
August 17, 2022 17 Aug'22
Cloudera users get fully managed data lakehouse platform

The vendor is expanding its set of offerings with the launch of CDP One, a service initially available only on AWS that enables serverless deployment in the cloud.
August 11, 2022 11 Aug'22
GridGain, Apache Ignite founder talks in-memory databases

Nikita Ivanov details the origin of his company and discusses the growing need organizations have for real-time database processing capabilities to complete modern transactions.
August 09, 2022 09 Aug'22
A look at Presto, Trino SQL query engines

The co-creator of the open source project at Facebook reflects on 10 years of growth as he helps lead one of its resulting tools into the future.

Bring yourself up to speed with our introductory content

data warehouse as a service (DWaaS)

Data warehouse as a service (DWaaS) is an outsourcing model in which a cloud service provider configures and manages the hardware and software resources a data warehouse requires, and the customer provides the data and pays for the managed service. Continue Reading
Elastic Stack (ELK Stack)

The Elastic Stack is a group of open source products from Elastic designed to help users take data from any type of source and in any format, and search, analyze and visualize that data in real time. Continue Reading
How to evaluate and optimize data warehouse performance

Organizations build data warehouses to satisfy their information management needs. Data warehouse optimization can help ensure that these warehouses achieve their full potential. Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

Cloud database comparison: AWS, Microsoft, Google and Oracle

Here's a look at the rival cloud database offerings from AWS, Google, Microsoft and Oracle based on their product breadth, migration capabilities and pricing models. Continue Reading
On-premises vs. cloud data warehouses: Pros and cons

Data warehouses increasingly are being deployed in the cloud. But both on-premises and cloud data warehouses have pluses and minuses to consider, as explained here. Continue Reading
Bill Inmon's data warehouse approach tackles text analysis

Learn the fine points of a concept at the heart of 'The Textual Warehouse' a new book that aims to help organizations profit through textual analysis. Continue Reading

Learn to apply best practices and optimize your operations.

NLP and AI boost the automated data warehouse

Businesses are working to automate as many elements of their data warehouses as they can through nascent tools like augmented analytics and natural language processing. Continue Reading
Top 5 elements needed for a successful data warehouse

While conventional data warehouses may struggle to keep up with growing volumes of data, these five elements best give the ability to tap into valuable BI. Continue Reading
6 strategies to tap into data warehouse BI

Data warehouse BI benefits include data storage, summarization and transformation and can be unlocked with these six strategies leveraging cloud architectures. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

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
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
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