Advanced Query Optimization in SQL Databases for Real-Time Big Data Analytics
Md Mostafizur Rahman,
Siful Islam,
Md Kamruzzaman
et al.
Abstract: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 … Show more
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.