Full Citation

Title: Processing Relational Top-N Queries with Text and Numeric Attributes

Citation Type: Journal Article

Publication Year: 2014

ISBN: 978-3-03835-001-9

ISSN:

DOI: 10.4028/www.scientific.net/AMM.490-491.1326

NSFID:

PMCID:

PMID:

Abstract: ]Relational top-N queries with both text attributes and numeric attributes are useful in many applications, by using the ranking functions based on both semantic distances for text attributes and numeric distances for numeric attributes. In this paper, we propose an approach for processing such type of top-N queries in relational databases. The basic idea of the approach is to create an index based on WordNet to expand the tuple words semantically for text attributes and on the related information of numeric attributes, meanwhile the size of the index increases linearly with the size of the database. The results of extensive experiments show that our method is efficient and effective.

Url: https://www.scientific.net/AMM.490-491.1326

User Submitted?: No

Authors: Zhu, Liang; Liu, Bin; Liu, Guang; Lei, Quan Long

Periodical (Full): Applied Mechanics and Materials

Issue:

Volume: 490-491

Pages: 1326-1329

Data Collections: IPUMS USA

Topics: Methodology and Data Collection

Countries: United States