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
You might also like to view...
What value is assigned to decTaxes by the following program segment, assuming that the user enters 50000 into the textbox txtSalary.Text?
Dim decSalary, decTaxes As Decimal decSalary = CDec (txtSalary.Text) If (decSalary > 50000) Then decTaxes = .40 * decSalary ElseIf (decSalary > 40000) Then decTaxes = .30 * decSalary ElseIf (decSalary > 30000) Then decTaxes = .20 * decSalary Else decTaxes = .10 * decSalary End If a. 20000 b. 15000 c. 10000 d. 5000
Specialized information systems include a wide range of artificial intelligence systems that can simulate ____ intelligence processes.
Fill in the blank(s) with the appropriate word(s).
________ testing refers to how many mistakes did users make
A) Emotional response B) Accuracy C) Recall D) Performance
The ________ displays across the top of the program window, grouping commands and features in the manner in which they would most logically be used
Fill in the blank(s) with correct word