LSIR course, summer semester 2005

Conception of Information Systems

Description

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

Prerequisites

  • Java Programming
  • Relational Databases and SQL

Team


Lecturers
  

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

jean-philippe.martin-flatin @ epfl.ch

Office: not based at EPFL

Part 2 (3 weeks): Alain Wegmann

alain.wegmann @ epfl.ch

Office: BC 103

 

Assistants  

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

Exercises

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
09.03.05
No exercise

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

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

deployed here

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

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

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

Jsp files (zipped): jsp.zip

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

10.05.05
Lecture 9: Overview of Web Services J.P. Martin-Flatin
11.05.05
No exercise
17.05.05
Lecture 10: Workflow Management and B2B Sarunas Girdzijauskas
18.05.05
No exercise
24.05.05
Lecture 11: Building Web Services with JAX-RPC J.P. Martin-Flatin
25.05.05
Exercise: Web Services
(for login info, read the guidelines)
Solution: solution.zip
31.05.05
Lecture 12: Introduction Part 2 & Requirements Analysis Alain Wegmann
01.06.05
Lecture 13 + Exercise: Requirements Analysis Alain Wegmann
07.06.05
Lecture 14 + Exercise: Requirements Analysis Alain Wegmann
08.06.05
No exercise
14.06.05
Lecture 15 + Exercise: Architecture-Driven Process Alain Wegmann
15.06.05
Lecture 16 + Exercise: Architecture-Driven Process Alain Wegmann

Literature

Books

 

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.

 

Papers

 

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.