No abstract

No abstract

Aim:Animal experiments tend to generate large-scale data. Some existing tools like Microsoft Excel and colony management cloud-based tools are either cumbersome or expensive. There is a need for an inexpensive and uncomplicated colony management software with specific individual database solutions.Methods:We have developed a database application named RodentSQL to meet most of the requirements of such animal colony management programs.Results:We present a user-friendly secure system for managing records of phenotype, genotype and metadata for comprehensive data analysis and mining. RodentSQL can be altered based upon user needs. We have successfully tested its usage in beta users for managing data of hamsters and mice.Conclusion:A central facility can share and benefit from this colony management system. RodentSQL can increase workflow efficiency and data security leading to significant cost savings and enhanced scientific results. RodentSQL is offered to the scientific community as an open source software.

Notebooks in research are an important part in tracking information of both wet and dry analytical data. Paper books or excel sheets remain the most popular and conventional ways of record keeping. To meet these demands, an open source electronic laboratory notebook is developed that can track users research need. Based on the user specifications, this suite is written in Hypertext Pre-processor (PHP) and based on a MySQL relational database. It enables the set-up of single or a multi-users access controls. A Linux server hosts the application and database. The hardware requirements of suite on the server side are moderate. Bounds and ranges have also been considered and need to be used according to the user instructions. The sharing can be limited to single individual or between research groups. Adequate server and database security measures and daily backups have been provided making its availability long-lasting and protecting data from aging damage. Important notable advantages of this system are that it runs entirely in the web browser with no client software need, industry standard server supporting major operating systems (Windows, Linux and OSX), and ability to upload and store external files. After testing and validating this suite on beta-users for 48 days, it has proven to bring higher quality documentation, data recording and retrieving information with un-parallel higher security. This suite is scalable to the size of laboratory by increasing server space with limited resources. Availability: The electronic notebook is hosted on personal linux server and can be accessed at: http://131.96.32.229/login-system/index.php Key words: Internet/Web-based learning, pedagogy, database, hypertext pre-processor (PHP), electronic laboratory notebook.

Several clinical trials using different interventions are being sponsored to combat human immunodeficiency virus (HIV) at different stages. For evidence-based knowledge studies in medicine, clinical trials are of utmost importance. A legislative requirement to register the clinical trials at the Clinical-Trials.gov provides the information necessary for intensive evaluation, which was previously not possible. The purpose of this study was to provide an intensive portfolio of HIV clinical trials and perform a retrospective ClinicalTrials.gov data review. All active, open, and recruiting clinical trials registered at ClinicalTrials.gov up to May 2018 were included. Information related to trial characteristics, intervention type, primary outcome, and patient enrollment timeline was extracted. Information related to 10,182 registered HIV trials was download from ClinicalTrials.gov. Phase 2 clinical trials were the major ones comprising nearly 1.6% of total clinical trials with the industry being the major sponsor followed by NIH. Other characteristics analyzed included the number of trial centers, primary outcome, treatment setting, and time relation with phases. Common intervention were classified into adjuvant, non-adjuvant, and radiotherapy. The clinical trials data analysis provides a comprehensive description of HIV trials. The information provided may be useful to re-tailor the intervention techniques and to overcome the discrepancy in data management for clinical trials which would improve clinical trial design, and reduce failures and cost of trials.