An Approach to Optimize Query Using Rank Aware Scoring Function

Information retrieving and storing are the basic tasks of the relational database. Query optimization is used for accessing database in an efficient manner, analyzing and choosing an optimized plan is a complex process. Today´s end-users are more interested in specific results rather than getting response in short time. Ranking queries (or top-k queries) are support for accessing specific results based on user´s demand. Efficient execution of top-k queries is becoming a major challenge for relational database. Ranking queries produce results that are ordered on some ranking attribute. This paper presents a scoring function based rank query optimization methodology where scoring function decide preference over conduction as per user demand and shows the result of both query without ranking and ranked query, the result of ranked query is better than without ranked query.