Explore BrainMass

Explore BrainMass

    Differences between OLTP and OLAP Databases

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

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

    © BrainMass Inc. brainmass.com October 10, 2019, 5:01 am ad1c9bdddf


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

    Solution Summary

    The differences between OLTP and OLAP databases are examined.