Information Systems (6 cfu) - A.A. 2017-18
Master of Science in Computer Engineering

Reference Book:
Database System Concepts (Fifth edition)
A. Silbershatz, H. Korth, S. Sudarshan
Mc Graw Hill

DATE per l'orale:

- Martedi' 20 gennaio ore 11.00 Dip Ing. Informazione
- Giovedi' 22 gennaio ore 9.30 Dip Ing. Informazione
Chiedo gentilmente di mandarmi una mail per l'iscrizione.


Course outline:

- Data Storage: File Structure and Indexing
- Query Optimization
- Transaction management
- Distributed databases
- Spatial and Geographic data (GIS)
- Decision Support Systems
- Faults, Errors, failures: basic concepts
- Stable storage implementation
- Recovery System
- Reliability and Availability measures


Background:
Database system concepts book.
Chapter 1: Introduction
PART 1: Chapter 2, 3, 4 (Subs. 4.1, 4.2, 4.3, 4.4)
PART 2: Chapter 6, 7 (Subs.7.1, 7.2, 7.3)
Tool MySQL5.0


Slides:
Data storage File/Record structure
Indexing Ordered indices
Static Multilevel Ordered Indices: exercises
B+-trees Indices: exercises
Operations on B+-trees: exercises
Indexing Hash indices
Query processing query optimizer
Transactions file1     file2
Concurrency control file
Serializability exercise
Distributed databases file1
Temporal, Spatial and Geographic data     G-Tree data structure
Query optimization: exercise1     exercise2
Decision support systems: file1     file2

Physical Storage: RAID
Recovery subsystem: Log-based recovery
Dependability: Basic concepts     Threats     Redundancy part1     Redundancy part2
Dependability evaluation: quantitative measures
Dependability software reliability


Supporting reading:
Basic Concepts and Taxonomy of Dependable and Secure Computing paper.pdf
A case Study of Toyota Unintended Acceleration and Software Safety slides.pdf

Mobius tool:
Fault trees Lab01.pdf
SAN models Lab02.pdf
Analysis of RAID5 and RAID51 Lab03.pdf


Examples of written test:
01-07-2016     17-02-2016     29-01-2016     14-01-2015     03-07-2015