DATA MANAGEMENT

Giancarlo NOTA DATA MANAGEMENT

0222500003
DIPARTIMENTO DI SCIENZE AZIENDALI - MANAGEMENT & INNOVATION SYSTEMS
INFORMATION TECHNOLOGY AND MANAGEMENT
2015/2016

OBBLIGATORIO
YEAR OF COURSE 1
YEAR OF DIDACTIC SYSTEM 2014
PRIMO SEMESTRE
CFUHOURSACTIVITY
1272LESSONS
Objectives
THE STUDENTS WILL LEARN CONCEPTS CONCERNING ADVANCED DATABASE ARCHITECTURES WITH RESPECT TO:
-UNDERSTANDING OF FUNDAMENTAL CONCEPTS: DATA, METADATA, INFORMATION, KNOWLEDGE AND THEIR USE WITHIN ORGANIZATIONS
-DATABASE PROGRAMMING TECHNIQUES
-WEB DATABASE PROGRAMMING
-ADVANCED DATABASE MODELS, SYSTEMS AND APPLICATIONS
-DOCUMENT MANAGEMENT SYSTEMS
Prerequisites
THE STUDENTS HAVE TO KNOW CONCEPTS CONCERNING FUNDAMENTAL ALGORITHMS AND DATA STRUCTURES TOGETHER WITH THE BASIC NOTIONS OF DATABASE SYSTEMS. IN PARTICULAR IS REQUIRED THE KNOWLEDGE OF THE RELATIONAL MODEL AND THE MAIN STRUCTURES OF THE LANGUAGE SQL. IT IS USEFUL SOME SKILL IN THE LANGUAGE PHP ALSO.
Contents
THE COURSE IS STRUCTURED INTO TWO FUNDAMENTAL PARTS: 1) INTRODUCTION TO ENTERPRISE ARCHITECTURES 2) DATA AND KNOWLEDGE MANAGEMENT. PART 1 INCLUDES THE FUNDAMENTAL CONCEPTS NECESSARY TO DESCRIBE ENTERPRISE ARCHITECTURES MODELS, THAT IS, FORMAL DESCRIPTIONS OF AN INFORMATION SYSTEM IN A WAY THAT SUPPORTS REASONING ABOUT STRUCTURAL AND BEHAVIORAL PROPERTIES OF AN ORGANIZATION. PART 2) INCLUDES ADVANCED ASPECTS CONCERNING DATA AND KNOWLEDGE MANAGEMENT.

1)INTRODUCTION TO ENTERPRISE ARCHITECTURES
THE THREE TIER FRAMEWORK ARCHIMATE: BUSINESS, APPLICATION AND TECHNOLOGY LAYER. STRUCTURAL, BEHAVIORAL AND INFORMATION CONCEPTS. SERVICE ORIENTED ORGANIZATIONS, BUSINESS INTERACTION AND COLLABORATION. BUSINESS PROCESS REENGINEERING, ACTIVITY AND PROCESS, MODELING OF BUSINESS PROCESSES IN THE NOTATION BPMN. THE ROLE OF ICT FOR THE REALIZATION OF INTERNAL (RESOURCE MANAGEMENT SERVICE) AND/OR EXTERNAL (CUSTOMER-FACING SERVICES) BUSINESS SERVICES.

2)DATA AND KNOWLEDGE MANAGEMENT
STRUCTURED DATA : PHYSICAL DATABASE FILE STRUCTURES, INDEXING AND HASHING, STORED PROCEDURES, TRIGGERS, TRANSACTION PROCESSING, CONCURRENCY CONTROL TECHNIQUES, WEB DATABASE PROGRAMMING, DATA WAREHOUSING.
SEMI-STRUCTURED DATA MODELS: SEMANTIC DATABASE, SPARQL AND LINKED OPEN DATA.
DOCUMENT MANAGEMENT SYSTEMS.
Teaching Methods
A PROJECT WILL BE ASSIGNED TO EACH GROUP OF STUDENTS. IT WILL BE REQUIRED TO DEVELOP A SOFTWARE APPLICATION THAT WILL EXPLOIT ADVANCED BATABASE ARCHITECTURES. LABORATORY SESSION WILL BE ORGANIZED IN ORDER TO TRANSFER THEORETICAL SUBJECTS TO PRACTICAL CONTEXT.
Verification of learning
1.A WRITTEN TEST ON THEORETICAL CONTENTS (20 P.)
2.AN ORAL TEST IN WHICH THE STUDENTS WILL PRESENT THE DELIVERABLES PRODUCED DURING THE PROJECT (10 P.)
Texts
1. P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI,
R. TORLONE: “BASI DI DATI 4A ED.”, MCGRAW HILL, 2014.
2. R. ELMASRI, S. B. NAVATE:
“FUNDAMENTALS OF DATABASE SYSTEMS 6A ED.” , ADDISON WESLEY, 2011
More Information
THE KNOWLEDGE MANAGEMENT PLATFORM “KNOWLEDGETREE” WILL BE USED
IN ORDER TO EXCHANGE DIDACTIC MATERIAL AND PROJECT DELIVERABLE
(WWW.KTREE.UNISA.IT)
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2016-09-30]