202: Building the Multi Terabyte Claims Data Warehouse:
Stephen Rokes , IFMC    Biography

Objectives: ETL performance impovement opportunities
Architecutral design opportunities to take into consideration in a healthcare claims warehouse
How to get things done faster.
Abstract: One of the goals of Section 723 of the Medicare Prescription Drug, Improvement, and Modernization Act of 2003 is to make Medicare data readily available to researchers who are studying chronic illness in the Medicare population. To support this effort, the Centers for Medicare & Medicaid Services (CMS) contracted with the Iowa Foundation for Medical Care (IFMC) to establish the Chronic Condition Data Warehouse (CCW). The CCW contains existing CMS beneficiary data (from multiple data sources) linked by a unique identifier, allowing researchers to analyze information across the continuum of care. The CCW currently contains multiple types of data from multiple sources. The data loaded from January 1, 1999 through December 31, 2004 is a random 5% Medicare beneficiary population. Starting in 2005 loading of data will be at 100%.

Audiernce Focus: Architects
Expertise: Advanced
Track: Business Intelligence/Warehousing
Date: Monday, April 14, 2008
Time: 9:15 AM - 10:15 AM