Conception of Information Systems

Summer Semester 2002-2003, School of Computer and Communication Sciences

Lecture Team

Prof. Karl ABERER (Part 1)	karl.aberer @ epfl.ch	+41-21-693 4679	PSE A 1.32
Prof. Alain WEGMANN (Part 2)	alain.wegmann @ epfl.ch	+41-21-693 4381	INN 135
Zoran DESPOTOVIC (Exercises part 1)	zoran.despotovic @ epfl.ch	+41-21-693 5260	PSE A 1.52
Philippe CUDRE-MAUROUX (Exercises part 1)	philippe.cudre-mauroux @ epfl.ch	+41-21-693 6787	PSE A 1.51
Gil REGEV (Exercises part 2)	gil.regev @ epfl.ch	+41-21-693 6790	INN 036

Time and Place

	Tuesday 14-16 Room CO 1, Wednesday 16-18 IN1, Room IN1 also reserved Tuesday 16-18 Contact hour with assistants: 13h-14h (Tuesday) and 15h-16h (Wednesday)

Newsgroup

	epfl.ic.cours.CIS

Description

	This lecture (4 credits) demonstrates the key concepts in the development of information systems with respect to technology selection and requirements analysis. In the first part of the lecture (11 units), given by Prof. Aberer, the state of the art technologies and their underlying concepts for developing intra and inter enterprise applications are introduced. Emphasis is given to those technologies that provide for Web integration. In the second part of the lecture (3 units), held by Prof. Wegmann, an introduction into a requirements analysis method is given. This should provide the students a method to perform a requirements technology selection.

Prerequisites

For the first part of the lecture some familiarity with the following will be assumed:

Java Programming
SQL (Relational Databases)
Transactions (Distributed Systems)
Message Oriented Middleware - JMS (Distributed Systems)
Distributed Objects - RMI, CORBA (Distributed Systems)

Final Exam

Written exam. Last year test exam (pdf), final exam (pdf)

Exercises

For part 1, the exercises consist of homework assignments of practical nature and serve to experience some of the technologies directly. They will be posed in a way that they can be solved in principle on paper, but we will offer the opportunity to gather practical experiences by doing them with real systems. For practical reasons, as these systems usually require complex software, this has to be done outside the exercise hours in the lab facilities of IN1/3, in groups of two.
There will be five homeworks:

XML and integration of heterogeneous data
JDBC and JSP
Distributed Transactions
JMS and Enterprise Java Beans
Web Services

They are to be solved by teams of two. The infrastructure of IN1/3 has UNIX platform. There will be one homework every two weeks. Solutions should be submitted electronically. Questions by email are possible. Solutions for the exercises and introduction to the new exercises will be presented during the exercise hours. Each exercise will be graded and can influence the final grade (positively).
For part 2, almost everything is the same except that exercises and lectures will be mixed and they are given in CO 1.

Grading:

You will have written exam. The grades are counted in the following way: Part 1 counts 75% and Part 2 counts 25%. The weight of exercise in PART 1 is 33% (one third). Score formula:

0.75max(grade_part1, (1-0.1nr_ex)grade_part1+0.1nr_exgrade_exercise)+0.25grade_part2

nr_ex=number of exercises submitted

grade_exercise=average grade of submitted exercises

grade_part1= grade exam Part 1 (3 questions)

grade_part2= grade exam Part 2 (1 questions)

Lecture Schedule

Date	Slides/Homeworks Title	Duration	Responsible	Homework Deadline/Solution
11.03.03	Lecture: Introduction (pdf), Structured Web Documents (pdf) (recapitulation)	2h	Karl ABERER
12.03.03	No Exercise
18.03.03	Lecture: Structured Web Documents (pdf)	2h	Karl ABERER
19.03.03	Exercise:XML DTD/Schemas (description)	2h		(xsd/dtd)
25.03.03	Lecture: Database Integration (pdf)	2h	Karl ABERER
26.03.03	No Exercise	2h
01.04.03	Lecture: Web Database Access (pdf)		Karl ABERER
02.04.03	Exercise: JDBC and JSP (description)			(solution)
08.04.03	Lecture: Transactions (pdf)	2h	Karl ABERER
09.04.03	No Exercise	2h
15.04.03	Lecture: Transaction Monitors (pdf)	2h	Karl ABERER
16.04.03	Exercise: Distributed Transactions (description/sample)			(solution/sources.zip)
22.04.03	Easter Holiday
23.04.03	Easter Holiday	2h
29.04.03	Lecture: Components/EJB (pdf)	2h	Karl ABERER
30.04.03	No Exercise
06.05.03	Lecture: EJB (pdf)	2h	Karl ABERER
07.05.03	Exercise: JMS andEnterprise Java Beans (description)	2h		(solution)
13.05.03	Lecture: Web Services (pdf)	2h	Karl ABERER
14.05.03	No Exercise
20.05.03	Lecture: Web Services (pdf)	2h	Karl ABERER
21.05.03	Exercise: Web Services (description)			(solution)
27.05.03	Lecture: Workflow systems (pdf)	2h	Karl ABERER
28.05.03	No Exercise
03.06.03	Lecture: Intro Part 2 & Req. Analysis	2h	Alain WEGMANN
04.06.03	Lecture / Exercise: Req. Analysis	2h	Alain WEGMANN
10.06.03	Lecture / Exercise: Req. Analysis	2h	Alain WEGMANN
11.06.03	No Exercise
17.06.03	Lecture / Exercise: Archi.Driven Process	2h	Alain WEGMANN
18.06.03	Lecture / Exercise: Archi.Driven Process	2h	Alain 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 Semistructured Data and XML, Morgan Kaufman, 2000.
	Vzsu, Valduriez: Principles of Distributed Database Sytems, 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)

Websites

	Companies: JAVA Web site W3C Web site BEA Web Site
	XML-related: Relevant XML standards XML Namespaces Microsoft XSLT IBM DB2 DataJoiner IBM DB2 XML Extender Tamino XML Starter Kit
	JDBC/JSP: JDBC JDBC Tutorial Servlets JSP Informix WebDataBlade
	OMG & Corba: OMG Website CORBA documents (including CORBA 2.0) Transaction POS Concurrency Query
	OTM: Weblogic CORBA-based OTM WebLogic EJB OTM
	Workflow: Workflow Management Coalition Weblogic Process Integrator
	B2B: SOAP BizTalk BEA WebLogic Collabrator

="Emptyline" colspan="2" height="8">