May 2009

Document Type


Degree Name



Dept. of Medical Informatics and Clinical Epidemiology


Oregon Health & Science University


An important service that the Oregon Clinical and Translational Research Institute (OCTRI) provides to its investigators is database application development. For the typical investigator-initiated clinical research study, OCTRI uses standardized database structures and application code developed in over a decade of supporting such projects. The database structures are based on the Clinical Data Interchange Standards Consortium Specification for the Operational Data Model (CDISC ODM) data model and include structures that hold study metadata. The study metadata defines the study structure in terms of study events (e.g., inpatient admissions, outpatient visits, phone interviews, etc), patients, and case report forms. Study metadata are used to generate a complete study calendar and e-case report form records for a patient based on study entry date. The system consists of a FirebirdSQL database and an application implemented in Borland Delphi. Firebird is an open source relational database management system that was released in March, 2002. Borland Delphi is a strong typed object oriented programming language that was introduced in 1996. The purpose of the Translational Research Web Application Framework project is to port the existing system into the more popular MySQL relational database management system paired with the un-typed scripting language called PHP. The PHP code takes advantage of the open source ZEND Framework, which facilitates many of the common functions and interactions with the MySQL database, making the code easy to read and understand, and the coding process very efficient and fast. The scope of the project includes an application structure and a Model View Controller (MVC) framework that will be used by other developers who will create a graphical user interface for their applications.




School of Medicine



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.