Purchase Solution

Online Transaction Processing and Online Analytical Processi

Not what you're looking for?

Ask Custom Question

Compare and contrast online transaction processing with online analytical processing.

Purchase this Solution

Solution Summary

This solution discusses comparison between online transaction processing and online analytical processing.

Solution Preview

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 ...

Purchase this Solution


Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.