BuyFindarrow_forward

Principles of Information Systems ...

12th Edition
Ralph Stair + 1 other
Publisher: Cengage Learning
ISBN: 9781285867168

Solutions

Chapter
Section
BuyFindarrow_forward

Principles of Information Systems ...

12th Edition
Ralph Stair + 1 other
Publisher: Cengage Learning
ISBN: 9781285867168
Chapter 5, Problem 16RQ
Textbook Problem
16 views

What is a data warehouse, and how is it different from a traditional database used to support OLTP?

Program Plan Intro

OLTP:

It is software processing in which everyday transactions become a part of the 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.

Explanation of Solution

Data Warehouse:

  • Data warehouse contains the collection of data that is used for decision making and business intelligence.
  • It is a unique kind of database, so it focuses on business intelligence, time variant data, and external data.
  • It is a subject-oriented, integrated, time-variant, and non-updateable data.

Differences of data warehouse from a traditional database:

Data warehouseTraditional database (OLTP)
It has large number of data and stores large data volumes...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 5 Solutions

Principles of Information Systems (MindTap Course List)
Show all chapter solutions
add
Ch. 5 - Multiple records can have the same primary key....Ch. 5 - A(n) ______ is a field or set of fields that...Ch. 5 - A(n) ___________ is a diagram of entities and...Ch. 5 - The ______ is a simple but highly useful way to...Ch. 5 - ______ involves eliminating columns in a table. a....Ch. 5 - Because the DBMS is responsible for providing...Ch. 5 - ______ is a special-purpose programming language...Ch. 5 - SQL databases conform to ACID properties that...Ch. 5 - A(n) _______ is a collection of instructions and...Ch. 5 - The _______ is a nontechnical, but important...Ch. 5 - A trend in database management, known as Database...Ch. 5 - _________ is a term used to describe data...Ch. 5 - An in-memory database (IMDB) is a database...Ch. 5 - A(n) ______ is a database that holds business...Ch. 5 - An information-analysis process that involves the...Ch. 5 - ______ allows users to explore data from a number...Ch. 5 - ______ is a form of data mining that combines...Ch. 5 - ___________ is a data visualization technique in...Ch. 5 - Identify all the components in the data hierarchy...Ch. 5 - What is the difference between a data attribute...Ch. 5 - What is the purpose of a primary key? What field...Ch. 5 - What is enterprise data modeling?Ch. 5 - What is an entity-relationship model and what is...Ch. 5 - What is data cleansing?Ch. 5 - What is SQL and how is it used?Ch. 5 - What are the essential differences between an SQL...Ch. 5 - What is database as a service (DaaS)? What are the...Ch. 5 - What is Hadoop?Ch. 5 - What is a schema, and how is it used?Ch. 5 - What is concurrency control? Why is it important?Ch. 5 - What is in-memory database processing, and what...Ch. 5 - What is the difference between projecting and...Ch. 5 - What is big data? Identify three characteristics...Ch. 5 - What is a data warehouse, and how is it different...Ch. 5 - What is meant by the front end and the back end of...Ch. 5 - What is the relationship between the Internet and...Ch. 5 - What is data mining? What is OLAP? How are they...Ch. 5 - What is business intelligence? Identify five...Ch. 5 - What is predictive analysis? Give an example where...Ch. 5 - When building a database, an organization must...Ch. 5 - Outline some specific steps an organization might...Ch. 5 - Briefly describe the ACID properties to which an...Ch. 5 - Briefly describe how a NoSQL database operates.Ch. 5 - Identify and briefly describe some of the...Ch. 5 - Identify and briefly describe the steps in the ETL...Ch. 5 - You are the vice president of information...Ch. 5 - What counterintelligence strategy might a large...Ch. 5 - Your luxury car dealership wants to identify...Ch. 5 - Make a list of the databases in which data about...Ch. 5 - If you were the database administrator for the...Ch. 5 - Identity theft, where people steal personal...Ch. 5 - You have been hired to set up a database for a...Ch. 5 - Develop a simple data model for the music you have...Ch. 5 - An online video movie rental store is using a...Ch. 5 - Using a graphics program, develop an...Ch. 5 - Use a Web search engine to find information on...Ch. 5 - Do research to find what career opportunities are...Ch. 5 - How could you use business intelligence (BI) to do...Ch. 5 - How did Medihelps use of a traditional database...Ch. 5 - How does Medihelps salesforce now use the...Ch. 5 - How did B.I. Practice improve the efficiency of...Ch. 5 - How does the new query system help Medihelp make...Ch. 5 - From the user side, Mr. Kim said that HanaTour...Ch. 5 - How does HanaTour use the data it collects from...Ch. 5 - HanaTour chose Wizbase as its implementation...Ch. 5 - Think of the data that your universitys database...Ch. 5 - What work is involved in merging multiple...Ch. 5 - Why do you think Altitude Online found it...Ch. 5 - In a major move such as this, what opportunities...Ch. 5 - Why do you think Altitude Online is beginning work...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What are the basic characteristics of a NoSQL database?

Database Systems: Design, Implementation, & Management

What is metadata?

Database Systems: Design, Implementation, & Management

Explain what is meant by direct current.

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What is a task? What is an event? What is a milestone?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Convert 5 megawatts of power into BTU/hr, ft-lbs/s, and kJ/hr.

Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)

Contemplating a Job Offer After graduating from college with a degree in computer science, you send your resume...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

Describe an ideal tack weld.

Welding: Principles and Applications (MindTap Course List)