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 [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 Database Management System (DBMS) Notes Pdf:
- Unit I: Introduction To Database Management System (DBMS)
- Unit II: Data Models
- Unit III: Relational Model
- Unit IV: Relational Database Query Languages
- Unit V: Database Constraints and Relational Database Design
- Unit VI: Database Security
- Unit VIII: File Organization and Indexing
- Unit IX: Crash Recovery
- Unit X: Transaction Processing and Concurrency Control
- Unit XI: Advanced Database Concepts
 Notes Pdf){kind=link}
0 Comments