TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF ENGINEERING |
| COMPUTER ENGINEERING PR. (ENGLISH) | |
| Code | CEN301 |
| Name | Data Management and File Structures |
| Term | 2017-2018 Academic Year |
| Semester | 5. Semester |
| Duration (T+A) | 3-0 (T-A) (17 Week) |
| ECTS | 6 ECTS |
| National Credit | 3 National Credit |
| Teaching Language | İngilizce |
| Level | Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Prof. Dr. SELMA AYŞE ÖZEL |
| Course Instructor |
Prof. Dr. SELMA AYŞE ÖZEL
(Güz)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
The objective of this course is to introduce students how to store and access data efficiently in secondary storage devices such as disk, CD, etc. and also to make abstraction of real life data using entity relationship model for efficient processing.
Course Content
Overview of storage and indexing. Disks and files. Redundant array of independent disks (RAID) systems. Disk space management. Files of records. Tree structured indexing (ISAM, B plus trees). Hash-based indexing (static hashing, extendible hashing, linear hashing). Secondary key retrieval (k-d trees, grid files). External sorting. Data abstraction using entity relationship model. Introduction to database management systems concepts.
Course Precondition
Yok
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Be able to understand the physical properties of secondary storage units, RAID systems, and data management processes. |
| LO02 | Be able to evaluate the performance of sequential and direct-access file structures and external sorting algorithms. |
| LO03 | Analyze index-based search methods and applications. |
| LO04 | Be able to solve real-world problems using the entity-relationship model. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Adequate knowledge of mathematics, science and related engineering disciplines; ability to use theoretical and applied knowledge in these fields in solving complex engineering problems. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Ability to identify, formulate and solve complex engineering problems; ability to select and apply appropriate analysis and modeling methods for this purpose. | 5 |
| PLO03 | Bilgi - Kuramsal, Olgusal | Ability to design a complex system, process, device or product to meet specific requirements under realistic constraints and conditions; ability to apply modern design methods for this purpose. | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Ability to select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in engineering practice; ability to use information technologies effectively. | |
| PLO05 | Bilgi - Kuramsal, Olgusal | Ability to design and conduct experiments, collect data, analyze and interpret results to investigate complex engineering problems or discipline-specific research topics. | |
| PLO06 | Bilgi - Kuramsal, Olgusal | Ability to work effectively in interdisciplinary and multidisciplinary teams; individual working skills. | |
| PLO07 | Bilgi - Kuramsal, Olgusal | Ability to communicate effectively verbally and in writing; knowledge of at least one foreign language; ability to write effective reports and understand written reports, prepare design and production reports, make effective presentations, and give and receive clear and understandable instructions. | |
| PLO08 | Bilgi - Kuramsal, Olgusal | Awareness of the necessity of lifelong learning; ability to access information, follow developments in science and technology, and constantly renew oneself. | 3 |
| PLO09 | Bilgi - Kuramsal, Olgusal | Knowledge of ethical principles, professional and ethical responsibility, and standards used in engineering practice. | |
| PLO10 | Bilgi - Kuramsal, Olgusal | Knowledge of business practices such as project management, risk management and change management; awareness of entrepreneurship and innovation; knowledge of sustainable development. | |
| PLO11 | Bilgi - Kuramsal, Olgusal | Knowledge of the effects of engineering practices on health, environment and safety in universal and social dimensions and the problems of the age reflected in the field of engineering; awareness of the legal consequences of engineering solutions. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Physical properties of the secondary storage devices. | Reading the lecture notes | |
| 2 | An overview to the RAID systems. | Reading the lecture notes, homework assignment | |
| 3 | Disk space management, buffer management, record and page formats. | Reading the lecture notes | |
| 4 | Pile (sequential) files and their performances. | Reading the lecture notes, homework assignment | |
| 5 | Direct Access files (ISAM, and B plus trees). | Reading the lecture notes | |
| 6 | Direct Access files. (Static, extendible, and linear hashing). | Reading the lecture notes, homework assignment | |
| 7 | Performance evaluation of direct access files. | Reading the lecture notes | |
| 8 | Midterm exam. | Reading the lecture notes | |
| 9 | External sorting algorithms. | Reading the lecture notes, homework assignment | |
| 10 | Performance impovements and analysis of external sorting algorithms. | Reading the lecture notes | |
| 11 | Secondary key retrieval (k-d trees and grid files). | Reading the lecture notes, homework assignment | |
| 12 | Introduction to database management systems and basic concepts of entity relationship model. | Reading the lecture notes | |
| 13 | Entity Relationship (E/R) diagrams. | Reading the lecture notes, homework assignment | |
| 14 | Sample applications using entity relationship diagrams. | Reading the lecture notes | |
| 15 | Integrity constraints in databases. | Reading the lecture notes | |
| 16 | Final Exam. | Reading the lecture notes | |
| 17 | Final Exam. | Reading the lecture notes |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 63 | 25.2 |
| 1. Homework | 37 | 14.8 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 4 | 56 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 3 | 4 | 12 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 15 | 15 |
| Final Exam | 1 | 25 | 25 |
| Total Workload (Hour) | 150 | ||
| Total Workload / 25 (h) | 6,00 | ||
| ECTS | 6 ECTS | ||