Research On Information Retrieval System Based On Keyword

With the more and more popular use of the Internet, more users can query, interact and exchange information through the Internet, and the information interaction must use database. Traditionally, people mainly use SQL to access data in a relational database. But learning SQL query syntax rules is a very complicated problem. For new users, it maybe spends a lot of energy. The paper realizes the database information retrieval based on text attributes and numeric attribute. Users do not need to know the underlying structure and any SQL structure query language knowledge. And also users do not need to understand the underlying database model. Through the related query interface, users input the key word to obtain the required data.The paper realizes the keywords query in a relational database, and analyzes the possibility of the system implementation. It describes data flow diagram of the system, all the relationships between tables, and the important functions of data the data storage process and fuzzy query implement. The system can is divided different query into numeric attribute query and text attribute query according to the keywords attribute. In these two kinds of query mode it can be divided into matching query, traversal queries and single table query. Matching query is a query by matching table. Traversal query is to query all attributes and tables in database. Single table query is specific to a particular query table.Finaly, the paper comprehensively summarizes the system development work, and describes further improvement of the system and the expansion of related functions in the next time.