Sumários

Indexing (cont.)

12 março 2021, 09:30 • Helena Galhardas


  • Basic Concepts: dense vs sparse indexes, clustering vs non-clustering indexes; multi-level indexes
  • Ordered Indices
    • B+-Tree Index Files: query and insertion algorithms.

Indexing (cont.)

12 março 2021, 09:30 • Helena Galhardas


  • Basic Concepts: dense vs sparse indexes, clustering vs non-clustering indexes; multi-level indexes
  • Ordered Indices
    • B+-Tree Index Files: query and insertion algorithms.

Lab 0 (aula online)

12 março 2021, 08:00 • Carlota de Oliveira Lopes Dias

  • Introduction to laboratory and practical classes
  • Setup of the required software
  • Execution of Lab 0

Lab 0: SSMS Tutorial (online class)

9 março 2021, 12:30 • João Tiago Aparício

  • Introduction to laboratory and practical classes
  • Setup of the required software
  • Execution of Lab 0

Storage and File Structure (cont.) and Indexing (online)

9 março 2021, 11:00 • Helena Galhardas

File Organization: 

  • Organization of Records in Files
  • Fixed-length records
  • Variable-length records
  • Comparison of file organisations: cost model
Data-dictionary storage Storage Access and Buffer Management 
  • Buffer Replacement Policies

Indexing: 

  • Basic Concepts
  • Ordered Indices