Sumários

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

Lab 0: SSMS Tutorial (online class)

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

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

No class

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

There were no lab classes in the first week.

Storage and File Structure (online)

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

Overview of Physical Storage Media:

  • Primary, Secondary and Tertiary Storage
  • Performance Measures of Disk
  • Optimization of Disk Block Access
  • RAID

File Organization: 

  • Organization of Records in Files
  • Fixed-length records

Storage and File Structure (online)

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

Overview of Physical Storage Media:

  • Primary, Secondary and Tertiary Storage
  • Performance Measures of Disk
  • Optimization of Disk Block Access
  • RAID

File Organization: 

  • Organization of Records in Files
  • Fixed-length records