Share This Article:

Evaluating Relational Ranking Queries Involving both Text Attributes and Numeric Attributes

Full-Text HTML Download Download as PDF (Size:206KB) PP. 88-93
DOI: 10.4236/jsea.2012.512B018    3,018 Downloads   4,259 Views Citations


In many database applications, ranking queries may reference both text and numeric attributes, where the ranking functions are based on both semantic distances/similarities for text attributes and numeric distances for numeric attributes. In this paper, we propose a new method for evaluating such type of ranking queries over a relational database. By statistics and training, this method builds a mechanism that combines the semantic and numeric distances, and the mechanism can be used to balance the effects of text attributes and numeric attributes on matching a given query and tuples in database search. The basic idea of the method is to create an index based on WordNet to expand the tuple words semantically for text attributes and on the information of numeric attributes. The candidate results for a query are retrieved by the index and a simple SQL selection statement, and then top-N answers are obtained. The results of extensive experiments indicate that the performance of this new strategy is efficient and effective.

Cite this paper

L. Zhu, Z. Xie and Q. Ma, "Evaluating Relational Ranking Queries Involving both Text Attributes and Numeric Attributes," Journal of Software Engineering and Applications, Vol. 5 No. 12B, 2012, pp. 88-93. doi: 10.4236/jsea.2012.512B018.

Copyright © 2020 by authors and Scientific Research Publishing Inc.

Creative Commons License

This work and the related PDF file are licensed under a Creative Commons Attribution 4.0 International License.