Sumários

Lab Guide 7: Schema Tuning (aula online)

4 maio 2021, 09:30 • João Tiago Aparício

Normalization vs denormalization:
  • denormalization by collapsing tables
  • denormalization by adding redundant columns
  • denormalization by adding derived attributes
Partitioning tables: vertically and horizontally
Materialised views in SQL Server 2012 Non-clustered indexes over derived attributes in SQL Server 2012. 
Exercise 2.1: Experiments with SQL ServerExercise 2.2: Paper & pencil exercise.

Clarification of doubts for the course project 

Lab Guide 6: Failure Recovery (online class)

30 abril 2021, 11:00 • Carlota de Oliveira Lopes Dias

Lab guide 6:

  • Experiment 2.1: Database backups
  • Exercise 2.2.1: Aries Algorithm
  • Exercise 2.2.1: Aries Algorithm.

Presentation of the project

30 abril 2021, 09:30 • Helena Galhardas

Presentation of the questions included in the project.

Presentation of the project

30 abril 2021, 09:30 • Helena Galhardas

Presentation of the questions included in the project.

Lab Guide 6: Failure Recovery (online class)

30 abril 2021, 08:00 • Carlota de Oliveira Lopes Dias

Lab guide 6:

  • Experiment 2.1: Database backups
  • Exercise 2.2.1: Aries Algorithm
  • Exercise 2.2.1: Aries Algorithm.