Matteo GAETA | HEALTH INFORMATION SYSTEMS
Matteo GAETA HEALTH INFORMATION SYSTEMS
cod. 0612800017
HEALTH INFORMATION SYSTEMS
| 0612800017 | |
| DEPARTMENT OF INFORMATION AND ELECTRICAL ENGINEERING AND APPLIED MATHEMATICS | |
| EQF6 | |
| INFORMATION ENGINEERING FOR DIGITAL MEDICINE | |
| 2024/2025 |
| OBBLIGATORIO | |
| YEAR OF COURSE 3 | |
| YEAR OF DIDACTIC SYSTEM 2022 | |
| AUTUMN SEMESTER |
| SSD | CFU | HOURS | ACTIVITY | ||
|---|---|---|---|---|---|
| SISTEMI INFORMATIVI SANITARI | |||||
| ING-INF/05 | 4 | 32 | LESSONS | ||
| ING-INF/05 | 2 | 16 | EXERCISES | ||
| SISTEMI INFORMATIVI SANITARI | |||||
| INF/01 | 1 | 8 | LESSONS | ||
| INF/01 | 2 | 16 | LAB | ||
| Exam | Date | Session | |
|---|---|---|---|
| SISTEMI INFORMATIVI SANITARI | 24/01/2025 - 09:00 | SESSIONE ORDINARIA | |
| SISTEMI INFORMATIVI SANITARI | 24/01/2025 - 09:00 | SESSIONE DI RECUPERO | |
| SISTEMI INFORMATIVI SANITARI | 17/02/2025 - 09:00 | SESSIONE ORDINARIA | |
| SISTEMI INFORMATIVI SANITARI | 17/02/2025 - 09:00 | SESSIONE DI RECUPERO |
| Objectives | |
|---|---|
| THE COURSE PROVIDES THE BASIC KNOWLEDGE RELATED TO THE WORLD OF HEALTHCARE INFORMATION SYSTEMS WITH REFERENCE ALSO TO THE CURRENT STANDARDS FOR THE DATA CLASSIFICATION AND EXCHANGE OF HEALTCARE DATA; THE MORE COMMON ARCHITECTURES, MODELS AND METHODOLOGIES FOR THE DESIGN OF DATABASES, THE LANGUAGES FOR IMPLEMENTING AND QUERYING THE RELATIONAL SYSTEMS; AS WELL AS THE ORGANIZATIONAL, FUNCTIONAL, ARCHITECTURAL ASPECTS USEFUL FOR THE DESIGN AND DEVELOPMENT OF COMPLEX APPLICATIONS FOR E-HEALTH. KNOWLEDGE AND UNDERSTANDING: ORGANIZATION OF A HEALTCARE INFORMATION SYSTEM; MAIN CLINICAL-ASSISTANCE PROCESSES, ADMINISTRATIVE AND MANAGEMENT CONTROL PROCESSES; BASIC CONCEPTS AND MAIN ARCHITECTURAL MODELS USED IN THE CONTEXT OF HEALTHCARE INFORMATION SYSTEMS; THE RELATIONAL MODEL; CONCEPTUAL, LOGIC AND PHYSICAL DESIGN OF A DATABASE; SQL LANGUAGE FOR THE DATA DEFINITION AND FOR DATA MANIPULATION AND DATA EXTRACTION; BASIC CONCEPTS OF A TRANSACTIONAL SYSTEM. APPLYING KNOWLEDGE AND UNDERSTANDING: ANALYZE, DEFINE, DESIGN AND REALIZE A COMPONENT AND/OR A PROTOTYPE OF A SUBSYSTEM, USING ALSO A RELATIONAL DATABASE IMPLEMENTED IN POSTGRESQL, OF A HEALTHCARE INFORMATION SYSTEM; CREATE SOFTWARE SOLUTIONS IN THE HEALTHCARE DOMAIN WITH ALSO THE USE OF THE CURRENT REFERENCE STANDARDS FOR THE CLASSIFICATION AND EXCHANGE OF HEALTH DATA. |
| Prerequisites | |
|---|---|
| FOR THE SUCCESSFUL ACHIEVEMENT OF THE OBJECTIVES, A BASIC KNOWLEDGE OF COMPUTER SCIENCE AND THE COURSE ALGORITMI E STRUTTURE DATI (ALGORITHMS AND DATA STRUCTURES). |
| Contents | |
|---|---|
| THE COURSE CONSISTS OF 72 HOURS (LESSONS 40 HOURS; EXERCISES 12 HOURS; LABORATORY 20 HOURS). IT IS DIVIDED INTO 2 MODULES: 1)MODULE INFORMATION SYSTEMS AND DATABASE, 52 HOURS (LESSONS 40 HOURS; EXERCISES 12 HOURS; 2) MODULE PROJECT OF AN INFORMATION SYSTEMS, 20 HOURS (LABORATORY 20 HOURS). 1) MODULE INFORMATION SYSTEMS AND DATABASES (LECTURE-PRACTICE-LABORATORY HOURS 40;12;0) DIDACTIC UNIT 1: INFORMATION SYSTEMS (LECTURE/PRACTICE/LABORATORY HOURS 14/3/0). - 1 (3 HOURS LECTURE): PROFESSIONAL SOFTWARE DEVELOPMENT; SOFTWARE ENGINEERING ETHICS; ENTERPRISE INFORMATION SYSTEM (EIS) MODELS - 2 (3 HOURS LECTURE): ORGANIZATIONAL MODELS; BASIC CONCEPTS OF ENTERPRISE ORGANIZATION; STRATEGY AND PROCESSES; INFORMATION INTENSITY AND INFORMATION NEEDS; BUSINESS PROCESSES AND PORTER’S VALUE CHAIN; OPERATIONAL SYSTEMS; INFORMATIONAL SYSTEMS; EXECUTIVE SYSTEMS. - 3 (2 HOURS LECTURE): BASIC CONCEPTS OF THE ORGANIZATIONAL STRUCTURE OF THE ITALIAN AND EUROPEAN HEALTHCARE SYSTEM; MAIN REFERENCE LEGISLATION; MAIN MODELS. - 4 (3 HOURS LECTURE): ITALIAN HEALTH INFORMATION SYSTEMS; NATIONAL LEVEL; REGIONAL LEVEL; LOCAL LEVEL. - 5 (3 HOURS LECTURE): FUNCTIONAL MODEL: REQUIREMENTS MODEL; PROCESS MODEL AND CRASO PARADIGM. - 6 (3 HOURS PRACTICE): HIERARCHICAL DIAGRAM AND FLOW DIAGRAM OF A BUSINESS PROCESS; BUSINESS PROCESS MODELING NOTATION (BPMN). KNOWLEDGE AND UNDERSTANDING: UNDERSTANDING THE SOCIAL IMPORTANCE OF PRODUCING CODE WITH PROFESSIONALISM IN PARTICULAR IN THE HEALTHCARE DOMAIN AND OF THE BASIC CONCEPTS OF ORGANIZATION AND EIS. UNDERSTANDING THE IMPORTANCE OF ORGANIZATIONAL STRUCTURE AND OF THE MAIN MODELS OF HEALTH INFORMATION SYSTEM (HIS). UNDERSTANDING A FUNCTIONAL MODEL OF A HEALTH INFORMATION SYSTEM. ABILITY TO UNDERSTAND AND DEFINE BUSINESS PROCESSES AND TO USE STANDARDS; BASIC KNOWLEDGE FOR THE REALIZATION OF DESIGN ARTIFACTS OF A HIS. APPLIED KNOWLEDGE AND UNDERSTANDING: ABILITY TO APPLY THE ETHICAL PRINCIPLES OF SOFTWARE ENGINEERING IN THE DEVELOPMENT OF SOFTWARE SYSTEMS AND TO BE ABLE TO IDENTIFY THE MAIN PECULIARITIES OF THE MAIN ORGANIZATIONAL MODELS. ABILITY TO IDENTIFY CHARACTERISTICS AND CONSTRAINTS OF THE ORGANIZATION OF A HIS. ABILITY TO CARRY OUT THE FUNCTIONAL DESIGN OF A COMPONENT OF A SUBSYSTEM AND TO PRODUCE THE RELATED ESSENTIAL DIAGRAMS: PROCESS DIAGRAM. KNOW HOW TO DESIGN A PROCESS USING BPMN NOTATION AND NO CODE SOLUTIONS. DIDACTIC UNIT 2 FUNCTIONAL MODELS: DATA AND DBMS (LECTURE/PRACTICE/LABORATORY HOURS 6/1/0). - 7 (2 HOURS LECTURE AND 1 HOUR PRACTICE): ARCHITECTURES; CONCEPT OF TRANSACTION; DBMS AND RDBMS ARCHITECTURE AND INSTALLATION OF A RDBMS (POSTGRES). - 8 (2 HOURS LECTURE): INTRODUCTION TO RELATIONAL MODEL AND INTRODUCTION TO THE RELATIONAL ALGEBRA.. - 9 (2 HOURS LECTURE): RELATIONAL MODEL. KNOWLEDGE AND UNDERSTANDING: UNDERSTANDING THE CONCEPT OF INFORMATION SYSTEM, THE IMPORTANCE OF DBMS AND RDBMS; KNOWLEDGE OF THE RELATIONAL MODEL. APPLYING KNOWLEDGE AND UNDERSTANDING: KNOW HOW TO REPRESENT THE ARCHIVES OF INTEREST FOR AN APPLICATION USING THE RELATIONAL MODEL. DIDACTIC UNIT 3: THE FUNDAMENTAL CONCEPTS OF SQL (LECTURE/PRACTICE/LABORATORY HOURS 10/4/0). - 10 (2 HOURS LECTURE): DECLARATIVE NATURE OF SQL; DDL - PRELIMINARY CONCEPTS; DOMAINS, SCHEMAS, AND TABLES DEFINITION; - 11 (1 HOUR LECTURE AND 1 HOUR PRACTICE): DEFINITION OF INTRA- AND INTER- RELATION CONSTRAINTS; REACTION POLICIES; ALTER AND DROP OF SCHEMAS; EXAMPLES IN POSTGRESQL. - 12 (2 HOURS LECTURE): PRELIMINARY CONCEPTS DML; INTRODUCTION TO QUERIES; INSERT, DELETE, UPDATE OF DATA; SIMPLE QUERIES; INNER AND OUTER JOINS. - 13 (2 HOURS LECTURE AND 1 HOUR PRACTICE): ORDER BY, AGGREGATION OPERATORS; GROUP BY; EXERCISES IN POSTGRESQL. - 14 (3 HOURS LECTURE): SET OPERATIONS AND NESTED QUERIES (SIMPLE AND COMPLEX INTERPRETATIONS); NESTED QUERIES IN SELECT AND FROM. - 15 (2 HOUR PRACTICE): EXERCISES ON SET AND NESTED QUERY. KNOWLEDGE AND UNDERSTANDING: KNOWLEDGE OF THE BASIC CONCEPTS, THE MAIN CONSTRUCTS AND COMMANDS OF SQL. UNDERSTANDING HOW DEFINE JOIN, SET AND NESTED QUERIES APPLYING KNOWLEDGE AND UNDERSTANDING: KNOW HOW TO CREATE, MODIFY, AND DELETE DOMAINS, TABLES, ETC. AND KNOW HOW TO CREATE A SIMPLE QUERY AND USE THE JOIN. KNOW HOW TO DEFINE SET AND NIDIFIED QUERIES DIDACTIC UNIT 4: METHODOLOGIES AND MODELS FOR THE DESIGN. (LECTURE/PRACTICE/LABORATORY HOURS 7/3/0). - 16 (3 HOURS LECTURE): E-R MODEL, ELEMENTS OF THE RELATIONAL MODEL. - 17 (2 HOURS PRACTICE): THE DOCUMENTATION IN THE E-R MODEL; INTRODUCTION TO THE DATA MODELING IN UML AND CASE TOOLS; - 18 (3 HOURS LECTURE): PHASES OF LOGIC DESIGN; PERFORMANCE ANALYSIS ON E-R SCHEMAS. LOGIC DESIGN; E-R SCHEMAS RESTRUCTURATION. - 19 (1 HOUR LECTURE AND 1 HOUR PRACTICE ): TRANSLATION TO THE RELATIONAL MODEL. KNOWLEDGE AND UNDERSTANDING: UNDERSTANDING THE E-R CONCEPTUAL MODEL; UNDERSTANDING THE PRINCIPLES OF LOGIC DESIGN; ACQUIRE THE CONCEPT OF LOGIC DESIGN PATTERN; UNDERSTANDING THE CONCEPT OF INDEX. APPLYING KNOWLEDGE AND UNDERSTANDING: KNOW HOW TO CREATE AN E-R SCEHMA; KNOW HOW TO RESTRUCTURE A RELATIONAL SCHEME; KNOW HOW TO TRANSLATE A RESTORED RELATIONAL SCHEME BY APPLYING THE LOGIC DESIGN PATTERN. DIDACTIC UNIT 5: IT MODEL OF A HEALTH INFORMATION SYSTEM (HIS) (LECTURE/PRACTICE/LABORATORY HOURS 3/1/0). - 20 (2 HOURS LECTURE): IT MODEL; APPLICATION MODEL; TECHNOLOGICAL MODEL; MAIN ARCHITECTURES FOR HIS. - 21 (1 HOUR LECTURE AND 1 HOUR PRACTICE): MAIN ASPECTS OF HEALTH APPLICATION PROCESSES; CLINICAL-ASSISTANCE PROCESSES; ADMINISTRATIVE AND MANAGEMENT CONTROL PROCESSES. KNOWLEDGE AND UNDERSTANDING: BASIC KNOWLEDGE FOR THE DEFINITION OF AN ARCHITECTURE OF A COMPONENT AND/OR A PROTOTYPE OF A SUBSYSTEM OF A HEALTH INFORMATION SYSTEM. APPLIED KNOWLEDGE AND UNDERSTANDING: ABILITY TO REALIZE ARCHITECTURAL VIEWS OF SOFTWARE SYSTEMS AND MAKE DESIGN ARTIFACTS. 2) MODULE DATABASE PROJECT (LECTURE-PRACTICE-LABORATORY 0; 0; 20) DIDACTIC UNIT 1: THE DESIGN OF A RELATIONAL DATABASE - ORIENTATION TO PROJECT WORK. (HOURS LECTURE/PRACTICE/LABORATORY 0/0/15). - 1 (3 HOURS LABORATORY): THE SOFTWARE LIFECYCLE - PROJECT WORK ORIENTATION; DATA ANALYSIS AND REQUIREMENTS SPECIFICATION (EXAMPLES). - 2 (3 HOURS LABORATORY) CONCEPTUAL DESIGN - PROJECT WORK ORIENTATION; REQUIREMENT ANALYSIS AND ELICITATION; CONCEPTUAL REPRESENTATION: CRITERIA AND DESIGN PATTERN; DESIGN STRATEGIES; QUALITY OF A CONCEPTUAL SCHEMA; A GENERAL METHODOLOGY; PROJECT PATTERN EXAMPLES AND EXERCISES. - 3 (3 HOURS LABORATORY) CASE STUDY: REQUIREMENT ANALYSIS AND E-R DIAGRAM. - 4 (3 HOURS LABORATORY): LOGIC DESIGN - PROJECT WORK ORIENTATION; PHASES OF LOGIC DESIGN. - 5 (3 HOURS LABORATORY): PERFORMANCE ANALYSIS AND E-R SCHEMAS RESTRUCTURATION. TRANSLATION TO THE RELATIONAL MODEL; PATTERN OF LOGIC DESIGN KNOWLEDGE AND UNDERSTANDING: UNDERSTANDING THE CONCEPTUAL DESIGN AND LOGIC PATTERN. APPLY THE KNOWLEDGE ACQUIRED TO A PROJECT. APPLYING KNOWLEDGE AND UNDERSTANDING: KNOW HOW TO APPLY THE CONCEPTUAL DESIGN PATTERN AND TO BE ABLE TO CREATE AN E-R SCEHMA; KNOW HOW TO RESTRUCTURE A RELATIONAL SCHEME; TO KNOW HOW TO TRANSLATE A RESTORED RELATIONAL SCHEME BY APPLYING THE LOGIC DESIGN PATTERN; APPLY THE KNOWLEDGE ACQUIRED TO A PROJECT. DIDACTIC UNIT 2: BUSINESS PROCESS AND SQL - PROJECT WORK ORIENTATION (LECTURE/PRACTICE/LABORATORY HOURS 0/0/5). - 6 (3 HOURS LABORATORY): APPLICATION OF BPMN NOTATION TO A BUSINESS PROCESS - NO CODE APPROACH (BIZAGI). - 7 (2 HOURS LABORATORY): SET AND NESTED QUERIES IN A BUSINESS PROCESS. KNOWLEDGE AND UNDERSTANDING: UNDERSTANDING HOW TO DEFINE SET AND NESTED FOR A BUSINESS PROCESS APPLYING KNOWLEDGE AND UNDERSTANDING: KNOW HOW TO CREATE SET QUERIES, NESTED FOR A BUSINESS PROCESS TOTAL HOURS OF LECTURE - PRACTICE - LABORATORY 40; 12; 20 |
| Teaching Methods | |
|---|---|
| THE COURSE CONSISTS OF LESSONS AND EXERCISES IN CLASS. MOREOVER, TEAMWORK ACTIVITIES WILL BE DONE DURING THE COURSE. DURING THE EXERCISES, THE STUDENTS ARE ASKED TO DEFINE BP AND DESIGN RELATIONAL DATABASES FOR GIVEN SCENARIOS, TO SOLVE QUERIES AND TO IMPLEMENT DATABASES USING AN RDBMS. IN ORDER TO PARTICIPATE IN THE FINAL ASSESSMENT AND TO GAIN THE CREDITS (CFU) CORRESPONDING TO THE COURSE, THE STUDENT MUST HAVE ATTENDED AT LEAST 70% OF THE HOURS OF ASSISTED TEACHING ACTIVITIES. |
| Verification of learning | |
|---|---|
| THE LEVEL OF ACHIEVEMENT OF THE TEACHING OBJECTIVES IS CERTIFIED BY PASSING AN EXAM WITH THE ASSESSMENT IN THIRTIETHS. THE EXAM CONSISTS OF A WRITTEN TEST AND AN ORAL INTERVIEW. IN THE WRITTEN TEST, THE STUDENTS, STARTING FROM A SYNTHETIC SPECIFICATION OF A PROBLEM, HAVE TO PERFORM ALL THE DESIGN STEPS LEADING TO THE DEFINITION OF BUSINESS PROCESS AND A DATABASE: 1) REQUIREMENT ANALYSIS AND SPECIFICATION; 2) CONCEPTUAL DESIGN; 3) LOGIC DESIGN; 4) DEFINITION AND MANAGEMENT OF DATABASE USING THE SQL LANGUAGE IN POSTGRESQL. ONLY STUDENTS PASSING THE PRACTICAL TEST ARE ADMITTED TO THE ORAL TEST. IN THE ORAL INTERVIEW, THE STUDENT DISCUSSES THE RESULTS OF THE WRITTEN TEST AND ALL THE OTHER TOPICS COVERED IN THE COURSE. THE FINAL EVALUATION CONSIDERS BOTH THE WRITTEN AND ORAL EXAMINATIONS. THE ORAL EXAMS COULD ALSO INCLUDE THE EXECUTION OF SOME EXERCISES IN POSTGRESQL. THE FINAL SCORING WILL BE ASSIGNED TAKING INTO ACCOUNT THE RESULTS OF THE ORAL INTERVIEW AND THE VOTE AWARDED TO THE WRITTEN TEST WHICH HAS A WEIGHT OF 60%. HONORS (“CUM LAUDE”) MAY BE ATTRIBUTED TO STUDENTS WHO PROVE THAT THEY HAVE EXCELLENT MASTERY OF THE COURSE CONTENT TOGETHER WITH THE ABILITY TO APPLY THE KNOWLEDGE ACQUIRED FOR THE RESOLUTION OF PROBLEMS NOT ADDRESSED DURING THE COURSE. |
| Texts | |
|---|---|
| TEXTBOOKS: P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE; BASI DI DATI - SESTA EDIZIONE; MCGRAW-HILL ITALIA ISBN: 9788838668005. A. ROSOTTI “INFORMATICA MEDICA” SECONDA EDIZIONE MCGRAW-HILL ITALIA ISBN: 8838699895. CONSULTATION TEXTBOOK: A. CHIANESE, V. MOSCATO, A. PICARIELLO, L. SANSONE, BASI DI DATI PER LA GESTIONE DELL'INFORMAZIONE - SECONDA EDIZIONE; MCGRAW-HILL ITALIA, ISBN: 9788838672217 SUPPLEMENTARY TEACHING MATERIAL WILL BE AVAILABLE ON THE UNIVERSITY E-LEARNING PLATFORM ACCESSIBLE TO THE STUDENTS USING THEIR OWN UNIVERSITY CREDENTIALS. |
| More Information | |
|---|---|
| THE COURSE IS HELD IN ITALIAN. |
BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2024-12-13]
