Searching for Efficient XML-to-Relational Mappings

  • Maya Ramanath
  • Juliana Freire
  • Jayant R. Haritsa
  • Prasan Roy
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2824)


We consider the problem of cost-based strategies to derive efficient relational configurations for XML applications that subscribe to an XML Schema. In particular, we propose a flexible framework for XML schema transformations and show how it can be used to design algorithms to search the space of equivalent relational configurations. We study the impact of the schema transformations and query workload on the search strategies for finding efficient XML-to-relational mappings. In addition, we propose several optimizations to speed up the search process. Our experiments indicate that a judicious choice of transformations and search strategies can lead to relational configurations of substantially higher quality than those recommended by previous approaches.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bohannon, P., Freire, J., Roy, P., Siméon, J.: From XML schema to relations: A cost-based approach to XML storage. In: Proc. of ICDE (2002)Google Scholar
  2. 2.
    Brown, A., Fuchs, M., Robie, J., Wadler, P.: XML Schema: Formal description (2001), W3C working draft available at
  3. 3.
    Conrad, A.: A survey of Microsoft SQL Server 2000 XML features (July 2001),
  4. 4.
    Fernandez, M., Tan, W.C., Suciu, D.: Silkroute: trading between relations and XML. WWW9/Computer Networks 33(1-6) (2000)Google Scholar
  5. 5.
    Florescu, D., Kossman, D.: Storing and querying XML data using an RDMBS. IEEE Data Engineering Bulletin 22(3) (1999)Google Scholar
  6. 6.
    Freire, J., Haritsa, J., Ramanath, M., Roy, P., Siméon, J.: Statix: Making XML count. In: Proc. of SIGMOD (2002)Google Scholar
  7. 7.
  8. 8.
    Internet movie database,
  9. 9.
    Krishnamurthy, R., Chakaravarthy, V., Naughton, J.: On the difficulty of finding optimal relational decompositions for XML workloads: a complexity theoretic perspective. In: Calvanese, D., Lenzerini, M., Motwani, R. (eds.) ICDT 2003. LNCS, vol. 2572, pp. 267–281. Springer, Heidelberg (2003)Google Scholar
  10. 10.
    Oracle XML DB:An oracle technical white paper (2003),
  11. 11.
    Ramanath, M., Freire, J., Haritsa, J., Roy, P.: Searching for efficient XML to relational mappings. Technical Report TR-2003-01, DSL/SERC, Indian Institute of Science (2003)Google Scholar
  12. 12.
    Roy, P., Seshadri, S., Sudarshan, S., Bhobe, S.: Efficient and extensible algorithms for multi query optimization. In: Proc. of SIGMOD (2000)Google Scholar
  13. 13.
    Rys, M.: Materialisation and Parallelism in the Mapping of an Object Model to a Relational Multi-Processor System. PhD thesis, ETH, Zurich (1997)Google Scholar
  14. 14.
    Schmidt, A., Kersten, M., Windhouwer, M., Waas, F.: Efficient relational storage and retrieval of XML documents. In: Suciu, D., Vossen, G. (eds.) WebDB 2000. LNCS, vol. 1997, p. 137. Springer, Heidelberg (2000)CrossRefGoogle Scholar
  15. 15.
    Shanmugasundaram, J., Tufte, K., He, G., Zhang, C., DeWitt, D., Naughton, J.: Relational databases for querying XML documents: Limitations and opportunities. In: Proc. of VLDB (1999)Google Scholar
  16. 16.
    Tatarinov, I., Viglas, S., Beyer, K., Shanmugasundaram, J., Shekita, E., Zhang, C.: Storing and querying ordered XML using a relational database system. In: Proc. of SIGMOD (2002)Google Scholar
  17. 17.
    Xiao-ling, W., Jin-feng, L., Yi-sheng, D.: An adaptable and adjustable mapping from XML data to tables in RDB. In: 1st VLDB Workshop on EEXTT (2002)Google Scholar
  18. 18.
    Yoshikawa, M., Amagasa, T., Shimura, T., Uemura, S.: Xrel: A path-based approach to storage and retrieval of XML documents using relational databases. ACM Transactions on Internet Technology 1(1) (2001)Google Scholar
  19. 19.
    Zheng, S., Wen, J.-R., Lu, H.: Cost-driven storage schema selection for XML. In: Proc. Of DASFAA (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Maya Ramanath
    • 1
  • Juliana Freire
    • 2
  • Jayant R. Haritsa
    • 1
  • Prasan Roy
    • 3
  1. 1.SERCIndian Institute of Science 
  2. 2.OGI/OHSU 
  3. 3.Indian Institute of TechnologyBombay

Personalised recommendations