How are OLTP and OLAP different? Give examples of their use


On-line transaction processing (OLTP) involves large numbers of relatively simple day-to-day transactions. For example, this may involve order entry which collects data on customers and detail of sales.

On-line analytical processing (OLAP) involves large amounts of data used to analyze relationships, involving aggregate data that can be analyzed, compared, and dissected.

Business

You might also like to view...

Fixed compensation receives more emphasis in sales rep jobs with ________

A) a high ratio of selling to nonselling duties B) a high requirement for individual initiatives C) an intensive focus on selling activities D) very little need for teamwork E) technical complexities

Business

Simulations ______.

a. are an imitation of the real service b. can be a simple drawing on a piece of paper c. can reveal problems that may not have been obvious d. are only created through computer programs

Business

By generating accurate forecasts of demand, time-phased delivery schedules can be developed. This is the underlying idea behind the ______ system.

a. manufacturing resource planning (MRP) b. manufacturing resource planning (MRP II) c. enterprise resource planning (ERP) d. distribution requirements planning (DRP)

Business

Any individual director can act as an agent to bind the corporation.?

Indicate whether the statement is true or false

Business