Defining and using schemas to capture particular kinds of XML document.
Semistructured data: what that is, the XPath data model of trees to represent it, and the XML language supporting that
Slides : Recording This afternoon the final lecture on Structure Data covered a range of database topics: ACID properties for transactions; the NoSQL movement; nested SQL queries, set operations, and aggregate queries; ultimate physical limits to computation; the wonders of
Basics of SQL: the language, writing simple queries, how these are executed.
One language to describe what data you want to see; another to formulate how to find it. Also, the unsettling capabilities of Facebook Graph Search.
Mathematical operations for slicing and dicing relational tables. Plus, some big databases.
Translating high-level visual plans for organising data into the linked tables of a relational database.
Capturing some high-level concepts in ER diagrams; and the classic “relational” model of linked tables making up a database.
Ways to talk about highly structured data: entities, attributes, keys, relationships, and the language of ER diagrams.
Brief overview of the course and its content.