Reengineering a Database for Clinical Trials Management: Lessons for System Architects

This paper describes the process of enhancing Trial/DB, a database system for clinical studies management. The system's enhancements have been driven by the need to maximize the effectiveness of developer personnel in supporting numerous and diverse users, of study designers in setting up new s...

Full description

Saved in:
Bibliographic Details
Published in:Controlled clinical trials 2000-10, Vol.21 (5), p.440-461
Main Authors: Brandt, Cynthia A, Nadkarni, Prakash, Marenco, Luis, Karras, Bryant T, Lu, Charles, Schacter, Lee, Fisk, John M, Miller, Perry L
Format: Article
Language:English
Subjects:
Biological and medical sciences
Clinical trial. Drug monitoring
Clinical trials
Clinical Trials as Topic
Database Management Systems
Databases as Topic
General pharmacology
Medical sciences
Pharmacology. Drug treatments
relational database systems
World Wide Web database applications
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites
container_end_page 461
container_issue 5
container_start_page 440
container_title Controlled clinical trials
container_volume 21
creator Brandt, Cynthia A
Nadkarni, Prakash
Marenco, Luis
Karras, Bryant T
Lu, Charles
Schacter, Lee
Fisk, John M
Miller, Perry L
description This paper describes the process of enhancing Trial/DB, a database system for clinical studies management. The system's enhancements have been driven by the need to maximize the effectiveness of developer personnel in supporting numerous and diverse users, of study designers in setting up new studies, and of administrators in managing ongoing studies. Trial/DB was originally designed to work over a local area network within a single institution, and basic architectural changes were necessary to make it work over the internet efficiently as well as securely. Further, as its use spread to diverse communities of users, changes were made to let the processes of study design and project management adapt to the working styles of the principal investigators and administrators for each study. The lessons learned in the process should prove instructive for system architects as well as managers of electronic patient record systems. Control Clin Trials 2000;21:440–461
doi_str_mv 10.1016/S0197-2456(00)00070-2
format article
fullrecord <record><control><sourceid>proquest_pubme</sourceid><recordid>TN_cdi_proquest_miscellaneous_72311000</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><els_id>S0197245600000702</els_id><sourcerecordid>72311000</sourcerecordid><originalsourceid>FETCH-LOGICAL-e291t-82cf121af3219fadaf9a3cfe833210f0cec5e77ac920bc25e4b76a9ea118732d3</originalsourceid><addsrcrecordid>eNo90dtKAzEQBuAgiq3VR1AWBNGL1Um2e_JGSj1CRdAq3oVpdlIju9mabAXf3lirV4HwzcA_P2P7HE458OzsCXiZx2KYZscAJwCQQyw2WJ8XeRlDCq-brP9PemzH-_eAUp4Nt1mPhxVFmok-e3kksnNjiZyx8wijS-xwhp4i3bpoXBtrFNbR1BmsfXSPFufUkO3Oowl531q_ck9fvqMmGjn1ZjpSnd9lWzoM0N76HbDn66vp-DaePNzcjUeTmETJu7gQSnPBUSeClxor1CUmSlORhA_QoEillOeoSgEzJVIazvIMS0IeYiaiSgbs6HfvwrUfS_KdbIxXVNdoqV16mYskZAUI8GANl7OGKrlwpkH3Jf8uEcDhGqAPibVDq4z_dwVP8yEP6uJXUQj1achJrwxZRZVxIbesWiM5yJ-G5Koh-XN-CSBXDUmRfAOHyYHm</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>72311000</pqid></control><display><type>article</type><title>Reengineering a Database for Clinical Trials Management: Lessons for System Architects</title><source>ScienceDirect Freedom Collection 2022-2024</source><creator>Brandt, Cynthia A ; Nadkarni, Prakash ; Marenco, Luis ; Karras, Bryant T ; Lu, Charles ; Schacter, Lee ; Fisk, John M ; Miller, Perry L</creator><creatorcontrib>Brandt, Cynthia A ; Nadkarni, Prakash ; Marenco, Luis ; Karras, Bryant T ; Lu, Charles ; Schacter, Lee ; Fisk, John M ; Miller, Perry L</creatorcontrib><description>This paper describes the process of enhancing Trial/DB, a database system for clinical studies management. The system's enhancements have been driven by the need to maximize the effectiveness of developer personnel in supporting numerous and diverse users, of study designers in setting up new studies, and of administrators in managing ongoing studies. Trial/DB was originally designed to work over a local area network within a single institution, and basic architectural changes were necessary to make it work over the internet efficiently as well as securely. Further, as its use spread to diverse communities of users, changes were made to let the processes of study design and project management adapt to the working styles of the principal investigators and administrators for each study. The lessons learned in the process should prove instructive for system architects as well as managers of electronic patient record systems. Control Clin Trials 2000;21:440–461</description><identifier>ISSN: 0197-2456</identifier><identifier>EISSN: 1879-050X</identifier><identifier>DOI: 10.1016/S0197-2456(00)00070-2</identifier><identifier>PMID: 11018562</identifier><language>eng</language><publisher>New York, NY: Elsevier Inc</publisher><subject>Biological and medical sciences ; Clinical trial. Drug monitoring ; Clinical trials ; Clinical Trials as Topic ; Database Management Systems ; Databases as Topic ; General pharmacology ; Medical sciences ; Pharmacology. Drug treatments ; relational database systems ; World Wide Web database applications</subject><ispartof>Controlled clinical trials, 2000-10, Vol.21 (5), p.440-461</ispartof><rights>2000 Elsevier Science Inc.</rights><rights>2001 INIST-CNRS</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>314,780,784,27924,27925</link.rule.ids><backlink>$$Uhttp://pascal-francis.inist.fr/vibad/index.php?action=getRecordDetail&amp;idt=815741$$DView record in Pascal Francis$$Hfree_for_read</backlink><backlink>$$Uhttps://www.ncbi.nlm.nih.gov/pubmed/11018562$$D View this record in MEDLINE/PubMed$$Hfree_for_read</backlink></links><search><creatorcontrib>Brandt, Cynthia A</creatorcontrib><creatorcontrib>Nadkarni, Prakash</creatorcontrib><creatorcontrib>Marenco, Luis</creatorcontrib><creatorcontrib>Karras, Bryant T</creatorcontrib><creatorcontrib>Lu, Charles</creatorcontrib><creatorcontrib>Schacter, Lee</creatorcontrib><creatorcontrib>Fisk, John M</creatorcontrib><creatorcontrib>Miller, Perry L</creatorcontrib><title>Reengineering a Database for Clinical Trials Management: Lessons for System Architects</title><title>Controlled clinical trials</title><addtitle>Control Clin Trials</addtitle><description>This paper describes the process of enhancing Trial/DB, a database system for clinical studies management. The system's enhancements have been driven by the need to maximize the effectiveness of developer personnel in supporting numerous and diverse users, of study designers in setting up new studies, and of administrators in managing ongoing studies. Trial/DB was originally designed to work over a local area network within a single institution, and basic architectural changes were necessary to make it work over the internet efficiently as well as securely. Further, as its use spread to diverse communities of users, changes were made to let the processes of study design and project management adapt to the working styles of the principal investigators and administrators for each study. The lessons learned in the process should prove instructive for system architects as well as managers of electronic patient record systems. Control Clin Trials 2000;21:440–461</description><subject>Biological and medical sciences</subject><subject>Clinical trial. Drug monitoring</subject><subject>Clinical trials</subject><subject>Clinical Trials as Topic</subject><subject>Database Management Systems</subject><subject>Databases as Topic</subject><subject>General pharmacology</subject><subject>Medical sciences</subject><subject>Pharmacology. Drug treatments</subject><subject>relational database systems</subject><subject>World Wide Web database applications</subject><issn>0197-2456</issn><issn>1879-050X</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2000</creationdate><recordtype>article</recordtype><recordid>eNo90dtKAzEQBuAgiq3VR1AWBNGL1Um2e_JGSj1CRdAq3oVpdlIju9mabAXf3lirV4HwzcA_P2P7HE458OzsCXiZx2KYZscAJwCQQyw2WJ8XeRlDCq-brP9PemzH-_eAUp4Nt1mPhxVFmok-e3kksnNjiZyx8wijS-xwhp4i3bpoXBtrFNbR1BmsfXSPFufUkO3Oowl531q_ck9fvqMmGjn1ZjpSnd9lWzoM0N76HbDn66vp-DaePNzcjUeTmETJu7gQSnPBUSeClxor1CUmSlORhA_QoEillOeoSgEzJVIazvIMS0IeYiaiSgbs6HfvwrUfS_KdbIxXVNdoqV16mYskZAUI8GANl7OGKrlwpkH3Jf8uEcDhGqAPibVDq4z_dwVP8yEP6uJXUQj1achJrwxZRZVxIbesWiM5yJ-G5Koh-XN-CSBXDUmRfAOHyYHm</recordid><startdate>20001001</startdate><enddate>20001001</enddate><creator>Brandt, Cynthia A</creator><creator>Nadkarni, Prakash</creator><creator>Marenco, Luis</creator><creator>Karras, Bryant T</creator><creator>Lu, Charles</creator><creator>Schacter, Lee</creator><creator>Fisk, John M</creator><creator>Miller, Perry L</creator><general>Elsevier Inc</general><general>Elsevier Science</general><scope>IQODW</scope><scope>CGR</scope><scope>CUY</scope><scope>CVF</scope><scope>ECM</scope><scope>EIF</scope><scope>NPM</scope><scope>7X8</scope></search><sort><creationdate>20001001</creationdate><title>Reengineering a Database for Clinical Trials Management: Lessons for System Architects</title><author>Brandt, Cynthia A ; Nadkarni, Prakash ; Marenco, Luis ; Karras, Bryant T ; Lu, Charles ; Schacter, Lee ; Fisk, John M ; Miller, Perry L</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-e291t-82cf121af3219fadaf9a3cfe833210f0cec5e77ac920bc25e4b76a9ea118732d3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2000</creationdate><topic>Biological and medical sciences</topic><topic>Clinical trial. Drug monitoring</topic><topic>Clinical trials</topic><topic>Clinical Trials as Topic</topic><topic>Database Management Systems</topic><topic>Databases as Topic</topic><topic>General pharmacology</topic><topic>Medical sciences</topic><topic>Pharmacology. Drug treatments</topic><topic>relational database systems</topic><topic>World Wide Web database applications</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Brandt, Cynthia A</creatorcontrib><creatorcontrib>Nadkarni, Prakash</creatorcontrib><creatorcontrib>Marenco, Luis</creatorcontrib><creatorcontrib>Karras, Bryant T</creatorcontrib><creatorcontrib>Lu, Charles</creatorcontrib><creatorcontrib>Schacter, Lee</creatorcontrib><creatorcontrib>Fisk, John M</creatorcontrib><creatorcontrib>Miller, Perry L</creatorcontrib><collection>Pascal-Francis</collection><collection>Medline</collection><collection>MEDLINE</collection><collection>MEDLINE (Ovid)</collection><collection>MEDLINE</collection><collection>MEDLINE</collection><collection>PubMed</collection><collection>MEDLINE - Academic</collection><jtitle>Controlled clinical trials</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Brandt, Cynthia A</au><au>Nadkarni, Prakash</au><au>Marenco, Luis</au><au>Karras, Bryant T</au><au>Lu, Charles</au><au>Schacter, Lee</au><au>Fisk, John M</au><au>Miller, Perry L</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Reengineering a Database for Clinical Trials Management: Lessons for System Architects</atitle><jtitle>Controlled clinical trials</jtitle><addtitle>Control Clin Trials</addtitle><date>2000-10-01</date><risdate>2000</risdate><volume>21</volume><issue>5</issue><spage>440</spage><epage>461</epage><pages>440-461</pages><issn>0197-2456</issn><eissn>1879-050X</eissn><abstract>This paper describes the process of enhancing Trial/DB, a database system for clinical studies management. The system's enhancements have been driven by the need to maximize the effectiveness of developer personnel in supporting numerous and diverse users, of study designers in setting up new studies, and of administrators in managing ongoing studies. Trial/DB was originally designed to work over a local area network within a single institution, and basic architectural changes were necessary to make it work over the internet efficiently as well as securely. Further, as its use spread to diverse communities of users, changes were made to let the processes of study design and project management adapt to the working styles of the principal investigators and administrators for each study. The lessons learned in the process should prove instructive for system architects as well as managers of electronic patient record systems. Control Clin Trials 2000;21:440–461</abstract><cop>New York, NY</cop><pub>Elsevier Inc</pub><pmid>11018562</pmid><doi>10.1016/S0197-2456(00)00070-2</doi><tpages>22</tpages></addata></record>
fulltext fulltext
identifier ISSN: 0197-2456
ispartof Controlled clinical trials, 2000-10, Vol.21 (5), p.440-461
issn 0197-2456
1879-050X
language eng
recordid cdi_proquest_miscellaneous_72311000
source ScienceDirect Freedom Collection 2022-2024
subjects Biological and medical sciences
Clinical trial. Drug monitoring
Clinical trials
Clinical Trials as Topic
Database Management Systems
Databases as Topic
General pharmacology
Medical sciences
Pharmacology. Drug treatments
relational database systems
World Wide Web database applications
title Reengineering a Database for Clinical Trials Management: Lessons for System Architects
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-24T19%3A46%3A46IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_pubme&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Reengineering%20a%20Database%20for%20Clinical%20Trials%20Management:%20Lessons%20for%20System%20Architects&rft.jtitle=Controlled%20clinical%20trials&rft.au=Brandt,%20Cynthia%20A&rft.date=2000-10-01&rft.volume=21&rft.issue=5&rft.spage=440&rft.epage=461&rft.pages=440-461&rft.issn=0197-2456&rft.eissn=1879-050X&rft_id=info:doi/10.1016/S0197-2456(00)00070-2&rft_dat=%3Cproquest_pubme%3E72311000%3C/proquest_pubme%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-e291t-82cf121af3219fadaf9a3cfe833210f0cec5e77ac920bc25e4b76a9ea118732d3%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_pqid=72311000&rft_id=info:pmid/11018562&rfr_iscdi=true