Development of a Cost-Effective Database Software for Psychiatric Research: A Study From Tertiary Care Teaching Hospital

Background: Technological progression made drastic changes in health care. Still there is a growing concern about proper utilization of health information within hospitals for various research activities. Huge volumes of such health information in majority of hospitals are redundant due to lack of appropriate and cost-effective technological tools for retrieving relevant health information for research purpose. Objective: To develop a cost-effective and user-friendly computerized medical record database for psychiatry using available technology with the department. Methodology: Study performed at a tertiary care teaching hospital in Udupi district of South India. Various datasets from psychiatry medical records were utilized for the design and creation of database. A computerized database called PsyCase was developed with the help of technology available within the department. A 4612 patient’s data were entered into the PsyCase and subjected to various analyses. Results: Applications of PsyCase in various epidemiological studies were explored through performing numerous analyses with actual data. PsyCase was found effective in supporting psychiatric research as well as routine clinical and administrative activities. Conclusion: This study emphasizes need of appropriate use of technology available within a healthcare system to facilitate medical research in psychiatry and role of health information professional in such initiatives. Healthcare organization must focus on collective utilization of resources within the system to improve the utilization of health information for medical research

Using geographical information systems for management of back-pain data

This is the post-print version of the Article. The official published version can be accessed from the link below - Copyright @ 2002 MCB UP LtdIn the medical world, statistical visualisation has largely been confined to the realm of relatively simple geographical applications. This remains the case, even though hospitals have been collecting spatial data relating to patients. In particular, hospitals have a wealth of back pain information, which includes pain drawings, usually detailing the spatial distribution and type of pain suffered by back-pain patients. Proposes several technological solutions, which permit data within back-pain datasets to be digitally linked to the pain drawings in order to provide methods of computer-based data management and analysis. In particular, proposes the use of geographical information systems (GIS), up till now a tool used mainly in the geographic and cartographic domains, to provide novel and powerful ways of visualising and managing back-pain data. A comparative evaluation of the proposed solutions shows that, although adding complexity and cost, the GIS-based solution is the one most appropriate for visualisation and analysis of back-pain datasets

Recording of time-varying back-pain data: A wireless solution

Chronic back pain is a debilitating experience for a considerable proportion of the adult population, with a significant impact on countries’ economies and health systems. While there has been increasing anecdotal evidence to support the fact that for certain categories of patients (such as wheelchair users), the back pain experienced is dynamically varying with time, there is a relative scarcity of data to support and document this observation, with consequential impact upon such patients’ treatment and care. Part of the reason behind this state of affairs is the relative difficulty in gathering pain measurements at precisely defined moments in time. In this paper,we describe a wireless-enabled solution that collects both questionnaire and diagrammatic, visual-based data, via a pain drawing, which overcomes such limitations, enabling seamless data collection and its upload to a hospital server using existing wireless fidelity technology. Results show that it is generally perceived to be an easy-to-use and convenient solution to the challenges of anywhere/anytime data collection

Intuitive querying of e-Health data repositories

At the centre of the Clinical e-Science Framework (CLEF) project is a repository of well organised, detailed clinical histories, encoded as data that will be available for use in clinical care and in-silico medical experiments. An integral part of the CLEF workbench is a tool to allow biomedical researchers and clinicians to query – in an intuitive way – the repository of patient data. This paper describes the CLEF query editing interface, which makes use of natural language generation techniques in order to alleviate some of the problems generally faced by natural language and graphical query interfaces. The query interface also incorporates an answer renderer that dynamically generates responses in both natural language text and graphics