|
|
| JDZ7201 | Database Management Systems For Gis | 3+0+0 | ECTS:7.5 | | Year / Semester | Fall Semester | | Level of Course | Third Cycle | | Status | Elective | | Department | DEPARTMENT of GEOMATICS ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face, Lab work | | Contact Hours | 14 weeks - 3 hours of lectures per week | | Lecturer | Prof. Dr. Çetin CÖMERT | | Co-Lecturer | None | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | To establish an understanding of Database Management Systems (DBMS) aspects of Geographic Information Systems (GIS) . |
| Programme Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | PO - 1 : | DBMS and GIS data management concepts will be learned comperatively | 2 | 1 | | PO - 2 : | Special features of spatial data will be learned | 2 | 1 | | PO - 3 : | Software for spatial data management will be learned | 2 | 4 | | PO - 4 : | Spatial data structures will be learned | 2 | 1 | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), PO : Learning Outcome | | |
| Database Management Systems (DBMS) concepts. Functions of a DBMS. Geographical Data Management issues. Geographic data management in the popular Geographic Information System (GIS) softwares and in Oracle Spatial. Spatial data extensions of these GIS softwares. Version management in these softwares. Spatial data structures used in these softwares. Term project. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Database Management Systems (DBMS) concepts Functions of a DBMS. Data model and Schema concepts, SQL | | | Week 2 | OGC Simple Feature Specification and its implementation in Spatial Databases | | | Week 3 | Lab - Spatial queries in PostGIS | | | Week 4 | Geographic data management in the popular Geographic Information System (GIS) softwares | | | Week 5 | Web GIS applications in PostGIS | | | Week 6 | NoSQL Databases | | | Week 7 | Lab-Web Application development in MongoDB | | | Week 8 | Spatial data structures | | | Week 9 | Mid-term exam | | | Week 10 | Term Project | | | Week 11 | Term Project | | | Week 12 | Term Project | | | Week 13 | Term project presentations and Oral Lab Exam | | | Week 14 | Term Project presentations and Oral Lab Exam | | | Week 15 | Term project presentations and Oral Lab Exam | | | Week 16 | End-of-term exam | | | |
| 1 | Elmasri R., Navathe, S.B,1989; Fundamentals of Database systems, Benjamin Cummings, Redwood City, California. | | | |
| 1 | Worboys, M, Duckham M., 2004, GIS, A computing Perspective, CRC Press, second edition. | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | | 1,5 | 30 | | Laboratory exam | 15 | | 2 | 20 | | End-of-term exam | 16 | | 1,5 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 3 | 10 | 30 | | Sınıf dışı çalışma | 9 | 13 | 117 | | Arasınav için hazırlık | 12 | 1 | 12 | | Arasınav | 1.5 | 1 | 1.5 | | Proje | 3 | 3 | 9 | | Kısa sınav | 2 | 1 | 2 | | Dönem sonu sınavı için hazırlık | 17 | 1 | 17 | | Dönem sonu sınavı | 1.5 | 1 | 1.5 | | Total work load | | | 190 |
|