ShreX: A Generic Middleware for Shredding and Querying XML in
XML is becoming the predominant data exchange format in a variety of
domains ( supply-chain, scientific data processing, telecommunication
By relying on relational storage, XML developers can benefit from a
set of data management services and from the highly optimized
query processors. In order to store XML data in a RDBMS, it is
first that an XML-to-relational mapping be defined. Once a
is selected, XML documents must be appropriately shredded and loaded
the database. Finally, queries over the XML documents must be
into SQL queries over the mapped relations.
ShreX provides a generic mechanism for specifying mappings,
and querying XML documents. The shredding component accepts as
inputs an annotated XML Schema and
documents, and outputs CREATE TABLE statements, and tuples to
the tables. The system provides a point-and-click (Java-based)
to help users perform storage operations and define mappings. The
GUI shows visually the correspondence between the XML schema
their counterparts in generated relational schema.
ShreX can be used with virtually any relational database. The
system was written in Java. Xerces is used to parse and shred XML
documents. Shrex has been tested with DB2 and MySQL.
- Download shrex.zip
- Enter your install directory (cd $install_dir$), and expand the
- Follow the Readme file in the expanded directory.
This project is currently funded by the National Science Foundation grant
Last modified: Feb 7, 2007