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