Συστήματα Διαχείρισης Βάσεων Δεδομένων

Weekly outline

• Course info

  Collapse all Expand all
  • 

    General info Page
  • 

    Course description - Content Page
  • 

    Instructor Details Page
  • 

    Requirements Page
  • 

    Bibliography - Sources Page
  • 

    Discussion group Forum

• Lectures
  • 

    1. Introduction File
  • 

    1. Data storage, Record and file structures
  • 

    2. Access methods, File organization, B+Tree
  • 

    3. Access methods: Hash Indexes File
  • 

    4. Physical and Logical Database Schema Tuning File
  • 

    5. External sorting File
  • 

    6. Query Execution File
  • 

    7. Query Processing File
  • 

    8. Transaction Management & Recovery File
  • 

    9. Recovery & Concurrency Control File
  • 

    10. Concurrency Control File

• Exercise Sessions
  • 

    1. Tutorial on buffer management File
  • 

    2. File Organization Examples
  • 

    3. Tutorial on Indexing - part 1 File
  • 

    4. Tutorial on Indexing - part 2 File
  • 

    5. Tutorial on External Sorting File
  • 

    6. Index Tuning File
  • 

    7. Tutorial on Query Optimization File
  • 

    8. Query Optimization and Tuning in Oracle File
  • 

    9. Transactions - part 1 File
  • 

    10. Transactions - part 2 File

• Self evaluation Exercises
  • 

    1. Storage - indexing File
  • 

    2. Query Optimization File
  • 

    3. Transactions File
  • 

    4. Project File