Drew Cardon

Professional Services, SVP

Drew Cardon joined Health Catalyst in November 2011 as a data architect. Prior to this, he worked for nine years in the state tax and revenue industry as a project manager and implementation consultant with Accenture, and later with Fast Enterprises. He was involved in the installation of large information technology systems for the State Tax Commissions in Arizona, Utah, and Oklahoma. He holds a Bachelor’s degree in business from Brigham Young University and an MBA from the University of Notre Dame.

See content from Drew Cardon

Database vs Data Warehouse: A Comparative Review

What are the differences between a database and a data warehouse?

A database is any collection of data organized for storage, accessibility, and retrieval.

A data warehouse is a type of database the integrates copies of transaction data from disparate source systems and provisions them for analytical use.

The important distinction is that data warehouses are designed to handle analytics required for improving quality and costs in the new healthcare environment. A transactional database, like an EHR, doesn’t lend itself to analytics.