Business Case
The NYS MDW requires compliance with several very stringent SLAs, including having the system available for 24 x 7 access.
The NYS MDW contains over 1 petabyte of data including: Over 600 tables; Over 185 tables containing over 1 million rows; Over 5 billion rows of claims data; and over 6 million active members.
The NYS MDW also accepts and processes over 250 inbound files on a weekly basis and generates over 450 weekly outbound files to 28 different agencies.
CMA had to accept and load several terabytes of new data into the NYS MDW on both a daily and weekly basis. This new data had to be successfully integrated in with existing data, replicated into several different environments, and backed up. This required migrating extremely large amounts of data extremely quickly to meet the stringent SLA’s that were put in place for the NYS MDW by DOH.
The existing COTS data movement technologies that were available and being used were not able to perform the required data migration within the required timeframes.
The Solution
CMA’s technical architects designed and created Mosaic Data at Rapid Transport (DART) to rapidly migrate the large amounts of healthcare data that CMA had to move and integrate in accelerated time periods.
Mosaic DART is a high-speed transport framework with end-point intelligence. It is designed to provide a flexible mechanism to orchestrate the publication of transformed data from source platforms to target databases in a manner that shrinks conversion and refresh cycles, and ensures the maximum availability of the target databases. Mosaic DART can be installed and configured to run on multiple source and target platforms allowing users to define Load Groups that operate against multiple data sources and/or target databases, which may take the form of individual schemas within a single database instance. Its metadata-driven design provides highly granular configuration options, avoiding the need for code changes that could result in project delays.
Mosaic DART’s design approach addresses the vital aspects of a successful solution that publishes big data to target systems: scalability, availability, flexibility, and interoperability.
The Results
By using DART, CMA was able to stay within compliance of all SLA’s related to data acquisition and data access and the MDW users were able to gain quick access to the most current healthcare data.
Satisfying the NYS MDW requirements and SLAs and providing MDW users with immediate access to critical healthcare data has led to several contract amendments for additional work to be performed by CMA within the NYS MDW.