The Community for Technology Leaders
Green Image
Issue No. 12 - December (2011 vol. 23)
ISSN: 1041-4347
pp: 1781-1794
Jianyong Wang , Dept. of Comput. Sci. & Technol., Tsinghua Univ., Beijing, China
Guoliang Li , Dept. of Comput. Sci. & Technol., Tsinghua Univ., Beijing, China
Jianhua Feng , Dept. of Comput. Sci. & Technol., Tsinghua Univ., Beijing, China
ABSTRACT
Existing studies on keyword search over relational databases usually find Steiner trees composed of connected database tuples as answers. They on-the-fly identify Steiner trees by discovering rich structural relationships between database tuples, and neglect the fact that such structural relationships can be precomputed and indexed. Recently, tuple units are proposed to improve search efficiency by indexing structural relationships, and existing methods identify a single tuple unit to answer keyword queries. However, in many cases, multiple tuple units should be integrated to answer a keyword query. Thus, these methods will involve false negatives. To address this problem, in this paper, we study how to integrate multiple related tuple units to effectively answer keyword queries. To achieve a high performance, we devise two novel indexes, single-keyword-based structure-aware index and keyword-pair-based structure-aware index, and incorporate structural relationships between different tuple units into the indexes. We use the indexes to efficiently identify the answers of integrated tuple units. We develop new ranking techniques and algorithms to progressively find the top-k answers. We have implemented our method in real database systems, and the experimental results show that our approach achieves high search efficiency and result quality, and outperforms state-of-the-art methods significantly.
INDEX TERMS
trees (mathematics), database indexing, query processing, relational databases, ranking technique, top-k answer, keyword search, relational database, Steiner tree, connected database tuple, tuple structural relationship, keyword query, single-keyword-based structure-aware index, keyword-pair-based structure-aware index, Relational databases, Keyword search, Steiner trees, Information retrieval, Periodic structures, Indexes, tuple units., Keyword search, relational databases, single-keyword-based index, keyword-pair-based index
CITATION
Jianyong Wang, Guoliang Li, Jianhua Feng, "Finding Top-k Answers in Keyword Search over Relational Databases Using Tuple Units", IEEE Transactions on Knowledge & Data Engineering, vol. 23, no. , pp. 1781-1794, December 2011, doi:10.1109/TKDE.2011.61
84 ms
(Ver )