An open-source SQL database schema for integrated clinical and translational data management in clinical trials
Unlocking the power of personalised medicine in oncology hinges on the integration of clinical trial data with translational data (i.e. biospecimen-derived molecular information). This combined analysis allows researchers to tailor treatments to a patient's unique biological makeup. However, cu...
Uložené v:
| Vydané v: | Clinical trials (London, England) Ročník 22; číslo 3; s. 374 |
|---|---|
| Hlavní autori: | , , , , |
| Médium: | Journal Article |
| Jazyk: | English |
| Vydavateľské údaje: |
England
01.06.2025
|
| Predmet: | |
| ISSN: | 1740-7753, 1740-7753 |
| On-line prístup: | Zistit podrobnosti o prístupe |
| Tagy: |
Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
|
| Abstract | Unlocking the power of personalised medicine in oncology hinges on the integration of clinical trial data with translational data (i.e. biospecimen-derived molecular information). This combined analysis allows researchers to tailor treatments to a patient's unique biological makeup. However, current practices within UK Clinical Trials Units present challenges. While clinical data are held in standardised formats, translational data are complex, diverse, and requires specialised storage. This disparity in format creates significant hurdles for researchers aiming to curate, integrate and analyse these datasets effectively. This article proposes a novel solution: an open-source SQL database schema designed specifically for the needs of academic trial units. Inspired by Cancer Research UK's commitment to open data sharing and exemplified by the Southampton Clinical Trials Unit's CONFIRM trial (with over 150,000 clinical data points), this schema offers a cost-effective and practical 'middle ground' between raw data and expensive Secure Data Environments/Trusted Research Environments. By acting as a central hub for both clinical and translational data, the schema facilitates seamless data sharing and analysis. Researchers gain a holistic view of trials, enabling exploration of connections between clinical observations and the molecular underpinnings of treatment response. Detailed instructions for setting up the database are provided. The open-source nature and straightforward design ensure ease of implementation and affordability, while robust security measures safeguard sensitive data. We further showcase how researchers can leverage popular statistical software like R to directly query the database. This approach fosters collaboration within the academic discovery community, ultimately accelerating progress towards personalised cancer therapies. |
|---|---|
| AbstractList | Unlocking the power of personalised medicine in oncology hinges on the integration of clinical trial data with translational data (i.e. biospecimen-derived molecular information). This combined analysis allows researchers to tailor treatments to a patient's unique biological makeup. However, current practices within UK Clinical Trials Units present challenges. While clinical data are held in standardised formats, translational data are complex, diverse, and requires specialised storage. This disparity in format creates significant hurdles for researchers aiming to curate, integrate and analyse these datasets effectively. This article proposes a novel solution: an open-source SQL database schema designed specifically for the needs of academic trial units. Inspired by Cancer Research UK's commitment to open data sharing and exemplified by the Southampton Clinical Trials Unit's CONFIRM trial (with over 150,000 clinical data points), this schema offers a cost-effective and practical 'middle ground' between raw data and expensive Secure Data Environments/Trusted Research Environments. By acting as a central hub for both clinical and translational data, the schema facilitates seamless data sharing and analysis. Researchers gain a holistic view of trials, enabling exploration of connections between clinical observations and the molecular underpinnings of treatment response. Detailed instructions for setting up the database are provided. The open-source nature and straightforward design ensure ease of implementation and affordability, while robust security measures safeguard sensitive data. We further showcase how researchers can leverage popular statistical software like R to directly query the database. This approach fosters collaboration within the academic discovery community, ultimately accelerating progress towards personalised cancer therapies. Unlocking the power of personalised medicine in oncology hinges on the integration of clinical trial data with translational data (i.e. biospecimen-derived molecular information). This combined analysis allows researchers to tailor treatments to a patient's unique biological makeup. However, current practices within UK Clinical Trials Units present challenges. While clinical data are held in standardised formats, translational data are complex, diverse, and requires specialised storage. This disparity in format creates significant hurdles for researchers aiming to curate, integrate and analyse these datasets effectively. This article proposes a novel solution: an open-source SQL database schema designed specifically for the needs of academic trial units. Inspired by Cancer Research UK's commitment to open data sharing and exemplified by the Southampton Clinical Trials Unit's CONFIRM trial (with over 150,000 clinical data points), this schema offers a cost-effective and practical 'middle ground' between raw data and expensive Secure Data Environments/Trusted Research Environments. By acting as a central hub for both clinical and translational data, the schema facilitates seamless data sharing and analysis. Researchers gain a holistic view of trials, enabling exploration of connections between clinical observations and the molecular underpinnings of treatment response. Detailed instructions for setting up the database are provided. The open-source nature and straightforward design ensure ease of implementation and affordability, while robust security measures safeguard sensitive data. We further showcase how researchers can leverage popular statistical software like R to directly query the database. This approach fosters collaboration within the academic discovery community, ultimately accelerating progress towards personalised cancer therapies.Unlocking the power of personalised medicine in oncology hinges on the integration of clinical trial data with translational data (i.e. biospecimen-derived molecular information). This combined analysis allows researchers to tailor treatments to a patient's unique biological makeup. However, current practices within UK Clinical Trials Units present challenges. While clinical data are held in standardised formats, translational data are complex, diverse, and requires specialised storage. This disparity in format creates significant hurdles for researchers aiming to curate, integrate and analyse these datasets effectively. This article proposes a novel solution: an open-source SQL database schema designed specifically for the needs of academic trial units. Inspired by Cancer Research UK's commitment to open data sharing and exemplified by the Southampton Clinical Trials Unit's CONFIRM trial (with over 150,000 clinical data points), this schema offers a cost-effective and practical 'middle ground' between raw data and expensive Secure Data Environments/Trusted Research Environments. By acting as a central hub for both clinical and translational data, the schema facilitates seamless data sharing and analysis. Researchers gain a holistic view of trials, enabling exploration of connections between clinical observations and the molecular underpinnings of treatment response. Detailed instructions for setting up the database are provided. The open-source nature and straightforward design ensure ease of implementation and affordability, while robust security measures safeguard sensitive data. We further showcase how researchers can leverage popular statistical software like R to directly query the database. This approach fosters collaboration within the academic discovery community, ultimately accelerating progress towards personalised cancer therapies. |
| Author | Foure, Vincent Niazi, Umar Griffiths, Gareth Soares, Patricia Stuart, Charlotte |
| Author_xml | – sequence: 1 givenname: Umar orcidid: 0000-0001-7176-8883 surname: Niazi fullname: Niazi, Umar organization: Cancer Research UK Southampton Clinical Trials Unit, MP131, Southampton General Hospital, University of Southampton, Southampton, UK – sequence: 2 givenname: Charlotte surname: Stuart fullname: Stuart, Charlotte organization: Cancer Research UK Southampton Clinical Trials Unit, MP131, Southampton General Hospital, University of Southampton, Southampton, UK – sequence: 3 givenname: Patricia surname: Soares fullname: Soares, Patricia organization: iSolutions, University of Southampton, Southampton, UK – sequence: 4 givenname: Vincent surname: Foure fullname: Foure, Vincent organization: iSolutions, University of Southampton, Southampton, UK – sequence: 5 givenname: Gareth surname: Griffiths fullname: Griffiths, Gareth organization: Cancer Research UK Southampton Clinical Trials Unit, MP131, Southampton General Hospital, University of Southampton, Southampton, UK |
| BackLink | https://www.ncbi.nlm.nih.gov/pubmed/39720844$$D View this record in MEDLINE/PubMed |
| BookMark | eNpNkEtLxDAUhYMozkN_gBvJ0k01rzbJchh8wYCIui5pejNW2mRM0oX_3g6O6OocPr5zF3eBjn3wgNAFJdeUSnlDpSBSipIJyongnB6h-Z4VUpb8-F-foUVKH4QwVSp-imZcS0aUEHMUVh6HHfgihTFawC_PG9yabBqTACf7DoPBLkTc-QzbaDK02Pad76zpsfEtztH41JvcBT-R_RIPxpstDODztPqzc-xMn87QiZsCzg-5RG93t6_rh2LzdP-4Xm0KK6jOReVUWVVSWg5cAlintGHtxCzRwrFSCOGUU6Cr1jaUKg0MgFqnmWuEFJwt0dXP3V0MnyOkXA9dstD3xkMYU82p0KTSotqrlwd1bAZo613sBhO_6t8nsW-Tk2wk |
| ContentType | Journal Article |
| DBID | CGR CUY CVF ECM EIF NPM 7X8 |
| DOI | 10.1177/17407745241304331 |
| DatabaseName | Medline MEDLINE MEDLINE (Ovid) MEDLINE MEDLINE PubMed MEDLINE - Academic |
| DatabaseTitle | MEDLINE Medline Complete MEDLINE with Full Text PubMed MEDLINE (Ovid) MEDLINE - Academic |
| DatabaseTitleList | MEDLINE MEDLINE - Academic |
| Database_xml | – sequence: 1 dbid: NPM name: PubMed url: http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=PubMed sourceTypes: Index Database – sequence: 2 dbid: 7X8 name: MEDLINE - Academic url: https://search.proquest.com/medline sourceTypes: Aggregation Database |
| DeliveryMethod | no_fulltext_linktorsrc |
| Discipline | Medicine |
| EISSN | 1740-7753 |
| ExternalDocumentID | 39720844 |
| Genre | Journal Article |
| GeographicLocations | United Kingdom |
| GeographicLocations_xml | – name: United Kingdom |
| GroupedDBID | --- -TM .2E .2J .2N 01A 04C 0R~ 1~K 29B 31R 31U 31X 31Z 36B 4.4 53G 54M 5GY 5RE 5VS 6PF 7RV 7X7 88E 8C1 8FI 8FJ 8G5 8R4 8R5 AABMB AACMV AACTG AADUE AAEWN AAGLT AAGMC AAJPV AAKGS AAPII AAQDB AAQXI AARDL AARIX AATAA AATBZ AAUAS AAWTL ABAWP ABCCA ABCJG ABEIX ABFWQ ABHQH ABIDT ABJIS ABJZC ABKRH ABLUO ABPNF ABQXT ABRHV ABTDE ABUJY ABUWG ABVFX ACARO ACDSZ ACDXX ACFEJ ACGFS ACGZU ACJER ACJTF ACLFY ACLZU ACOFE ACOXC ACPRK ACROE ACRPL ACSIQ ACUAV ACUIR ACXKE ACXMB ADBBV ADDLC ADEBD ADNMO ADNON ADRRZ ADVBO ADYCS ADZZY AECGH AEDTQ AEIJN AEKYL AENEX AEPTA AEQLS AERKM AESZF AEUHG AEWDL AEWHI AEXNY AFEET AFKRA AFKRG AFMOU AFQAA AFRAH AFUIA AFWMB AGHKR AGKLV AGNHF AGPXR AGQPQ AGWFA AGWNL AHDMH AHHFK AHMBA AIIQI AJGYC AJUZI AJVBE AJXAJ ALIPV ALKWR ALMA_UNASSIGNED_HOLDINGS AMCVQ AN0 ANDLU ARTOV ASPBG AUTPY AUVAJ AVWKF AYAKG AZFZN AZQEC B3H B8M B8R B8Z B94 BBRGL BDDNI BENPR BKEYQ BKIIM BKSCU BMSDO BNQBC BPACV BPHCQ BSEHC BVXVI BWJAD CAG CCPQU CDWPY CFDXU CGR COF CS3 CUY CVF DB0 DC- DC. DF0 DO- DOPDO DU5 DV7 DV9 DWQXO EBD EBS ECM EIF EIHBH EJD EMB EMOBN EX3 F5P FEDTE FHBDP FYUFA GNUQQ GROUPED_SAGE_PREMIER_JOURNAL_COLLECTION GUQSH H13 HF~ HMCUK HVGLF HZ~ J8X K.F M1P M2O N9A NAPCQ NPM O9- P.B P2P PADUT PHGZM PHGZT PJZUB PPXIY PQQKQ PROAC PSQYO Q2X Q7L Q7U Q83 ROL S01 SASJQ SAUOL SCNPE SDB SFC SFK SFT SGO SGR SGV SGZ SHG SNB SPJ SPQ SPV STM SV3 UDS UKHRP WOW YHZ ZGI ZONMY ZPPRI ZRKOI ZSSAH 7X8 AJHME |
| ID | FETCH-LOGICAL-c419t-6f856677c3e37eecf89a2d856c094f25444f8f8e96dcb1189e2ee1cf92fb47432 |
| IEDL.DBID | 7X8 |
| ISICitedReferencesCount | 1 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=001382697200001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| ISSN | 1740-7753 |
| IngestDate | Sun Nov 09 14:25:00 EST 2025 Mon Jul 21 06:07:02 EDT 2025 |
| IsDoiOpenAccess | false |
| IsOpenAccess | true |
| IsPeerReviewed | true |
| IsScholarly | true |
| Issue | 3 |
| Keywords | clinical trial data integration with translational data Open-source SQL database schema for clinical trials personalised medicine in clinical research |
| Language | English |
| LinkModel | DirectLink |
| MergedId | FETCHMERGED-LOGICAL-c419t-6f856677c3e37eecf89a2d856c094f25444f8f8e96dcb1189e2ee1cf92fb47432 |
| Notes | ObjectType-Article-1 SourceType-Scholarly Journals-1 ObjectType-Feature-2 content type line 23 |
| ORCID | 0000-0001-7176-8883 |
| OpenAccessLink | https://pubmed.ncbi.nlm.nih.gov/PMC12092935 |
| PMID | 39720844 |
| PQID | 3149069463 |
| PQPubID | 23479 |
| ParticipantIDs | proquest_miscellaneous_3149069463 pubmed_primary_39720844 |
| PublicationCentury | 2000 |
| PublicationDate | 2025-06-01 |
| PublicationDateYYYYMMDD | 2025-06-01 |
| PublicationDate_xml | – month: 06 year: 2025 text: 2025-06-01 day: 01 |
| PublicationDecade | 2020 |
| PublicationPlace | England |
| PublicationPlace_xml | – name: England |
| PublicationTitle | Clinical trials (London, England) |
| PublicationTitleAlternate | Clin Trials |
| PublicationYear | 2025 |
| SSID | ssj0028583 |
| Score | 2.399907 |
| Snippet | Unlocking the power of personalised medicine in oncology hinges on the integration of clinical trial data with translational data (i.e. biospecimen-derived... |
| SourceID | proquest pubmed |
| SourceType | Aggregation Database Index Database |
| StartPage | 374 |
| SubjectTerms | Clinical Trials as Topic - methods Data Management - methods Database Management Systems Databases, Factual Humans Information Dissemination - methods Precision Medicine Translational Research, Biomedical United Kingdom |
| Title | An open-source SQL database schema for integrated clinical and translational data management in clinical trials |
| URI | https://www.ncbi.nlm.nih.gov/pubmed/39720844 https://www.proquest.com/docview/3149069463 |
| Volume | 22 |
| WOSCitedRecordID | wos001382697200001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwpV1LS8QwEA7qinjx_VhfRPAa7CPbJidZxMWDu6yosLclTSYguO1qV3-_kzRbLx4ELz2EDrTpNPPN8yPkSmWKiwiAxQZ_Nw6xZajKMZOFtrmCyKSyIZvIRyMxmchxCLjVoaxyeSb6g9pU2sXIr1OE8q5JM0tv5u_MsUa57Gqg0FglnRShjCvpyidtFiERPT-GE0F3hCiyl4asphu45NYQ-fR8WqnlmPsVYXpLM9j-7zPukK2AMWm_UYpdsgLlHtkYhiz6Pqn6JXWsWayJ3NOnxwfqKkWdRaPo7cJMUcSytB0lYeiygZKq0tCFs29vIYroJemsraJBqZ-7PSdIfUBeBnfPt_csEC8wzWO5YJkViPLyXKeQ5gDaCqkSg2sanUHrhppxK6wAmRldoIciIQGItZWJLThCkuSQrJVVCceEWsPzDEAUES9ck61QRjsLKcEqEamsSy6XWzlFxXbZClVC9VlPfzazS46a7zGdNxM4pgiikkhwfvIH6VOymTjOXh85OSMdi-8N52Rdfy1e648LrzF4HY2H3znLy6g |
| linkProvider | ProQuest |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=An+open-source+SQL+database+schema+for+integrated+clinical+and+translational+data+management+in+clinical+trials&rft.jtitle=Clinical+trials+%28London%2C+England%29&rft.au=Niazi%2C+Umar&rft.au=Stuart%2C+Charlotte&rft.au=Soares%2C+Patricia&rft.au=Foure%2C+Vincent&rft.date=2025-06-01&rft.issn=1740-7753&rft.eissn=1740-7753&rft.spage=17407745241304331&rft_id=info:doi/10.1177%2F17407745241304331&rft.externalDBID=NO_FULL_TEXT |
| thumbnail_l | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1740-7753&client=summon |
| thumbnail_m | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1740-7753&client=summon |
| thumbnail_s | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1740-7753&client=summon |