Library Management System
Enterprise library catalog, member management, book tracking, and fine calculation system built with Java, Spring Boot, and MySQL.
Backend Software Engineer
Independent Academic Project
Enterprise Software Project
Backend & Database Architecture
June 2025
Spring Boot + MySQL
The Problem & Real-World Friction
Academic and institutional libraries require structured cataloging, member checkout tracking, and automated fine calculation.
Architectural & Technical Approach
Engineered a backend system with Java, Spring Boot, Hibernate/JPA, and MySQL implementing clear domain boundaries, transaction safety, and REST APIs.
Key Technical Highlights
Clean Architecture Spring Boot & MySQL Platform
Clean Architecture & Domain Boundaries
Decoupled domain models, interface adapters, and JPA persistence adhering to strict SOLID principles and clean code standards.
ACID Transactional Integrity
Hibernate/JPA transactional boundaries guaranteeing consistency during concurrent book checkouts, renewals, and returns.
Automated Fine Calculation Engine
Automated business logic calculating overdue book fines dynamically based on membership tier and return grace periods.
Optimized MySQL Indexing
B-Tree indexed catalog search supporting multi-parameter queries across ISBNs, authors, categories, and availability status.
Project Results & Impact
Robust backend service maintaining relational integrity and automated business logic.
Reproducible Benchmarks & Test Setup
Test setup, evaluation procedure, and validated outcomes reported for this architecture:
June 2025
MySQL 8.0 indexed query execution over 18,500 simulated book records.
Outcome: Sub-25ms response time on multi-table join searches with pagination.
Separation of Implemented, Prototyped & Planned Features
- •Spring Data JPA repositories with custom pagination and filtering
- •ACID transactional book loan issue and return service
- •Dynamic fine calculation engine with automated grace period accounting
- •Barcode scanner hardware integration via web USB
- •Automated member SMS return reminders via cron worker
Role & Contributions
Backend Software Engineer
Independent Academic Project
- Engineered Spring Boot REST API adhering to Clean Architecture and SOLID principles.
- Designed MySQL relational database with ACID transactional boundaries for checkout and returns.
- Built automated fine escalation engine and barcode scanner validation endpoint.
Technologies Used
6 toolsCivic AI
AI-powered civic issue reporting and government management platform that won Champion at the AI & API Hackathon 2026.
View next case studyInterested in this architecture?
Have a question about the system design, tech stack, or potential collaboration?
Let's discuss