Abstract
Keyword-based search is well studied in the world of text documents and Internet search engines. While traditional database management systems offer powerful query languages, they do not allow keyword-based search. In this paper, we discussed ITREKS, a system that support efficient keyword-based search over relational database by indexing tuple relationship: A basic database tuple relationship, FDJT, is established in advance. Then a FDJT-Tuple-Index table is created, which records relationships between each tuple and FDJT. At query time, for each of keywords, system first finds tuples in every relation that contain it, using full text indexes offered by database management system. Then use FDJT-Tuple-Index table to find the joinable tuples contain all keywords in the query.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Galindo-Legaria, C.: Outerjoins as disjunctions. In: ACM SIGMOD International Conf. on Management of Data (1994)
Rajaraman, A., Ullman, J.D.: Integrating information by outerjoins and full disjunctions.
Oracle Text, http://otn.oracle.com/products/text/index.html
Hristidis, V., Papakonstantinou, Y.: Discover: Keyword search in relational databases. In: Proc. of VLDB (2002)
Hristidis, V., Gravano, L., Papakonstantinou, Y.: Efficient IR-Style Keyword Search over Relational Databases. In: Proc. Of VLDB (2003)
Bhalotia, G., Hulgeri, A., Nakhe, C., Chakrabarti, S., Sudarshan, S.: Keyword searching and browsing in databases using banks. In: Proc. of ICDE (2002)
Agrawal, S., Chaudhuri, S., Das, G.: Dbxplorer: A system for keyword-based search over relational databases. In: Proc. of ICDE (2002)
Raghavan, P.: Structured and unstructured search in enterprises. IEEE Data Engineering Bulletin 24(4) (2001)
Dar, S., Entin, G., Geva, S., Palmon, E.: Dtl’s dataspot: Database exploration using plain languages. In: Proc. Of VLDB (1998)
Wheeldon, R., Levene, M., Keenoy, K.: Search and navigation in relational databases, http://arxiv.org/abs/cs.DB/0307073
Su, Q., Widom, J.: Efficient and Extensible Keyword Search over Relational Databases. Stanford University Technical Report (2003)
DBLP bibliography (2004), http://www.informatik.uni-trier.de/~ley/db/index.html
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zhan, J., Wang, S. (2007). ITREKS: Keyword Search over Relational Database by Indexing Tuple Relationship. In: Kotagiri, R., Krishna, P.R., Mohania, M., Nantajeewarawat, E. (eds) Advances in Databases: Concepts, Systems and Applications. DASFAA 2007. Lecture Notes in Computer Science, vol 4443. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-71703-4_8
Download citation
DOI: https://doi.org/10.1007/978-3-540-71703-4_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-71702-7
Online ISBN: 978-3-540-71703-4
eBook Packages: Computer ScienceComputer Science (R0)