• HOME
• ABOUT US
  • Name Address
  • General Description
  • Governance
  • Academic Calendar
  • Degree Programmes
  • List of Programmes in English
  • General Admission and Registration Procedures
  • Credit Mobility and Recognition of Prior Learning
  • ECTS Credit Allocation
  • Academic Guidance
  • Contacts
• Degree Programmes
  • Third Cycle Programmes (Doctorate Degree)
  • Second Cycle Programmes (Master's Degree)
  • First Cycle Programmes (Bachelor's Degree)
  • Short Cycle Programmes (Associate's Degree)
• GENERAL INFORMATION FOR STUDENTS
  • Cost of Living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Disabled Students
  • Insurance
  • Financial Supports
  • Student Affairs Office
  • Practical Information for International Students
  • Language Courses
  • Work Placement Possibilities
  • Sports, Social and Cultural Facilities
  • Student Associations and Clubs
  • About İzmir - Turkey
• INTERNATIONAL RELATIONS
  • International Relations Office
  • Registration Procedures
  • Agreements
  • Coordinators
  • Documents
  • List of Programmes in English
  • ECTS / DS Labels

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS YBS 3002 SPATIAL DATABASES COMPULSORY 2 2 0 4

Offered By

Management Information Systems

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

PROFESSOR VAHAP TECIM

Offered to

Management Information Systems

Course Objective

The course aims to teach students to transfer spatial into database structures, design spatial database, query and management of spatial databases.

Learning Outcomes of the Course Unit

1   Understanding spatial data sources. 2   Establishing a relation between database technologies. 3   Creating spatial database structure according to requirements and objectives. 4   Performing an effective spatial database management.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Introduction to Spatial Databases: Basic Descriptions, Model Applications, Physical Data Management 2 Database Management Systems: Data Storage, Data Arrangement, Spatial Data, Relational Database 3 Database Design: Representation of Spatial Objects, Spatial Data Formats 4 Relational Model: Creating Relationship, Querying Related Data 5 Limitations 6 Computation Geometry: Algorithmic Strategies, Polygon Allocation, Algorithms for Spatial Databases, Relational Calculations 7 SQL: I/O Algorithm, Basic Queries, Nested Queries 8 Mid-Term 9 Mid-Term 10 Database Development: Database Access, Database Structures, Links 11 Storage and Indexing: Index Data Structures, File Organization, Data Storage Formats, Indexing Formats 12 Query Evaluation: Evaluation Plan, Sorting, Evaluating Relational Operators, Optimization 13 Management, Control and Back-up 14 Spatial Databases: Use in Web Applications

Recomended or Required Reading

Main Textbook: Philippe Rigaux, Michel Scholl & Agnes Voisard, Spatial Databases with Application to GIS, 2002 Help book: Regina O. Obe, Leo S. Hsu, PostGIS in Action, 2011 Simon Greener, Siva Ravada, Applying and Extending Oracle Spatial,2013

Planned Learning Activities and Teaching Methods

Activities are given in detail in the Assessment Methods and Total Workload sections.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA 1 MTE MIDTERM EXAM 2 MTEG MIDTERM GRADE MTEG * 1 3 FIN FINAL EXAM 4 FCGR FINAL COURSE GRADE MTEG * 0.40 + FIN * 0.60 5 RST RESIT 6 FCGR FINAL COURSE GRADE (RESIT) MTEG * 0.40 + RST * 0.60 *** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

Students will undergo two exams, one mid-term and one final.

Assessment Criteria

Assessment criteria will be announced later.

Language of Instruction

Turkish

Course Policies and Rules

The rules applied by the department are valid.

Contact Details for the Lecturer(s)

Contact details will be announced later.

Office Hours

Office hours will be announced later.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Lectures 12 3 36 Preparations before/after weekly lectures 12 3 36 Preparation for final exam 1 20 20 Preparation for midterm exam 1 15 15 Final 1 1 1 Midterm 1 1 1 TOTAL WORKLOAD (hours) 109

Contribution of Learning Outcomes to Programme Outcomes

PO/LO PO.1 PO.2 PO.3 PO.4 PO.5 PO.6 PO.7 PO.8 PO.9 PO.10 PO.11 PO.12 PO.13 LO.1 5 LO.2 5 LO.3 5 LO.4 5