Development of a Lightweight Employee Information System using Java and MySQL: A Backend Optimization Perspective

The Increasing demand for enterprise data systems has led to continuous use of relational databases and traditional programming platforms like java. This paper presents the development of lightweight Information management system using java, JDBC and MySQL. The project focuses on data filtering, indexing and backend performance using SQL queries. Despite of the growing popularity of NoSQL and ORM tools, this paper highlights the value of direct SQL execution for better control, performance and educational clarity. The Benchmarked results demonstrate improvements in data retrieval speed using indexing and structured query design. Though the modern tools like NoSQL and frameworks have become popular, many developers and learners have advantage of directly working with SQL. KEYWORDS: Java, JDBC, MySQL, Indexing, Backend Development, Data Filtering, Full Stack, Relational Database, Employee Management System