Unit VII: Query Processing – Database Management System

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.

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

Introduction to Query in Database
Methods for Creating Queries
Selecting Parameters from a Menu, Query by Example (QBE)
Power of Queries
Query Language
Query Processing
Steps of Query Processing
Parsing and Translation, Optimization, Evaluation
Equivalence of Expression
Equivalence Rules
Query Cost Estimation
Query Optimization
Relational Algebraic Query Tree
Steps for Query Optimization through Query Tree
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.