A Hadoop-Based Database Querying Approach for Non-expert Users

摘要：

　　Increasingly complex relational databases are challenging for non-expert users to query.To facilitate querying,keyword search and form-based interface methods have been proposed,but they both have limitations.Besides,existing methods rely on single machine,leading to insufficient memory and long time consuming for large-scale data.This paper proposes a Hadoop-based database querying method combining the advantages of form-based interface and keyword search.We first generate a set of query forms according to the database schema,and build distributed indexes offline.At online query stage,aiming at the keywords that users input,we return top-k related forms.After users choose and fill out the form,we can automatically create a structured query and return results to them.Experiments show that our method can not only provide an easy way to query databases for non-expert users,but also achieve better performance in time efficiency.

关键词： search Query form Hadoop Relational database

作者: Yale Chai Chao Wang Yanlong Wen Xiaojie Yuan

作者单位: College of Computer and Control Engineering,Nankai University,38 Tongyan Road,Tianjin 300350,Peoples Republic of China

会议类型: 国际会议

会议名称: International Asia-Pacific Web Conference(第18届国际亚太互联网大会)

会议地点: 苏州

会议语种:英文

页码: 449-453

在线出版日期: 2016-09-23（万方平台首次上网日期，不代表论文的发表时间）