National Technical Symposium on Advancements in Computing Technologies |
Foundation of Computer Science USA |
NTSACT - Number 1 |
August 2011 |
Authors: Anuja K. Gaikwad, Rupali A. Davalgaonkar, Seema Vaidya |
f8224250-7b6d-4b86-8b03-f2e5312d9ffa |
Anuja K. Gaikwad, Rupali A. Davalgaonkar, Seema Vaidya . Pathfinder of X Query for a Relational Database System. National Technical Symposium on Advancements in Computing Technologies. NTSACT, 1 (August 2011), 22-24.
There has been extensive work in query optimization since the early ‘70s. Relational query languages provide a high-level “declarative” interface to access data stored in relational databases. Two key components of the query evaluation component of a SQL database system are the query optimizer and the query execution engine. The query execution engine implements a set of physical operators. An operator takes as input one or more data streams and produces an output data stream. The simplest way to think of physical operators is as pieces of code that are used as building blocks to make possible the execution of SQL queries.