“CASE STUDY TOPIC NAME”

This case study report is submitted to

Department Of Computer Science & Engineering

By
Name of students

Under the guidance of

“Faculty Name”

WAINGANGA COLLEGE OF ENGINEERING AND MANAGEMENT

NAGPUR
2025-26
Instruction for case study:
1. Choose a Real-World Problem
Pick a topic that involves a clear technical challenge—like optimizing an algorithm,
deploying a cloud solution, or fixing a security vulnerability.
2. Do Your Research
Gather all relevant data: system specs, logs, user feedback, performance metrics, and any
academic or technical references.
3. Structure Your Case Study
Use this format:
 Title – Clear and specific (e.g., “Improving Database Query Speed Using Indexing in
MySQL”)
 Abstract / Executive Summary – A snapshot of the problem, solution, and outcome
 Background – Context about the system, organization, or environment
 Problem Statement – What went wrong or needed improvement?
 Objectives – What were you trying to achieve?
 Methodology – Tools, techniques, and data collection methods used
 Analysis / Findings – What did the data reveal?
 Solution / Implementation – What was done to fix or improve the situation?
 Results – Measurable outcomes (e.g., “reduced latency by 40%”)
 Conclusion – Lessons learned and future recommendations
 References – Cite all sources and tools used
4. Use Visuals
Include diagrams, flowcharts, or performance graphs to make your findings clearer and more
engaging.
5. Keep It Technical but Clear
Use precise terminology, but explain complex concepts so that even readers outside your
specialty can follow along.
(Add Geotag photo of your visit to the site it is mandatory )
Example for case study
Title:
Enhancing Web Application Performance Using Caching and Load Balancing: A Case Study
of EduPortal
Executive Summary
EduPortal, a fast-growing e-learning platform catering to over 50,000 students, encountered
severe performance issues during peak usage. This case study documents the technical
challenges encountered, the methodology adopted to investigate them, and the solutions
implemented—namely Redis caching and NGINX load balancing. The result was a 60%
improvement in load speed and near-perfect uptime, significantly enhancing user experience.
Key outcomes:
 Page load time decreased from 4.8s to 1.9s
 Uptime increased from 92% to 99.98%
 User complaints reduced by 80%
1. Background
EduPortal is an Indian e-learning platform offering video-based courses, quizzes, and
community features. The backend stack includes:
 Framework: Django (Python)
 Database: PostgreSQL
 Hosting: AWS EC2 ([Link] instances)
 Front-end: HTML5, Bootstrap, and jQuery
As the user base grew rapidly—particularly during exam periods—performance bottlenecks
began to surface, including increased latency and server timeouts.
2. Problem Statement
Despite sufficient backend infrastructure, users frequently experienced delays of up to 5
seconds while accessing key features such as logging in, streaming videos, and submitting
quizzes. More critically, server crashes during peak hours were causing academic disruptions,
leading to frustration among students and instructors.
3. Objectives
This case study aimed to:
 Improve average page load time to less than 2 seconds
 Minimize backend crashes during peak usage hours
  Improve scalability to support future user base growth
 Enhance overall user satisfaction
4. Methodology
The investigation involved a combination of:
 Performance Profiling Tools: New Relic and AWS CloudWatch
 Database Analysis: PostgreSQL logs and slow query reports
 Infrastructure Monitoring: EC2 CPU/RAM usage during load testing
 Feedback Collection: Surveys from 200+ active users
5. Findings / Analysis
 Approximately 40% of page load delay originated from repeated database queries
 Redis caching was not utilized, despite many repeat data requests (user sessions,
course data)
 Load testing revealed that CPU usage spiked above 90% with just 700 concurrent
users
 EC2 instances were under-optimized: static assets were being served directly instead
of via CDN
6. Proposed Solutions / Implementation
The following actions were taken:
Redis Caching:
 Cached user sessions and commonly accessed data like course metadata and quiz
content
 Reduced backend DB queries by 70%
NGINX Load Balancing:
 Implemented NGINX as a reverse proxy with round-robin load balancing across 3
EC2 instances
 Separated media assets and routed them via AWS CloudFront CDN
Code & Query Optimization:
 Added database indexes to high-traffic tables
 Refactored slow Django views and implemented async calls where feasible
7. Results
After implementation:
 Page load time dropped from 4.8 seconds to 1.9 seconds
 Uptime improved from 92% to 99.98%, eliminating crash reports
 User satisfaction survey showed an 80% drop in complaints
 The architecture is now scalable, with plans to introduce auto-scaling policies for
future traffic spikes
8. Conclusion
This case demonstrates how intelligent caching and load balancing, coupled with backend
optimization, can drastically improve the performance of web-based applications. As
EduPortal continues to scale, maintaining modular, scalable architecture will be key to
preserving reliability.
9. References
 Django Documentation (2024): Query Optimization and Caching
 New Relic Insights Report (2025): Peak Load Analysis for EduPortal
 AWS Whitepaper: Best Practices for Load Balancing and Scalability

Instruction for writing case study:

Repetition of the case study topic will not be accepted
Add more information related to your case study title.
The material above is for your reference only; do not use it in the same way.
A minimum of 1 or 2 geotagged photos is required.