Data architecture concepts and patterns
To support the data-driven use cases, architecture concepts and patterns have evolved over the years to solve specific problems. Let’s review them together, and later, we will discuss SAP data management capabilities in this context.
OLTP, OLAP, HTAP
The terms online transaction processing (OLTP) and online analytical processing (OLAP) look similar but refer to two different kinds of data systems. An OLTP system captures and manages transactions in a database, in the form of insertion, updating, and deletion of data frequently. Tables in an OLTP database are usually normalized, and data integrity must be taken care of in case of any transaction failure. In comparison, OLAP’s main operation is to extract multidimensional data for analytics, which has less frequent transactions but requires a longer time to process data as data needs to be denormalized and joined together by running complex queries to turn data into information...