Abstract:

Query processing has always been the most significant component of any database management system. In it, query is posed in high level language and after parsing, the query is converted to a low level query. Then against this low level query multiple execution plans are generated. Query with the lowest cost is selected based on cost estimation. Results are extracted and shown to the user. Until recently, this approach of query processing was unquestionable.