EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

An open-source SQL database schema for integrated clinical and translational data management in clinical trials

Umar Niazi iD, Charlotte Stuart, Patricia Soares, Vincent Foure, Gareth Griffiths

Clinical Trials · 2025

DOI: 10.1177/17407745241304331 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Clinical Trials, 2025. Verfasst von Umar Niazi und 4 weiteren Autor:innen. Beteiligte Einrichtung: Cancer Research UK Southampton Clinical Trials Unit, MP131, Southampton General Hospital, University of Southampton, Southampton, UK. Hauptthemen laut MEDLINE: Clinical Trials as Topic, Translational Research, Biomedical, Data Management, Databases, Factual. Die Arbeit nennt 4 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0). Gefördert von: Cancer Research UK.

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

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.

Schlagwörter

MeSH-Schlagwörter (MEDLINE)

Clinical Trials as TopicTranslational Research, BiomedicalData ManagementDatabases, FactualDatabase Management SystemsHumansInformation DisseminationPrecision MedicineUnited Kingdom

Stichwörter der Autor:innen

Open-source SQL database schema for clinical trialsclinical trial data integration with translational datapersonalised medicine in clinical research

Autor:innen und Institutionen

  • Cancer Research UK Southampton Clinical Trials Unit, MP131, Southampton General Hospital, University of Southampton, Southampton, UK.
  • iSolutions, University of Southampton, Southampton, UK.

ORCID-Profile: Umar Niazi

Förderung

  • Cancer Research UK

Zitieren

APA

Niazi, U., Stuart, C., Soares, P., Foure, V., & Griffiths, G. (2025). An open-source SQL database schema for integrated clinical and translational data management in clinical trials. Clinical Trials. https://doi.org/10.1177/17407745241304331

Vancouver

Niazi U, Stuart C, Soares P, Foure V, Griffiths G. An open-source SQL database schema for integrated clinical and translational data management in clinical trials. Clinical Trials. 2025. doi:10.1177/17407745241304331

BibTeX
@article{Niazi2025,
  author = {Niazi, Umar and Stuart, Charlotte and Soares, Patricia and Foure, Vincent and Griffiths, Gareth},
  title = {An open-source SQL database schema for integrated clinical and translational data management in clinical trials},
  journal = {Clinical Trials},
  year = {2025},
  doi = {10.1177/17407745241304331}
}
Kostenlos starten →