TDDD43 Advanced Data Models and Databases

Resources for theme 3

• Data sets
  • See separate page
• HShreX
  • The HShrex tool. (Zipped jar-file)
  • Instructions: Launching HShreX on the lab computers
  • HShreX Howto
  • HShreX annotations and shredding rules
• MSDN: Implementing XML in SQL Server
  Information on how to use the XML data type in MS SQL Server. The most useful for the laboration in theme 3 are probably:
  • Creating XML Data Type Variables and Columns
    How to create a column with the XML data type (HShreX already does this, check resulting table definitions created by Shrex.)
  • xml Data Type Methods
    Methods you need for queries on XML data in MS SQL server, e.g. using .query() for XQuery resulting in XML.
  • Generating XML Instances
    How to populate XML columns with data, either as specified by you in the console or read from file (see link to bulk importing for the latter).

Page responsible: Patrick Lambrix
Last updated: 2011-09-20