Purchase Solution

Differences between OLTP and OLAP Databases

Not what you're looking for?

Ask Custom Question

? Define and describe the differences between OLTP and OLAP databases.
o What are the characteristics of each that make them different?
o What types of businesses would use an OLTP database?
o What kinds of companies would use an OLAP database?
? Describe the differences between a data mart and data warehouse.
o Is it possible that one company may set up a data warehouse that a different company may call a data mart? Support your answer.

Purchase this Solution

Solution Summary

The differences between OLTP and OLAP databases are examined.

Solution Preview

Complete the following:
• Define and describe the differences between OLTP and OLAP databases.

Operational databases (OLTP): these database mainly for hosting a large amount of customer data, personal data, inventory data is called operation or production database or subject area database (SADB) or transaction databases. The data can be manipulated (update, deleted, insert) depending on the day to day business requirements.
It allows transaction-related applications and provides real time access to data will constantly being updated.
OLAP which stands for Online Analytical Processing refers to a process where it provides answers to simple to complicated analytical queries that are multi-dimensional in nature that business needs to get answers. ...

Purchase this Solution

Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

C++ Operators

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

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

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.