DocumentCode :
2144950
Title :
An Approach to Optimize Query Using Rank Aware Scoring Function
Author :
Shrivastava, Vivek ; Patel, B.
Author_Institution :
Comput. Sci. Dept., Rajiv Gandhi Technol. Univ., Bhopal, India
fYear :
2013
fDate :
27-29 Sept. 2013
Firstpage :
503
Lastpage :
507
Abstract :
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.
Keywords :
information retrieval; optimisation; query processing; relational databases; database access; information retrieval; query optimisation approach; rank aware scoring function; relational database; Estimation; Internet; Optimization; Query processing; Relational databases; Cardinality Estimation; Query Optimization; Ranking Function; Scoring Function;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Computational Intelligence and Communication Networks (CICN), 2013 5th International Conference on
Conference_Location :
Mathura
Type :
conf
DOI :
10.1109/CICN.2013.110
Filename :
6658045
Link To Document :
بازگشت