Working with XML as with SQL. With using what?

Question

Database

Good afternoon. Probably a stupid question, but still.
I have a SQL database. I can easily query a table, change data in it based on queries, and so on.
And so what tools are for similar work with XML? Well, for example, I need to go through an XML document and, in each specific branch, replace the element values ​​according to a request for another document. xQuery? XPath? I am very poorly familiar with these technologies, push at least where to dig.
Thank you.

Answer 1

XQuery is a more general standard that includes XPath .
And as far as I understand, he does not know how to make ixemel updates. They promise to implement this operation in the new version of the standard.
It says:
The XML Query Working group is working on a facility to allow XQuery expressions to create and update persistent data.
In general, in programming languages ​​and frameworks there are implementations of Xml Query with the ability to update.

Answer 2

DOM?

Answer 3

xpath

Answer 4

If .net, then linq to xml - queries will be essentially exactly the same as in regular sql.

Answer 5

XSLT. Receives an XSLT and XML document and possibly parameters as input, then traverses the document and applies templates according to the XSLT content. Can load additional XML documents.

Answer 6

I recently tried Groovy's XmlSlurper - loved it
groovy.codehaus.org/Reading+XML+using+Groovy%27s+XmlSlurper

Answer 7

To work with a database in XML format, there are such tools as, for example, BaseX .
Provides client-server technology (there are clients for most popular languages ) and has its own REST API for working with data.
Very handy for creating your own data access API. The query language is XQuery . SQL
data access facilities included .