LSIR course, summer semester 2004

Conception of Information Systems

Description

This lecture demonstrates the key concepts in the development of information systems with respect to technology selection and requirements analysis.
The first part of the lecture (11 units), given by Prof. Aberer, introduces the state of the art 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 units), held by Prof. Wegmann, gives an introduction to a requirements analysis method. It provides the students with a method to perform a requirements technology selection.

Credits: 3
Written exam (see last year's test exam and final exam)
Time and Place: Lecture: Tuesday 14:00 - 16:00, room CO 2, Exercise: Wednesday 16:00 - 18:00, IN3.
Newsgroup: epfl.ic.cours.CIS

Prerequisites

  • Java Programming
  • Relational Databases and SQL
  • Transactions
  • Message Oriented Middleware: JMS
  • Distributed Objects: RMI, CORBA

Team

Lecturers      

Part 1 (11 units): Prof. Karl Aberer

karl.aberer @ epfl.ch

Office: PSE A 1.32

 

Part 2 (3 units): Prof. Alain Wegmann

alain.wegmann @ epfl.ch

Office: INN 135

 

 

 

 

 

Assistants      

Exercise 1: XML

Office hours:

Tue 13:00 - 14:00

Exercise 2: JDBC and JSP

Office hours:

Wed 14:00 - 15:00

Exercise 3: Distributed Transactions

Office hours:

Mon 14:30 - 15:30

Exercise 4: Enterprise Java Beans

Office hours:

Mon 14:30 - 15:30

Exercise 5: Web Services

Office hours:

 

Exercises

Part 1

  • The exercises consist of practical homework assignments and are solved in groups of two.

  • There are five exercises:

    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 every two weeks.

  • You can use the machines in IN 1 and IN 3 to solve the exercises..

  • Solutions are submitted electronically.

  • Solutions for the old exercise and an introduction to the new one will be presented during the exercise hours.

  • Please read these 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 CO 2.

  • The exercises of part 2 are not graded.

Finale Grade

There is a final written exam. The final grade is computed in the following way:

0.75 · max(gradepart1, (1 - 0.1 · nrex) · gradepart1 + 0.1 · nrex · gradeexercise) + 0.25 · gradepart2

 

nrex = number of exercises submitted

gradeexercise= average grade of submitted exercises

gradepart1 = exam grade part 1 (3 questions)

gradepart2 = exam grade part 2 (1 question)

Thus, part 1 counts 75% and part 2 counts 25%. The weight of the exercises (of part 1) is at most 33% if they are better than the exam grade of part 1.

 

You can download Test Exam

Lecture Schedule

Date Slides/Homework Lecturer Homework Solutions
09.03.04 Lecture: Introduction (pdf), Structured Web Documents (pdf) (recap) Prof. Aberer
10.03.04
No exercise


16.03.04
Lecture: Structured Web Documents (pdf) Prof. Aberer
17.03.04
Exercise: XML, DTD, XML Schema
bank.dtd, bank.xsd

grades are distributed on May, 5th

23.03.04
Lecture: Database Integration (pdf)  Prof. Aberer
24.03.04
No exercise

30.03.04
Lecture: Web Database Access (pdf)  Prof. Aberer
31.03.04
Exercise: JDBC and JSP
exercise2.war
06.04.04
Lecture: Transactions (pdf) Prof. Aberer
07.04.04
No exercise

13.04.04
Easter Holiday

14.04.04
Easter Holiday

20.04.04
Lecture: Transaction Monitors (pdf) Prof. Aberer
21.04.04
Exercise: Distributed Transactions
Solution_ex3.zip
27.04.04
Lecture: Components/EJB (pdf) Prof. Aberer
28.04.04



04.05.04
Lecture: EJB Prof. Aberer
05.05.04
Exercise: JMS and Enterprise Java Beans
Solution
11.05.04
Lecture: Web Services (pdf) Prof. Aberer
12.05.04



18.05.04
Lecture: Web Services (pdf) Prof. Aberer
19.05.04
Exercise: Web Services
Solution
25.05.04
Lecture: Workflow systems (pdf) Prof. Aberer
26.05.04



01.06.04
Lecture: Intro Part 2 & Req. Analysis Prof. Wegmann
02.06.04
Lecture / Exercise: Req. Analysis Prof. Wegmann
08.06.04
Lecture / Exercise: Req. Analysis Prof. Wegmann
09.06.04



15.06.04
Lecture / Exercise: Archi.Driven Process Prof. Wegmann
16.06.04
Lecture / Exercise: Archi.Driven Process Prof. Wegmann

Literature

Books

 

P. Timmers, "Electronic commerce - strategies and models for business-to-business trading", Wiley 2000.

 

F. Leymann, D. Roller: "Production Workflows", Prentice Hall, 2000.

 

R. Monson-Haefel, "Enterprise Java Beans", O'Reilly, Second Ed., 2000.

 

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

 

R. Zahavi, Enterprise Application Integration with CORBA, John Wiley, New York, 2000.

 

R. Orfali, D. Harkey, J. Edwards: Client/Server Survival Guide, third edition, John Wiley, New York, 1999.

 

Box, Skonnard, Lam: Essential XML, Addison Wesley, 2000.

 

Goldfarb, Prescod: The XML Handbook, Prentice Hall, 2000.

 

K. Boucher, F. Katz: "Essential Guide to Object Monitors", John Wiley, New York, 1999.

 

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

 

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

 

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

 

Vzsu, Valduriez: Principles of Distributed Database Systems, Second Edition, Prentice Hall, 1999.

 

Papers

 

S. Busse, R.-D. Kutsche, U. Leser, H. Weber, Federated Information Systems: concepts, terminology and architectures, Technical Report Nr. 99-9, TU Berlin, 1999.

 

IEEE Data Engineering Bulletin, Volume 21, Number 3, September 1998, Special Issue on Interoperability.

 

Stefano Spaccapietra, Christine Parent, Yann Dupont: Model Independent Assertions for Integration of Heterogeneous Schemas. VLDB Journal 1(1): 81-126 (1992).

 

Fernando de Ferreira Rezende, Klaudia Hergula: The Heterogeneity Problem and Middleware Technology: Experiences with and Performance of Database Gateways. VLDB 1998: 146-157.

 

Supplementary reading material

 

XSL Transformations: XSLT Alleviates XML Schema Incompatibility Headaches, Don Box, Aaron Skonnard, John Lam (html document)
XML Schema Part 0: Primer, W3C Candidate Recommendation 24 October 2000 (html document)

 

Federated Information Systems: Concepts, Terminology and Architectures, Susanne Busse, Ralf-Detlef Kutsche, Ulf Leser, Herbert Weber, Forschungsberichte des Fachbereichs Informatik, Bericht Nr. 99-9 (pdf article)

 

Using the Web DataBlade Module (html document): http://examples.informix.com/frameset.html#top?initial_page=/doc/case_studies/datablade/apb/apbLOC.html

 

Database Technologies for Large Scale Databases in Telecommunication, Eurescom Deliverable, Part 1: Transaction Processing Monitors (pdf document)
OMG Transaction Service Specification, ch 1-2 (pdf document)

 

Introduction to BEA WebLogic Server 5.1 (html document)

 

Workflow Management Coalition: The Workflow Reference Model (pdf document)

 

Biztalk Framework 2.0 (Word document) and Biztalk server example (html document)