A NoSQL document based eCRF system for study of vaccines with variable adverse events case study on COVID19 vaccines

In case report studies (adverse effects of drugs/vaccines) that are unstructured, a structured relational model is not applicable for designing a database, necessitating the use of an unstructured data model, specifically NoSQL. Therefore, the most important and optimal unstructured data model for eCRF, which has the nature of a form, is the document-oriented model. This paper develops and evaluates a reporting system for drug intervention studies with high variability in adverse events that utilizes a document-based NoSQL data model and the eCRF nature, allowing for the management of structured and unstructured data. The main objective of the research is to create a flexible, fast, and efficient system for collecting and analyzing data related to drug/vaccine adverse events, especially the COVID-19 vaccine, for stakeholders. This research is of an applied-descriptive type. In this research, first, after studying library resources, the requirements and requirements for the design of the proposed system were determined in the form of the Software requirements specification (SRS) standard. Then, the design and implementation included modeling and creating a prototype of the web-based system. To evaluate usability, the User Experience Questionnaire (UEQ) was used, system security was assessed using the Application Security Verification Standard (ASVS) questionnaire, and a comparative evaluation of the performance between MongoDB and SQLServer was performed. This research was conducted with the aim of designing and evaluating a reporting system for COVID-19 vaccine side effects, based on a document-oriented data model. It includes key components such as the information and side effects collection module, the document management module, and the reporting module. The results indicated that the user experience of the system, in terms of attractiveness, transparency, efficiency, reliability, motivation, and innovation, had an average score of 2.31, placing it within the top 10% of results. Additionally, the evaluations showed that the system employs effective security controls; however, improvements were needed in certain areas such as meeting management and authentication. A comparative assessment of the performance between the document-oriented data model and the relational data model demonstrated that the proposed system was able to provide better performance in response time and management of unstructured data. Evaluations have shown that utilizing case report forms, along with the advantages of a document-oriented data model, can be effective in collecting the minimum necessary data set for interventional studies, particularly those related to drug side effects such as the COVID-19 vaccine. Given the variable nature of the virus and the potential for unknown side effects, this requires flexible and precise approaches. Additionally, the use of the existing system, considering the results of the security and usability assessment, could be effective if access to external systems is improved.