Compare and contrast online transaction processing with online analytical processing.© BrainMass Inc. brainmass.com June 4, 2020, 12:25 am ad1c9bdddf
See the attached file.
Compare and contrast online transaction processing with online analytical processing.
Online transaction processing also known as OLTP in short form is a system that allows transactions to take place usually by means of querying in a sophisticated fashion. Sophisticated fashion means that the queries are entered using application interface to interact with the underlying database. Transactions that take place are based mostly on simple queries. Usually OLTPs are customer oriented and the database design and architecture is based on the ER (Entity Relationship) models. Data that is used in fulfilling transactions is usually product based and in a current state. Processing in OLTP depends on the type of industry that uses ...
This solution discusses comparison between online transaction processing and online analytical processing.