DB Project
Contents
The goal of this course is to help students gain practical experience in the areas of object-relational DB schema design, modern database application development and data analytics. The project is divided into worksheets with a focus on below:
- Survey of relevant functionalities 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 develop 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 and docker.
- 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 datastores.
- OLAP and Business Analytics on real-world datasets.
There will be a total of 4 mandatory worksheets to be solved, each worksheet with three weeks time. There will be two students per project group, and the evaluation is done both per group and individually.
In addition to the worksheets, there will be Q&A where the individual student should demonstrate and explain the solutions. We shall provide more details in the kick-off meeting.
Prerequisites: The project includes the tasks of database designing, user-defined functions, stored procedures, triggers, etc., along with Java application development. Hence, we expect an in-depth understanding of relational database systems, hands-on experience with advanced SQL queries, good Java programming skills, and knowledge of three-tier architectures and web-development.
News
02-Mar-2023 | Registration for the DB Project SoSe 2023 started. Registration deadline : 07-April-2023 16-April-2023. Please follow the registration process as given below.
|
Details about the Registration Process
- The number of participants is limited, and the registration is not on the first-come-first-serve.
- To register, download this json template registration file, rename it to {yourmatriculationnumber}.json, edit it to reflect your information and send it as attachment via email to Gajendra Doniparthi. Please use your offcial university email account @cs.uni-kl.de or @rhrk.uni-kl.de to register and for future project related communication.
- The registration deadline is 07th April 2023(Friday) and the results will be notified few days later.
- We shall announce a kick-off meeting date once registration completes. In the meeting, we shall form the groups, discuss organizational aspects, provide reference material for documentation, and introduce the development environment. Participation in this meeting is mandatory.