IT-højskolen /Courses Fall 2001 /Database-based Web Publishing

Home page for the course Database-based Web-publishing, fall 2001 (DKM)

Schedule Literature Students Course Grader Q&A Web-Server Hug.it.edu Using Ssh

Teaching Assistants
Kenneth Riis
kenneth@it.edu
Office 1.49
Office hours: Thursday 12.00 - 13.00
Frank Bjergø
bjergoe@it.edu
Office 1.49
Office hours: Wednesday 12.00 - 13.00
Course Responsible
Niels Hallenberg
nh@it-c.dk
Office 2.38
Office hours: Monday 12.00 - 13.00 and Friday 12.00 - 13.00

NEWS

  • 2002-01-21: Resultaterne af eksamen offentliggøres i løbet af den første uge i februar.
  • 2002-01-07: Eksamenssæt for E2000 diskuteres 8. januar klokken 10 -- 12, Lokale 1.60.
  • 2002-01-07: Eksamenssæt for F2001 diskuteres 10. januar klokken 10 -- 12. Lokale 1.60.
  • 2002-01-07: Spørgetime den 11. januar klokken 10 -- 12. Lokale 1.60.
  • 2001-12-07: Eksamen er den 15. januar 2002 fra 09.00 til 13.00 i lokale 0.19. Kom i god tid.
  • 2001-12-07: Pensum er kolonnen ``Reading'' på forelæsningsplanen på hjemmesiden, slides og øvelser. Dog er slides 10.12 -- 10.23 samt 12.1 -- 12.24 undtaget.
  • 2001-11-19: The 12th lecture is held in room 0.10 on Tuesday November 6 at 09.00. You find the slides in the schedule below.
  • 2001-11-12: En projektide af Jacques og Klaus.
  • 2001-10-15: If you are interested in four week projects in December, then Niels is available as your supervisor.

Course Objectives

Learn to use advanced web-techniques to develop realistic, usable web-sites involving interchange of information with a database.

Prerequisites

The course Grundlæggende Web-design or similar prerequisites. If you have no programming experience, then you must be motivated and prepared to put extra effort into the problem sets.

Course Description

Based on knowledge about the creation of static web-sites, the course provides the student with techniques for creating web-sites that are programs and web-sites that are databases. The students are introduced to the programming language TCL (Tool Command Language), for generating HTML code dynamically, and database-programming with Oracle SQL (Structured Query Language), for enriching web-pages with dynamic content. See the schedule below for details.

There is a homepage for this course taught last term.

You may also find more information in the course book (Danish).

When and Where

12 weeks in the fall semester. Lectures are on Tuesdays from 09.00 to 12.00 in room 0.10. Class hours are on Tuesdays from 12.30 to 16.30 in room 4.04 and 4.05.

Grading Policy

Each student is evaluated with a grade in the 13-point scale. The grade is computed from completion of problem sets (50 percent) and a 4-hour written exam (50 percent). The problem sets and the written exam must be independently passed with a grade of 6 to pass the course.

Students turn-in 11 problem sets, individually. Each turned-in problem set is graded with points in the range 0 to 100. A non-turned-in problem set is graded with 0 points. For each student, only the problem sets with the 8 highest scores counts. To get credit for problem set solutions, the student must turn-in the solutions using CourseGrader before 9.00 on the Tuesday following the assignment. Here is a how-to for turning-in a problem set:

To turn-in your solutions to ``Problem set 1'', first make CourseGrader email you your password by providing CourseGrader with your IT-C email address (i.e., login@it-c.dk). You can then login to CourseGrader and turn-in your problem set by pressing the ``status'' link for the course and then the ``turn-in'' link for ``Problem set 1''. You should not enter entire solutions in the text-box. Rather, enter a link to your index-page and briefly describe what you have done and what you haven't done.
For the written exam all kinds of helping material (books, notes, old problem sets, calculators) is allowed, exept programmable computers (or programmable calculators).

Got Questions?

If you have a question about the course or the problem sets, you can post your question on the Q&A forum for the course. In this way, other people benefit from the answers. Notice, that the Q&A forum is the same that were used last semester, and therefore already contains answers to many questions.

You are also welcome to visit the course responsible or a teaching assistant during office hours.

Schedule

The schedule below is tentative, and changes will happen during the semester.

