Business - Online transaction processing (OLTP)
About
Online transaction processing (or OLTP) refers to a class of application that support a business transaction process.
Articles Related
Example
Model
The data model that supports this process are called entity-relationship model (ER)
IO pattern
I/O - Workload (Access Pattern)
Typically 2KB – 16KB request sizes;
Read modify, write, verify operations resulting in 2 reads for every write;
Primarily random accesses.
Large number of concurrent requests.
When running SQL statements in parallel, Database will perform typically large random I/Os.
Documentation / Reference