Business - Online transaction processing (OLTP)

Card Puncher Data Processing


Online transaction processing (or OLTP) refers to a class of application that support a business transaction process.


  • Databases (SAP, Oracle, SQL) supporting Online Transaction Processing


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

Discover More
(Business) Process (BP) - Procedure

A business process is anatural process (ie versus machine process) where activities are performed in a organisation. Example business process : raw materials purchasing orders shipments invoicing...
Data System Architecture
(Data|State|Operand) Management and Processing

This section is and state management as opposed to code. System that manages data are called database. In a computer, there is two kinds of byte instruction byte and data byte. This section is...
Oltp Dwh
Data Warehousing - Contrasting OLTP and Data Warehousing Environments

One major difference between the types of system is that data warehouses are not usually in third normal form (3NF), a type of data normalization common in Online Transaction Processing (OLTP) environments....
Star Schema
Dimensional Data Modeling - Degenerate Dimension of Fact dimension (i.e. event/header entity)

In a dimensional model, you may find a dimension table: with a cardinality (distinct value is higher than 10,000). cardinality which has a many-to-one relationship with the fact table close to a one-to-one...
Card Puncher Data Processing
I/O - Workload (Access Pattern)

Each server has unique workload characteristics. However there are some basic pattern that we can found in the storage demands. Although storage system workloads differ quantitatively in terms of the:...
Relational Algebra Between Sql And Query Plan
Nested Loop - Operations Involved

A NESTED LOOPS operation joins two data sources. It indicates that an index is available for use during the join. As a row operation, NESTED LOOPS returns each row to the next operation as it is processed...
Data System Architecture
Online Analytical Processing (Olap)

Online Analytical Processing (OLAP) refers to: a class of application an approach to quickly answer multi-dimensional analytical queries. The term OLAP was created as a slight modification of...
Parallel Linearly Scalable Operation
Oracle Database - Parallel Operations

The fundamental difference and advantage of Oracle's capabilities, however, is that parallel data access and therefore the necessary data redistribution are not constrained by any given hardware architecture...
Data System Architecture
Relational Data Modeling - Aggregate Table (Summary Table)

An Aggregate table is a persistence unit of aggregate data. Aggregate tables are also known as summary table (from summary) materialized view A aggregate is a table that contains the result of a query...
Data System Architecture
Relational Data Modeling - Denormalization

Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique. Denormalization should...

Share this page:
Follow us:
Task Runner