548-0080/01 – Spatial Databases (PDB)

Gurantor departmentDepartment of GeoinformaticsCredits5
Subject guarantordoc. Ing. Jiří Horák, Dr.Subject version guarantordoc. Ing. Jiří Horák, Dr.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2009/2010Year of cancellation
Intended for the facultiesHGFIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOR10 doc. Ing. Jiří Horák, Dr.
DUR30 RNDr. Daniela Szturcová, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 6+6

Subject aims expressed by acquired skills and competences

The aim of the subject is to educate students how to create databases for spatial data and utilise DBMS for solving of different spatial tasks.

Teaching methods

Lectures
Tutorials

Summary

Data administration in R and OR DBMS. Client-server processes. Oracle. Extension of SQL. Geometrical data types. SQL/MM:1999. OGC Simple Feature Specification. Conceptual Modelling for Spatial Data. Storing and indexing of spatial data stored in databases. Spatial queries. Visualisation. Indexation of multidimensional trajectories. Data mining and pattern.

Compulsory literature:

Yeung A.K.W, Hall G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. ISBN 10-1-4020-5393-2. 553 pages.

Recommended literature:

Adam Nabil R., Gangopadhyay Aryya: Database Issues in Geographic Information Systems. Kluwer, 2.vydání, 1998. Rigaux P., Scholl M., Voisard A.: Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages. Manolopoulos Y., Papadopoulos, Vassilakopoulos M.: Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1. Aitchinson A.:Beginning Spatial with SQL Server 2008,Apress 2009, ISBN 978-1-4309-1828-1, 458 s.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

No additional requirements are imposed on the student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Data administration in R and OR DBMS. Client-server processes. Extension of SQL. Geometrical data types. SQL/MM:1999. OGC Simple Feature Specification. Storing and indexing of spatial data stored in databases. Spatial queries. Indexation of multidimensional trajectories. Data mining and pattern. Transaction, distributed processing.

Conditions for subject completion

Full-time form (validity from: 2012/2013 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 33  17
        Examination Examination 67 (67) 18
                Písemná zkouška Written examination 50  18
                Ústní zkouška Oral examination 17  0
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2012/2013 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 33  17
        Examination Examination 67 (67) 18
                Písemná zkouška Written examination 50  18
                Ústní zkouška Oral examination 17  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2016/2017 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2016/2017 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2015/2016 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2015/2016 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2014/2015 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2014/2015 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2013/2014 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2013/2014 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2012/2013 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) P Czech Ostrava 1 Compulsory study plan
2012/2013 (N3646) Geodesy and Cartography (3602T002) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2012/2013 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) K Czech Ostrava 1 Compulsory study plan
2012/2013 (N3646) Geodesy and Cartography (3602T002) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2012/2013 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics K Czech Ostrava 1 Compulsory study plan
2012/2013 (N3654) Geodesy, Cartography and Geoinformatics (3608T002) Geoinformatics P Czech Ostrava 1 Compulsory study plan
2011/2012 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) P Czech Ostrava 1 Compulsory study plan
2011/2012 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) K Czech Ostrava 1 Compulsory study plan
2010/2011 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) P Czech Ostrava 1 Compulsory study plan
2010/2011 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) K Czech Ostrava 1 Compulsory study plan
2009/2010 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) P Czech Ostrava 1 Compulsory study plan
2009/2010 (N3646) Geodesy and Cartography (3602T002) Geoinformatics (10) K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
ECTS - FMG 2016/2017 Full-time English Optional 501 - Study Office stu. block
O - ECTS FMG 2015/2016 Full-time Czech Optional 501 - Study Office stu. block
O - ECTS FMG - Study Further 2014/2015 Full-time Czech Optional 501 - Study Office stu. block
O - ECTS FMG - Study Further 2013/2014 Full-time Czech Optional 501 - Study Office stu. block
O - ECTS FMG - Study Further 2012/2013 Full-time Czech Optional 501 - Study Office stu. block