Browse > Article
http://dx.doi.org/10.9708/jksci.2013.18.12.091

Semantic-based Keyword Search System over Relational Database  

Yang, Younghyoo (Dept. of Information Management, Hanyang Women's University)
Publication Information
Journal of the Korea Society of Computer and Information / v.18, no.12, 2013 , pp. 91-101 More about this Journal
Abstract
One issue with keyword search in general is its ambiguity which can ultimately impact the effectiveness of the search in terms of the quality of the search results. This ambiguity is primarily due to the ambiguity of the contextual meaning of each term in the query. In addition to the query ambiguity itself, the relationships between the keywords in the search results are crucial for the proper interpretation of the search results by the user and should be clearly presented in the search results. We address the keyword search ambiguity issue by adapting some of the existing approaches for keyword mapping from the query terms to the schema terms/instances. The approaches we have adapted for term mapping capture both the syntactic similarity between the query keywords and the schema terms as well as the semantic similarity of the two and give better mappings and ultimately 50% raised accurate results. Finally, to address the last issue of lacking clear relationships among the terms appearing in the search results, our system has leveraged semantic web technologies in order to enrich the knowledgebase and to discover the relationships between the keywords.
Keywords
Semantic Web; Relational Database/SQL; Keyword Search; RDF; SPARQL;
Citations & Related Records
Times Cited By KSCI : 3  (Citation Analysis)
연도 인용수 순위
1 Hak Soo Kim, Gun-Woo Kim, Hyemyung Seo, Jin Hyun Son, " An Efficient Semantic Query Processing Method based on SQL", Database Researcch, Vol. 24, No. 3, pp. 14-29, Dec. 2008.
2 Kim Youn Hee, Shin Hye Yeon, Lim Haechull, Chong Kyun Park, "Indexing and Storage Schemes for Keyword-based Query Processing over Semantic Web Data", Journal of The Korea Society of Computer and Information, Vol. 12, No. 5, pp. 93-102, Nov. 2007.   과학기술학회마을
3 Youn-Hee Kim, Jee-Hyun Kim, "The Scheme for Path-based Query Processing on the semantic Data", Journal of The Korea Society of Computer and Information, Vol. 14, No. 10, pp. 31-41, October 2009.   과학기술학회마을
4 Sung Wan Kim, "Suffix Array Based Path Query Processing Scheme for Semantic Web Data", Journal of The Korea Society of Computer and Information, Vol. 17, No. 10, pp. 107-116, October 2012.   과학기술학회마을   DOI   ScienceOn
5 V. Hristidis and Y. Papakonstantinou, "Discover: Keyword search in relational databases", In VLDB, pages 670.681, 2002.
6 Sanjay Agrawal, Surajit Chaudhuri, Gautam Das, "DBXplorer: A System for Keyword-Based Search over Relational Databases," icde, pp.0005, 18th International Conference on Data Engineering (ICDE'02), 2002.
7 Zhou, Q., Wang, C., Xiong, M., Wang, H., Yu, Y., "Spark: Adapting keyword query to semantic search. In: A berer, K., Choi, K.-S., Noy, N., Allemang, D., Lee, K.-I., Nixon, L., Golbeck, J., Mika, P., Maynard, D., Mizoguchi, R., Schreiber, G., Cudre-Mauroux, P. (eds.) ISWC 2007. LNCS, vol. 4825, pp. 694-707. Springer, Heidelberg (2007)
8 Bergamaschi S, Domnori E, Guerra F, OrsiniM, Lado RT, Velegrakis Y., "Keymantic: Semantic keyword based searching in data integration systems", Proceedings of VLDB, vol 3(2), pp. 1637-1640, 2010.
9 Ziyang Liu , Jeffrey Walker , Yi Chen, "XSeek: a semantic XML search engine using keywords", Proceedings of the 33rd international conference on Very large data bases, September 23-27, Vienna, Austria, 2007.
10 Shufeng Zhou, "Exposing Relational Database as RDF", 2nd International Conference on Industrial and Information Systems, 2010.
11 http://en.wikipedia.org/wiki/Hungarian_algorithm