Case Study CLIENT - Healthcare Management SystemImplementation
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 1
Client
Requirement
CLIENT - Healthcare Management System is a huge web-based application created exclusively for CLIENT Hospital and Medical College for handling patient data starting from patient admission to discharge. The application included recording of patient data, money collection, bill generation, scheduling, pharmacy purchase and sale, stores management, laboratory and radiology management, blood bank etc. The application being web-based could be accessed from anywhere without any installation. The application is based on MVC architecture with ability to take load of huge number of patient data. User role management provided the user functions to control every user’s rights and accessibility. Following is the list of modules present in the CLIENT - Healthcare system.
Reception and Appointment Scheduling Out Patient Management In Patient Management Laboratory and Radiology Management Operation Theatre Management Pharmacy Management Stores Management & Purchases Management Billing (Cash & Credit) Account & Receivables (Cash & Credit) Contract Management Security and Administration MIS and Department Reports Medical Reports Blood Bank CSSD Bio Medical and Maintenance Personnel and Payroll
Project
Challenges
Team faced the following challenges:
Developing a system that was capable of delivering good performance and speed to handle hospital patient records and multi-user access.
Developing a system with ability to handle data extracted from old hospital information system being used by the client.
Integration with Laboratory equipments and saving the output data at runtime into the database.
Designing a system such that it covers all the hospital modules and be user-friendly to be a single-point of access for all hospital users.
Ensuring safe and secure transfer of data.
www.brainvire.com | © 2014 Brainvire Infotech Pvt. Ltd
Page 2 of 2
Technologies Operating System & Server Management
Development Tools & Environments
Used Windows OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance ASP.Net, MVC, C#, SSRS etc. MSSQL Database Server 2008, Report Service (SSRS), DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Database
Manpower Project Leader
2
Developers
4
Designers
2
Quality Assurance Testers
2
Planning Taking into consideration the functionality of the server the following development areas were charted out to be elaborated upon: The web server using HTTP protocol for communication with the web browser. System-level windows services were developed in order for capturing data from the laboratory equipments. Desktop-based executable was developed in order to ensure that equipment exported data is inserted into the database. Requirement gathering was done on-site and complete development was done off-site. The equipment integration was carried out on-site parallel to deployment. www.brainvire.com | © 2014 Brainvire Infotech Pvt. Ltd
Page 3 of 3
 Complex Reporting.
Architecture We are using 3-tier architecture which provides Presentation layer (PL), Business Access layer (BL) and Data Access layer (DAL). BAL: Business Access layer contains business logic, validation related to the data. DAL: Data Access layer contains method which helps Business layer to connect the data and perform required action like returning data or manipulating data (insert, delete, update). PL: Presentation layer contain .asp or html where data is presented to the user and inputs are taken from the users. Deployment Architecture For deployment we are using Windows Server 2008 with IIS7. We are using MVC architecture. Benefits of MVC are given below: 1. 2. 3. 4. 5. 6. 7. 8. 9.
Enables the full control over the rendered HTML. Provides clean separation of concerns (SoC). Enables Test Driven Development (TDD). Easy integration with JavaScript frameworks. Follows the design of stateless nature of the web. Restful urls that enables SEO. No View-State and Post-Back events. It provides RAD development. Easy development models for developers those coming from WinForm development.
Development
Highlights
The application provided the client with a system capable of handling all hospital data and with ease of access for everyone. The detailed requirement gathering done on-site helped setting up a well-designed system with all modules integrated into it along with control over user access. Laboratory equipment data was easily transported from machine to the database and in turn shown to the user on web interface. The control of site was given to administrator, who can set up users, user roles and assign page-level access to each of these roles.
www.brainvire.com | Š 2014 Brainvire Infotech Pvt. Ltd
Page 4 of 4