Clinical Database Management Systems and Ontologies

Graduate / Professional

This course introduces database and ontology in the clinical/public health domain. It reviews how data and information are generated in clinical/public health settings. It introduces different approaches to representing, modeling, managing, querying, and integrating clinical/public health data. In terms of database technologies, the course describes two main approaches—SQL database and non-SQL (NoSQL) database—and shows how these technologies can be used to build electronic health records (EHR), data repositories, and data warehouses. In terms of ontologies, it discusses how ontologies are used in connecting and integrating data with machine-readable knowledge. The course reviews the major theories, methods, and tools for the design and development of databases and ontologies. It also includes clinical/public health use cases demonstrating how databases and ontologies are used to support clinical/public health research. Prerequisite: CPSC 223 or permission of the instructors. The general expectation to obtain instructor permission is that students have basic command of the Python programming language sufficient to pass CPSC 223 or the equivalent. Th 1pm-2:50pm