BIDMC Data Marts

At BIDMC, our clinical systems are written in a hierarchical database called Cache - a very fast transactional system with great reliability and disaster recovery features.

However, for population health, quality, and performance analysis, we export our clinical care data into over 80 data marts build with SQL Server 2008.

These data marts are focused on specific reporting areas such as pharmacy, radiology, lab, and O.R. They are designed and maintained by an IS team within Clinical Information Systems. Updates generally occur daily and are managed via SSIS packages.

BIDMC data marts are used to support ad hoc queries by analysts as well as standard reporting via Performance Manager, a web-based, self-service reporting application developed by BIDMC IS. Some of the key content areas and uses for the data are shown in the graphic above.

One of our most powerful data marts is the BIDMC/Joslin Diabetes registry, which uses a Master Patient Index to link all the records of the two institutions together into one reporting infrastructure. It identifies all diabetic patients and consolidates a variety of relevant clinical and operational data into a single data mart optimized for tracking and reporting. Data elements include laboratory results Hemoglobin A1C and cholesterol, blood pressure, and outpatient medical and vision care appointments. In addition to data from BIDMC, the registry includes laboratory and vision care data from Joslin, providing a complete picture for BIDMC patients who also receive diabetic care at Joslin.

We've identified the person whom we believe is the Primary Care Physician and generated web-based reports for PCPs to validate that patients in the registry actually have diabetes. Surprisingly large number don't have diabetes. Diabetes was coded, for example, in ordering an A1C as a "rule out". We've also designed management reports that measure compliance with guidelines for diabetes care. We hope to leverage this infrastructure as part of our Beacon Communities grant application and make it available as a model for diabetic care throughout the community.

Our data marts, combined with the community quality data center hosted by MAeHC, provide us all the tools we need to improve quality and efficiency in our inpatient, ED, and ambulatory practices throughout greater Boston.