Query processing is a set of activities that involve in getting the result of a query expressed in a high-level language. These activities include parsing the queries and translate them into expressions that can be implemented at the physical level of the file system then optimizing the query of internal form to get suitable execution strategies for processing and then doing the actual execution of queries to get the results.

Query Processing – Database Management System

In this “Query Processing – Database Management System” you will learn about the following topics:

  1. Introduction to Query in Database
  2. Methods for Creating Queries
  3. Selecting Parameters from a Menu, Query by Example (QBE)
  4. Power of Queries
  5. Query Language
  6. Query Processing
  7. Steps of Query Processing
  8. Parsing and Translation, Optimization, Evaluation
  9. Equivalence of Expression
  10. Equivalence Rules
  11. Query Cost Estimation
  12. Query Optimization
  13. Relational Algebraic Query Tree
  14. Steps for Query Optimization through Query Tree
  15. Example of Optimized Query Tree



==== Point to Note ====

This article Query Processing – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at bcanotespu@gmail.com.

See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students to excel.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester Database Management System (DBMS) Notes Pdf: