Genoveffa TORTORA | DATABASE II
Genoveffa TORTORA DATABASE II
cod. 0522500005
DATABASE II
| 0522500005 | |
| COMPUTER SCIENCE | |
| EQF7 | |
| COMPUTER SCIENCE | |
| 2024/2025 |
| YEAR OF COURSE 1 | |
| YEAR OF DIDACTIC SYSTEM 2016 | |
| SPRING SEMESTER |
| SSD | CFU | HOURS | ACTIVITY | |
|---|---|---|---|---|
| INF/01 | 9 | 72 | LESSONS |
| Objectives | |
|---|---|
| General Objective The Databases II course provides a comprehensive study of advanced models and database technologies used in the context of business information systems. It also covers the core concepts and fundamentals of the components used in large-scale analytical and information retrieval systems. Knowledge and Understanding The student will be able to -know the organization of databases on disk and indexing techniques -have an in-depth knowledge of transactional systems, competition and recovery theory -have an in-depth knowledge of the problems inherent to the network distribution of databases -know XML and concepts relating to the management of semi-structured databases on the web -understand security management in databases, access control and data privacy -understand principles of information retrieval and web searches -understand business intelligence systems and big data Ability to Apply Knowledge and Understanding The student will be able to -design information systems based on some of the aforementioned technologies -design and manage semi-structured databases -use a content management system -design a data warehouse and a business intelligence system Autonomy of Judgment The student will be able to -critically analyze information retrieval models and technologies, propose possible extensions, or experiment with their performance -fully manage the process of developing a data-driven system, including the ability to make design choices for real-world scenarios -assess the quality of analytics results to improve business intelligence processes Communication Skills The student will be able to -describe in detail, by means of appropriate documentation, the decisions made during the design and implementation phases of a course project -clearly articulate the functional objectives and implementation details of the application implemented as part of the project Learning Skills The student will be able to -independently acquire, test and apply analytics models in information retrieval processes to work with and manage big data -critically evaluate the capabilities of different technology platforms in order to effectively employ them to build information systems for real-world contexts |
| 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: •DATA DEPENDENCIES AND NORMALIZATION PROCESSES (8 HOURS) •PHYSICAL DATABASE ORGANIZATION AND INDEXING (8 HOURS) •CONCURRENCY (8 HOURS) •TRANSACTION MANAGEMENT (8 HOURS) •DISTRIBUTED DATABASES (8 HOURS) •DATA SECURITY (8 HOURS) EMERGING TOPICS IN THE AREA OF DATA MANAGEMENT AND OF KNOWLEDGE SOURCE (LABORATORY): •SEMI STRUCTURED DATA SOURCES (4 HOURS) •INFORMATION RETRIVAL (4 HOURS) •DATA WAREHOUSE (4 HOURS) •BUSINESS INTELLIGENCE SYSTEMS (4 HOURS) •MULTIMEDIA AND XML DATABASES (4 HOURS) •BIG DATA AND NOSQL (4 HOURS) |
| 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: 1. R.A. ELMASRI, S.B. NAVATHE, “FUNDAMENTALS OF DATABASE SYSTEMS”, 6 7TH EDITION, PEARSON, 2015 2. P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI”, 6TH EDITION, MCGRAW-HILL, 2023 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/ CONTACTS PROF.SSA GENOVEFFA TORTORA TORTORA@UNISA.IT |
BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2024-11-18]
