|Year : 2014 | Volume
| Issue : 2 | Page : 182-185
Development of a web-based glaucoma registry at King Khaled Eye Specialist Hospital, Saudi Arabia: A cost-effective methodology
Babar Zaman1, Rajiv Khandekar1, Sami Al Shahwan1, Jonathan Song2, Ibrahim Al Jadaan1, Leyla Al Jiasim1, Ohood Owaydha1, Nasira Asghar1, Amar Hijazi3, Deepak P Edward2
1 Department of Research, King Khaled Eye Specialist Hospital, Riyadh, Saudi Arabia
2 Department of Research, King Khaled Eye Specialist Hospital, Riyadh, Saudi Arabia; Wilmer Eye Institute, Johns Hopkins University, School of Medicine, Baltimore, Maryland, United States of America
3 Department of Information Technology, King Khaled Eye Specialist Hospital, Riyadh, Saudi Arabia
|Date of Web Publication||1-Apr-2014|
Department of Research, King Khaled Eye Specialist Hospital, POB: 7191, Riyadh 11462, Saudi Arabia
Source of Support: None, Conflict of Interest: None
| Abstract|| |
In this brief communication, we present the steps used to establish a web-based congenital glaucoma registry at our institution. The contents of a case report form (CRF) were developed by a group of glaucoma subspecialists. Information Technology (IT) specialists used Lime Survey softwareTM to create an electronic CRF. A MY Structured Query Language (MySQL) server was used as a database with a virtual machine operating system. Two ophthalmologists and 2 IT specialists worked for 7 hours, and a biostatistician and a data registrar worked for 24 hours each to establish the electronic CRF. Using the CRF which was transferred to the Lime survey tool, and the MYSQL server application, data could be directly stored in spreadsheet programs that included Microsoft Excel, SPSS, and R-Language and queried in real-time. In a pilot test, clinical data from 80 patients with congenital glaucoma were entered into the registry and successful descriptive analysis and data entry validation was performed. A web-based disease registry was established in a short period of time in a cost-efficient manner using available resources and a team-based approach.
Keywords: Congenital Glaucoma, Health Register, Web-Based Registry
|How to cite this article:|
Zaman B, Khandekar R, Al Shahwan S, Song J, Al Jadaan I, Al Jiasim L, Owaydha O, Asghar N, Hijazi A, Edward DP. Development of a web-based glaucoma registry at King Khaled Eye Specialist Hospital, Saudi Arabia: A cost-effective methodology. Middle East Afr J Ophthalmol 2014;21:182-5
|How to cite this URL:|
Zaman B, Khandekar R, Al Shahwan S, Song J, Al Jadaan I, Al Jiasim L, Owaydha O, Asghar N, Hijazi A, Edward DP. Development of a web-based glaucoma registry at King Khaled Eye Specialist Hospital, Saudi Arabia: A cost-effective methodology. Middle East Afr J Ophthalmol [serial online] 2014 [cited 2022 Aug 19];21:182-5. Available from: http://www.meajo.org/text.asp?2014/21/2/182/129773
| Introduction|| |
Disease registries are important tools for tracking disease trends or treatment outcomes. ,, The health/disease registry could be hospital/clinic-based or population based. The former is used for a specific disease irrespective of the location of the case. Alternately, a population based registry is used to compile information on specified diseases by region, community, and state in which they are diagnosed.  They exist in different formats; paper based registries, the most common types of registries in the past were complemented over time by computerized records. In recent years, web-based registries have become popular because they are user friendly and can be managed from different locations. Additionally, the web-based approach overcomes data management issues and allows for periodic generation of information for monitoring and policy making. Health managers at hospitals, national, and international levels use web-based registries to compile information on different health issues. ,,
Since 1983, paper and computer-based retinoblastoma and tumor registries had been in place at the King Khaled Eye Specialist Hospital (KKESH) Riyadh, Saudi Arabia. , On the basis of the computer-based congenital glaucoma registry, baseline features of primary and secondary congenital glaucoma were described.  Saudi Arabia has one of the highest incidences of primary congenital glaucoma worldwide.  However, there is a relative paucity of information on the outcomes of managed children. A simple, yet effective web-based registry was created to prospectively collect data on congenital glaucoma. To the best of our knowledge, web-based registries have not been used to track outcomes or disease trends in congenital glaucoma (CG). We also discuss the validity and cost effectiveness of this registry.
| Methods|| |
This study was undertaken between January 2012 and March 2013. The approval of research department of (KKESH) was obtained information from paper/computer registry. A registry committee comprising of ophthalmologists, epidemiologist, statistician, information and a technology specialists, and a registry manager was formed.
Two glaucoma specialists prepared a case report form (CRF) that included a questionnaire on congenital glaucoma [Table 1]. They also defined mandatory fields/questions. Information technology specialists provided the Lime Survey form (Lime Survey 2.05, Germany) that is available without cost.  All the CRF questions were incorporated as an electronic form in the Lime Survey software. To minimize manual entry by the end user, drop down boxes and check boxes were used for data entry. The biostatistician checked the validity of the case report form to ensure that the questionnaire could gather sufficient information from end users as per the registry manual that was prepared for web-based data entry. A person with basic knowledge of database and programming should be able to use 'MySQL' software and create an electronic CRF using 'Lyme Survey'. The eCRF was then linked to 'MySQL' software through a virtual machine operating system in the IT department at KKESH.  This system in KKESH is subscription based and is used by numerous departments in the hospital. Hence, use of this system for CGR was a small fraction of the total cost of this service.
|Table 1: Cost analysis by full time equivalent for establishing a web-based congenital glaucoma registry|
Click here to view
To make the registry web based, a Uniform Resource Locator (URL) was created for the CGR.  The website could only be accessed with a unique login identification and password. The data manager provided access for data entry via the URL. The web-based CGR was tested by entering the data from different locations. The CGR data was tested and could be exported to common analytical software such as Statistical Package for Social Studies (SPSS, IBM Corp., New York, NY, USA) and R-language. ,
The individuals involved in establishing the CGR were interviewed to determine the approximate time they spent in developing the online registry. From their responses, we calculated the Full Time Equivalent (FTE). A cost analysis based on FTE spent in establishing a web-based CG registry was performed.
The time required for completing one CGR form was calculated. The time to analyze and interpret the CGR by a data manager was also calculated.
| Results|| |
The algorithm to establish the CGR is illustrated in [Figure 1]. An example of populated drop boxes in the electronic CRF is presented in [Figure 2].
|Figure 2: Populated drop boxes in electronic case report form (CRF) for congenital glaucoma registry|
Click here to view
The data of 80 patients from an existing paper/computer based CGR at KKESH (2000 to 2003) was entered in the electronic CRF as a pilot project. Descriptive analyses of the 80 cases were performed and plotted using an automatic outcomes function available in the Lime survey software. This exercise enabled a validity check of the computer-based registry.
The time for a clinician or data entry personnel to complete the CRF during clinical assessment was less than 4 minutes.
The web-based registry was easily accessible from different locations following signature. In addition, automated descriptive analysis in a graph format could be generated [Figure 3].
|Figure 3: Web-based congenital glaucoma registry generated automated graphical display of outcomes|
Click here to view
The cost analysis based on the full time equivalent (FTE) spent in establishing web-based CG registry is presented in [Table 1].
| Discussion|| |
Web-based registries have been previously established in other fields of medicine. ,, Most involve conversion of existing manual and computer-based registries to web-based registries. Experience in other fields of medicine indicated that these registries are sustainable because they are user friendly, easily accessible from any part of the world, provide epidemiological data with minimum errors, and have important applications.
In this study, we outline the process of creating a web-based CGR using 'off the shelf' software, and based on our experience it was relatively easy to establish. Some of the key components in making the endeavor successful was to have a knowledgeable ophthalmic and IT team combined with an efficient data entry manager and biostatistician. A cost analysis of the registry included factors such as human resources, equipment, and supplies and it was determined that a product was created at a fraction of the cost of commercially available or customized databases. Some of the cost savings achieved during this project were related to the existing infrastructure in the hospital's information technology department and the free downloadable software. An accurate estimate of actual cost of commercially available or customize databases was not available despite attempts to procure information on specific costs. However, rough estimates from personal communication with local institutions in Saudi Arabia that maintain registries suggested that the costs of customizing and maintaining registries/databases are much higher.
From the clinician's perspective, the feedback received was that the data entry was intuitive, quick, and easy, and that allied health personnel could be trained to enter the data. Also of importance was the data could be entered at any workstation connected to the Internet or intranet. We believe that this process which includes additional data entry other than what is entered in the medical record will not decrease the efficiency of clinical practice. The software feature of generating automated descriptive analysis plotted on graphs will help track data in real time enabling the data manager to prepare policy briefs in an efficient manner. Due to the relatively simple IT infrastructure required, we suggest that establishment of similar registries would be feasible in most developing countries. The cost of FTE in each country would differ. Hence, providing cost in terms of "dollars" would not be practical. Individuals from each country that plan to use such a registry would need to calculate costs per FTE.
Since the registry is web-based, it is feasible for such a registry to be used to collect data from multiple centers nationally or internationally and could be created for any ophthalmic condition. The web-based registry has already been expanded to other diseases and pathology such as retinoblastoma, ocular tumors, retinal dystrophies, and keratoconus at our institute. These registries will soon cover the Kingdom and then the gulf countries. Since the IT infrastructure is simple it can be located at only one institution, and the costs associated with creating and maintaining the registry will be further reduced. To the best of our knowledge, such a web-based registry has been created for diabetic patients with data on 10,000 cases. 
It is possible that one of the weaknesses of establishing such a registry might be accommodating large data sets. In addition, a potential weakness is the discontinuation of free downloadable software or the absence of technical support for this product in the future may cause difficulties in continuing additional data entry using the same format. However, since the data stored on a My SQL server internally, data that was collected would not be lost. Congenital glaucoma registry information was collected from both glaucoma and pediatric ophthalmology units at KKESH. The pilot was based on transferring retrospective data from a paper-based registry to a web-based registry. The actual data collection henceforth would be prospective. If many institutions are involved in the registry, the time required to register a case could be longer than that described in the current study. Cloud testing by external institutions could further strengthen the web-based CGR. Using cloud computing, the development for a larger storage capacity should also be explored.
| References|| |
|1.||Khandekar R, Al Harby S. National Register for the Blind: A tool for health programme management. East Mediterr Health J 2006;12:170-7. |
|2.||Demirkaya E, Ozen S, Bilginer Y, Ayaz NA, Makay BB, Unsal E, et al. The distribution of juvenile idiopathic arthritis in the eastern Mediterranean: Results from the registry of the Turkish Paediatric Rheumatology Association. Clin Exp Rheumatol 2011;29:111-6. |
|3.||Goh PP, Shamala R, Chandamalar S, Tai XY; National Eye Database Study Group. Contact lens--related corneal ulcer: A two-year review. Med J Malaysia 2010;65:120-3. |
|4.||Drolet BC, Johnson KB. Categorizing the world of registries. J Biomed Inform 2008;41:1009-20. |
|5.||Wang Y, Le LH, Wang X, Tao Z, Druschel CD, Cross PK, et al. Development of web-based geocoding applications for the population-based birth defects surveillance system in New York state. J Registry Manag 2010;37:16-21. |
|6.||Mouttalib S, Rice HE, Snyder D, Levens JS, Reiter A, Soler P, et al. Evaluation of partial and total splenectomy in children with sickle cell disease using an Internet-based registry. Pediatr Blood Cancer 2012;59:100-4. |
|7.||Samaras L, García-Barriocanal E, Sicilia MA. Syndromic surveillance models using Web data: The case of scarlet fever in the UK. Inform Health Soc Care 2012;37:106-24. |
|8.||Mullaney PB, Karcioglu ZA, al-Mesfer S, Dowaidi M. Retinoblastoma referral patterns in Saudi Arabia. Ophthalmic Epidemiol 1996;3:35-46. |
|9.||Alsuhaibani AH. Uveal melanoma in the Saudi Arabian population: Two decades of management at the King Khaled Eye Specialist Hospital. Saudi J Ophthalmol 2009;23:157-63. |
|10.||Alanazi FF, Song JC, Mousa A, Morales J, Al Shahwan S, Alodhayb S, et al. Primary and secondary congenital glaucoma: Baseline features from a registry at king khaled eye specialist hospital, Riyadh, Saudi Arabia. Am J Ophthalmol 2013;155:882-9. |
|11.||Lime Survey. Available from: http://www.limesurvey.org/. [Last accessed on 2013 Mar 13]. |
|12.||MySQL 5.6. Available from: http://www.mysql.com/products/enterprise/database/. [Last accessed on 2013 Mar 13]. |
|13.||Disease registry in King Khaled Eye Specialist Hospital Research Department. Available from: http://registries.kkesh.med.sa/admin/admin.php?action=logout. [Last accessed on 2013 Mar 13]. |
|14.||Norus MJ. Statistical Package for Social Studies, Guide to analysis (SPSS Inc) Upper Saddle River, New Jersey, USA: Prentice Hall; 2006. |
|15.||The R Project for Statistical Computing. Available from: http://www.r-project.org/. [Last accessed on 2013 Mar 13]. |
|16.||Cuadros J, Bresnick G. EyePACS: An adaptable telemedicine system for diabetic retinopathy screening. J Diabetes Sci Technol 2009;3:509-16. |
[Figure 1], [Figure 2], [Figure 3]