Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
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)...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
What are the primary differences between OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) databases, and when should each be used?
What role does OLAP (Online Analytical Processing) play in data warehousing, and how does it differ from OLTP (Online Transaction Processing)?
What are OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) databases, and how do they differ in terms of their data modeling and usage?
Chapter 1 Solutions
Database Concepts (8th Edition)
Ch. 1 - Prob. 1.1RQCh. 1 - Prob. 1.2RQCh. 1 - Prob. 1.3RQCh. 1 - Why is the study of database technology important?Ch. 1 - Prob. 1.5RQCh. 1 - Describe the purpose of a database.Ch. 1 - Prob. 1.7RQCh. 1 - Prob. 1.8RQCh. 1 - Prob. 1.9RQCh. 1 - Prob. 1.10RQ
Ch. 1 - Break the list in Figure 1-34 into two tables,...Ch. 1 - Show how the tables you created for question 1.11...Ch. 1 - Prob. 1.13RQCh. 1 - Prob. 1.14RQCh. 1 - Break the list in Figure 1-35 into tables, each...Ch. 1 - Describe in your own words and illustrate with...Ch. 1 - Prob. 1.18RQCh. 1 - Define the term database.Ch. 1 - Prob. 1.20RQCh. 1 - List the components of a database.Ch. 1 - Prob. 1.22RQCh. 1 - Prob. 1.23RQCh. 1 - Prob. 1.24RQCh. 1 - What is the purpose of a DBMS?Ch. 1 - List the specific functions of a DBMS.Ch. 1 - Define the term referential integrity constraint....Ch. 1 - Prob. 1.28RQCh. 1 - List the functions of a database application.Ch. 1 - Prob. 1.30RQCh. 1 - Prob. 1.31RQCh. 1 - Prob. 1.32RQCh. 1 - Prob. 1.33RQCh. 1 - Prob. 1.34RQCh. 1 - Prob. 1.35RQCh. 1 - Prob. 1.36RQCh. 1 - Prob. 1.37ECh. 1 - Prob. 1.38ECh. 1 - Prob. 1.39E
Knowledge Booster
Similar questions
- How are the entities described in the information world?arrow_forwardWhat exactly is online analytical processing (OLAP), and how might it be put to use?arrow_forwardCompare and contrast OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) databases in terms of their design, usage, and typical applications.arrow_forward
- What are OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing), and how do they fit into a data warehousing environment?arrow_forwardSystems that handle online transaction processing (OLTP) are compared and contrasted with systems that handle data warehousing. The abbreviation for "online transaction processing" is "OLTP." In addition, could you kindly describe some of the most significant benefits and cons associated with using a data warehouse?arrow_forwardWhat exactly is an expert system, and how can a data warehouse assist in its development?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning