Abstract
With storing XML data as a type of a column, relational databases have become more powerful. A relational database including both XML data and relational data is termed a hybrid XML-Relational database (XML-RDB) in this paper. Because existing keyword-search techniques on either relational databases (RDB) or XML databases (XML DB) cannot get appropriate results, we propose a new method of keyword search on XML-RDB to get more reasonable results than existing methods. To realize it, a new join operator, named XRjoin, is designed and utilized to join XML data with relational data. We construct a demo system by using DB2 v9.5, and our experiments show that the system can find the answers that we want to get.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Agrawal, S., Chaudhuri, S., Das, G.: DBXplorer: A System for Keyword-Based Search over Relational Databases. In: ICDE, pp. 5–16. IEEE, San Jose (2002)
Guo, L., Shao, F., Botev, C., Shanmugasundaram, J.: XRANK: Ranked Keyword Search over XML Documents. In: SIGMOD, pp. 16–27. ACM, California (2003)
Zhang, L., Ohmori, T., Hoshi, M.: Keyword Search on Hybrid XML-Relational Databases By using XRjoin. In: Kitagawa, H., Ishikawa, Y., Li, Q. (eds.) DASFAA 2010, Part II. LNCS, vol. 5982, pp. 292–298. Springer, Heidelberg (2010)
Hristidis, V., Papakonstantinou, Y.: DISCOVER: Keyword search in relational databases. In: VLDB, pp. 670–681. Morgan Kaufmann, Hong Kong (2002)
IBM DB2 Database Information Center, http://publib.boulder.ibm.com/infocenter/db2luw/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zhang, L., Ohmori, T., Hoshi, M. (2010). A System for Keyword Search on Hybrid XML-Relational Databases Using XRjoin. In: Kitagawa, H., Ishikawa, Y., Li, Q., Watanabe, C. (eds) Database Systems for Advanced Applications. DASFAA 2010. Lecture Notes in Computer Science, vol 5982. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-12098-5_47
Download citation
DOI: https://doi.org/10.1007/978-3-642-12098-5_47
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-12097-8
Online ISBN: 978-3-642-12098-5
eBook Packages: Computer ScienceComputer Science (R0)