|Abbreviation: B23A01||Load: 30(L)
|Lecturers in charge: ||prof. dr. sc. Damir Medak
Students will acquire theoretical background and practical usage of contemporary databases in context of geodesy and geoinformatics.
Learning outcomes expected at the level of the course
- define basic database concepts
- differentiate relational. object, object-relational and deductive database models
- apply entity-relationship model on a concrete problem in fields of geodesy and geoinformatics
- crate a database relational schema using the normal forms
- explain database indexing
- solve practical problems using SQL commands and functions
Learning outcomes at the level of the programme to which the course contributes
- Maintain topographic, cartographic, maritime and navigation, and land information systems, integrate and visualise spatial information.
- Use information technology in solving geodetic and geoinformation tasks.
- Recognise problems and tasks in the application of geodetic and geoinformation principles and methods, and select proper procedures for their solution.
- Keep pace with and adopt new technological achievements in the field of surveying, geoinformation systems and services based on the position, and the changes in regulations, norms and standards.
Course content broken down in detail by weekly class schedule (syllabus)
- Introduction, Course goals. Definitions of basic concepts. Motivation for Databases.
- Database Management System (DBMS). Three levels of abstraction.
- Entity Relationship Schema. Logical data models.
- Acces methods. Linear and binary searching. Data indexing.
- Entities and attributes. Primary and foreign keys.
- Relational model. Normal forms.
- Relational algebra.
- SQL-92: Data Definition Language, Data Manipulation Language.
- Multitable queries. Aggregation and grouping operations.
- Transactions. ACID conditions.
- Object databases. Encapsulation. Reusability. Inheritance. Polymorphism
- Extensions to relational model. Spatial extensions. OGC standards.
- Geometric data types and operations.
- Knowledge databases. Facts and rules.
- Prolog. NoSQL.
Screening student work
- Tests - 2 ECTS
- Oral exam - 1 ECTS
- Written exam - 1 ECTS
- Project - 1 ECTS
|1. ||Worboys, M.F. and Duckham, M. (2004) GIS: A Computing Perspective, Second Edition, CRC Press.
|3. ||Douglas, K., Douglas, S (2005): PostgreSQL (2nd Edition), SAMS.
|4. ||Medak, D. (2011): Baze podataka - predavanja. Geodetski fakultet Sveučilišta u Zagrebu.
|2. ||Date, C.J. (2000): An Introduction to Database Systems. Addison Wesley Longman; 7th edition.