02170 Database Systems, Spring 2006

Mainpage Course Plan E-bar Software Web Docs Project

Lectures

During the first 9-10 weeks there will be a lecture every Thursday (10-12).

Subjects:

 

 

Below is a preliminary plan showing the topics that will be treated at each lecture.

date topic
2/2 Introduction. Relational Algebra and SQL (review).

slides: 1-intro.pdf, RelAlgSQL.pdf
Database eLearning: http://db.grussell.org/index.html SQL, Rel. Alg.
Uploaded Exercises: 5.x.x, 6.x.x, e.g. 5.2.1 a)-f), 6.1.3 a)- f), 6.2.2 a)- -e), etc.

9/2 Entity Relationship Diagrams and Modelling.
slides: 2- ER-diagrams
Database Systems, Dr. Mark Llewellyn, University of Central Florida: http://www.cs.ucf.edu/courses/cop4710/spr2006/notes.html , chapter 2.
Enrico Franconi: Entity-relationship modelling:
http://www.inf.unibz.it/~franconi/teaching/2000/ct481/er-modelling/
Uploaded Exercises:
2.1.1, 2.1.2 a-c, 2.1.3, 2.1.4 a-b, 2.2.3, 2.2.4, 2.3.1 a-b, 2.4.1, 2.4.2
16/2 SQL. From ER diagrams to relational database schemas. Constraints.
slides: 3-ER2Rel.pdf
1) http://www.cs.ucf.edu/courses/cop4710/spr2006/notes.html , ch.3,The Relational Data Model.
2) Bruce Momjian: PostgreSQL: Introduction and Concepts: Constraints
     http://www.postgresql.org/files/documentation/books/aw_pgsql/node127.html
3)Oracle: Maintaining Data Integrity Through Constraints:
     http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a96590/adg05itg.htm
Uploaded Exercises: 3.2.1, 3.2.3, 3.4.4
23/2 SQL subqueries. SQL-invoked routines. Persistent stored modules.
Program access to relational databases. JDBC.
slides: 4-StPro-JDBC-SQL.pdf, slides 1-45.
PostgreSQL manual: Query Language Functions, 32.4: http://www.postgresql.org/docs/8.1/static/xfunc-sql.html
SUN's Java Tutorial, JDBC(TM) Database Access: http://java.sun.com/docs/books/tutorial/jdbc/
2/3 Normalization, SQL constraints
slides: 5-Normalization.pdf, 4-StPro-JDBC-SQL.pdf, slides 46- .
1) http://www.cs.ucf.edu/courses/cop4710/spr2006/notes.html
     CHAPTER 19 - FUNCTIONAL DEPENDENCIES AND NORMALIZATION
2) Database eLearning, http://db.grussell.org/ch4.html , chapter 4, Normalization.
9/3 Semi-structured data & XML
slides: 6-SemiStr-XML.pdf.
1)Chapter 1-3 in Data on the WEB, uploaded to Campusnet.
2)Managing Semi-Structured Data:
http://www.acmqueue.com/modules.php?name=Content&pa=showpage&pid=335 .
3)Read e.g. part of XML for the absolute beginner or one of the many XML tutorials on the net.

4)You can find the complete specifications of XML v 1.0, in the W3C XML Specifications.

5)A pdf-file "XMLtutorial.pdf" corresponding to The XML Revolution,Technologies for the future Web: http://www.brics.dk/~amoeller/XML/ is uploaded to Campusnet.
16/3 XML, DTD, XPath, Demonstration of jEdit
slides: 7-DTD-XPath.pdf.
DTD tutorials/refences (are part of most XML tutorials):
1) http://www.thescarms.com/XML/DTDTutorial.asp#atttype
2) http://www.mihaiu.name/2005/xml-dtd-reference/

XPath tutorials/references:
1) http://doc.ddart.net/xmlsdk/htm/xpath_ref_overview_0pph.htm
2) Microsofts XML Standards Reference:
http://msdn2.microsoft.com/en-us/library/ms256177(VS.80).aspx , XPath section.
3) http://www.w3schools.com/xpath/default.asp

23/3 XML Schema
slides: 8-XMLSchema.pdf.
1) ch.20 in XML1.1 Bible (easy, only a subset), http://www.ibiblio.org/xml/books/bible3/chapters/
2) Anders Møller, MichaelI. Schwartzbach:
 An Introduction to XML and Web Technologies: http://www.brics.dk/ixwt/ ,
ch. 4: http://www.brics.dk/ixwt/IXWT_C04c.pdf (print with gsview)
 3) XFront http://www.xfront.com/ has a link to
Roger L. Costello's XML Schema Tutorial.
30/3 XPath, XQuery.
slides: 9-XQuery.pdf
1)Introduction to XQuery: Priscilla Walmsley:
    http://www.datypic.com/services/xquery/IntroductionToXQuery.pdf
2)XQuery from the Experts:
      ch. 1: XQuery: a guided tour:
      http://www.datadirect.com/developer/xquery/xquerybook/index.ssp
      ch. 2: Influences on the Design of XQuery:
      www.informit.com/content/downloads/chap2_0321180607.pdf
3) XQuery tutorial, Peter Fankhauser and Philip Wadler. XML 2001:
     http://homepages.inf.ed.ac.uk/wadler/papers/xquery-tutorial/xquery-tutorial.pdf
7/4 XQuery, XML Schema, demo of XML database eXist.
slides: 10-XQuery-XMLSchema-2.pdf.
Exist documentation: http://exist.sourceforge.net/documentation.html
  No more lectures

 

All lectures start at 10:00 and will take place in room 13, building 308.

 

 

Hans Bruun     (  hab@imm.dtu.dk ) 06-04-2006