CSC 560: Topics in Database Systems: XML Data Management
Fall 2007

Instructor: Alexander Dekhtyar, dekhtyar at csc.calpoly.edu, 14-209

Office Hours:

When		Who	Where
Monday		Alex	14-209
Tuesday	11:00am - 12:00pm	Alex	14-209
Wednsday		Alex	14-209
Thursday	11:00am - 12:00pm	Alex	14-209

Additional appoinments: send email.

News and Notes

• We now have a wiki. The wiki will be devoted to XML indexing methodologies.
  [November 5, 2007]

• The next step for the course project is November 6, the Progress Report Day. Information about progress reports is here.
  [October 8, 2007]

• Syllabus (final draft, some minor things may change) is now posted.
  [September 2, 2007]

• This quater's database topics course will be concentrated on XML, its uses in the field of databases and data management and various aspects of working with XML data. We will try to concentrate on two things: (a) studying the ways of storing XML data in various kinds of databases (relational, native XML) and (b) querying XML data using XPath and XQuery. Hands-on experience with building software for management of XML data and for working with XML-supported applications will be provided throughout the course. More here....
  [August 28, 2007]

• Page created. Some links are just placeholders, the files will be placed later.
  [August 28, 2007]

Course Materials

Homeworks

Homework 1	Due: September 20	CD database	Postscript	PDF	Powerpoint (results)	[September 18, 2007]
Homework 2	Due: September 25	Groups	Postscript	PDF		[September 18, 2007]
Homework 3	Due: October 16	XPath and MonetDB	Postscript	PDF		[October 11, 2007]
Homework 4	Due: November 22 26	XQuery	Postscript	PDF		[November 1, 2007]
Homework 5	Due: November 20	XML Indexing wiki	Postscript	PDF		[November 5, 2007]

Project

Project Proposal	Due: October 4	Postscript	PDF	[September 24, 2007]
Design and Progress Report	Due: November 6	Postscript	PDF	[October 8, 2007]
Project Completion Instructions	Due: December 4	Postscript	PDF	[November 7, 2007]

Data Files

hello.xml	simple sample XML file		[October 11, 2007]
dblp-tiny.xml	a tiny portion of the DBLP database	DTD	[October 11, 2007]
auctions1.xml	smallest output generated by XMark's xmlgen utility		[October 11, 2007]
deep.xml	a small synthetic XML file		[October 11, 2007]
menu.xml	Restaurant menu		[November 1, 2007]
orders.xml	List of restaurant orders		[November 1, 2007]

Lecture Notes

Lecture 1a	XML in a Nutshell	Postscript	PDF		[September 17, 2007]
Lecture 1b	XML Recommendation in a Nutshell	Postscript	PDF	Powerpoint (grammars)	[September 16/20, 2007]
Lecture 2	XML DTD	Postscript	PDF		[September 17, 2007]
Lecture 4	Document Object Model (DOM)	Postscript	PDF	Powerpoint	[September 17, 2007]
Lecture 5	XPath	Postscript	PDF		[September 17, 2007]
Lecture 6	XPath axis evaluation	Postscript	PDF		[September 17, 2007]
Lecture 7	MonetDB installation	Postscript	PDF		[October 11, 2007]
Lecture 8	Intro to XQuery	Postscript	PDF		[October 11, 2007]
Lecture 9	XQuery quantification	Postscript	PDF		[October 23, 2007]
Diagram	XQuery/XML Schema atomic types diagram	Postscript	PDF		[October 30, 2007]
Lecture 10	XQuery built-in functions	Postscript	PDF		[October 30, 2007]
Lecture 11	User-defined functions in XQuery	Postscript	PDF		[October 30, 2007]
Lecture 12	Storage of XML in Relational Data	Postscript	PDF		[November 1, 2007]

MonetDB XQuery

MonetDB XQuery on-line documentation

Linux installation script (monetdb-install.sh), local version

MonetDB downloads page

MonetDB project home page

Pathfinder XQuery project

XMark - an XQuery benchmark

Other Materials

General Resources

• World Wide Web Consortium

• DBLP - Database and Logic Programming Bibliography server. (ACM mirror. Original site is here).[posted: Sep 25]

• ACM SIGKDD: Special Interest Group on Knowledge Discovery in Databases.