Database Keyword Search: A Perspective from Optimization

Optimization-related techniques are playing ever increasing role for Web intelligence. Yet optimization may mean different things to different people. In this paper, starting with a general discussion on the many facets of optimization in information technology (IT), we focus our examination on the recent development in database keyword search, from an optimization-oriented perspective. We first present a review and analysis on related literature, pointing out the need for incorporating contextual information in database keyword queries to achieve better performance. We then present our recently proposed approach, where keyword search is extended to simple English queries to better capture user intension. We conclude this paper by providing a discussion on the importance of database keyword search optimization for data mining and Web intelligence.

[1]  Vagelis Hristidis,et al.  DISCOVER: Keyword Search in Relational Databases , 2002, VLDB.

[2]  Zachary G. Ives,et al.  Sharing work in keyword search over databases , 2011, SIGMOD '11.

[3]  S. Sudarshan,et al.  Database System Concepts, 4th Edition , 2001 .

[4]  Zhengxin Chen,et al.  STRUCT: incorporating contextual information for English query search on relational databases , 2012, KEYS '12.

[5]  Jöran Bela Erik Beel,et al.  Academic Search Engine Optimization (ASEO ): Optimizing Scholarly Literature for Google Scholar & Co. , 2010 .

[6]  Surajit Chaudhuri,et al.  DBXplorer: a system for keyword-based search over relational databases , 2002, Proceedings 18th International Conference on Data Engineering.

[7]  Wei Wang,et al.  Keyword-based search and exploration on databases , 2011, 2011 IEEE 27th International Conference on Data Engineering.

[8]  Kristopher B. Jones,et al.  Search Engine Optimization , 2008 .

[9]  Louiqa Raschid,et al.  Logic-Based Query Optimization for Object Databases , 2000, IEEE Trans. Knowl. Data Eng..

[10]  Pierre Hansen,et al.  Hyperbolic 0–1 programming and query optimization in information retrieval , 1991, Math. Program..

[11]  Luis Gravano,et al.  Efficient IR-Style Keyword Search over Relational Databases , 2003, VLDB.

[12]  John N. Hooker,et al.  Logic-Based Methods for Optimization , 1994, PPCP.

[13]  Abraham Silberschatz,et al.  Database Systems Concepts , 1997 .

[14]  Yiyu Yao,et al.  Web Intelligence (WI) , 2008, Wiley Encyclopedia of Computer Science and Engineering.

[15]  Abraham Silberschatz,et al.  Database System Concepts , 1980 .

[16]  Clement T. Yu,et al.  Effective keyword search in relational databases , 2006, SIGMOD Conference.

[17]  Robert Armstrong Seven Steps to Optimizing Data Warehouse Performance , 2001, Computer.