Christian Medical College, Vellore (CMC Vellore) is a hospital and medical teaching institute in southern India. The hospital and its outreach centers provide emergency, inpatient, and outpatient treatment to more than two million people in India, and from countries such as Bangladesh, Pakistan, and Sri Lanka. The medical institute trains more than 1,000 students a year in a variety of medical disciplines, including anesthesiology, general medicine, and nursing.
CMC Vellore stores medical and administrative data for patients, staff, and students in its primary hospital information system. The organization wanted to ensure system availability 24 hours a day, seven days a week, so the hospital and college could operate efficiently. It also wanted to add financial data to the information system.
CMC Vellore decided to upgrade to Oracle Database 11g, Enterprise Edition with Real Application Clusters and implement Oracle Enterprise Manager to achieve 99.999% availability and eliminate system downtime during scheduled maintenance. The upgrade also improved system performance by approximately 50%—enabling it to complete month-end financial processes more quickly. It can now generate pharmaceutical drug usage reports in 20 minutes, compared to 3.5 hours, previously.
CMC Vellore has been using Oracle Database since 2001 and is continuously impressed by its strength, speed, and scalability. The organization also uses Oracle’s PeopleSoft Campus Solutions to manage its medical college administrative information and wanted to continue using products from the same vendor for its infrastructure.
“We didn’t look at other databases, as we knew Oracle Database is always best in class,” said Ebenezer Sundararaj, systems manager, Christian Medical College, Vellore. “We wanted to take advantage of the enhanced availability of Oracle Database, Enterprise Edition 11g, and since we were already happy with the previous database’s performance, it was an added bonus to achieve such a great improvement.”
CMC Vellore completed the upgrade to Oracle Database 11g, Enterprise Edition with Real Application Clusters and Oracle Audit Vault, in just one month. The organization also implemented Oracle Enterprise Manager Database Management Diagnostic and Tuning Packs.
The new infrastructure went live in May 2010, followed by Oracle Advanced Analytics in June 2010.
CMC Vellore engaged Oracle Specialized Partner Tata Consulting Services Limited to support the organization’s in-house team during the main database upgrade. CMC Vellore then worked with Oracle Advanced Customer Support Services to install the new two-node disaster recovery database.
“Both Tata Consulting Services Limited and Oracle Advanced Customer Support Services provided excellent support throughout the project, and we were very pleased with their services,” said Sundararaj.