Standing on the Shoulders of Ants: Towards More Efficient XML-to-Relational Mapping Strategies

As XML has become a standard for data representation, it is inevitable to propose and implement techniques for efficient managing of XML data. A natural alternative is to exploit features and functions of (O)RDBMSs, i.e. to rely on their long theoretical and practical history. The main concern of such techniques is the choice of an appropriate XML-to-relational mapping strategy. In this paper we propose an enhancing of so-called adaptive mapping methods which evaluate several mapping possibilities and choose the one which suits the current application the most. We optimize the process of searching the optimal strategy using a heuristic called ant colony optimization and we enhance the adaptivity using similarity of XML data and ideas of user-driven techniques.

[1]  Sihem Amer-Yahia Storage Techniques and Mapping Schemas for XML , 2003 .

[2]  Vishu Krishnamurthy,et al.  Performance Challenges in Object-Relational DBMSs , 1999, IEEE Data Eng. Bull..

[3]  I. Mlynkova A Journey towards More Efficient Processing of XML Data in (O)RDBMS , 2007, 7th IEEE International Conference on Computer and Information Technology (CIT 2007).

[4]  Holger Meyer,et al.  XML and Object-Relational Database Systems - Enhancing Structural Mappings Based on Statistics , 2000, WebDB.

[5]  Yannis Papakonstantinou,et al.  Storing and querying XML data using denormalized relational databases , 2005, The VLDB Journal.

[6]  Mauro Birattari,et al.  Dm63 Heuristics for Combinatorial Optimization Ant Colony Optimization Exercises Outline Ant Colony Optimization: the Metaheuristic Application Examples Generalized Assignment Problem (gap) Connection between Aco and Other Metaheuristics Encodings Capacited Vehicle Routing Linear Ordering Ant Colony , 2022 .

[7]  David J. DeWitt,et al.  Relational Databases for Querying XML Documents: Limitations and Opportunities , 1999, VLDB.

[8]  Juliana Freire,et al.  From XML schema to relations: a cost-based approach to XML storage , 2002, Proceedings 18th International Conference on Data Engineering.

[9]  C. M. Sperberg-McQueen,et al.  Extensible Markup Language (XML) , 1997, World Wide Web J..

[10]  Sihem Amer-Yahia,et al.  A comprehensive solution to the XML-to-relational mapping problem , 2004, WIDM '04.

[11]  Daniela Florescu,et al.  Storing and Querying XML Data using an RDMBS , 1999, IEEE Data Eng. Bull..

[12]  Hongjun Lu,et al.  Cost-driven storage schema selection for XML , 2003, Eighth International Conference on Database Systems for Advanced Applications, 2003. (DASFAA 2003). Proceedings..

[13]  Dong Yi-sheng,et al.  An Adaptable and Adjustable Mapping from XML Data to Tables in RDB , 2003, VLDB 2003.