548-0921/05 – Spatial Databases (PDB)

Gurantor department	Department of Geoinformatics	Credits	10
Subject guarantor	prof. Ing. Jiří Horák, Dr.	Subject version guarantor	prof. Ing. Jiří Horák, Dr.
Study level	postgraduate	Requirement	Choice-compulsory type B
Year		Semester	winter + summer
		Study language	English
Year of introduction	2020/2021	Year of cancellation
Intended for the faculties	HGF, FEI	Intended for study types	Doctoral

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
HOR10	prof. Ing. Jiří Horák, Dr.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Examination	20+0
Part-time	Examination	20+0

Subject aims expressed by acquired skills and competences

The objective is to develop student’s knowledge in the field of object-relational and NoSQL databases dedicated to spatial data and spatial tasks, and increase his/her capability to utilize spatial databases in case studies with topics related to the theme of his/her PhD thesis.

Teaching methods

Individual consultations
Project work

Summary

The course is focused to storage, indexation, maintenance and querying of spatial data in object-relational databases such as Oracle or PostgreSQL+PostGIS and in NoSQL databases (namely graph, document, multidimensional) such as Gephi, Hadoop, MongoDB, storage of vector, raster, TIN and lidar data, extension of SQL for spatial operations, advanced methods of indexation of spatial data, spatial trajectories, data mining of spatial data.

Compulsory literature:

YEUNG A.K.W, HALL G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. 553 p. ISBN 10-1-4020-5393-2. MANOLOPOULOS Y., PAPADOPOULOS, VASSILAKOPOULOS M. Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1 OBE R., HSU L. PostGIS in Action. Manning Publications, 2011. ISBN 1935182269 SULLIVAN, D., 2015. NoSQL for mere mortals. Addison-Wesley, Hoboken, NJ. 510 s. ISBN 978-0-13-402321-2

Recommended literature:

MARQUEZ A. PostGIS Essentials. Packt Publishing, 2015. ISBN 978-1-78439-529-2 SAMET H. Foundations of Multidimensional and Metric Data Structures, Morgan Kaufmann, 2006. PostGIS 3.0dev Manual. Available at https://postgis.net/docs/ BEINAT, E., GODFRIND, A., KOTHURI, R. Pro Oracle Spatial for Oracle Database 11g. Springer, 2007, 787 p. ISBN 1590598997. RIGAUX P., SCHOLL M., VOISARD A. Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages.

Way of continuous check of knowledge in the course of semester

Účast na konzultacích, seminární práce, ústní zkouška.

E-learning

Other requirements

No additional requirements are imposed on the student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Concepts of storage methods for spatial objects and geometries in databases Standards of spatial object representation (OGC Simple Feature Specification and others) Integrity of spatial data and integrity constraints Spatial indexation Spatial querying and spatial extension of SQL Storage of raster data, TIN and lidar data in databases Object-relational databases. Oracle Spatial, MS SQL Server, PostGIS. NoSQL databases. Graph, cloud, multidimensional, XML databases, spatio-temporal databases, stream databases. Gephi, Hadoop, MongoDB. Storage and spatial indexation of multidimensional trajectories. Data mining of spatial data.

Conditions for subject completion

Full-time form (validity from: 2020/2021 Winter semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Examination	Examination			3

Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic year	Programme	Form	Study language	Tut. centre	Type of duty
2023/2024	(P0532D330038) Geoinformatics	P	English	Ostrava	Choice-compulsory type B	study plan
2023/2024	(P0532D330038) Geoinformatics	K	English	Ostrava	Choice-compulsory type B	study plan
2022/2023	(P0532D330038) Geoinformatics	K	English	Ostrava	Choice-compulsory type B	study plan
2022/2023	(P0532D330038) Geoinformatics	P	English	Ostrava	Choice-compulsory type B	study plan
2021/2022	(P0532D330038) Geoinformatics	P	English	Ostrava	Choice-compulsory type B	study plan
2021/2022	(P0532D330038) Geoinformatics	K	English	Ostrava	Choice-compulsory type B	study plan

Occurrence in special blocks

Block name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.