Introduction to Information Systems (IIS)
Spring Term 2009
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: Toufic Saad (Toufic dot Saad 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:
- Project 50% + written exam 50% (the exercises are not graded).
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||Optional Exercise||Project and milestones|
Start Phase 1
|Wed 25-02-2009||Advanced SQL||E1: SQL (solutions)||
Team finalisation (11:30)
Understand Linux, Java, MySQL
|Wed 04-03-2009||Entity/Relitionship Modelling||Create data model and database for your company|
|Wed 11-03-2009||Database Programming, JDBC
Software Development Review
|Get experiene with JDBC: first implementation of Java program|
|Wed 18-03-2009||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 23-03-2008||Phase 1 deadline (15:00)|
Discussion of Phase 1
||Start: 9:00 in exercise room (INF1)|
|Wed 01-04-2009||Relational Algebra||
Start Phase 2
Start interface design
|Wed 08-04-2009||XML and Web Services||Extended design|
|Wed 15-04-2009||Vacation (Easter)|
|Mon 20-04-2009||Web Services 2 INR219|
|Wed 22-04-2009||XML Parsers, XPath and XQuery||E3: XML and Web Services Part I , Part II (solutions)||
Project meeting (discussion of interfaces and roles
Understand Web services
|Mon 27-04-2009||Regular expressions
|Wed 29-04-2009||Recovery||E4: Transactions & recovery (Solutions)||
Phase 2 deadline (15:00)
Start Phase 3
Receive URL (endpoint) + WSDL
|Wed 20-05-2009||Database Heterogeneity||Test service interaction|
Phase 3 deadline (15:00)
Submit final report
|Wed 01-07-2009dd||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)
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: 20 May 2009.