Donor Management System – 2+ Million Records

Management of a large organ database with 2+ million records using Joomla. New records in huge volume were imported into the database on a monthly basis and search queries are performed on a daily basis to access the donor information.

Project Summary

The system was developed to provide an online interface to users who want to register as an organ donor. The website received over 2 million registrations over time and new data is being added on a continued basis from more than one source. The website was developed to be responsive and the donor form was optimized for the mobile screens to capture the registration data efficiently. Apart from a comprehensive organ donation form, the site also accepted monetary donations through online payment system integrated with multiple payment solutions to choose from. The system was a collection of more than one website and all the websites were developed on the Joomla CMS platform. The donor data was maintained using a custom developed Joomla component that offered multiple useful features helpful in managing a large database.

Some of these useful features included tools for fresh data import, tools for data deduplication and data cleanup tools. System performance was one of the key focuses for this project as we were dealing with an extraordinarily high volume of data. Several database optimization techniques were implemented to achieve a seamless user experience for both the site users and the administrators. The system handled a large amount of search queries on a daily basis and offered a very high performance. Reporting was another important feature that was implemented as a part of the administrative features.


Technologies

PHP, MySQL, HTML, CSS, Java Script, jQuery, AJAX, JSON, Web Services, Joomla

php
mysql
html
...
...
...
...
...
...

Screenshots


Use Case Summary

The summary of various use cases for this website is listed below. These include both the frontend and administrative functions for the website.

  1. Donor Registration
  2. Online Donations
  3. Content Setup
  4. Donor Database Management

  1. Export Data
  2. Import Data
  3. Data Deduplication
  4. Search

  1. Advanced Search
  2. Multicolumn Sort
  3. Filter
  4. Reporting (Textual/Graphical)

  1. Payment Integration
  2. Payment Reports
  3. Template Installations
  4. Multisite Configuration

 

Case Studies