What is online analytical processing system

Assignment Help Computer Engineering

Reference no: EM133074

Question

We've been focusing on operational databases, often called online transaction processing (OLTP) systems. These OLTP systems handle the day-to-day business of the company and are accessed by multiple users simultaneously updating data in short transactions.

Business intelligence systems are sometimes called online analytical processing (OLAP) systems. These OLAP systems are used to create decisions and are characterized by few users submitting long running queries that do not update database to analyze the historic data of the company. What is some other dissimilarity between OLTP and OLAP systems? How are data warehouses alike or different from these two database models?

Reference no: EM133074

Questions Cloud

Write down a program to solve linear system : Write down a program to solve linear system

Explain how attitudes can be acquired by social learning : Define Attitude Explain how attitudes can be acquired by social learning Describe the characteristics of sources and audiences of persuasive messages that influence attitude change

How to use ms access and create a database : How to use MS Access and create a database

How to figure out possibly stacks, queues and trees : How to figure out possibly stacks, queues and trees

What is online analytical processing system : What is online analytical processing system

Execute the boolean functions : Execute the Boolean functions

Problem on bubble sort algorithm : Problem on Bubble sort algorithm

Write down a user-defined function : Write down a user-defined function

Critically explain the four goals of social work practice : Critically explain the four goals of social work practice as laid down by the National Association of Social Workers.

User Account

All Pages