Author's Name: |
Mohd Muntjir |
Subject Area: |
Science and Engineering |
Subject |
Computer Science |
Section |
Research Paper |
Keyword:
Query Optimization, Query Processing, DBMS, and Database
Abstract
Query Processing is the systematic method of accessing the require information from a database system in an expected and reliable trends. Database management systems must be agile to respond to requests for information from the user i.e. process queries. In huge database systems that may be running on unreliable and elusive domain it is no easy to outcome to dynamic database query plans based on information available exclusively at compile time. Obtaining and finding the database results in a prompt manner deals with the method of Query Optimization. Adequate processing of queries is a major requirement in various interactive environments that associates huge amounts of data. Dynamic query processing in environments such as the multimedia search, Web, and distributed systems has shown a main impact on performance and optimization. This paper will suggest and propose the main concepts of query processing and query optimization in the relational database systems. It is also describing and differentiating query-processing method in relational database systems.