Introduction to Information Systems (IIS)
SSC, 6th semester. Summer Term 2008.
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.
Time & place
Lecturer: Priv.-Doz. Dr. Heinz Stockinger
Student Assistant: Christian Abegg (Christan dot Abegg at epfl dot ch)
- 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%.
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|
Start Phase 1
|Mon 25-02-2008||Advanced SQL||E1: SQL (solutions)||
Team finalisation (11:30)
Understand Linux, Java, MySQL
|Mon 03-03-2008||Entity/Relitionship Modelling||Create data model and database for your company|
|Mon 10-03-2008||Database Programming, JDBC
Software Development Review
|Get experiene with JDBC: first implementation of Java program|
|Mon 17-03-2008||Relational Data Model||E2: Database tuning, Functional dependencies (solutions)||
Adapt database schema accoring to normal forms.
Improved program and DB tuning for inserts and queries.
|Mon 24-03-2008||Vacation (Easter)|
|Mon 31-03-2008||Relational Algebra||Finalise program and report|
|Thu 03-04-2008||Phase 1 due (17:00)|
|Mon 07-04-2008||XML and Web Services||
Phase 1 discussion
Start Phase 2
First design ideas for tranding place (companies + bank).
|Mon 14-04-2008||Web Services 2||E3: XML and Web Services Part I , Part II (solutions)||
Project meeting (discussion of interfaces and roles (companies + bank)
Understand Web services
|Mon 21-04-2008||XML Parsers, XPath and XQuery||Build Web service and create WSDL|
|Mon 28-04-2008||Regular expressions
Phase 2 due (10:00)
Phase 2 discussion (Finalisation of interfaces and screen shots)
Start Phase 3
Receive URL (endpoint) + WSDL
|Mon 04-05-2007||Recovery||E4: Transactions & recovery (Solutions)||Start full service implementation acording to WSDL|
|Mon 12-05-2008||Vacation (Pentecôte)|
|Mon 19-05-2008||Database Heterogeneity||Test service interaction|
Phase 3 due (17:00)
Submit final report
Project finalisation: on-line trading (8:15-12:00 INF1)
|Thu 26-06-2008dd||Final exam.
Databases and Transaction Processing, An application-oriented approach: Philip M. Lewis, Arthur Bernstein, Michael Kifer, Addison-Wesley 2002. (main reference book for the course)
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)
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.
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: 16 May 2008.