Abstract: The retrieval of meaningful information is referred to as a query. It can be done in one of three ways: by selecting parameters from a menu, by Query by Example, or by Query language. It is critical that the user understands what he is asking from the query while searching. Energy efficiency is an important consideration when designing and running queries in databases. When the query processing stage is not well understood, attempts are made to execute too many calculations across a large result set during result processing, loading the system beyond its query rate capacity, generating a backlog of queries, resulting in higher query latencies and possibly service disruption.
Keyword: Query Processing, Global information, DBMS , DML, Query translator, Query processing strategy.