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.

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

View More Free Quizzes
Related BrainMass Solutions

  • Databases for Business Intelligence

    OLAP, Available at: http://datawarehouse4u.info/OLTP-vs-OLAP.html This essay talks about the differences and similarities between Online Analytic Processing System and Online Transaction Processing System.

  • Online Transaction Processing and Online Analytical Processi

    Key differences: OLTP uses real-time or current data; OLAP uses historical data OLTP is for transactions; OLAP is for analytics and patterns identification OLTP is customer oriented; OLAP is managers or analysts oriented OLTP is for assisting with

  • Data WareHousing and Data Mining

    Often designed as OLAP (On-Line Analytical Processing) systems, these databases contain read-only data that can be queried and analysed far more efficiently as compared to your regular OLTP application databases.

  • Data Warehousing

    Often designed as OLAP (On-Line Analytical Processing) systems, these databases contain read-only data that can be queried and analysed far more efficiently as compared to your regular OLTP application databases.

  • OLAP versus RDBMS

    Studies show that the Multidimensional database (OLAP): - Uses almost half the disk space of what Relational database requires for the same task, - Retrieves data between 8 and 200 times faster, and - Calculates the derived data at least 2 orders

  • Online Transaction & Online Analytical Processing

    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.

  • difference between ROLAP and MOLAP

    36554 difference between ROLAP and MOLAP What is the difference between ROLAP and MOLAP. Which is perferred? Why?

  • Discussing Databases and the Advantages of Wireless Networks for Businesses

    Application databases are OLTP (On-Line Transaction Processing) systems where every transaction has to be recorded and that too at a fast speed.

  • Data Mining

    117359 Data Mining Differentiate between the following terms: A. Independent data mart and dependant data mart B. Fact table and dimension table C. OLTP and OLAP Chapter 7 1. Differentiate between the following terms: A.

View More Related Solutions