Efficient Processing of Queries with Set Predicates using Reduced Function based Approach
A.Regita Thangam, S.John Peter · Journal of Emerging Technologies and Innovative Research · 2019
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.