DayWeekTopicReadingProblem set
28/0835Introduction. Static sites. HTML. Slides and Links. *Philip and Alex's Guide to Web Publishing, chapters 1, 4 og 5PS1
PS1-extra
04/0936Introduction to the programming language Tcl. My first dynamic web-page. Slides and Links. *A Smooth Introduction to Tcl for Web NerdsPS2
PS2-extra
11/0937Tcl continued. Tcl on the web server. Forms; obtaining data from users. Slides and Links. *A Smooth Introduction to Tcl for Web Nerds
*Philip and Alex's Guide to Web Publishing, chapter 10 (read example 4; skip the other examples)
PS3
PS3-extra
18/0938Tcl continued. Random numbers. States in web-programs with the use of form variables. Slides and Links. *Tcl for Web Nerds, Sections instroduction and strings.
*Philip and Alex's Guide to Web Publishing, chapter 10, example 3
PS4
PS4-extra
25/0939Tcl continued. Lists. Obtaining data from foreign web-sites. Securing your data by checking form variables. Slides and Links. *Tcl for Web Nerds, Section about lists.
*Philip and Alex's Guide to Web Publishing, chapter 10, example 5
PS5
PS5-extra
02/1040 Tcl continued. Pattern-matching. Slides and Links. *Tcl for Web Nerds, Section about pattern-matching;
*Philip and Alex's Guide to Web Publishing, chapter 11 and 12.
PS6
PS6-extra
09/1041Filebased databases. Sites that are databases. SQL (Structured Query Language). Slides and Links. *SQL for Web Nerds, chapter 2 and 3.
*Philip and Alex's Guide to Web Publishing, chapter 15, case 1 and 2.
PS7
16/1042No TeachingNo TeachingNo Teaching
23/1043Sites that are databases and SQL. Database-transactions via web-forms. Slides and Links. *Philip and Alex's Guide to Web Publishing, chapter 13PS8
30/1044 Interfacing a database to the Web. Online communities. ACS (ArsDigita Community System). Slides and Links. *Philip and Alex's Guide to Web Publishing, chapter 2 and 3PS9
06/1145Securing your data by checking form variables. Procedures for checking form-variables and creating a changable site-design. Slides and Links. No reading for this TuesdayPS10
13/1146Image-maps. Publicizing a site. User tracking. Adding images to a site. The final. The future. Slides and Links. *Philip and Alex's Guide to Web Publishing, chapter 6, 7, 9 and 17 PS11
PS11-extra
20/1147Cookies. User authentification. An PhP3 example. Slides and Links. No reading for this Tuesday 

Literature

Related Literature

Development Server

In the course, we use the development server hug.it.edu, on which all students has a web server running. The development server hug.it.edu is a PC running RedHat Linux. Each student has obtainted a user name and a password to hug.it.edu by email.

You are personally responsible for backing up your files on hug.it.edu!

Software

  • ssh - software for logging in to remote machines securely and for transferring files to and from remote machines securely
  • tclsh - the tcl shell for experimenting with non-web-based tcl-programs
  • AOLserver - the great webserver available for UNIX and Windows. To install this webserver on your own machine, follow the installation instructions on the AOLserver website (Open Source)
  • Postgressql - an Open Source RDBMS

Students

The following class tables maps students to their home pages on hug.it.edu.

If you have not been assigned a class, then please send Niels an email.

