LSIR course, summer semester 2005

Conception of Information Systems


This lecture presents the key concepts in the development of information systems with respect to technology selection and requirements analysis.
The first part of the lecture (11 weeks), given by Jean-Philippe Martin-Flatin, introduces the state of the art of the technologies and their underlying concepts for developing intra- and inter-enterprise applications. It gives emphasis to those technologies that provide for Web integration.
The second part of the lecture (3 weeks), given by Alain Wegmann, gives an introduction to a requirements analysis method. It provides the students with a method to select a requirements technology.

Credits: 4
When: Lectures: Tuesday 2:00 pm - 4:00 pm, Exercises: Wednesday 5:00 pm - 7:00 pm.
Where: Lectures: room CO2, Exercises: room INF3.
Newsgroup: epfl.ic.cours.cis


  • Java Programming
  • Relational Databases and SQL



Part 1 (11 weeks): J.P. Martin-Flatin

jean-philippe.martin-flatin @

Office: not based at EPFL

Part 2 (3 weeks): Alain Wegmann

alain.wegmann @

Office: BC 103



Exercise 1: XML

Office: BC 160

Exercise 2: JDBC and JSP

Office: BC 170

Exercise 3: Distributed Transactions

Office: BC 170

Exercise 4: Enterprise Java Beans

Office: BC 170

Exercise 5: Web Services

Office: BC 118


Part 1

  • The exercises consist of practical assignments (programming) and are solved in groups of two people.

  • There are five exercises in the semester:

    1. XML and integration of heterogeneous data

    2. JDBC and JSP

    3. Distributed Transactions

    4. JMS and Enterprise Java Beans

    5. Web Services

  • There will be one exercise session every second week in room INF3.

  • Your proposed solutions will be submitted electronically to the assistant in charge of that exercise.

  • Solutions to the exercises will be provided online. Each one can be discussed with the assistant in charge of this exercise session.

  • The exercises of part 1 are not graded.

  • Please read some practical guidelines before starting to work on the exercises.

Part 2

  • Similar to part 1 except that exercises and lectures are mixed and given in CO2.

  • The exercises of part 2 are not graded.

Final Grade

There is a final written exam. The final grade is computed as follows:

final_grade = 0.75 · exam_grade_part1 + 0.25 · exam_grade_part2


Here is an example of an exam for this course.

Lecture Schedule

Date Slides/Assignments Lecturer
08.03.05 Introduction to the course

Lecture 1: Basics
J.P. Martin-Flatin
No exercise

Lecture 2: Structured Web Documents J.P. Martin-Flatin
Exercise: XML, DTD, XML Schema
(for login info, read the guidelines)

Lecture 3: Integration of Heterogeneous Databases  J.P. Martin-Flatin
No exercise
Easter Holiday
Easter Holiday
Lecture 4: Web Access to Databases J.P. Martin-Flatin
Exercise: JDBC and JSP
(for login info, read the guidelines)
solution: ex2.war, use unzip

deployed here

Lecture 5: Transactions J.P. Martin-Flatin
No exercise
Lecture 6: Transaction Monitors

Seminar: Information Systems: a Business Perspective
J.P. Martin-Flatin

Consultant from Accenture
Exercise: Distributed Transactions
(for login info, read the guidelines)
Solution: pdf

Jsp files (zipped):

Lecture 7: CORBA J.P. Martin-Flatin
No exercise
Lecture 8: J2EE and EJBs J.P. Martin-Flatin
Exercise: EJB
(for login info, read the guidelines)
solution:, use unzip

Lecture 9: Overview of Web Services J.P. Martin-Flatin
No exercise
Lecture 10: Workflow Management and B2B Sarunas Girdzijauskas
No exercise
Lecture 11: Building Web Services with JAX-RPC J.P. Martin-Flatin
Exercise: Web Services
(for login info, read the guidelines)
Lecture 12: Introduction Part 2 & Requirements Analysis Alain Wegmann
Lecture 13 + Exercise: Requirements Analysis Alain Wegmann
Lecture 14 + Exercise: Requirements Analysis Alain Wegmann
No exercise
Lecture 15 + Exercise: Architecture-Driven Process Alain Wegmann
Lecture 16 + Exercise: Architecture-Driven Process Alain Wegmann




P. Timmers, Electronic Commerce - Strategies and Models for Business-to-Business Trading, Wiley, 2000.


F. Leymann and D. Roller, Production Workflows, Prentice Hall, 2000.


R. Monson-Haefel, Enterprise Java Beans, O'Reilly, 2nd Edition, 2000.


P. Gomez and P. Zadroznyy, Java 2 Enterprise Edition with BEA Weblogic Server, Wrox Press, 2000.


R. Zahavi, Enterprise Application Integration with CORBA, Wiley, 2000.


R. Orfali, D. Harkey and J. Edwards, Client/Server Survival Guide, 3rd Edition, Wiley, 1999.


D. Box, A. Skonnard and J. Lam, Essential XML: Beyond Markup, Addison Wesley, 2000.


C. Goldfarb and P. Prescod, The XML Handbook, 5th Edition, Prentice Hall, 2004.


G. Alonso, F. Casati, H. Kuno and V. Machiraju, Web Services: Concepts, Architectures and Applications, Springer, 2004.


M. Singh and M. Huhns, Service-Oriented Computing: Semantics, Processes, Agents, Wiley, 2005.


K. Boucher and F. Katz, Essential Guide to Object Monitors, Wiley, 1999.


M. Henning and S. Vinoski, Advanced CORBA Programming with C++, Addison Wesley, 1999.


St. Laurent, Cerami, Building XML Applications, McGraw Hill, 1999.


S. Abiteboul, D. Suciu and P. Bunemann, Data on the Web: From Relations to Semi-Structured Data and XML, Morgan Kaufman, 2000.


M.T. Vzsu and P. Valduriez, Principles of Distributed Database Systems, 2nd Edition, Prentice Hall, 1999.




S. Busse, R.-D. Kutsche, U. Leser and H. Weber, "Federated Information Systems: Concepts, Terminology and Architectures", Technical Report Nr. 99-9, TU Berlin, 1999.


IEEE Data Engineering Bulletin, Special Issue on Interoperability, Vol. 21, No. 3, September 1998.


S. Spaccapietra, C. Parent and Y. Dupont, "Model Independent Assertions for Integration of Heterogeneous Schemas", VLDB Journal, Vol. 1, No. 1, pp. 81-126, 1992.


F. de Ferreira Rezende and K. Hergula, "The Heterogeneity Problem and Middleware Technology: Experiences with and Performance of Database Gateways", in Proc. VLDB 1998, pp. 146-157.


Supplementary reading material


D. Box, A. Skonnard and J. Lam, XSL Transformations: XSLT Alleviates XML Schema Incompatibility Headaches.


D. Fallside and P. Walmsley (Eds.), XML Schema Part 0: Primer Second Edition, W3C Recommendation, 28 October 2004.


S. Busse, R.D. Kutsche, U. Leser and H. Weber, Federated Information Systems: Concepts, Terminology and Architectures, Forschungsberichte des Fachbereichs Informatik, Bericht Nr. 99-9.


About Monitors: Database Technologies for Large Scale Databases in Telecommunication.


OMG Transaction Service Specification, ch 1-2.


Introduction to BEA WebLogic Server 5.1.


The Workflow Reference Model.


Biztalk Framework 2.0 and Biztalk server example.