Introduction to Information Systems (IIS)
SSC, 6th semester. Summer Term 2007.
Page outline
Course Description
Databases are at the heart of modern commercial application development. Their use extends beyond this to many applications and environments where large amounts of data must be stored for efficient update and retrieval. The purpose of this course is to provide an introduction to the design and use of database systems, as well as an appreciation of the key issues in building such systems in heterogeneous and Web environments.
We begin with the relational model and the SQL language. We then study methods for database design, covering the entity relationship model. Next, we discuss XML as a data model, and present languages for querying it. We see how XML is used for sharing data among different applications in a distributed environment. There is also a strong focus on XML (SOAP) based Web services. Finally, we touch on some advanced topics on the implementation of database systems, such as transactions, recovery etc.
Organisation
Time & place
Lectures take place in ELA 1, Monday 8:15 - 10:00
Exercises/project: INF 1 & INF 3, Monday 10:15 - 12:00
Your team
Lecturer: Priv.-Doz. Dr. Heinz Stockinger
Assistants:
Gleb Skobeltsyn Project Phase 1
Wojciech Galuba Project phase 2
Sarunas Girdzijauskas Exercises
Ali Salehi Technical infrastructure
Communication
- All announcements regarding the course will be made here on this
page and/or via the course newsgroup: please check both regularly.
- Please use the epfl.ic.cours.IIS newsgroup (Web access). The simple
reason is that your questions (and, more important, the answers) will
be accessible to everybody.
- Use e-mail to ask personal questions or make an appointment.
Exercises, Project & Grading
Students are requested to follow exercises and complete a
project during the course.
The exercises are not graded, but solving them will help to prepare
for the exam. Additionally, some exercises provide important
information on the project!
The project is divided into 3 phases, and each phase will be
graded. More information is available on IIS Project Web site. Please
check it regularly for updates!
The grading formula:
- Exercises 0% + Project 50% + written exam 50%.
Overall Schedule
The following table gives you a quick overview of the semester. We will update it to reflect necessary changes, add slides, solutions, etc.
| Date | Lecture | Exercise | Project and milestones |
| Mon 12-03-2007 | Introduction
Basic SQL
|
Project introduction Start Phase 1 |
|
| Mon 19-03-2007 | Advanced SQL
|
E1: SQL (solutions) |
Team finalisation (11:30) Understand Linux, Java, MySQL |
| Mon 26-03-2007 | Conceptual Modelling and Schema Design
|
Understand data source (Web site) and create data model and database | |
| Mon 02-04-2007 | Database Programming, JDBC Regular Expressions
|
Web crawler and data import with JDBC: first implementation of Java program | |
| Mon 09-04-2007 | Vacation (Easter) | ||
| Mon 16-04-2007 | Functional Dependencies
|
E2: Functional Dependency, Relational Algebra and DB Tuning (solutions) | Improved program/crawler and DB tuning for inserts and queries |
| Mon 23-04-2007 | Relational Algebra
|
Finalise program and report | |
| Thu 26-04-2007 | Phase 1 due (17:00) | ||
| Mon 30-04-2007 | XML and Web Services
|
Phase 1 discussion Start Phase 2 Design/implement local interface |
|
| Mon 07-05-2007 | Web Services 2
|
E3: XML and Web Services (Part 1) | Understand Web services |
| Mon 14-05-2007 | XML Parsers, XPath and XQuery
|
E3: XML and Web Services (Part 2 - solutions Part 1) | Build Web service and create WSDL |
| Mon 21-05-2007 | Transactions
|
E3: XML and Web Services (solutions Part 2) | Finalise Web service |
| Mon 28-05-2007 | Vacation (Pentecôte) | ||
| Tue 29-05-2007 | Phase 2 due (17:00) | ||
| Wed 30-05-2007 |
Start Phase 3 Receive URL (endpoint) + WSDL |
||
| Mon 04-06-2007 | Recovery
|
E4: Transactions & recovery (Solutions) | Schema integration |
| Mon 11-06-2007 | Database Heterogeneity
|
Project finalisation and report | |
| Fri 15-06-2007 | Phase 3 due (17:00) | ||
| Mon 18-06-2007 |
Final project discussion (8:15-12:00 INF1) |
||
| Mon 25-06-2007 | Test exam | ||
| Fri 13-07-2007 | Final exam.
|
Rules:
|
Miscellaneous
Literature
Databases and Transaction Processing, An application-oriented approach: Philip M. Lewis, Arthur Bernstein, Michael Kifer, Addison-Wesley 2002.
Database Systems: The Complete Book: Hector Garcia-Molina, Jeffrey Ullman, Jennifer Widom
Database Management Systems: Ramakrishnan
Fundamentals of Database Systems, Elmasri, Navathe
Database Systems, Date (7. edition)
Modern Database Management, Hoffer, (4. edition)
Database Systems Concepts, Silverschatz, (4. edition)
IIS course summary 2005 by Martin Rubli. (we do not support this document, but it can be useful as a reference)
Attendance
We hope you will attend every lecture. If you miss a lecture, please contact a colleague who was present, and be sure to check the Web site for any information passed during the lecture.
Academic Misconduct
All work turned in is expected to be your own. Although students are encouraged to study together, each student is expected to produce her/his own solution to the homework problems and projects. Copying or using sections of someone else's or some other group's program, even if it has been modified by you, is not acceptable.
_____________________
Latest update: 25 June 2007.