| Literature DB >> 22505956 |
Haibin Wang1, Mahendra Yatawara, Shao-Chi Huang, Kevin Dudley, Christine Szekely, Stuart Holden, Steven Piantadosi.
Abstract
In this paper, we present the design and implementation of the integrated proactive surveillance system for prostate cancer (PASS-PC). The integrated PASS-PC is a multi-institutional web-based system aimed at collecting a variety of data on prostate cancer patients in a standardized and efficient way. The integrated PASS-PC was commissioned by the Prostate Cancer Foundation (PCF) and built through the joint of efforts by a group of experts in medical oncology, genetics, pathology, nutrition, and cancer research informatics. Their main goal is facilitating the efficient and uniform collection of critical demographic, lifestyle, nutritional, dietary and clinical information to be used in developing new strategies in diagnosing, preventing and treating prostate cancer.The integrated PASS-PC is designed based on common industry standards - a three tiered architecture and a Service- Oriented Architecture (SOA). It utilizes open source software and programming languages such as HTML, PHP, CSS, JQuery, Drupal and MySQL. We also use a commercial database management system - Oracle 11g. The integrated PASS-PC project uses a "confederation model" that encourages participation of any interested center, irrespective of its size or location. The integrated PASS-PC utilizes a standardized approach to data collection and reporting, and uses extensive validation procedures to prevent entering erroneous data. The integrated PASS-PC controlled vocabulary is harmonized with the National Cancer Institute (NCI) Thesaurus. Currently, two cancer centers in the USA are participating in the integrated PASS-PC project.THE FINAL SYSTEM HAS THREE MAIN COMPONENTS: 1. National Prostate Surveillance Network (NPSN) website; 2. NPSN myConnect portal; 3. Proactive Surveillance System for Prostate Cancer (PASS-PC). PASS-PC is a cancer Biomedical Informatics Grid (caBIG) compatible product. The integrated PASS-PC provides a foundation for collaborative prostate cancer research. It has been built to meet the short term goal of gathering prostate cancer related data, but also with the prerequisites in place for future evolution into a cancer research informatics platform. In the future this will be vital for successful prostate cancer studies, care and treatment.Entities:
Keywords: Cancer research informatics; caBIG.; multi-center clinical data database; proactive surveillance; prostate cancer; service-oriented architecture
Year: 2012 PMID: 22505956 PMCID: PMC3322433 DOI: 10.2174/1874431101206010001
Source DB: PubMed Journal: Open Med Inform J ISSN: 1874-4311
Definition of Variables in the USER_AUDIT Table
| Variable Name | Definition |
|---|---|
| USER_ID | Specific identification number of the database User |
| LOGIN_TIME | The system date and time when the user logged in and began a session |
| LOGOUT_TIME | The system date and time when the user logged out and ended a session |
| IP_ADDRESS | The IP address of the computer where the user accesses the database |
Definition of Variables in the OPERATION_AUDIT Table
| Variable Name | Definition |
|---|---|
| USER_ID | Specific identification number of the database User |
| TIME_STAMP | The system date and time that the action was performed |
| TABLE | The specific table name where the action occurred |
| COLUMN | The specific table column name where the action occurred |
| OPERATION_TYPE | The specific action that was performed by the user |
| OLD_VALUE | The original value that existed prior to the new action |
| NEW_VALUE | The new value that exists subsequent to the action |