DATABASE CONCEPTS+MYITLAB
DATABASE CONCEPTS+MYITLAB
18th Edition
ISBN: 9780134821245
Author: KROENKE
Publisher: PEARSON C
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)...

Expert Solution & Answer
Check Mark

Want to see the full answer?

Check out a sample textbook solution
Blurred answer
Previous
Chapter 1, Problem 1.33RQ
Next
Chapter 1, Problem 1.35RQ
Students have asked these similar questions
Dijkstra's Algorithm (part 1).  Consider the network shown below, and Dijkstra’s link-state algorithm. Here, we are interested in computing the least cost path from node E (note: the start node here is E) to all other nodes using Dijkstra's algorithm. Using the algorithm statement used in the textbook and its visual representation, complete the "Step 0" row in the table below showing the link state algorithm’s execution by matching the table entries (i), (ii), (iii), and (iv) with their values.  Write down your final [correct] answer, as you‘ll need it for the next question.
4. |z + 5 - 5i| = 7
14. dz, C: |z❘ C: |z❘ = 0.6 ze² - 2iz H

Chapter 1 Solutions

DATABASE CONCEPTS+MYITLAB

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
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
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
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
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
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
SEE MORE TEXTBOOKS