Database II

Genoveffa TORTORA Database II

0522500005
DIPARTIMENTO DI INFORMATICA
EQF7
COMPUTER SCIENCE
2019/2020



OBBLIGATORIO
YEAR OF COURSE 1
YEAR OF DIDACTIC SYSTEM 2016
SECONDO SEMESTRE
CFUHOURSACTIVITY
972LESSONS
Objectives
KNOWLEDGE AND UNDERSTANDING
•KNOWLEDGE OF PHYSICAL ORGANIZATION OF DATABASES AND INDEXING TECHNIQUES
•KNOWLEDGE OF TRANSACTIONAL SYSTEMS, CONCURRENCY AND RECOVERY THEORY
•DEEP KNOWLEDGE OF DISTRIBUTED DATABASES
•KNOW XML AND CONCEPTS RELATED TO SEMI-STRUCTURED DATABASES ON THE WEB
•KNOW DATA SECURITY, ACCESS CONTROL AND DATA PRIVACY CONCEPTS
•KNOW PRINCIPLES OF INFORMATION RETRIEVAL AND WEB SEARCH
•KNOWLEDGE OF BUSINESS INTELLIGENCE AND BIG DATA SYSTEMS

APPLYING KNOWLEDGE AND UNDERSTANDING
•KNOW HOW TO DESIGN INFORMATION SYSTEMS BASED ON ONE OF THE TECHNOLOGIES MENTIONED ABOVE
•KNOW HOW TO DESIGN AND MANAGE SEMI STRUCTURED DATA SOURCES
•KNOW HOW TO USE A CONTENT MANAGEMENT SYSTEM
•KNOW HOW DESIGN DATA WAREHOUSES AND BUSINESS INTELLIGENCE SYSTEMS
•KNOW HOW TO CRITICALLY ANALYSE ADVANCED MODELS AND TECHNOLOGIES FOR INFORMATION RETRIEVAL, AND TO PROPOSE POSSIBLE EXTENSIONS OR TO EXPERIMENTALLY VALIDATE THEM


Prerequisites
THE STUDENTS MUST HAVE PREVIOUS KNOWLEDGE OF:
•DATABASES
•SOFTWARE ENGINEERING
•OPERATING SYSTEMS
•NETWORKING AND DISTRIBUTED SYSTEMS
•OBJECT ORIENTED PARADIGMS, AND FAMILIARITY WITH A PROGRAMMING LANGUAGE
Contents
ADVANCED MODELS AND TECHNOLOGIES FOR DATABASES USED IN THE CONTEXT OF ENTERPRISE INFORMATION SYSTEMS:
•PHYSICAL DATABASE ORGANIZATION AND INDEXING
•CONCURRENCY
•TRANSACTION MANAGEMENT
•DISTRIBUTED DATABASES
•DATA SECURITY

EMERGING TOPICS IN THE AREA OF DATA MANAGEMENT AND OF KNOWLEDGE SOURCE:
•SEMI STRUCTURE DATA SOURCES
•INFORMATION RETRIVAL
•DATA WAREHOUSE
•BUSINESS INTELLIGENCE SYSTEMS
•MULTIMEDIA AND XML DATABASES
•BIG DATA AND NOSQL
Teaching Methods
THE COURSE INCLUDES:
•FRONTAL LECTURES TO TRANSFER THE KNOWLEDGE RELATED TO THE COURSE CONTENTS (6 CFUS/42 HOURS)
•LABORATORY SESSIONS AND TUTORIALS TO TRAIN STUDENTS ON PRACTICAL AND COLLABORATIVE ACTIVITIES (3 CFUS/24 HOURS)

STUDENTS WILL BE ASSIGNED A PROJECT CONCERNING:
•A SURVEY ON AN EMERGING RESEARCH TOPIC IN DATABASE SYSTEMS
•EXPERIMENTS TO COMPARE AND VALIDATE INNOVATIVE METHODOLOGIES AND TECHNOLOGIES IN DATABASE SYSTEMS
•IMPLEMENTATION OF TOOLS SUPPORTING INNOVATIVE METHODOLOGIES AND TECHNIQUES IN DATABASE SYSTEMS
•PROPOSAL OF AN INNOVATIVE METHODOLOGY OR TECHNOLOGY TO SOLVE A PROBLEM RELATED TO DATABASE SYSTEMS
Verification of learning
•THE EXAM CONSISTS OF A PRELIMINARY WRITTEN TEST AND AN ORAL EXAMINATION TO VERIFY THE ACQUIRED KNOWLEDGE AND TO DISCUSS THE ACTIVITIES CARRIED OUT DURING THE COURSE. ACTIVITIES INCLUDE THE REALIZATION OF A PROJECT IN GROUP. WRITTEN EXAMS CAN BE REPLACED BY TWO PROGRESSIVE ASSESSMENT TESTS THAT INCLUDE QUESTIONS CONCERNING BOTH THE KNOWLEDGE AND UNDERSTANDING OF CLASSROOM ARGUMENTS AND THE ABILITY TO APPLY THEM THROUGH EXERCISES.

