Chapter 12, Problem 7SG

Program Plan Intro

Transaction Processing System (TPS):

• TPS handles the everyday accounting needs of an organization.
  • TPS is also referred as data processing system or operational system.
  • To know the stock of a particular item, often the TPS is connected with the control systems of production and inventory.

Program Plan Intro

Online Transaction Processing (OLTP):

• OLTP is the program that is used for supporting transaction oriented applications over the internet.
• It is helps in retail sales, Customer Relationship Management (CRM), financial transactions and order entries.
• It includes three steps. They are:
  • Collecting the input data
  • Processing the data
  • Updating the existing data
• The performance of OLTP includes clusters, discrete transactions, rollback segments, database tuning, buffer cache size and many others.