English   Danish

2010/2011  KAN-CMIT_VSYI  System Integration

English Title
System Integration

Course Information

Language English
Point 7,5 ECTS (225 SAT)
Type Elective
Level Full Degree Master
Duration One Quarter
Course Period Second Quarter
Pending schedule: Thurs. 14.25-17.00,uge:43-50
Time Table Please see course schedule at e-Campus
Study Board
Study Board for BSc/MSc in Business Administration and Information Systems
Course Coordinator
Lars Frank - lpf.inf@cbs.dkSecretary Annie Olsesen - ao.inf@cbs.dk
Main Category of the Course
  • Supply Chain Management and Logistics
  • Information Systems
  • Management of Information and Knowledge Management
  • Financial and management accounting

Taught under Open University-Taught under open university.
Last updated on 29 maj 2012
Prerequisite
The student should should have basic knowledge about databases.
Exam Period Winter Term
Examination
Mini project with all types of exam aids
The re-take takes place according to the same rules as the regular examination.
Course Content

The functions of a company’s value or supply chains should be integrated, i.e. the functions should operate on consistent data. In the old days, the value chain functions operated on their own data, and therefore, the systems were not integrated. Nowadays, databases make it possible for different functions to operate on common data, and therefore it should be easy to make integrated systems. ERP (Enterprise Resource Planning) systems are examples of how to integrate the functions of value chain by using a common database. However, in practice companies have integration problems even if they have an ERP system. The Integration methods used in the course are the following:

· ERP systems and other systems that use a common central database

· Workflows that integrate local systems or distributed systems by e.g. using SOA service or other inernet techniques.

· Databases and applications with relaxed ACID properties. That is, data are e.g. not locked by transactions across a dialog with the user or across distributed database locations, but from a user point of view it should function as if the traditional ACID properties have been implemented.

· ETL (Extract Transform and Load) products that may repair inconsistencies in both operative systems and datawarehouses.

Teaching Methods
The teaching is integrated with exercises and discussion of the solutions. The teaching also consists of supervising the project groups and discussion of the solutions followed by student presentation of their work with the mini project.
Literature

Code

Author

Title

Publishers

Pages

Wil van der Aalst and Kees van Hee

Workflow Management, Models, Methods, and Systems, 2002

The MIT Press,

300

Ralph Kimball and Joe Caserta

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, 2004

John Wiley & Sons

200

L. Frank

Databases and Applications with Relaxed ACID Properties, 2008.

Chap. 1-9.

CBS, Sitescabe

90

Total

590

Other:

Code

Author

Title

Publishers

Pages

0-619-21663-8

Ellen Monk, Bret Wagner

Concepts in Enterprise Resource Planning, Second Edition, 2005

Thomson Learning

240