XML via SQL Data Provider loads hierarchical XML data into a relational schema that you can query like a relational database.
XML via SQL Data Provider is designed for data-centric XML documents, such as sales order, stock quotes, or scientific data, which are characterized by a regular hierarchical structure.