Types of Data Processing
2 Primary Types of Processing
- Online transactional processing (OLTP)
- A class of software that allows large numbers of database transactions in real time, typically over the Internet
- database transaction
- statements of one or more DML commands that perform a change or update to record(s)
- any change to data in a system, whether it’s an insertion, deletion, or query
- e.g., using ATM
- Online analytical processing (OLAP)
- A class of software that allows complex analysis to be conducted on large databases without negatively affecting transactional systems
- allows a high volume of data to be analyzed more effectively
- meant to handle multi-dimensional analysis at high speeds