2. Professors
  3. POLESE Giuseppe
  4. Teaching

DATA MANAGEMENT

Giuseppe POLESE DATA MANAGEMENT

0323000027
DIPARTIMENTO DI SCIENZE POLITICHE, SOCIALI E DELLA COMUNICAZIONE
LANGUAGE AND AUDIOVISUAL COMMUNICATION THEORY
2014/2015

OBBLIGATORIO
YEAR OF COURSE 1
YEAR OF DIDACTIC SYSTEM 2011
SECONDO SEMESTRE
CFUHOURSACTIVITY
1KNOWLEDGE MANAGEMENT AND DATA ENGINEERING
636LESSONS
2SISTEMI DI SUPPORTO ALLE DECISIONI E BUSINESS INTELLIGENCE
324LAB
GENOVEFFA TORTORA1 T Curriculum
GIUSEPPE POLESE2 Curriculum
Objectives
The course concerns advanced data management technologies, including emerging technologies for knowledge and information source management. In particular, at the end of the course the student should have acquired the following knowledge:
•knowledge of physical organization of databases and indexing techniques
•knowledge of transactional systems, concurrency and recovery theory
•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 content management systems

Moreover, at the end of the course the student should have acquired the following skills:

•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 to critically analyze advanced models and technologies for information retrieval, and to propose possible extensions or to experimentally validate them.
Prerequisites
The student should have backgrounds on databases, software engineering, operating systems, networking and distributed systems, object oriented paradigms, and familiarity with a programming language.
Contents
This course consists of two parts. First part describes advanced models and technologies for databases used in the context of enterprise information systems, whereas second part introduces emerging topics in the area of data management and of knowledge sources in general. In particular, first part analyzes in depth physical database organization and indexing, concurrency, transaction management, distributed databases, and data security. Second part concerns instead emerging topics such as semi structure data sources, information retrieval, and content management systems, with particular emphasis on their use on the web.
Teaching Methods
•Lectures
•Drill-lessons
•Seminars
Verification of learning
•DEVELOPMENT OF A COURSE 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.

ON THE AVERAGE, THE PROJECTS WEIGHS ABOUT 50% TO DETERMINE THE FINAL GRADE, EVEN THOUGH, DEPENDING ON THE COMPLEXITY OF THE PROJECT, SUCH WEIGH MIGHT INCREMENT UP TO 80%.

•ORAL EXAMINATION, CONTRIBUTING AN AVERAGE 50% TO DETERMINE THE FINAL VOTE.
Texts
•BOOKS
1.R.A. ELMASRI, S.B. NAVATHE, “FUNDAMENTALS OF DATABASE SYSTEMS”, 6TH EDITION, ADDISON WESLEY, 2007. ALTERNATIVELY: R.A. ELMASRI, S.B. NAVATHE, “SISTEMI DI BASI DI DATI – COMPLEMENTI”, 4TH EDITION, PEARSON - ADDISON WESLEY, 2005.

2.P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI – ARCHITETTURE E LINEE DI EVOLUZIONE”, 2D EDITION, MCGRAW-HILL, 2007.

3.ANDERS MOLLER, MICHAEL SCHWARTZBACH, INTRODUZIONE A XML, PEARSON.

•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.
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2016-09-30]