Datawarehousing and Analytics Data-Warehouse-, Data

Anwendersoftware
as
Anwendungssoftware
Datawarehousing and Analytics
Data-Warehouse-, Data-Mining- und
OLAP-Technologien
Advanced Information Management
Bernhard Mitschang, Holger Schwarz
Universität Stuttgart
Winter Term 2014/2015
Departments of
Institute of Parallel and Distributed Systems (IPVS)
Applications of Parallel and Distributed Systems
Prof. B. Mitschang, Prof. M. Herschel
Machine Learning and Robotics
Prof. M. Toussaint
Parallel Systems
Prof. S. Simon
Simulation of Large Systems
Prof. M. Mehl, Jun.-Prof. D. Pflüger
Distributed Systems
Prof. K. Rothermel
Infrastructure
Dipl.-Inf. M. Matthiesen
2
http://www.ipvs.uni-stuttgart.de
Universität Stuttgart
Applications of Parallel and Distributed Systems
Repository Technologies,
Data Warehouse and Data Mining,
Domain-specific query optimization
and processing,
Product Data Management,
Data Integration
Data and Metadata
Focussed Semantic Search,
Scalable Content Management
Content and Semantics
Information Systems and Applications
Data in
the Cloud
3
Federated
Systems /
Application
Integration
Metadata
Management
Database Middleware,
Information Services,
Generative Application Development,
Model-driven Engineering,
Technical Information Systems
Content
Management
Business
Intelligence /
Business
Processes
Query
Optimization
Universität Stuttgart
Anwendersoftware
as
Anwendungssoftware
How to contact us
• Lecture
Bernhard Mitschang
Office: 2.359
Tel.: 0711 685 88449
[email protected]
• Exercises and assignments
Holger Schwarz
Office: 2.361
Tel.: 0711 685 88244
[email protected]
4
Anwendersoftware
as
Anwendungssoftware
Planned Schedule
09:00 –
11:15
Monday
9/29/14
Tuesday
9/30/14
Wednesday
10/1/14
Thursday
10/2/14
Tuesday
10/7/14
Wednesday
10/8/14
Chapter 1
Introduction
Chapter 3
Chapter 4
Chapter 6
Chapter 7
• Materialized
Summary
Data
• Derivability
Chapter 6
Chapter
• Wrap up
• Intro to
Assignments
Chapter 2
• Data Warehouse
Architecture
• Design Process
• Conceptual
Design
• Logical Design
•
•
•
•
•
Monitoring
Extraction
Transformation
Load
Tools
• Data Mining
Introduction
• Applications
• KDD
• SQL & OLAP
• SQL & Mining
• Database
Support
Break
12:00 –
14:15
Chapter 2
• Data Marts
• Operational Data
Store
• Meta Data
Chapter 3
• Extended
Dimension Table
Design
• Extended Fact
Table Design
• Physical Design
Chapter 5
• OLAP
• Architecture
• Storage of Data
Cubes
•
•
•
•
•
Assoc. Rules
Clustering
Classification
Regression
Tools and Trends
Examples and
Miscellaneous
Break
15:00 –
16:30
•
•
Intro SQL and
ODPS
Issues of data
integration
• Data Warehouse
Architecture
• Conceptual and
Logical Data
Warehouse
Design
• Monitoring
• Storage of Data
Cubes
• ETL
• Transformation
• Cleansing
15:00 – 17:15
• Data Mining
• Classification
• Clustering
• Association
Rules
Lectures
Exercises
5
Anwendersoftware
as
Anwendungssoftware
Exercises and Assignments
Type
Description
Date
Exercise
Detailed discussion of major
topics, case studies, examples
etc. (all)
September 29 – October 8
Assignment
Hands-on training for topics
related to dbms
(groups of 2-3 students)
Introduction on October 8
Due: TBA
Assignment
Hands-on training for ETL, OLAP Introduction on October 8
and data mining
Due: TBA
(groups of 2-3 students)
6
Anwendersoftware
as
Anwendungssoftware
Teaching Materials
• General information:
http://www.ipvs.uni-stuttgart.de/abteilungen/as/lehre/lehrveranstaltungen/vorlesungen/WS1415/DWDM/en
• Slides, exercises, assignments, …
 Login to ILIAS: https://ilias3.uni-stuttgart.de/login.php
 Search and Join the course "Data Warehousing and Analytics"
Repository -> Engineering -> Computer Science -> Lehrveranstaltungen WS
14/15
7
Anwendersoftware
as
Anwendungssoftware
Exams
• IMSE
 Exam: Friday, December 12
• Informatik / Softwaretechnik / Infotech / Wirtschaftsinformatik / …
 Register at your examination office
 Make an appointment for the oral exam
• Appointments for oral exams
 Annemarie Roesler
Tel. 0711 685 88448
[email protected]
8
Anwendersoftware
as
Anwendungssoftware
Books
[BG04]
[Len03]
[KR+98]
[Inm05]
[HK00]
[JL+02]
[Kim96]
[LN07]
[Wes01]
A. Bauer, H. Günzel: Data Warehouse Systeme. 2. Aufl., dpunkt, 2004.
W. Lehner: Datenbanktechnologie für Data-Warehouse-Systeme.
dpunkt, 2003.
R. Kimball, L. Reeves, M. Ross, W. Thornthwaite: The Data Warehouse
Lifecycle Toolkit. Wiley, 1998.
W. H. Inmon: Building the Data Warehouse. 4th Edition, Wiley, 2005.
J. Han, M. Kamber: Data Mining – Concepts and Techniques. Morgan
Kaufmann, 2nd Edition, 2006.
M. Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis: Fundamentals of
Data Warehouses. Springer, 2002.
R. Kimball: The Data Warehouse Toolkit. Wiley, 1996
U. Leser, F. Naumann: Informationsintegration, dpunkt, 2007.
P. Westerman: Data Warehousing. Morgan Kaufmann. 2001.
9
Anwendersoftware
as
Anwendungssoftware
Papers
[Ber98]
[CD97]
[HLV00]
[Zeh03]
P. Bernstein: Repositories and Object Oriented Databases, SIGMOD
Record 27(1):88-96, 1998.
S. Chaudhuri, U. Dayal: An Overview of Data Warehousing and OLAP
Technology, SIGMOD Record 26(1):65-74, 1997.
B. Hüsemann, J. Lechtenbörger, G. Vossen: Conceptual Data
Warehouse Design. Proc. of the Second International Workshop on
Design and Management of Data Warehouses, Stockholm, 2000.
T. Zeh: Data Warehousing als Organisationskonzept des
Datenmanagements. In: Informatik Forschung und Entwicklung, Band
18, Heft 1, August 2003.
10