Project Overview

The Library Classification & Book Collection Management System is a purpose-built desktop application designed to help educational institutions and libraries efficiently manage, analyze, and visualize their book collections using the Library of Congress (LC) classification framework.

The system replaces fragmented, manual record-keeping methods with a centralized, structured, and visual management platform. It enables library staff to maintain accurate classification records while providing administrators and stakeholders with real-time insights into collection distribution, growth, and gaps.

Built to operate offline and within local networks, the solution is ideal for institutions that require reliability, speed, and data ownership without dependence on internet connectivity.

The Challenge

Many libraries continue to rely on paper records or basic spreadsheets to manage their collections.

These approaches often result in:

• Data inconsistencies across departments and computers

• Limited visibility into collection strength and coverage

• Time-consuming reporting processes

• Difficulty tracking volumes across LC classifications

• Over-dependence on internet-based systems that are unreliable in local environments

These challenges hinder informed decision-making and long-term collection planning.

The Solution

This system delivers a modern, intuitive, and data-driven solution to library classification management.

By digitizing LC classification records and pairing them with interactive visual analytics, the platform transforms raw data into actionable insights. Staff can securely manage records, while administrators gain immediate visibility into collection performance through dashboards and reports.

The result is a scalable, offline-ready library management tool built for real-world institutional use.

Key Features & Capabilities

LC Classification Management

• Structured registration of LC subclasses, titles, and volume counts

• Automatic detection of main LC classes

• Data validation to prevent duplication and inconsistencies

Secure Editing & Control

• Role-based access for staff and general users

• Edit and delete functionality with safeguards

• Clean, form-driven data management interface

Data Visualization & Insights

• Interactive, treemap-style visualization of book collections

• Color-coded representation by LC main class

• Instant updates reflecting live data changes

Reporting & Export

• Comprehensive LC classification reports in tabular format

• Export options for CSV and PDF

• Print-ready summaries for administrative use

Offline & Network-Ready Architecture

• Fully functional without internet access

• Local database deployment

• Multi-PC synchronization over local area networks (LAN)

Data Backup & Import

• One-click database backup

• Bulk data import from CSV or Excel files

Technology Stack

Frontend & Interface

• Python + Streamlit
  Clean, responsive, and interactive dashboard interface optimized for desktop use.

Backend & Database

• SQLite for standalone installations

• MySQL for multi-computer LAN deployments

Data Visualization

• Interactive charting and treemap visualization libraries

• Real-time UI updates linked to database changes

Deployment

• Packaged as a Windows desktop application

• Distributed via executable installer for easy installation and maintenance

User Experience Flow

1. Authorized staff log into the system

2. LC classification data is registered or updated

3. Changes instantly propagate across dashboards and reports

4. Administrators review analytics and export reports

5. Data is backed up or shared across networked systems

General users can explore visualizations and reports without modifying records.

My Role

Product Designer & Software Developer

I led the project end-to-end, including system planning, user interface design, database modeling, application development, visualization strategy, and deployment architecture.

Outcome & Impact

The system delivers measurable value by:

• Improving data accuracy and consistency

• Reducing manual record-keeping effort

• Enabling faster, insight-driven decision-making

• Providing clear visibility into library collection distribution

• Offering a reliable, offline-first solution for institutions

Use Cases

• Academic libraries

• Public and institutional libraries

• Research centers

• Educational institutions managing LC-classified collections

Final Note

This project demonstrates my ability to design and build practical, scalable, and institution-ready digital systems that solve real operational challenges through thoughtful UX, structured data design, and clear visual analytics.