How are OLTP and OLAP different? Give examples of their use.
What will be an ideal response?
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.
PTS: 1
Computer Science & Information Technology
You might also like to view...
A(n) ________ is a form inserted within another form and is frequently used for tables in a one-to-many relationship
Fill in the blank(s) with correct word
Computer Science & Information Technology
When you use the Freeze Panes option you freezing both columns and rows
Indicate whether the statement is true or false
Computer Science & Information Technology