Class 1: Thuesday 12.30-16.30Room 4.04Frank Bjergoe
NameEmailWWW
Andreas Jørgensenaj@it-c.dkhttp://hug.it.edu:8217
Anne Mette Kirkegaardannek@it-c.dkhttp://hug.it.edu:8227
Barbara Tvede Andersenbarbaratvede@it-c.dkhttp://hug.it.edu:8213
Benjamin Brink Allsoppben@it-c.dkhttp://hug.it.edu:8242
Christian Güttlerguttler@it-c.dkhttp://hug.it.edu:8202
Christian Gyldahlgyldahl@it-c.dkhttp://hug.it.edu:8250
Daniel Barkaibarkai@it-c.dkhttp://hug.it.edu:8240
Gunver Gjettinggg@it-c.dkhttp://hug.it.edu:8201
Hans Henrik Stiboldt Truelsenhht@it-c.dkhttp://hug.it.edu:8222
Henriette Agerskov Enemarkne@it-c.dkhttp://hug.it.edu:8205
Ina Kristensenina@it-c.dkhttp://hug.it.edu:8204
Jacques Holm Villaume Johansenjacques@it-c.dkhttp://hug.it.edu:8236
Jakob Weber Schjørringjaksen@it-c.dkhttp://hug.it.edu:8221
Jannet Grønfeldtsg@it-c.dkhttp://hug.it.edu:8223
Jens Høystadhoystad@it-c.dkhttp://hug.it.edu:8241
Jesper Guhle Mogensenguhle@it-c.dkhttp://hug.it.edu:8136
Kasper Holstghost@it-c.dkhttp://hug.it.edu:8243
Kathrine Egemaregemar@it-c.dkhttp://hug.it.edu:8229
Katja Charlotte Prausekatprause@it-c.dkhttp://hug.it.edu:8226
Katrine Kornerupkkornerup@it-c.dkhttp://hug.it.edu:8232
Klaus Holger Larsenkhl@it-c.dkhttp://hug.it.edu:8219
Klaus Svarre Christensenkc@it-c.dkhttp://hug.it.edu:8225
Kristian Suomala Fischerksf@it-c.dkhttp://hug.it.edu:8224
Lea Stevens Senderovitzlea@it-c.dkhttp://hug.it.edu:8231
Rikke Kochrikoko@it-c.dkhttp://hug.it.edu:8247
Tina Svenssontsvensson@it-c.dkhttp://hug.it.edu:8251
Class 2: Thuesday 12.30-16.30Room 4.05Kenneth Riis
NameEmailWWW
Birgitte Bindslevbit@it-c.dkhttp://hug.it.edu:8248
Lasse Steensgaard Petersenxls@it-c.dkhttp://hug.it.edu:8249
Lizet Hee Olesenlizet@it-c.dkhttp://hug.it.edu:8210
Maiken Søltoftmaikens@it-c.dkhttp://hug.it.edu:8206
Margit Perlt Jensenmpj@it-c.dkhttp://hug.it.edu:8215
Martin Haagerupmartinh@it-c.dkhttp://hug.it.edu:8209
Mette Kirstine Biebie@it-c.dkhttp://hug.it.edu:8234
Mette Schouschou@it-c.dkhttp://hug.it.edu:8208
Mikkel Jakob Kristiansenmkr@it-c.dkhttp://hug.it.edu:8245
Mohammad Mahbubul Haqmmh@it-c.dkhttp://hug.it.edu:8237
Morten Bach Jensenmbj@it-c.dkhttp://hug.it.edu:8220
Morton Peter Christiansenmorton@it-c.dkhttp://hug.it.edu:8233
Per Haugaard Jacobsenperjacobsen@it-c.dkhttp://hug.it.edu:8235
Poul Erik Stengerstenger@it-c.dkhttp://hug.it.edu:8239
Poul Henning Fabricius Kjærfabric@it-c.dkhttp://hug.it.edu:8214
Rasmus Dan Poulsenripsky@it-c.dkhttp://hug.it.edu:8230
Saif Abduljabbar Mandeel Al Ghanemisaal@it-c.dkhttp://hug.it.edu:8207
Sigrid Jensdottir Dalsgaardsigrid@it-c.dkhttp://hug.it.edu:8244
Steffen Koch Mørck-Larsenskm@it-c.dkhttp://hug.it.edu:8218
Sune Kobberøsunekobberoe@it-c.dkhttp://hug.it.edu:8203
Søren Haubjerg Mortensenshm@it-c.dkhttp://hug.it.edu:8228
Thomas Nørgaardkyklop@it-c.dkhttp://hug.it.edu:8246
Tim Priergaard Rasmussenmazrim@it-c.dkhttp://hug.it.edu:8238
Torben Munksgaardmunksgaard@it-c.dkhttp://hug.it.edu:8216
Trine Malene Holst Jensentrineholst@it-c.dkhttp://hug.it.edu:8212

Others

Name/EmailWWW
Kenneth Riis - teaching assistanthttp://hug.it.edu:8001
Frank Bjergø - teaching assistanthttp://hug.it.edu:8085
Niels Hallenberg - course responsiblehttp://hug.it.edu:8077

updated 2001-05-06
Niels Hallenberg

til top