8
Query Processing and Optimization
1. What do you mean by query processing? What are the various steps involved in query processing? Explain with the help of a block diagram.
Ans: Query processing includes translation of high-level queries into low-level expressions that can be used at the physical level of the file system, query optimization and actual execution of the query to get the result. It is a three-step process that consists of parsing and translation, optimization and execution of the query submitted by the user (see Figure 8.1). These steps are discussed below:
Figure 8.1 Query-processing Steps
1. Parsing and translation: Whenever ...
Get Express Learning: Database Management Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
