>
Courses Spring 2002
>
Web Publishing with Databases
Home page for the course ``Web Publishing with Databases'', spring 2002 (DKM)
| Schedule | Literature | Students | Course Grader | Q&A | Web Server | Hug.it.edu | Using Ssh |
| Course Responsiple | Office | |
|---|---|---|
| Martin Elsman (mael@it.edu) | 2.42 | |
| Teaching Assistants | Office | Office hours |
| Frank Bjergøe (bjergoe@it.edu) | 1.49 | Tuesdays, 12-13 |
| Lasse Steensgaard (xls@it.edu) | 1.49 | Wednesdays, 12-13 |
News
- 07-12-2002: Grades are entered in CourseGrader and the exam questions and solutions are available. The final grades have been delivered to the administration office.
- You can now fetch solutions to exercises 7, 8, 9, and 10.
- Earlier exams and solutions are available: F2001 (vejl), E2000 (vejl) og E2000t (vejl).
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 spring semester. Lectures are on Mondays from 09.00 to 12.00 in room 0.19, except February 25 where the lecture is in room 0.10. Class hours are on Mondays from 12.30 to 17.00 in rooms 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 passed independently 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 Monday following the assignment. Here is how you turn-in the first problem set:
To turn-in your solution 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 have not 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 was 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 subject to changes:| Day | Week | Topic | Reading | Problem set |
|---|---|---|---|---|
| 04/02 | 6 | Introduction. Static sites. HTML. Slides. | *Philip and Alex's Guide to Web Publishing, chapters 1, 4 and 5 | |
| 11/02 | 7 | Introduction to the programming language Tcl. My first dynamic Web page. Slides. | *A Smooth Introduction to Tcl for Web Nerds | PS1 PS1-extra |
| 18/02 | 8 | Tcl continued. Tcl on the Web server. Forms; obtaining data from users. Slides. |
*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) | PS2 PS2-extra |
| 25/02 | 9 | Tcl continued. Random numbers. States in Web programs using hidden form variables. Slides. |
*Tcl for Web Nerds, Sections
introduction and strings. *Philip and Alex's Guide to Web Publishing, chapter 10, example 3 | PS3 PS3-extra |
| 04/03 | 10 | Tcl continued. Lists. Slides. | *Tcl for Web Nerds, Section about lists. |
PS4 PS4-extra |
| 11/03 | 11 | Tcl continued. Pattern-matching. Obtaining data from foreign Web sites. Securing your data by checking form variables. Slides. |
*Tcl for Web Nerds,
Section about pattern-matching; *Philip and Alex's Guide to Web Publishing, chapter 10, example 5. | PS5 PS5-extra |
| 18/03 | 12 | Sites that are databases. Filebased databases. SQL (Structured Query Language). Slides. | *Philip and Alex's Guide to Web Publishing, chapter 11, 12, and 15 (case 1 and 2). | PS6 PS6-extra |
| 25/03 | 13 | Sites that are databases and SQL. Database-transactions via Web forms. Slides. | *SQL for Web Nerds, chapter 2 and 3. | PS7 |
| 01/04 | 14 | No Teaching | No Teaching | No Teaching |
| 08/04 | 15 | Interfacing a database to the Web. Building a library of procedures for checking form-variables. Slides. | *Philip and Alex's Guide to Web Publishing, chapter 13 | PS8 |
| 15/04 | 16 | Online communities. ACS (ArsDigita Community System). Procedures for creating a changable site-design. Slides. | *Philip and Alex's Guide to Web Publishing, chapter 2 and 3 | PS9 |
| 22/04 | 17 | Image-maps. Publicizing a site. User tracking. Adding images to a site. The final. The future. Slides. | *Philip and Alex's Guide to Web Publishing, chapter 6, 7, 9 and 17 | PS10 |
| 29/04 | 18 | Cookies. User authentification. Exam E2000. Slides. | No reading | PS11 PS11-extra |
Literature
- Philip Greenspun. Philip and Alex's Guide to Web Publishing. Paperback. 618 pages. May 1, 1999. Morgan Kaufmann. ISBN 1558605347. You have the options of printing it out for free, getting it at Amazon, or buying it from a local book store - I know that Polyteknisk Boghandel at DTU has some copies.
- Martin Elsman. A Smooth Introduction to Tcl for Web Nerds.
- Hal Abelson, Philip Greenspun, and Lydia Sandon. Tcl for Web Nerds.
- Philip Greenspun. SQL for Web Nerds. Tutorial for the SQL language; links into online Oracle docs for completeness.
- Niels Hallenberg. SlideExtractor - the engineering behind a tool for extracting slides from WimpyPoint, a Web based slide-constructor.
Related Literature
- Peter Sestoft. HTML overview. Notes from KVL.
- Mads Tofte. En kort introduktion til skrivning af HTML-dokumenter.
- MIT/W3C. HTML-codes for unusual characters and symbols
- Philip Greenspun. Four Part Article about AOLserver, tcl, and Oracle. In LinuxWorld.
- A Beginner's Guide to HTML
- Ray Johnson. Tcl Style Guide.
- Scriptics.com. Overview of tcl commands.
- Jakob Nielsen. Designing Web Usability.
- Scriptics.com. Tcl Primer.
- Brent Welch. Practical Programming in Tcl and Tk. Selected chapters are available online, among them the chapters Tcl Fundamentals and Regular Expressions. The first version of Welsh's book is available as Postscript
- www.aolserver.com contains complete online docs for the AOLserver Tcl API.
Previous Exams
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 stand alone Tcl programs
- AOLserver - the great Web server available for UNIX and Windows. To install this Web server on your own machine, follow the installation instructions on the AOLserver Web site (Open Source)
- Postgressql - an Open Source RDBMS
