File Organization

2 março 2018, 09:30 • Bruno Emanuel Da Graça Martins

• File Organisation
  
• • Organization of Records in Files
  • Fixed-length Records
  • Variable-length Records and the slotted page structure
  • Heap, sequential, and hash file organisations
  • Comparison of file organizations with a simple cost model
• Data-Dictionary Storage
• Storage Access and Buffer Management
• Buffer Replacement Policies
• Fundamental Concepts on Indexing

Lab 0: Introduction to the environment

2 março 2018, 08:00 • Diogo Ribeiro Ferreira

Tutorial on SQL Server Management Studio using the AdventureWorks database.

Not Taught.

27 fevereiro 2018, 12:30 • Diogo Ribeiro Ferreira

Não houve aula laboratorial por motivos de saúde do docente.

Storage Devices + RAID Architectures

27 fevereiro 2018, 11:00 • Bruno Emanuel Da Graça Martins

• Overview of Physical Storage Media
  
• Electro-mechanical Hard Drives
• Performance Measures of Disk
• Optimization of Disk Block Access
• RAID Architectures
• File Organization
  

Storage Devices + RAID Architectures

27 fevereiro 2018, 11:00 • Bruno Emanuel Da Graça Martins

• Overview of Physical Storage Media
  
• Electro-mechanical Hard Drives
• Performance Measures of Disk
• Optimization of Disk Block Access
• RAID Architectures
• File Organization