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