oltp
Online Transaction Processing (OLTP) systems represent "classic" database applications, where the emphasis is placed on relatively short, reading and mainly writing operations ("transactions"). Data timeliness, correctness, and consistency play an important role; so do degree of parallelism and response time.

OLTP systems are an important component of our competence portfolio. The projects we have contributed to in this context come from various domains, such as cost settlement systems, planning tools, or steering programs (CRM, Supply Chain Management), etc. Independently of their background, these projects had a series of common characteristics, whereby the most important ones are:
  • OLTP systems must cope with large numbers of users, many of them working simultaneously on the database.

  • The main load on the database is caused by many relatively short transactions.

  • In the design of an OLTP system, the emphasis is placed on normalization, relations between tables, efficient joins (often FK-PK), usage of indexes, etc.

  • The database must guarantee short response times for targeted queries and DML operations. For this purpose, the execution plans for queries/DML operations must be optimal; nested loops are often used therein.

  • Many OLTP system are highly available databases, and require as such special high-availability constructs, like stand-by instances/data guards, etc.

  • Data correctness, consistency, and timeliness have a crucial importance in OLTP systems; they must be guaranteed even across database or hardware crashes (no transaction may get lost, unfinished transactions must be rolled back, etc.

  • . . .