DATABASES

Giuseppe FENZA DATABASES

0212800011
DEPARTMENT OF ECONOMICS AND STATISTICS
EQF6
STATISTICS FOR BIG DATA
2021/2022

OBBLIGATORIO
YEAR OF COURSE 2
YEAR OF DIDACTIC SYSTEM 2018
SPRING SEMESTER
CFUHOURSACTIVITY
1060LESSONS
Objectives
THE COURSE (60 HOURS AND 10 ECTS) AIMS AT PROVIDING STUDENTS WITH AN ENDOWMENT OF KNOWLEDGE RELATED TO DATA ANALYSIS, IN ORDER TO ALLOW A SCALABLE MANAGEMENT OF COMPLEX SYSTEMS. IT ALSO AIMS AT DEVELOPING ANALYTICAL CAPABILITIES TO SOLVE COMPLEX PROBLEMS, WHOSE SOLUTIONS GO TOWARD SYNERGIC APPROACHES IN TERMS OF DATA MINING ALGORITHMS, ADVANCED COMPUTATIONAL PARADIGMS, DISTRIBUTED SYSTEM FOR DATA MANAGEMENT, TARGETED AT DATA-DRIVEN DISCOVERY AND PREDICTIVE ANALYSIS.

THE STUDENT, AT THE END OF THE COURSE, WILL HAVE ACQUIRED THEORETICAL KNOWLEDGE AND PRACTICAL SKILLS RELATED TO DATA ANALYSIS AND ANALYTICS (FOR SOLVING PROBLEMS RELATED TO THE ACQUISITION AND MANAGEMENT OF SMALL AND MEDIUM SIZE DATA) AND THE ABILITY TO USE THE MAIN TECHNIQUES AND TOOLS FOR THE RESOLUTION OF SPECIFIC PROBLEMS.

THE STUDENT WILL BE ENCOURAGED TO DEVELOP ANALYTICAL SKILLS TARGETED AT EXTRACTING INTRINSIC DATA FEATURES AND THE CAPABILITY TO GET AN ABSTRACTION THAT EMPHASIZES THE NATURE OF THE PROCESSED DATA.

THE COURSE AIMS AT FOSTERING THE DEVELOPMENT OF SKILLS IN DATA COLLECTION AND DATA ANALYSIS, THROUGH HYBRID APPROACHES THAT COMBINE COMPLEX STRATEGIES TO EXTRACT EFFECTIVE INFORMATION FROM ROUGH DATA
Prerequisites
BASIC NOTIONS OF PROGRAMMING
Contents
INTRODUCTION TO INFORMATION SYSTEMS (4 HOURS OF LECTURES)
THE RELATIONAL MODEL (4 HOURS OF LECTURES)
THE SQL LANGUAGE (6 HOURS OF LESSONS + 4 HOURS OF PRACTICE)
CONCEPTUAL DESIGN, THE ENTITY-RELATIONS MODEL (6 HOURS OF LECTURES)
LOGICAL DESIGN (6 HOURS OF LESSONS)
PHYSICAL DESIGN (6 HOURS OF LESSONS)
DATAWAREHOUSE (6 HOURS OF LESSONS + 4 HOURS OF PRACTICE)
INTRODUCTION TO BIG DATA (4 HOURS OF LECTURES)
NOSQL (4 HOURS OF LESSONS)
MONGODB (2 HOURS OF LESSONS + 4 HOURS OF PRACTICE)
Teaching Methods
THE COURSE REQUIRES 60 HOURS OF TEACHING BETWEEN LESSONS AND LABORATORY EXERCISES: 48 HOURS OF LESSONS IN THE CLASSROOM (8 CFU) AND 12 HOURS OF GUIDED EXERCISES IN THE LABORATORY (2 CFU). THE LABORATORY EXERCISES WILL BE ENHANCED BY CASE STUDIES WITH PROGRAMS DEVELOPED IN THE CLASSROOM WITH THE HELP OF THE TEACHER, WHO WILL SUGGEST ADDITIONAL EXERCISES ON WHICH STUDENTS MAY APPLY WITH INDIVIDUAL STUDY. THE FREQUENCY OF CLASSROOM LECTURES AND LABORATORY EXERCISES, WHILE NOT REQUIRED, IS STRONGLY RECOMMENDED IN ORDER TO OBTAIN FULL ACHIEVEMENT OF THE LEARNING OBJECTIVES.
Verification of learning
THE ACHIEVEMENT OF THE OBJECTIVES OF TEACHING IS CERTIFIED BY PASSING AN EXAMINATION WITH
AN ASSESSMENT OUT OF THIRTY. THE EXAM INCLUDES A PRACTICAL TEST (PRJECT) AND AN ORAL TEST.
THE EVALUATION OF THE PROJECT WILL ACCOUNTS FOR 60% WHILE THE INTERVIEW FOR THE REMAINING 40%. THE CUM LAUDE MAY BE GIVEN TO STUDENTS WHO DEMONSTRATE THAT THEY CAN APPLY THE KNOWLEDGE AUTONOMOUSLY EVEN IN CONTEXTS OTHER THAN THOSE PROPOSED IN THE COURSE.

THE PRACTICAL TEST IS USED TO ASSESS THE CURRENT ABILITY OF THE STUDENT TO APPLY THE KNOWLEDGE ACQUIRED AND DEMONSTRATE COMPREHENSION SKILLS IN DEALING WITH A PRACTICAL PROBLEM IN PROGRAMMING, DESIGN AN ALGORITHMIC SOLUTION AND WRITE THE PROGRAM THAT SOLVES IT. THE PRACTICAL TEST IS PREPARATORY TO THE ORAL EXAMINATION, AND REQUIRES THE ACHIEVEMENT OF PREDETERMINED MINIMUM SCORE. THE ORAL TEST IS USED TO ASSESS THE DEGREE OF ATTAINMENT OF THE LEARNING OBJECTIVES, PARTICULARLY REGARDING THE LEVEL OF KNOWLEDGE AND UNDERSTANDING AND COMMU
NICATION ACHIEVED BY THE STUDENT.
Texts
HOFFER, VENKATARAM, TOPPI, "MODERN DATA BASE MANAGEMENT", PEARSON
More Information
EXERCISES PROVIDED FROM THE PROFESSOR
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2022-11-21]