Complete course notes

Page 1

TIS Notes Author: Simone Staffa Disclaimer!! This document is not intended to be a source of truth to prepare the exam. The materials included here are taken from the official course slides, I’m not responsible for wrong answers or errors reported here (even though I’ve done my best to provide valid material that regards all the topics that were spoken in the course). This notes are an extension of this document: Appunti Riassuntivi del Corso Released with Beerware License, Rev. 42 (https://spdx.org/licenses/Beerware.html) “As long as you retain this notice you can do whatever you want with this stuff. If we meet some day, and you think this stuff is worth it, you can buy me a beer in return” January 26, 2021 1 Contents 1 Data Integration 4 1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.1.1 Interoperability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.1.2 4 Vs of Big Data in data integration . . . . . . . . . . . . . . . . . . . . . . 4 1.1.3 Heterogeneity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 1.2 The Steps of Data Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 1.2.1 Design Steps for Data Integration . . . . . . . . . . . . . . . . . . . . . . . 6 1.3 Conflict Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 1.3.1 Conflict Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 1.4 Mapping between the Global Logical Schema and the Single Source Schemata (log- ical view definition) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 1.5 Inconsistencies in the Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.5.1 Record Linkage (aka Entity…