Keyword Search Based Information Retrieval System in Relational Database

Abstract

Keyword search technology has been the most widely used querying method nowadays. The amount of data in relational databases is growing rapidly. The information discovery from these databases is necessary for users. Free-form keyword search over relational database management system (RDBMS) has been attracted. The information discovery from the commercial RDBMS requires the knowledge of query language and the database structure .This paper presents the medicine information searching system that is implemented on the free-form keyword search strategies. This system allows users to search medicine information by entering keyword only. The algorithm of join expression generator is used to generate the join expressions of non-free tuples. As a ranking function, the "state-of-the-art IR definition" ranking function is used. The resulted answers are ranked according to the score from the ranking function. Thus, the system can give the answers that are more related to the input sentence.