Build a Drug Trial Database with the Multi-Model SurrealDB
A third case study of the clinical trials
A drug trial evaluates drug safety, efficacy, and effectiveness in human subjects. It is a crucial step in the drug development process before a drug can be approved for public use. But it is expensive. Moore et al. estimated that the median cost of 101 drug trials between 2015 and 2017 was US$48 million. One of the primary challenges in drug trials is promoting awareness and recruiting volunteers. Many patients are unfamiliar with the concept of drug trials, let alone considering them as a potential treatment option. One potential solution to this problem is the development of a user-friendly drug trial search engine. It could increase awareness of drug trials, making it easier for patients to find and participate in studies relevant to their needs.
In my two preceding articles, I developed two prototypes: Clinical Trial Search with Google Spanner: Graph, SQL, Vector, and LLM All in One Query and PostgreSQL Goes Multi-Model: Graph, Vector, and SQL, They were constructed using Google Spanner and PostgreSQL, respectively. Both platforms are multi-model. Specifically, data for drugs, disorders, mechanisms of action (MOA), and trials were stored in a combination of graph, table, and vector formats. Users can search the data across all the models with…
