Abstract
In relational database management systems indexes are used to accelerate specific queries. The selection of indexes is an important task when tuning a database which is performed by a database administrator or an index propagation tool which suggests a set of suitable indexes. In this paper we introduce a new index approach, called key-oriented XML index (KeyX), that uses specific XML element or attribute values as keys referencing arbitrary nodes in the XML data. KeyX is selective to specific queries avoiding efforts spent for elements which are never queried. This concept reduces memory consumption and unproductive index updates.
We transfer the Index Selection Problem (ISP) to XDBMS. Applying the ISP, a workload of database operations is analyzed and a set of selective indexes that minimizes the total execution time for the workload is suggested. Because the workload is analyzed periodically and suitable indexes are created or dropped automatically our implementation of KeyX guarantees high performance over the total life time of a database.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Caprara, A., Fischetti, M., Maio, D.: Exact and approximate algorithms for the index selection problem in physical database design. IEEE Transactions on Knowledge and Data Engineering 7(6), 955–967 (1995)
Chaudhuri, S., Narasayya, V.R.: An efficient cost-driven index selection tool for microsoft sql server. In: VLDB 1997, Proceedings of 23rd International Conference on Very Large Data Bases, Athens, Greece, August 25-29, Morgan Kaufmann, San Francisco (1997)
Chung, C.-W., Min, J.-K., Shim, K.: Apex: an adaptive path index for xml data. In: SIGMOD 2002, Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, Madison, Wisconsin, USA, pp. 121–132. ACM Press, New York (2002)
Comer, D.: The difficulty of optimum index selection. ACM Transactions on Database Systems 3(4), 440–445 (1978)
Cooper, B.F., Sample, N., Franklin, M.J., Hjaltason, G.R., Shadmon, M.: A fast index for semistructured data. In: Proceedings of 27th International Conference on Very Large Data Bases, Roma, Italy, September 11-14, Morgan Kaufmann, San Francisco (2001)
Fiebig, T., Helmer, S., Kanne, C., Moerkotte, G., Neumann, J., Schiele, R., Westmann, T.: Anatomy of a native xml base management system. The VLDB Journal 11, 292–314 (2002)
Fiebig, T., Moerkotte, G.: Evaluating queries on structure with extended access support relations. In: Suciu, D., Vossen, G. (eds.) WebDB 2000. LNCS, vol. 1997, pp. 41–46. Springer, Heidelberg (2001)
Gehrmann, T., Pfalzgraf, A.: Indizierung von schemalosen xmldokumenten anhand von xpath-anfragen. Bachelor thesis, Institute for Information Systems, University of Lübeck (2004)
Guo, Z., Xu, Z., Zhou, S., Zhou, A., Li, M.: Index selection for efficient xml path expression processing. In: ER 2003 Workshops, 22nd International Conference on Conceptual Modeling, Chicago, Illinois, USA, October 13 (2003)
Hammerschmidt, B.C., Kempa, M., Linnemann, V.: On the index selection problem applied to key oriented xml indexes. Technical report, A-04-09, Institute of Information Systems, University of Lübeck (2004)
Hammerschmidt, B.C., Kempa, M., Linnemann, V.: Keyx: a selective key-oriented xml index for native xml databases (submitted for publication)
IBM Corporation. IBM DB2 XML Extender, http://www-3.ibm.com/software/data/db2/extenders/xmlext/
Infonyte GmbH. Infonyte DB (2003), http://www.infonyte.com
McHugh, J., Abiteboul, S., Goldman, R., Quass, D., Widom, J.: Lore: A database managment system for semistructured data. SIGMOD Record 26(3) (1997)
McHugh, J., Widom, J., Abiteboul, S., Luo, Q., Rajamaran, A.: Indexing semistructured data. Technical report, Stanford University, Computer Science Department (1998)
Microsoft Corporation. SQL Server 2000 Web Services Toolkit (2002), http://www.microsoft.com/sql/techinfo/xml/default.asp
Milo, T., Suciu, D.: Index structures for path expressions. In: Beeri, C., Bruneman, P. (eds.) ICDT 1999. LNCS, vol. 1540, pp. 277–295. Springer, Heidelberg (1998)
Naughton, J.F., DeWitt, D.J., Maier, D., Aboulnaga, A., Chen, J., Galanis, L., Kang, J., Krishnamurthy, R., Luo, Q., Prakash, N.n., Ramamurthy, R., Shanmugasundaram, J., Tian, F., Tufte, K., Viglas, S., Wang, Y., Zhang, C., Jackson, B., Gupta, A., Chen, R.: The niagara internet query system. IEEE Data Engineering Bulletin 24(2), 27–33 (2001)
Oracle XML DB, http://otn.oracle.com/tech/xml/xmldb/index.html
Schöning, H.: Tamino - a dbms designed for xml. In: Proceedings of the 17th International Conference on Data Engineering, Heidelberg, Germany, April 2-6, pp. 149–154. IEEE Computer Society, Los Alamitos (2001)
Valentin, G., Zuliani, M., Zilio, D.C.: Db2 advisor: An optimizer smart enough to recommend its own indexes. In: Proceedings of the 16th International Conference on Data Engineering, San Diego, USA, February 28- March 3, IEEE Computer Society, Los Alamitos (2000)
W3C. An XML Query Language (XQuery), http://www.w3.org/TR/xquery
W3C. Document Object Model (DOM), http://www.w3.org/DOM
W3C. XML Path Language (XPath), http://www.w3.org/TR/xpath
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Hammerschmidt, B.C., Kempa, M., Linnemann, V. (2004). A Selective Key-Oriented XML Index for the Index Selection Problem in XDBMS. In: Galindo, F., Takizawa, M., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2004. Lecture Notes in Computer Science, vol 3180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30075-5_27
Download citation
DOI: https://doi.org/10.1007/978-3-540-30075-5_27
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22936-0
Online ISBN: 978-3-540-30075-5
eBook Packages: Springer Book Archive