- Survey of relevant functionality of PostgreSQL (or any other ORDBMS), its components and extensions needed for writing complex database queries (SQL, JSON, XQuery, etc).
- Analysis and documentation of the given object-relational schemas.
- Design and development of complex SQL queries, functions, procedures, views, and triggers for the given object-relational DB requirements.
- Development of a web-based standalone application using an enterprise Java application framework.
- Database design and schema modeling for the given application from semi-structured datasets.
- Transformation, cleaning, loading, and indexing of the application data.
- Session management, caching, and performance improvements using NoSQL data stores.
- OLAP and Business Analytics on real-world datasets.
DB Scheme Design and Programming (Project) (M, 8.0 LP)
|Module Number||Module Name||CP (Effort)|
|INF-21-46-M-7||DB Scheme Design and Programming (Project)||8.0 CP (240 h)|
|CP, Effort||8.0 CP = 240 h|
|Position of the semester||1 Sem. in SuSe|
|Level|| Master (Advanced)|
|Area of study||[INF-INSY] Information Systems|
|Reference course of study||[INF-88.79-SG] M.Sc. Computer Science|
This module used to be called 'ORDB scheme design and implementation'
|Type/SWS||Course Number||Title||Choice in |
|SL||SL is |
required for exa.
DB Scheme Design and Programming (Project)
|P||56 h||184 h||
Evaluation of grades
The module is not graded (only study achievements)..
Competencies / intended learning achievements
As a major goal of the project, the participants are made familiar with the most important techniques for the design of a relational database (information requirements analysis, DB-schema design, DB programming), for DB optimization as well as for design and realization of Web-based DB applications.
After successfully completing the module, students will be able to
- determine basic and extended requirements for a system solution in discussions with users,
- independently define additional requirements for a system solution according to heuristic criteria
- divide agreed and self-chosen tasks into subtasks and to work on them together in a cooperative manner,
- estimate and plan the project effort in detail and to use resources in a goal-oriented way,
- document and manage work results comprehensively and accurately and to present results
- present a specialist lecture using suitable media to a heterogeneous specialist audience,
- lead and moderate a well-founded discussion on the chosen topic based on a technical lecture,
- assess their own scope for action and decision-making and the associated responsibility and, if necessary, obtain targeted information, define priorities, derive tasks, develop solutions and monitor progress
- recognize misunderstandings and role conflicts in communication situations at an early stage and to contribute to conflict resolution,
- argue goal-oriented in controversial discussions and to deal with criticism objectively,
- participate constructively and actively in heterogeneous working groups,
- represent independent points of view and, if necessary, points of view that differ from others in a very comprehensible way and to argue plausibly and convincingly.
- lead, instruct and motivate a working group frequently
- lead heterogeneously composed groups responsibly and to represent work results to third parties.
- develop their own professional, methodological, technological, interdisciplinary, social and personal skills independently.
- see Database Systems
- further material related to the applied technologies and products will be provided
Requirements for attendance of the module (informal)None
- Notice: Some Courses have informal requirements for attendance:
Requirements for attendance of the module (formal)None
References to Module / Module Number [INF-21-46-M-7]
|Course of Study||Section||Choice/Obligation|
|[INF-88.79-SG] M.Sc. Computer Science||[Specialisation] Specialization 1||[WP] Compulsory Elective|