Research Integrated Network of Systems (RINS): a virtual data warehouse for the acceleration of translational research.

OBJECTIVE: Integrated, real-time data are crucial to evaluate translational efforts to accelerate innovation into care. Too often, however, needed data are fragmented in disparate systems. The South Carolina Clinical & Translational Research Institute at the Medical University of South Carolina (MUSC) developed and implemented a universal study identifier-the Research Master Identifier (RMID)-for tracking research studies across disparate systems and a data warehouse-inspired model-the Research Integrated Network of Systems (RINS)-for integrating data from those systems. MATERIALS AND METHODS: In 2017, MUSC began requiring the use of RMIDs in informatics systems that support human subject studies. We developed a web-based tool to create RMIDs and application programming interfaces to synchronize research records and visualize linkages to protocols across systems. Selected data from these disparate systems were extracted and merged nightly into an enterprise data mart, and performance dashboards were created to monitor key translational processes. RESULTS: Within 4 years, 5513 RMIDs were created. Among these were 726 (13%) bridged systems needed to evaluate research study performance, and 982 (18%) linked to the electronic health records, enabling patient-level reporting. DISCUSSION: Barriers posed by data fragmentation to assessment of program impact have largely been eliminated at MUSC through the requirement for an RMID, its distribution via RINS to disparate systems, and mapping of system-level data to a single integrated data mart. CONCLUSION: By applying data warehousing principles to federate data at the "study" level, the RINS project reduced data fragmentation and promoted research systems integration.

SPARC: A Multi-institutional Integrated Web Based Research Management System.

SPARC is a web-based research management system that integrates both research and routine clinical care work flows and has now been in operation at the Medical University of South Carolina (MUSC) since March 1, 2012. The system provides a one-stop-shop to researchers for all service requests related to their research with a focus on billing compliance, proposal and budget development, and work fulfillment data collection. Upgrades and enhancements based on user feedback from institutions around the country include increased invoicing and billing functionality, clinical research visit and assessment tracking, and outcome assessment using grant and publication data links. System development leverages home grown and community open source components.