A transaction is a sequence of operations (actions), which transfers a database from a consistent state into another eventually changed consistent state, applying the ACID properties. Naturally, transactions are at the heart of everyday data-driven applications where business logic and users expect consistency in the face of concurrent operations. Transactions are behind e-commerce, collaborative online document editing, and many others.

In this course we study:

  • Basic and Advanced Transaction Models
  • Fundamentals of Transaction Management
  • Recovery
  • Distributed Transactions
  • Replication

By the end of this course you will have sufficient understanding to work with (and improve) data applications in charge of transaction processing. You will also have a great background for tackling engineering research in this field.

Course Image Credit: Getty Images/iStockphoto

In this course, attendee's soft skills are strengthened and applied on a small project in the field of databases, modern hardware, and AI applications in data management. These soft skills include apart from the project completion:

  • Team management
  • Project and time management
  • Presentation of intermediate results

The projects are handled by teams of 3-6 persons.

Each of the related projects consists of two parts: a theoretical and a practical part. The first, theoretical part consists of a literature review of existing approaches of each project topic. The approaches identified have to be worked in a structured format (eg, classification, evaluation, etc.) and the results must be written as a final report in the form of a scientific paper (8-10 pages). The written report must meet the requirements of a scientific publication and will be evaluated afterwards. The second, practical part consists of a relevant topic for the project implementation. During the complete project, each team will also hold 3 intermediate presentations (aka. milestones, each taking 10 minutes) in which the current progress of the project is presented. These presentations will take place at predetermined times. The conclusion of the project also provides a presentation (15 minutes) and delivery of the written report.

Hint: A big part of the course has to be performed as autonomous work - either alone, or in the team. Thus, all attendees should plan one day per week (8-10 hours) to work on the project.