Skip to main content
SpringerLink
Log in

Searching Databases with Keywords

  • Published:
Journal of Computer Science and Technology Aims and scope Submit manuscript

Abstract

Traditionally, SQL query language is used to search the data in databases. However, it is inappropriate for end-users, since it is complex and hard to learn. It is the need of end-user, searching in databases with keywords, like in web search engines. This paper presents a survey of work on keyword search in databases. It also includes a brief introduction to the SEEKER system which has been developed.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. Silberschatz A, Korth H, Sudarshan S. Database System Concepts. 4th Edition, McGraw Hill, 2001.

  2. Baeza-Yates R, Ribeiro-Neto B. Modern Information Retrieval. ACM Press, 1999.

  3. Florescu D, Levy A Y, Mendelzon A O. Database techniques for World Wide Web: A survey. SIGMOD Record, 1998, 27(3): 59–74.

    Google Scholar 

  4. Lawrence S, Giles C L. Searching the World Wide Web. Science, 1998, 280(5360): 98–100.

    Google Scholar 

  5. Bergman M K. The deep web: Surfacing hidden value. White Paper, Bright Planet, 2000.

  6. Raghavan S, Garcia-Molina H. Integrating diverse information management systems: A brief survey. IEEE Data Engineering Bulletin, 2001, 24(4): 44–52.

    Google Scholar 

  7. Hulgeri A, Bhalotia G et al. Keyword search in databases. IEEE Data Engineering Bulletin, 2001, 24: 22–32.

    Google Scholar 

  8. Bhalotia G, Hulgeri A, Nakhe C et al. Keyword searching and browsing in databases using BANKS. In Proc. 18th International Conference on Data Engineering, 2002.

  9. Agrawal S, Chaudhuri S, Das G. DBXplorer: A system for keyword-based search over relational databases. In Proc. 18th International Conference on Data Engineering, 2002.

  10. Hristidis V, Papakonstantinou Y. DISCOVER: Keyword search in relational databases. In Proc. the 28th International Conference on Very Large Data Bases, 2002.

  11. Hristidis V, Gravano L, Papakonstantinou Y. Efficient IR-style keyword search over relational databases. In Proc. the 29th Int. Conf. Very Large Data Bases, 2003.

  12. Dixon P. Basics of Oracle text retrieval. IEEE Data Engineering Bulletin, 2001, 24(4): 11–14.

    Google Scholar 

  13. Maier A, Simmen D. DB2 optimization in support of full text search. IEEE Data Engineering Bulletin, 2001, 24(4): 3–6.

    Google Scholar 

  14. Hamilton J, Nayak T. Microsoft SQL Server full-text search. IEEE Data Engineering Bulletin, 2001, 24(4): 7–10.

    Google Scholar 

  15. Balmin A, Hristidis V, Papakonstantinou Y. ObjectRank: Authority-based keyword search in databases. In Proc. the 30th Int. Conf. Very Large Data Bases, 2004.

  16. Brin S, Page L. The anatomy of a large-scale hyper-textual web search engine. In Proc. 7th Int. WWW Conference, 1998.

  17. Dar S, Entin G, Geva S, Palmon E. DTL’s dataSpot: Database exploration using plain language. In Proc. the 24th International Conference on Very Large Data Bases, 1998.

  18. Goldman R, Shivajumar N, Venkatasubramanian S, Garcia-Molina H. Proximity search in databases. In Proc. the 24th International Conference on Very Large Data Bases, 1998.

  19. Wheeldon R, Levene M, Keenoy K. DbSurfer: A search and navigation tool for relational databases. In Proc. the 21st Annual British National Conference on Databases, 2004.

  20. Sarda N L, Jain A. Mragyati: A system for keyword-based searching in databases. Report No. cs.DB/011052 on CORR, 2001.

  21. Masermann U, Vossen G. Schema independent database querying (on and off the Web). In Proc. 4th IDEAS, 2000.

  22. Masermann U, Vossen G. Design and implementation of a novel approach to keyword searching in relational databases. In ADBIS-DASFAA Symposium, 2000.

  23. Agrawal R, Srikant R. Searching with numbers. In Proc. the 11th International World Wide Web Conference, 2002.

  24. Geerts F, Mannila H, Terzi E. Relational link-based ranking. In Proc. the 30th Int. Conf. Very Large Data Bases, 2004.

  25. Ilyas I, Aref W, Elmagarmid A. Supporting top-k join queries in relational databases. In Proc. the 29th International Conference on Very Large Data Bases, 2003.

  26. Fagin R, Lotem A, Naor M. Optimal aggregation algorithms for middleware. Journal of Computer and System Sciences, 2003, 66(4): 614–656.

    Google Scholar 

  27. Hristidis V, Papakonstantinou Y, Balmin A. Keyword proximity search on XML graphs. In Proc. 19th International Conference on Data Engineering, 2003.

  28. Voorhees E M, Harman D K. Overview of the 6th text retrieval conference (TREC-6). In Proc. the 6th Text REtrieval Conference, 1997.

  29. Gövert N, Kazai G. Overview of the INitiative for the Evaluation of XML retrieval (INEX 2002). In Proc. the First INEX Workshop, 2002.

  30. Florescu D, Kossmann D, Manolescu I. Integrating Keyword Search into XML Query Processing. In Proc. the 9th International World Wide Web Conference, 2000.

  31. Guo L, Shao F, Botev C, Shanmugasundaram J. XRANK: Ranked keyword search over XML documents. In Proc. the ACM SIGMOD Int. Conf. Management of Data, 2003.

  32. Cohen S et al. XSearch: A semantic search engine for XML. In Proc. the 29th Int. Conf. Very Large Data Bases, 2003.

  33. Li Y, Yu C, Jagadish H V. Schema-free XQuery. In Proc. the 30th Int. Conf. Very Large Data Bases, 2004.

Download references

Author information

Authors and Affiliations

  1. School of Information, Renmin University of China, Beijing, 100872, P.R. China

    Shan Wang & Kun-Long Zhang

Authors
  1. Shan Wang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Kun-Long Zhang
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Shan Wang.

Additional information

The work was supported by the National Natural Science Foundation of China under Grant Nos.60473069, 60496325 and the National High Technology Development 863 Program of China under Grant No.2003AA4Z3030.

Shan Wang is a professor of School of Information, Renmin University of China. Her current research interests include database and knowledge systems, data warehousing technology, and grid data management.

Kun-Long Zhang is a Ph.D. candidate in School of Information, Renmin University of China. His current research interests include database systems and distributed systems.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Wang, S., Zhang, KL. Searching Databases with Keywords. J Comput Sci Technol 20, 55–62 (2005). https://doi.org/10.1007/s11390-005-0006-4

Download citation

  • Received:

  • Revised:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s11390-005-0006-4

Keywords

Search

Navigation