Course

DB2 - Data Base Systems 2

PDF Course Catalog Deutsche Version: DB2

Version: 1 | Last Change: 11.09.2019 19:04 | Draft: 0 | Status: vom verantwortlichen Dozent freigegeben

Long name Data Base Systems 2
Approving CModule DB2_BaTIN
Responsible
Prof. Dr. Andreas Behrend
Professor Fakultät IME
Level Bachelor
Semester in the year summer semester
Duration Semester
Hours in self-study 60
ECTS 5
Professors
NF Büchel
Requirements Basic Course Mathematics
Basic Course Computer Science
Data Base Systems 1
Language German
Separate final exam Yes
Literature
C. Türker: SQL 1999 & SQL 2003
St. Edlich: NoSQL Datenbanken
Final exam
Details
Examination questions are programming of XML parser functions for generating insert- or update-commands, definition of a XML grammar using XML scheme, transformation of a UML class diagramm in a sequence of abstract data types, transformation of abstract data types in object-relational data types and in JSON types, insert- and delete-operations in Bayer trees.
Minimum standard
Programming of a XML parser functions for generating an insert- or an update-commands,
Transformation of an abstract data type in the scheme of a JSON type,
An insert- or a delete-operation of a key in a Bayer tree.
Exam Type
Examination questions are programming of XML parser functions for generating insert- or update-commands, definition of a XML grammar using XML scheme, transformation of a UML class diagramm in a sequence of abstract data types, transformation of abstract data types in object-relational data types and in JSON types, insert- and delete-operations in Bayer trees.

Learning goals
Knowledge
XML Grammar with XML scheme
abstract data types
object oriented data bases
object relational data bases
NoSQL data bases
Bayer trees
Expenditure classroom teaching
Type Attendance (h/Wk.)
Lecture 2
Exercises (whole course) 0
Exercises (shared course) 2
Tutorial (voluntary) 0
Special literature
keine/none
Special requirements
none
Accompanying material
Script "Data Base Systems 2" (on the WEB-Page and as printed text); a lot of examples of XML parser programes using XML scheme and programmes for object relational data bases and for NoSQL data bases.
Separate exam
none

Learning goals
Skills
Definition of XML schemes, of abstract data types, of data types in object-relational data bases. Programming of CRUD Operations on object-relational data bases and on NoSQL data bases. Validating parsing of JSON documents.
Expenditure classroom teaching
Type Attendance (h/Wk.)
Practical training 1
Tutorial (voluntary) 0
Special literature
keine/none
Special requirements
none
Accompanying material
Script "Data Base Systems 2" (on the WEB-Page and as printed text); a lot of examples of XML parser programes using XML scheme and programmes for object relational data bases and for NoSQL data bases.
Separate exam
none

Impressum
Datenschutzhinweis
Haftungshinweis
Bei Fehlern, bitte Mitteilung an die
Webredaktion der Fakultät IME

© 2022 Technische Hochschule Köln