Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Geospatial databases (17.GI408A)

Native organizations units: Sub-department for Applied Computer Science and Informatics

Type of studies	Title
Undergraduate Academic Studies	Geodesy and Geoinformatics (Godina: 4, Winter)

General information:

Category	Scientific-professional
Scientific or art field	Geoinformatika
Interdisciplinary	No
ECTS	6

Educational goal:

To acquire basic and applied knowledge in the field of geodesy, geomatics and geoinformatics. To acquire basic and applied knowledge in the field of databases and geospatial databases.

Educational outcome:

Acquired knowledge is used in professional courses, as well as in the recognition and in solving the engineering problems.

Course content:

Lecture content: Modelling spatial entities and databases. Raster and vector models, geometry, spatial topology and topography. Systems for database control and spatial expansions. SQL and spatial entities. Query spatial languages. Spatial operators. 9IM matrix. Realization of spatial queries. Optimization and adjustment of performances. Distributed databases with spatial expansion and entities. Practice content: Practical application of presented concepts from lectures.

Teaching methods:

Teaching forms: lectures, computer practice, consultations, individual elaboration of obligatory tasks. Knowledge evaluation: 3 defended computer tasks, 4 tests, final examination – oral form.

Literature:

Authors	Title	Year	Publisher	Language
Govedarica, M., Sladić, D., Radulović, A.	Infrastruktura geoprostornih podataka i geoportala	2018	Fakultet tehničkih nauka, Novi Sad	Serbian language
Galić, Z.	Geoprostorne baze podataka	2006	Golden marketing, Zagreb	Serbian language
Burrough, P., McDonnell, R.	Principi geografskih informacionih sistema	2006	Građevinski fakultet, Beograd	Serbian language
Worboys M.F., Duckham, M.	GIS: A Computing Perspective	2004	CRC Press	English
Mogin, P., Luković, I., Govedarica, M.	Principi projektovanja baza podataka	2004	Fakultet tehničkih nauka, Novi Sad	Serbian language
Shekhar, S., Chawla, S.	Spatial Databases: A Tour	2003	Prentice-Hall, New Jersey	English

Knowledge evaluation:

Course activity	Pre-examination	Obligations	Number of points
Test	Yes	Yes	5.00
Oral part of the exam	No	Yes	50.00
Computer excersise defence	Yes	Yes	10.00
Exercise attendance	Yes	Yes	5.00
Computer excersise defence	Yes	Yes	10.00
Computer excersise defence	Yes	Yes	15.00
Test	Yes	Yes	5.00