Question

which of tha following are stepe in query processing

Answer 1

Hey there!

--------

Q. Which of the following are steps in query processing?

(A) Parsing and translation
(B) Optimization
(C) Evaluation
(D) All of the mentioned ✔

▪Answer => Option (D) All of the mentioned

▪Explanation -:

☆ Query Processing ☆

--> Query Processing refers to the range of activities involved in extracting data from a database. The activities include translation of queries in high-level database language into expressions that can be used at the physical level of the file system, a variety of query-optimizing transformations, and actual evaluation of queries.

The basic steps in processing a query are:-
(i) Parsing and translation
(ii) Optimization
(iii) Evaluation

Before query processing can begin, the system must translate the query into a usable form. A language such as SQL is suitable for human use, but is ill suited to be the system's internal representation of a query. A more useful internal representation is one based on the extended algebra.

Thus, the first action the system must take in query processing is to translate a given query into its internal form. This translation process is similar to the work performed by the parser of a compiler. In generating the internal form of the query, the parser checks the syntax of the user's query, verifies that the relation names appearing in the query are names of the relations in the database, and so on. The system constructs a parse-tree representation of the query which it then translates into a relational-algebra expression. If the query was expressed in terms of view, the translation phase also replaces all uses of the view by the relational-algebra expression that defines the view. Most compiler take cover parsing in detail.