Salta al contenuto principale della pagina

TRANSACTIONAL SYSTEMS & DATA WAREHOUSE

CODE 86794
ACADEMIC YEAR 2021/2022
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 AULAWEB

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

Exam Board

ANTONIO BOCCALATTE (President)

ALESSIO MERLO

MASSIMO PAOLUCCI

ALESSANDRO ARMANDO (President Substitute)

LESSONS

Class schedule

All class schedules are posted on the EasyAcademy portal.

EXAMS

EXAM DESCRIPTION

Individual project and discussion

ASSESSMENT METHODS

Design capabilities compared to the training objectives

Exam schedule

Date Time Location Type Notes
11/01/2022 10:00 GENOVA Scritto
14/02/2022 10:00 GENOVA Scritto
10/06/2022 10:00 GENOVA Scritto
12/07/2022 10:00 GENOVA Scritto
06/09/2022 10:00 GENOVA Scritto