Description
XML is commonly supported by SQL database systems. However, existing mappings of XML to tables can only deliver satisfactory query performance for limited use cases. In this paper, we propose a novel mapping of XML data into one wide table whose columns are sparsely populated. This mapping provides good performance for document types and queries that are observed in enterprise applications but are not supported efficiently by existing work. XML queries are evaluated by translating them into SQL queries over the wide sparsely-populated table. Mapping nested elements to flattened tables is the key problem for supporting XML on SQL databases. Many mapping schemes have been proposed to decompose nested structures into normalized tables.
Tags: 2014, Data Mining Projects, Java