TRANSACTIONAL SYSTEMS & DATA WAREHOUSE

TRANSACTIONAL SYSTEMS & DATA WAREHOUSE

_
iten
Last update 02/07/2020 18:47
Code
86794
ACADEMIC YEAR
2020/2021
CREDITS
6 credits during the 1st year of 11160 COMPUTER ENGINEERING (LM-32) GENOVA
SCIENTIFIC DISCIPLINARY SECTOR
ING-INF/05
LANGUAGE
English
TEACHING LOCATION
GENOVA (COMPUTER ENGINEERING )
semester
2° Semester
Teaching materials

AIMS AND CONTENT

LEARNING OUTCOMES

The first part of the course will focus on architectural aspects of transactional systems, query processing, transaction management and recovery. The second part will deal with the issues of data warehouse design, data mining and knowledge discovery techniques .The student will be able to apply the acquired skills in : Query processing Transaction management and recovery. Conceptual data warehouse project Fact and Snowflake models Logical data warehouse project Architecture of a Data Mart. Data mining and knowledge discovery techniques Frequent Pattern Analisys Classification techniques Decision tree and Bayesian Classifiers

SYLLABUS/CONTENT

The course will focus on architectural aspects of transactional systems, query processing, transaction management and recovery.
The second part of the course will address the issues of data warehouse project is the conceptual point of view and from the point of view of logic, will present the models Fact and Snowflake and architecture of a Data Mart.
In the third part the course will analyze and discuss techniques of data mining and knowledge discovery for the retrieval of information in large amounts of data, with particular reference to the Frequent Pattern Analysis and techniques of classification and prediction.

RECOMMENDED READING/BIBLIOGRAPHY

Kimball and Ross "The data warehouse toolkit" - Wiley & Sons 
Jiawei Han, Micheline Kamber, “Data Mining: Concepts and Techniques” - Morgan Kaufmann

TEACHERS AND EXAM BOARD

Ricevimento: By appointment

Exam Board

ANTONIO BOCCALATTE (President)

MASSIMO PAOLUCCI

ALESSIO MERLO

ALESSANDRO ARMANDO

ORARI

L'orario di tutti gli insegnamenti è consultabile su EasyAcademy.

EXAMS

Exam description

Individual project and discussion

Assessment methods

Design capabilities compared to the training objectives