54 Using your knowledge of the college environment identify

54. Using your knowledge of the college environment, identify three transactions that might be handled by online transaction processing (OLTP) systems.

55. Using your knowledge of the college environment, identify three questions to answer using online analytical processing (OLAP) software.

Solution

54. Online transaction processing, or OLTP, is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). It is a class of information systems that facilitate and manage transaction-oriented applications.

Three examples will be,

a) online banking.

b) online reservations.

c) ATM machine transactions etc