Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically _______________.

A) the end result of BI processes and operations.
B) a repository of actionable intelligence obtained from a data mart.
C) a distinct system that provides storage for data that will be made use of in analysis.
D) an integral subsystem of an online analytical processing (OLAP) system

Question

17-04-2020
Computers and Technology

contestada

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically _______________.

A) the end result of BI processes and operations.
B) a repository of actionable intelligence obtained from a data mart.
C) a distinct system that provides storage for data that will be made use of in analysis.
D) an integral subsystem of an online analytical processing (OLAP) system

Respuesta :

Otras preguntas

After the delegates to the philadelphia convention drafted the constitution, they sent it to the

When only constitutional amendments are on the ballot in texas, __________ percent of registered voters turn out to vote?

Using the numbers 8, 6, 4, and 2 write an expression that equals 7. ( You can not change the order of the numbers and you can only use: parentheses, divided by,

The individual whose name is associated with a natural experiment during an outbreak of cholera in london was

A fossil of a whole prehistoric insect would most likely be found ____. A. Encased in amber B. Frozen in a glacier C. In a mold in sedimentary rock D. In a c

What principle of government presented by the U.S. Constitution is Montesquieu describing? Use this quote by the French Enlightenment thinker Baron de Montesqiu

Select the word that best completes the first sentence. El __________ era muy grande. Nos baÃ±amos e hicimos piragÃ¼ismo por varias horas. selva volcÃ¡n lago mo

At which temperature will water boil when the external pressure is 31 kpa

Lewis company has $25,000 in retained earnings, $40,000 in assets, and $11,000 in liabilities. how much is in common stock?

To make 5 apple pies, you need about 2 pounds of apples. How many pounds of apples do you need to make 20 apple pies? Ratio Table: 5 _ 20

ACCESS MORE

monica789412 monica789412 · Answer 1 · 2020-04-24T18:14:44+02:00

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically a distinct system that provides storage for data that will be made use of in analysis.

Explanation:

OLTP (Online Transactional Processing) is a category of data processing that is focused on transaction-oriented tasks. OLTP typically involves inserting, updating, and/or deleting small amounts of data in a database.
OLTP is an online database modifying system. OLAP is an online database query management system.
OLTP uses traditional DBMS. OLAP uses the data warehouse
OLTP mainly deals with large numbers of transactions by a large number of users
OLTP database systems are commonly used for order entry, financial transactions, customer relationship management and retail sales via the Internet.
Online Analytical Processing tools enable to analyze multidimensional data interactively from multiple perspectives.