Database Concepts (8th Edition)
Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter 1, Problem 1.34RQ

Explanation of Solution

Online Transaction Processing (OLTP):

  • It is software processing in which everyday transactions become part of a company’s database.
  • The current production data is maintained for a company by using OLTP.
  • OLTP is used in business such as banks, airlines, and merchants.

Online analytical processing (OLAP):

  • It is software processing that provides analysis for data stored in the data warehouses.
  • It is used for analysis of data by the company.
  • Data for analysis are generally stored in data warehouses that can be used for data mining – extraction of data for knowledge.
  • OLAP is an example of Business Intelligence (BI) systems.

Business Intelligence (BI) System:

  • BI systems are tools used to examine or inspect and prepare reports and dashboards on all the company’s structured or unstructured data present in the data warehouse.
  • It is used for querying and reporting of business data.
  • An efficient BI can be gained through the implementation of the Customer Relationship Management (CRM)...

Blurred answer
Students have asked these similar questions
Compare and contrast OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) databases in terms of their design, usage, and typical applications.
What exactly is meant by the term "online analytical processing" (OLAP), and how is it used in practise?
What, precisely, does a person who manages databases do? How should he define his roles and responsibilities?
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning