Weeks | Topic |
---|---|
Weeks 1-4 | DB Design & SQL |
Weeks 5-11 | Heterogeneous Data (XML, Text, RDF/Graph) |
Lecture | Topic | Read | Slides | Extra Read |
---|---|---|---|---|
Lecture 1 | Introduction, Basics of XML | [WDM, chapter 1] | ||
Lecture 2 | Document Type Definitions (DTDs) | [WDM, chapter 1] | ||
Lecture 3 | DTDs (regular expressions) and DOM | [WDM, chapter 1] | ||
Lecture 4 | SAX Parsing, Entity Relationship Model | [WDM, chapter 1] | ||
Lecture 5 | ER Model, normal forms | |||
Lecture 6 | normal forms | |||
Lecture 7 | simple SQL queries | |||
Lecture 8 | SQL and beyond | |||
Lecture 9 | Spatial queries and indexes in MySQL | |||
Lecture 10 | Text indexing (inverted files), scoring | [WDM, chapter 13] | [Zobel, Moffat 2006] | |
Lecture 11 | TFIDF Scoring, Lucene | [Robertson 2004] | ||
Lecture 12 | Lucene, JDBC | |||
Lecture 13 | Online Text Matching (Automaton, KMP) | |||
Lecture 14 | KMP, Boyer-Moore | |||
Lecture 15 | Off-Line String Matching: Suffix Tree | |||
Lecture 16 | Surrix Array, Burrows-Wheeler Transform | |||
Lecture 17 | XPath | [WDM, chapter 2.3] | ||
Lecture 18 | XSLT | [WDM, chapter 10] | ||
Lecture 19 | RDF and SPARQL | [WDM, chapter 7] | ||
Lecture 20 | Recap I | |||
Lecture 21 | Recap II | |||
Lecture 22 | NULLs considered harmful (guest lecture) |
Informatics Forum, 10 Crichton Street, Edinburgh, EH8 9AB, Scotland, UK
Tel: +44 131 651 5661, Fax: +44 131 651 1426, E-mail: school-office@inf.ed.ac.uk Please contact our webadmin with any comments or corrections. Logging and Cookies Unless explicitly stated otherwise, all material is copyright © The University of Edinburgh |