VERİ YÖNETİMİ VE İŞLEME ALGORİTMALARI

AMAÇ

This course introduces the basics of data management and processing. It covers various important topics, including storage manangement, indexing, query processing and optimization, concurrency control, data recovery, data warehouses, data privacy and security.

İÇERİK

Bu ders; Week 1 10-02 Introduction to the course material, overview of data management and processing Week 2 17-02 Storage management and Indexing Week 3 24-02 Queries and query processing Week 4 03-03 Heuristic based Query optimization Quiz #1 Week 5 10-03 Cost based query optimzation Week 6 17-03 Transaction management Quiz #2 Week 7 24-03 Concurrency control Quiz #3 exam Week 8 14-04 Project Progress presentation Week 9 21-04 presentations by students Week 10 28-04 presentations by students Week 11 05-05 Concurrency and Recovery Week 12 12-05 Various Recovery Schemes Quiz #4 Week 13 19-05 Data security and privacy Quiz #5 Week 14 26-05 Project Presentations ; konularını içermektedir.

1. 1

   After successful completion of the course, the student will be able to: 1 Understanding the basics of data storage and indexing 2 Understanding the basics of query processing and optimization 3 Understanding the basics of concurrency control 4 Understanding the basics of data recovery 5 Understanding of basics of data warehouse management 6 Understanding of basics of data privacy and security

HAFTALIK PLAN

1. HAFTA 1

   Week 1 10-02 Introduction to the course material, overview of data management and processing Week 2 17-02 Storage management and Indexing Week 3 24-02 Queries and query processing Week 4 03-03 Heuristic based Query optimization Quiz #1 Week 5 10-03 Cost based query optimzation Week 6 17-03 Transaction management Quiz #2 Week 7 24-03 Concurrency control Quiz #3 exam Week 8 14-04 Project Progress presentation Week 9 21-04 presentations by students Week 10 28-04 presentations by students Week 11 05-05 Concurrency and Recovery Week 12 12-05 Various Recovery Schemes Quiz #4 Week 13 19-05 Data security and privacy Quiz #5 Week 14 26-05 Project Presentations

   Ön hazırlık: none

DEĞERLENDİRME

• Ara Sınavın Başarıya Oranı50%
• Genel Sınavın Başarıya Oranı50%

KAYNAKLAR

• Elmasri and Navathe Database Management Systems, 7th edition

ÖĞRETİM ELEMANLARI

• Prof.Dr. Reda ALHAJJKOORDİNATÖR
• Prof.Dr. Reda ALHAJJ