EUVIMEDEUVIMED entdecken
Crossref

ADVANCED QUERY OPTIMIZATION IN SQL DATABASES FOR REAL-TIME BIG DATA ANALYTICS

Md Mostafizur Rahman, Siful Islam, Md Kamruzzaman, Zihad Hasan Joy

ACADEMIC JOURNAL ON BUSINESS ADMINISTRATION, INNOVATION & SUSTAINABILITY · 2024

DOI: 10.69593/ajbais.v4i3.77 ↗

Kurz gefasst

Fachartikel in der Zeitschrift ACADEMIC JOURNAL ON BUSINESS ADMINISTRATION, INNOVATION & SUSTAINABILITY, 2024. Verfasst von Md Mostafizur Rahman und 3 weiteren Autor:innen. Die Arbeit wurde bisher 8-mal zitiert (Crossref).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This study investigates the effectiveness of advanced query optimization techniques in SQL databases, focusing on multi-level indexing, query rewriting, and dynamic query execution plans. The research employs a qualitative approach, gathering data from a variety of SQL databases characterized by large datasets typical of big data environments. Through structured interviews, focus groups, and observational methods, insights from database administrators highlight the practical benefits and challenges associated with implementing these techniques. The findings reveal significant improvements in query performance, with multi-level indexing reducing data retrieval times by approximately 40%, query rewriting decreasing execution times by 35%, and dynamic query execution plans enhancing resource utilization efficiency by 25%. These techniques were also praised for their ease of use, adaptability to different data types and query complexities, and overall reliability. This study contributes to the existing body of knowledge by providing a comprehensive analysis of the practical applications and performance enhancements offered by advanced query optimization methods in SQL databases, underscoring their value in managing large-scale, dynamic data environments.

Zitieren

APA

Rahman, M. M., Islam, S., Kamruzzaman, M., & Joy, Z. H. (2024). ADVANCED QUERY OPTIMIZATION IN SQL DATABASES FOR REAL-TIME BIG DATA ANALYTICS. ACADEMIC JOURNAL ON BUSINESS ADMINISTRATION, INNOVATION & SUSTAINABILITY. https://doi.org/10.69593/ajbais.v4i3.77

Vancouver

Rahman MM, Islam S, Kamruzzaman M, Joy ZH. ADVANCED QUERY OPTIMIZATION IN SQL DATABASES FOR REAL-TIME BIG DATA ANALYTICS. ACADEMIC JOURNAL ON BUSINESS ADMINISTRATION, INNOVATION & SUSTAINABILITY. 2024. doi:10.69593/ajbais.v4i3.77

BibTeX
@article{Rahman2024,
  author = {Rahman, Md Mostafizur and Islam, Siful and Kamruzzaman, Md and Joy, Zihad Hasan},
  title = {ADVANCED QUERY OPTIMIZATION IN SQL DATABASES FOR REAL-TIME BIG DATA ANALYTICS},
  journal = {ACADEMIC JOURNAL ON BUSINESS ADMINISTRATION, INNOVATION & SUSTAINABILITY},
  year = {2024},
  doi = {10.69593/ajbais.v4i3.77}
}
Kostenlos starten →