Innovative Approaches to Enterprise Database Performance: Leveraging Advanced Optimization Techniques for Scalability, Reliability, and High Efficiency in Large-Scale Systems

Authors

  • Ahmad Faizal Department of Computer Science, Universiti Malaya
  • Nur Aisyah Department of Computer Science, Universiti Teknologi Malaysia

Keywords:

SQL, NoSQL, Oracle, MySQL, PostgreSQL, MongoDB

Abstract

 

 

Abstract

This research explores innovative approaches to enhancing the performance of enterprise databases, which are critical for managing extensive data storage, retrieval, and real-time access in large organizations. Addressing current performance challenges such as handling big data, query optimization, hardware constraints, and security, the study examines cutting-edge solutions including database sharding, in-memory databases, AI-driven query optimization, and cloud-based Database as a Service (DBaaS). These approaches aim to improve scalability, reduce latency, and ensure data integrity and availability. By evaluating the effectiveness and applicability of these techniques, the research provides valuable insights and recommendations for database administrators and IT managers to optimize enterprise database systems, ultimately supporting operational efficiency and growth.

Author Biographies

Ahmad Faizal, Department of Computer Science, Universiti Malaya

 

 

Nur Aisyah, Department of Computer Science, Universiti Teknologi Malaysia

 

 

Downloads

Published

2024-01-20

How to Cite

Ahmad Faizal, & Nur Aisyah. (2024). Innovative Approaches to Enterprise Database Performance: Leveraging Advanced Optimization Techniques for Scalability, Reliability, and High Efficiency in Large-Scale Systems. Sage Science Review of Applied Machine Learning, 7(1), 42–65. Retrieved from https://journals.sagescience.org/index.php/ssraml/article/view/186