• A.Regita Thangam
• Dr. S.John Peter
• A. Nagarajan

Query Processing is process of obtaining the desired information from a database system in a predictable and reliable manner. Efficient processing of query is an important requirement in many interactive environments that involve massive amounts of data. Efficient query processing in domains such as Data Warehousing, multimedia search and distributed systems has shown a great impact on performance. The complex SQL queries consist of many scalar-level operations to support the comparison between group of tuples with their attributes and values. Such queries are challenging for a database engine to optimize. But they can be easily implemented with very simple set-level semantics. In this paper, we have developed an efficient algorithm using Reduced Function based Approach for processing queries with set predicates. The efficiency of our technique is demonstrated by running experiments using the WorldCup98 data set.

Data warehousing, optimize, Set predicates, SQL, Reduced Function based Approach, query processing, efficiency

"Efficient Processing of Queries with Set Predicates using Reduced Function based Approach", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.6, Issue 2, page no.1229-1233, February-2019, Available :http://www.jetir.org/papers/JETIRAB06226.pdf

"Efficient Processing of Queries with Set Predicates using Reduced Function based Approach", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.6, Issue 2, page no. pp1229-1233, February-2019, Available at : http://www.jetir.org/papers/JETIRAB06226.pdf