Ordered Indices

6 março 2018, 11:00 • Bruno Emanuel Da Graça Martins

• Ordered Indices
• B+-Tree Index Files
• B-Tree Index Files
  

Ordered Indices

6 março 2018, 11:00 • Bruno Emanuel Da Graça Martins

• Ordered Indices
• B+-Tree Index Files
• B-Tree Index Files
  

Lab 1: Storage and file structure

6 março 2018, 09:30 • Diogo Ribeiro Ferreira

Tutorial about database creation and file storage in SQL Server. Exercise about accessing data on hard disks.

Lab 0: Introduction to the environment

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

Tutorial on SQL Server Management Studio using the AdventureWorks database.

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