A Survey on Automatic Query Optimization Approaches In Multi Store Systems For Big Data Analytics

Abstract

Relational Database Management System (RDBMS) was the most used storage and query processing engine for data warehousing applications till the arrival of Bigdata stores. Enterprises are recently adopting a multi store system with combined use of Bigdata stores and RDBMS. Bigdata stores are used for exploratory queries and gathering business insights. RDBMS is used for business reporting. Though, Multi storage systems improves the query processing capability by executing it over multiple stores it is challenging to optimize the query execution considering queries on both structured and unstructured data for big data analytics. This work surveys the existing methods for query optimization in multi storage systems. The objective is to identify the challenges and shortcoming in the existing methods on query optimization over multi data stores. © 2022 IEEE.