JOURNAL ARTICLE

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

  • Published In: International Scientific Journal of Engineering & Management, 2025, v. 4, n. 4. P. 1 1 of 3

  • Database: Applied Science & Technology Source Ultimate 2 of 3

  • Authored By: K., Meghaa; Behera, Saswati; P. R., Krishna Kumar 3 of 3

Abstract

The article focuses on the development of a lightweight Employee Information System using Java, JDBC (Java Database Connectivity), and MySQL, emphasizing backend optimization through direct SQL query execution and indexing. It demonstrates that using indexing significantly improves query performance for filtering employee data by department, salary, and location, with benchmark results showing reduced query times when indexes are applied. The study contrasts JDBC with Object-Relational Mapping (ORM) frameworks, highlighting JDBC's advantages in speed, control, and transparency for data-intensive applications, while noting ORM's ease of development but potential performance overhead. The paper also suggests future enhancements such as integrating graphical user interfaces and web-based CRUD operations to improve usability.

Additional Information

  • Source:International Scientific Journal of Engineering & Management. 2025/04, Vol. 4, Issue 4, p1
  • Document Type:Article
  • Subject Area:Computer Science
  • Publication Date:2025
  • ISSN:25836129
  • DOI:10.55041/ISJEM02977
  • Accession Number:185147142
  • Copyright Statement:Copyright of International Scientific Journal of Engineering & Management is the property of International Scientific Journal of Engineering & Management and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)

Looking to go deeper into this topic? Look for more articles on EBSCOhost.