PS1-39: The Kaiser Permanente Northern California Oracle Research Database

摘要

NCAL developed a pilot Research Database (RDB) in KPNC that contains clinical and administrative data for the 3.3 million current and 10 million past Health Plan members in the KPNC region, with some data that spans a 40 year period. The primary reason to create such a data warehouse is that researchers are often frustrated by the difficulty of finding, extracting, cleaning, interpreting and transforming the data into useful analytical datasets. This is due to the absence of an efficient research data infrastructure that is optimized for the analytical needs of researchers. In the RDB, we have aggregated clinical data from legacy systems, the current electronic health record (EHR) system, various public use datasets, and research datasets into a research data warehouse.AimsThe specific aims of the project are: class="enumerated" style="list-style-type:decimal">to develop a uniform schema with consistent data definitions and coding, using standardized terminology, that will harmonize aggregated legacy and current KP electronic health records,develop interfaces and extract, transform and load (ETL) processes for the KP electronic medical record system and other clinical systems that will feed data to the NRDB,implement a security model that is compliant with HIPAA and State regulations and KP policies, anddevelop federated schema with the other KP regions, so that it will be possible to do federated queries of each region’s databases and aggregate the results, while enabling each region to control access to its data.MethodsWe developed the RDB in Oracle. ETLs to various data sources were developed in SAS, Informatica and PL/SQL.