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 [email protected].

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 DBMS (Database Management System) Notes Pdf:

  1. Unit I: Introduction To Database Management System (DBMS) - Database Management System
  2. Unit II: Data Models - Database Management System
  3. Unit III: Relational Model - Database Management System
  4. Unit IV: Relational Database Query Languages - Database Management System
  5. Unit V: Database Constraints and Relational Database Design - Database Management System
  6. Unit VI: Database Security - Database Management System
  7. Unit VIII: File Organization and Indexing - Database Management System
  8. Unit IX: Crash Recovery - Database Management System
  9. Unit X: Transaction Processing and Concurrency Control - Database Management System
  10. Unit XI: Advanced Database Concepts - Database Management System