Clinical Research Information Technology
Data Warehousing and Business Intelligence Software
CHB offers a wide variety of business intelligence and analytical tools to the research community. These tools include the following and are support by Clinical Research IT, ISD Knowledge Management, Research Computing and the Clinical Research Program.
- Statistical Analysis Packages (SAS, SPSS, Stata)
- CHQuery (Business Objects Enterprise)
- Oracle Clinical Data Warehouse
The ISD Business Intelligence team hosts a CHB-branded instance of Business Objects Enterprise named "CHQuery". This instance is accessible to all CHB staff members and may be used to access data stored in a variety of locations. Custom domains may be created to join clinical research registry data with data from the clinical data warehouse. In addition, data from business and administrative systems be accessed too.
CHQuery is used commonly to perform cohort discovery and generate aggregate statistics for supporting grant proposals. The system may also be used to create patient prescreening lists for assessing clinical trial eligibility and initial contact.
An IRB-approved protocol is required to access patient identifiable data. However, once approved, access to demographic data, lab and physical exam results as will as operational notes are available.
CHQuery may also be employed to enhance ad hoc reporting capability on top of pre-existing electronic data capture systems and clinical registries.
Oracle Data Warehouse Facilities
The CRIT, in partnership with the ISD Data Warehouse team, can provide researchers with access to the enterprise data warehouse infrastructure including the Clinical Data Warehouse (CDW). The CDW contains both legacy and current data fed from the medical records system. Please contact the Clinical Research IT team for more information regarding data warehousing for research and data archival.
CHB is a participating member of I2B2 (Informatics for Integrating Biology and the Bedside) project. Support for an institutional I2B2 Hive is forthcoming. For more information regarding I2B2 please visit the project Web site.