Querying MeSH with XQuery and SQL

This is the third in a series of posts on MeSH headings and how they can be manipulated in XML form in XML databases like SQL Server. Before reading this, you’ll want to read the previous post on loading the data, which in turn refers to the original post where I described the schema.

Continue reading


Loading MeSH into SQL Server 2005

One of the neat things you can do with many modern relational database servers is import and index hierarchically-structured XML data in a similar way as you would with tabular data — without ‘shredding’ it into tables and rows.
Continue reading