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