Authors:
Padmaja Pulivarthy

Addresses:
Department of Enterprise Data Systems, Samsung, Austin, Texas, United States of America. p.pulivarthy@samsung.com

Abstract:

Information technology is spreading very fast, and it has become socially important to manage this kind of organization, such as efficient work for JEE (U) 2016. Education institution management systems have been suitable for storing information in data and then acquiring high performance by using Software used in the University Educational Management System database while managing these organizations. Oracle is the database of choice for its high capabilities and scalability, but it has resistance to performance optimization. In this study, we analyze the several ways Oracle database performance can be improved by operating in a UEMS setting and implementing various optimizations, such as indexing or query optimization, through resource allocation. Query execution times, CPU utilization, memory usage, and I/O operations were significantly improved. To gain a deeper understanding of the optimization techniques, this survey research combines both qualitative data and quantitative data. In our results, the traditional bump up in performance supports that resource and customer satisfaction proponents of development. Therefore, colleges/organizations that are unwilling to improve their CMS for online managerial tasks and client experience should pursue these bits of knowledge.

Keywords: Oracle Database; Performance Optimization; University Educational Management System; Information Technology; Database Management; Database Performance.

Received on: 11/01/2024, Revised on: 05/03/2024, Accepted on: 22/04/2024, Published on: 03/06/2024

DOI: 10.69888/FTSCS.2024.000200

FMDB Transactions on Sustainable Computing Systems, 2024 Vol. 2 No. 2, Pages: 84-95

• Views : 110
• Downloads : 8

Download PDF