Explore BrainMass

Explore BrainMass

    Online Transaction & Online Analytical Processing

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Compare and contrast online transaction processing with online analytical processing.

    452 words.

    © BrainMass Inc. brainmass.com March 4, 2021, 10:45 pm ad1c9bdddf

    Solution Preview


    Please find below my response to your homework.

    Thank you for using BrainMass.

    Your OTA

    Online transaction processing (OLTP) are database applications that are used to facilitate and manage transaction-related information which are used in the daily business operations. It is also known as operational processing. It allows real-time processing of retail processes, e-commerce and other time-sensitive data. With online transaction processing, many users perform transactions together that change real-time data. Individual users may request only few records but these requests are being made simultaneously. The main concerns of the OLTP are atomicity and concurrency (msdn.microsoft.com).

    Most industries use the OLTP for most of their data entry and retrieval transactions. Among these industries are banking, manufacturers, airlines, mail order and supermarkets. They ...