A Selective Key-Oriented XML Index for the Index Selection Problem in XDBMS

  • Beda Christoph Hammerschmidt
  • Martin Kempa
  • Volker Linnemann
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3180)


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.


Index Structure Range Query Selective Index Suitable Index Query Optimizer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    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)CrossRefGoogle Scholar
  2. 2.
    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)Google Scholar
  3. 3.
    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)CrossRefGoogle Scholar
  4. 4.
    Comer, D.: The difficulty of optimum index selection. ACM Transactions on Database Systems 3(4), 440–445 (1978)CrossRefGoogle Scholar
  5. 5.
    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)Google Scholar
  6. 6.
    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)zbMATHCrossRefGoogle Scholar
  7. 7.
    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)CrossRefGoogle Scholar
  8. 8.
    Gehrmann, T., Pfalzgraf, A.: Indizierung von schemalosen xmldokumenten anhand von xpath-anfragen. Bachelor thesis, Institute for Information Systems, University of Lübeck (2004)Google Scholar
  9. 9.
    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)Google Scholar
  10. 10.
    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)Google Scholar
  11. 11.
    Hammerschmidt, B.C., Kempa, M., Linnemann, V.: Keyx: a selective key-oriented xml index for native xml databases (submitted for publication)Google Scholar
  12. 12.
    IBM Corporation. IBM DB2 XML Extender,
  13. 13.
    Infonyte GmbH. Infonyte DB (2003),
  14. 14.
    McHugh, J., Abiteboul, S., Goldman, R., Quass, D., Widom, J.: Lore: A database managment system for semistructured data. SIGMOD Record 26(3) (1997)Google Scholar
  15. 15.
    McHugh, J., Widom, J., Abiteboul, S., Luo, Q., Rajamaran, A.: Indexing semistructured data. Technical report, Stanford University, Computer Science Department (1998)Google Scholar
  16. 16.
    Microsoft Corporation. SQL Server 2000 Web Services Toolkit (2002),
  17. 17.
    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)CrossRefGoogle Scholar
  18. 18.
    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)Google Scholar
  19. 19.
  20. 20.
    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)CrossRefGoogle Scholar
  21. 21.
    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)Google Scholar
  22. 22.
    W3C. An XML Query Language (XQuery),
  23. 23.
    W3C. Document Object Model (DOM),
  24. 24.
    W3C. XML Path Language (XPath),

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Beda Christoph Hammerschmidt
    • 1
  • Martin Kempa
    • 1
  • Volker Linnemann
    • 1
  1. 1.Institut für InformationssystemeUniversität zu LübeckLübeckGermany

Personalised recommendations