Data Modeling: From Relational Databases to Big Data_first part

5 Sept 2023, 09:00
1h 30m
ROOM S8 (Consorzio Universitario)

ROOM S8

Consorzio Universitario

Via Prasecco 3a

Speaker

Prof. Andrea Brunello (University of Udine)

Description

Database management systems are a fundamental tool to store and analyze data in countless
domains, empowering business intelligence as well as descriptive, predictive, and prescriptive
analytics tasks. Choosing the right database technology is not trivial since, due to the intrinsic
heterogeneous nature of information, different approaches must be followed to handle structured,
semi-structured, and unstructured data, and the so called Big Data. This gives rise to complex
information systems, in which data regarding a specific object may be fragmented and possibly
replicated into several repositories, both relational as well as NoSQL in their nature. Data
warehousing allows to bring order into such an information jungle, by means of employing a single,
enterprise-wide storage, which should be continuously fed by data streams, engineered to perform
ETL (Extract, Transform, Load) tasks. The goal of the lecture is that of covering, from a general and
intuitive point of view, all the main aspects pertaining to the previously described issues.
1. What is data? (Lecture)
2. Approaches to store, integrate and manage data within an enterprise IT infrastructure (Lecture)

Presentation materials