ECTS @ IUE ECTS @ IUE ECTS @ IUE ECTS @ IUE ECTS @ IUE ECTS @ IUE ECTS @ IUE

Syllabus ( GEOD 551 )


   Basic information
Course title: Geo-Database Management
Course code: GEOD 551
Lecturer: Prof. Dr. Arif Çağdaş AYDINOĞLU
ECTS credits: 7.5
GTU credits: 3 (3+0+0)
Year, Semester: 1/2, Fall and Spring
Level of course: Second Cycle (Master's)
Type of course: Area Elective
Language of instruction: Turkish
Mode of delivery: Face to face , Lab work
Pre- and co-requisites: none
Professional practice: No
Purpose of the course: Geo-database, main component of GIS, enables effective management of geo-data sets coming from different sources to provide information for decision makers. In this course, according to GIS application needs, geo-database is designed, built, and managed. This course aims to concentrate specifically on geo-databases as a resource and knowledge base for decision making, working on geo-information. This course aims to define and use informatics sources for geo-database development, to examine concepts and technology about database and user-centric approach concerning geo-information
   Learning outcomes Up

Upon successful completion of this course, students will be able to:

  1. Grasp database concept, review database principles and models

    Contribution to Program Outcomes

    1. Define and manipulate advanced concepts of Geodesy and Photogrammetry Engineering
    2. Review the literature critically pertaining to his/her research projects, and connect the earlier literature to his/her own results
    3. Acquire scientific knowledge
    4. Work effectively in multi-disciplinary research teams

    Type of Assessment

    1. Written exam
  2. Make requirement analysis for designing information systems in view of application need, design object-oriented and relational geo-data model

    Contribution to Program Outcomes

    1. Formulate and solve advanced engineering problems
    2. Review the literature critically pertaining to his/her research projects, and connect the earlier literature to his/her own results
    3. Recognize, analyze and solve engineering problems in surveying, planning, GIS and remote sensing fields
    4. Acquire scientific knowledge
    5. Design and conduct research projects independently
    6. Work effectively in multi-disciplinary research teams
    7. Find out new methods to improve his/her knowledge.

    Type of Assessment

    1. Written exam
    2. Homework assignment
  3. Integrate and Build geo-database coming from different sources such as Surveying, GPS, Remote Sensing, Photogrammetry, and field work.

    Contribution to Program Outcomes

    1. Define and manipulate advanced concepts of Geodesy and Photogrammetry Engineering
    2. Recognize, analyze and solve engineering problems in surveying, planning, GIS and remote sensing fields
    3. Operate modern equipments and hardwares, and use related technical skills in the field of Geodesy and Photogrammetry Engineering.
    4. Work effectively in multi-disciplinary research teams
    5. Develop an awareness of continuous learning in relation with modern technology

    Type of Assessment

    1. Homework assignment
    2. Laboratory exercise/exam
  4. Define feature geometry, attributes, associations, topology, and other properties; and implement this on any GIS software environment

    Contribution to Program Outcomes

    1. Formulate and solve advanced engineering problems
    2. Recognize, analyze and solve engineering problems in surveying, planning, GIS and remote sensing fields
    3. Operate modern equipments and hardwares, and use related technical skills in the field of Geodesy and Photogrammetry Engineering.
    4. Design and conduct research projects independently
    5. Develop an awareness of continuous learning in relation with modern technology
    6. Find out new methods to improve his/her knowledge.
    7. Effectively express his/her research ideas and findings both orally and in writing

    Type of Assessment

    1. Written exam
    2. Homework assignment
    3. Laboratory exercise/exam
  5. Build geo-database, manage according to application requirement.

    Contribution to Program Outcomes

    1. Define and manipulate advanced concepts of Geodesy and Photogrammetry Engineering
    2. Recognize, analyze and solve engineering problems in surveying, planning, GIS and remote sensing fields
    3. Operate modern equipments and hardwares, and use related technical skills in the field of Geodesy and Photogrammetry Engineering.
    4. Design and conduct research projects independently
    5. Work effectively in multi-disciplinary research teams
    6. Develop an awareness of continuous learning in relation with modern technology
    7. Support his/her ideas with various arguments and present them clearly to a range of audience, formally and informally through a variety of techniques

    Type of Assessment

    1. Homework assignment
    2. Laboratory exercise/exam
   Contents Up
Week 1: The current status of geographic information technology
Week 2: Introduction to geo-database concepts
Week 3: Database working principles and architecture
Week 4: Definitions of feature types, geometry, attributes, attribute and topology associations, and other properties in relational and object-oriented geo-database models
Week 5: Schemas of geo-data(base) models with Entity-Relationship (ER) and Unified Modelling Language (UML)
Week 6: Geo-Database Systems and structure- ArcGDB, PostGIS, etc.
Week 7: Using SQL for data entry, management, and query in geo-database
Week 8: Midterm Exam
Week 9: Determining user data requirement for a GIS application area
Week 10: Designing geo-database for a GIS application area
Week 11: Building and Managing geo-database for a GIS application area
Week 12: Project management in a multiuser geo-database
Week 13: Network / Web-based geo-database systems
Week 14: Data sharing with geo-data warehouses and portals
Week 15*: Future trends of geo-database systems and Cloud GIS
Week 16*: Final Exam
Textbooks and materials: ders slaytları ve notları / course slides and textbooks (hazırlayan / prepared by: A.C. Aydınoğlu)
Recommended readings: - Yeung, K.W. and Hall, G.B., 2007. Spatial Database Systems: Design, Implementation and Project Management, Springer, ISBN 10-1-4020-5393-2
- ISO 19109- Application Schema Language, ISO/TC211 Standard.
- ISO 19110- Feature Cataloguing, ISO/TC211 Standard.
- Butler, J.A., 2008. Designing Geodatabases, Esri Press, ISBN 978-1-58948-164-0.
- Manolopoulos, Y., Papadopoulos, A.N. and Vassilakopoulos, M., 2005. Spatial Databases: Technologies, Techniques and Trends, Idea Group Publishing, ISBN 1-59140-387-1.
  * Between 15th and 16th weeks is there a free week for students to prepare for final exam.
Assessment Up
Type of Assessment Week number Weight (%)
Mid-terms: 8 30
Other in-term studies: 0
Project: 0
Homework: 4,12 30
Quiz: 0
Final exam: 16 40
  Total weight:
(%)
   Workload Up
Activity Duration (Hours per week) Total number of weeks Total hours in term
Courses (Face-to-face teaching): 3 14
Own studies outside class: 4 15
Practice, Recitation: 0 0
Homework: 5 12
Term project: 0 0
Term project presentation: 0 0
Quiz: 0 0
Own study for mid-term exam: 5 2
Mid-term: 1 2
Personal studies for final exam: 6 2
Final exam: 1 2
    Total workload:
    Total ECTS credits:
*
  * ECTS credit is calculated by dividing total workload by 25.
(1 ECTS = 25 work hours)