Case Study Community Resource Portal for the Healthcare Sector
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 1
Client
Requirement
This is an example of a massive medical website offering transparent insight into the whole medical industry. The website is designed to provide fact-based insights into the product quality and performance to help patients, providers, payors, manufacturers and others make informed decisions. Owning to its huge structure the client expected the following features:
• • • • • • • • • • • •
Scalable and reliable database technology Impeccable database performance offering alerts on millions of adverse event reports Better algorithms for manual cleaning and logical linking of various data sets Latest graphical representation technology for better visualization and reporting Advanced security features Development of several features such as rating system, importing reports and so on Better categorical divisions Advanced search features Login features Printing options and filters wherever necessary Dashboards summarizing the information Inclusion of social networking features
Project
Challenges
According to the requirement, client demanded high-ranking search techniques to be implemented in the application. Apache Solar which is a competent technology is used to meet user requirement. The application can now search according to various sections such as search according to tags, geographical focus, category based, related disciplines and so on. We included automated meta-tagging feature in this website. Also cross-linking and creating extended core taxonomy fields came as a challenge. As the website includes the community networking features, Drupal framework was used to ease the task of creating social login. Other challenges include addition of quality graphical representation at any and every place in the website and importing data by CSV for all the content type.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 2
Technologies Used Operating System & Server Management
Development Tools & Environments Database
Linux 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 Drupal 6.22, Solr Server, Java Script, AJAX, Apache 2.0 Handler MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Manpower
Project Leader
1
Developers
1
Designers
1
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 3
Planning The enormous structure of the website and the challenges involved necessitated the adoption of a four-tier approach that consisted of: •
MySQL Server Database, Tables, Stored Procedures etc… incorporated within the database layer.
•
Conversion of data between incompatible type systems in databases and accessing data from the database for the Interface layer and Database Abstraction layer respectively.
•
All the business logic procedures for modules such as User Profiles, Invitations, Forums and Blogs etc… forming the Business Logic layer.
•
The GUI of the website formed by the User Interface layer.
Architecture The website was mainly characterized by rich user data and featured extensive capabilities of social networking nature which entailed MySQL Server and Drupal. The development structure was specifically implemented to facilitate the ‘Faster to Market’ transition of such concepts. Drupal Framework was used to develop modules like User Profiles, Invitations, Forums, Blogs and other modules such that direct execution from the UI layer was possible. Effective access to the database in an object oriented context was implemented using an interface translating the object logic to relational logic so as to communicate with the relational databases in an object-oriented manner. Access to the database was enabled through the creation of an intermediary abstraction layer. Scrum methodology was used to manage risk and to make effective changes. Due to its higher productivity and lower costs, scrum lets us create a flexible agile process.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4