•WRITTEN EXAMINATION (2 HOURS): TO EVALUATE THE GAINED KNOWLEDGE ON ADVANCED DATABASE TECHNIQUES, THE TESTS WILL BE COMPOSED BY OPEN QUESTIONS AND EXERCIZES. THE SCORES ARE ASSIGNED DEPENDING ON THE COMPLEXITY OF THE QUESTIONS OR EXERCISES (BETWEEN 4 AND 10 POINTS). THE EVALUATION CRITERIA INCLUDE THE CORRECTNESS AND COMPLETENESS OF THE LEARNING AND THE CLARITY OF THE PRESENTATION. THE FINAL MARK IS OUT OF 30.

•ASSESSMENT TESTS: TWO NON-CUMULATIVE TESTS WILL BE DELIVERED, ONE IN THE MIDDLE AND ONE AT THE END OF THE COURSE. THE FINAL MARK OF EACH TEST IS OUT OF 30. STUDENTS WHO WILL PASS THE TESTS WILL BE EXEMPTED FROM THE WRITTEN EXAMINATION. THE AIM IS TO ENCOURAGE STUDENTS TO FOLLOW EFFECTIVELY THE COURSE.

•PROJECT: THE PROJECT ALLOWS THE STUDENT TO PRACTICE ON THE CONTENTS LEARNED DURING THE COURSE. DURING THE ORAL EXAM, THE PROJECT WILL BE DISCUSSED DIRECTLY WITH THE TEACHER THAT WILL VERIFY THE FOLLOWING:
•COMPLETENESS AND THE CORRECTNESS OF THE PROJECT
•COMPREHENSION OF THE REALIZED ARTIFACTS
•LEVEL OF FAMILIARITY AND ABILITY TO MODIFY THE PRODUCED SOFTWARE.

•ORAL EXAMINATION AIMS TO EVALUATE THE GENERAL KNOWLEDGE OF THE STUDENT WITH RESPECT TO THE ENTIRE COURSE PROGRAM. THE EVALUATION CRITERIA INCLUDE THE COMPLETENESS AND CORRECTNESS OF THE LEARNING AND THE CLARITY OF THE PRESENTATION.

•FINAL EVALUATION: THE EVALUATION WILL BE GIVEN BY THE AVERAGE SCORE OF ASSESSMENT TESTS (OR THE WRITTEN EXAMINATION) AND THE POINTS OBTAINED BY DISCUSSING THE PROJECT AND THE ORAL TEST.
Texts
COURSE BOOKS
•R.A. ELMASRI, S.B. NAVATHE, “FUNDAMENTALS OF DATABASE SYSTEMS”, 6TH EDITION, ADDISON WESLEY, 2011
IN ALTERNATIVA: R.A. ELMASRI, S.B. NAVATHE, “SISTEMI DI BASI DI DATI – COMPLEMENTI”, 4TH EDITION, PEARSON - ADDISON WESLEY, 2005
•P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI – ARCHITETTURE E LINEE DI EVOLUZIONE”, 2D EDITION, MCGRAW-HILL, 2007

OTHER
•TEACHER’S HANDOUTS
More Information
ATTENDANCE OF LECTURES IS STRONGLY ENCOURAGED. STUDENTS MUST SPEND A CONSIDERABLE AMOUNT OF TIME STUDYING AT HOME, AND FOR DEVELOPING THE COURSE PROJECT.
INFORMATION CONCERNING THE COURSE IS AVAILABLE ON THE E-LEARNING PLATFORM OF THE DIPARTIMENTO DI INFORMATICA AT HTTP://ELEARNING.INFORMATICA.UNISA.IT/EL-PLATFORM/
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2021-02-19]