data integrity
-
OLTP, OLAP, and ETLDB/RDB 2019. 9. 11. 14:28
1. Overview 1.1 On-line Transaction Processing (OLTP) OLTP stands for On-line Transaction Processing. OLTP based systems (account, ticket booking, banking systems, money transfer system) are used to perform a large number of short transactions. Almost all of the database queries in OLTP system consist of commands insert, update, delete. Select queries are mainly designed to enable users to selec..