Explain why we need different 'data models for transaction processing systems (operational data characteristics) and data warehouses (analytics data, or decision support data characteristics) Give examples of how data is different.

Explain why we need different 'data models for transaction processing systems (operational data characteristics) and data warehouses (analytics data, or decision support data characteristics) Give examples of how data is different.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 2WE

See similar textbooks

Related questions

Q: What is expert system and how data warehouse help to create an expert system?

A: Expert system An expert system is a computer system used for making decisions. These are used for…

Q: Provide use of examples to make a comparison and contrast between unstructured and structured data.…

A: Structured data are data that is highly organized, factual, and to-the-point. Unstructured data…

Q: Suppose you're promoting the data warehouse idea. What does multidimensional data analysis mean to…

A: An organization's decision-making is aided by a data warehouse, a vast collection of corporate data.…

Q: A data warehouse is a type of data management system that is designed to enable and support business…

A: Introduction : We have asked for how a data-ware house works.

Q: What is facilitated by data modelling?

A: Introduction: Data modelling makes it simpler for developers, data builders, business analysts, and…

Q: Assume you're pitching your users on the data warehouse concept. For them, how would you define…

A: Introduction: Multidimensional data analysis is a strategy in which, in response to management…

Q: Assume you're presenting the idea of a data warehouse to a group of potential customers. Which of…

A: Customer data warehouse: A customer data warehouse is a data warehouse created to assist your…

Q: Assume you're pitching your users on the data warehouse concept. For them, how would you…

A: Here is the answer:

Q: a. how is a database different from a data warehouse? b. How is data warehousing related to business…

A: As per guidelines we are suppose to answer first question Answer :- a. Database Database System is…

Q: Examine the people who could utilize your data warehouse. Can you categorize the users as casual,…

A: Data Warehouse: Using a data warehouse, users will be able to access large volumes of data quickly…

Q: There are some key differences between online transaction processing systems and business…

A: Actually, given the facts: There are critical differences between online transaction processing…

Q: How can data visualisation make use of the following five graphical data features in order to…

A: Introduction: Data visualization: It visually depicts ordered or unstructured data to show…

Q: Say, for example, that you're trying to get people to think about building a data warehouse. What is…

A: A data warehouse is a data management system that stores large amounts of data for later use in…

Q: data mining

A: Introduction of Data Mining Data Mining is defined as a process used to extract usable data from a…

Q: Find out which kind of data is more prevalent in a typical business environment by comparing and…

A: Structured data is well-organized and presented in relational databases to make it simple to locate.…

Q: Provide an example of a qualitative data analysis. The example should be within the healthcare…

A: answer is

Q: Can you take me through each step that is required to integrate data for a data warehouse?

A: Data Warehouse Integration: What is it? Data warehouse integration brings together information from…

Q: Unmistakable assertions are what are known as business norms, and they are developed through a…

A: A business rule is a clear expression of a company's policy, method, or concept. Business rules…

Q: Present an example where data mining is crucial to the success of a business. What data mining…

A: To assist firms make better business decisions, data mining is done to find patterns and links in…

Q: In what ways can using the same data model for both conceptual and logical design serve the designer…

A: Introduction: In addition to information acquired from business needs, logical ERD models them as…

Q: What is Expert system and how Data warehouse helps to create an Expert system ?

A: Expert system: Expert system are the computer applications developed to solve complex problems in a…

Q: Explain why we need different ‘data models’ for transaction processing systems (operational data…

A: NOTE :- Below i explain the answer in my own words by which you understand it well. Data…

Q: Using RDF and SPARQL, create a data model for a system (such as a company or institution) of your…

A: Answer

Q: - Compare the main similarities between industry (business, et cetera) data classification and US…

A: Data classification is the process of classifying data into distinct categories so that companies…

Q: How can data visualisation make use of the following five graphical data features in order to…

A: Data visualization is a graphic representation of organized or unstructured data that displays…

Q: Discuss three differences between the Pyramid and Funnel forms of

A: difference between pyramid and funnel form- pyramid…

Q: What types of meta-data are there that is relevant to the data warehouse design and who would…

A: Database Management System(DBMS) is a software for storing and retrieving users data while…

Q: What are the importance and usefulness of data modeling in the analysis phase. How do we know what…

A: Actually, importance and usefulness of data modeling in the analysis phase is given below:

Q: 3)How might Mercy benefit from an enterprise data model? Does Mercy’s move into big data make it…

A: Mercy: Mercy is the health care system which has 46 acute care and specialty hospitals and more…

Q: Explain how the three big data characteristics relate to the data acquired by healthcare providers,…

A: INtro Big Data: Big Data is a large amount of structured, semi-structured, or unstructured data…

Q: Assume you're pushing the concept of a data warehouse. To them, what does multidimensional data…

A: Introduction: A data warehouse, an extensive collection of company data, helps an organization make…

Q: Why is exploratory data analysis something that has to be done? It's possible that you're scratching…

A: Data scientists use exploratory data analysis (EDA) to explore and investigate data sets and define…

Q: Use examples to contrast unstructured and structured data. Which type is more common in a business…

A: Introduction: Unstructured Data: It is data or information that has no utility or logic. As a…

Q: unstructured and structured data

A: Unstructured vs Structured data: Comparison Chart Structured Data Unstructured Data Format…

Q: What other means of communication are there amongst people? Open a channel of communication. a…

Q: What is data visualisation, and how does it work? Give examples of various data visualisation…

A: To be determine: What is data visualisation, and how does it work? Give examples of various data…

Q: Data warehouses in health care are influenced by dominant power of a few large hospitals. V third…

A: The data warehouse is a repository of an organization's electronically stored data extracted from…

Q: Use examples to compare and contrast unstructured and structured data. Which type is more prevalent…

A: Data Type Images, audio, video , etc. Unstructured data Emails Unstructured data Tables in…

Q: Make use of examples to compare and contrast unstructured and structured data. Which kind is more…

A: The Answer

Q: Identify and then discuss two different data mining methodologies

A: Introduction: Various primary data mining approaches, including association, classification,…

Concept explainers

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.

Question

DO NOT COPY FROM OTHER WEBSITES

Write your own answer. Thank you!!!

Explain why we need different 'data models'
for transaction processing systems
(operational data characteristics) and data
warehouses (analytics data, or decision
support data characteristics).
Give examples of how data is different.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

please answer the question and not just list pros?

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Utilize relevant examples to compare and contrast unstructured and structured data in order to identify which kind of data is more prevalent in a typical business context.
There are some key differences between online transaction processing systems and business intelligence platforms. Using the example of a university student-focused data warehouse and how it varies from the university student records system, discuss two of these distinctions.
Suppose you're promoting the data warehouse idea. What does multidimensional data analysis mean to them? How would you characterize the advantages?
Define the term "data warehouse" and its role in data modeling. How does it support complex data analytics and reporting?
Make use of examples to compare and contrast unstructured and structured data. Which kind is more common in a typical company setting?
Explain the concept of data cubes in data warehousing. How are they used to facilitate multidimensional analysis, and what benefits do they offer for business decision-making?
Consider the impact of data integration tools on one's daily existence.
Provide use of examples to make a comparison and contrast between unstructured and structured data. Which of the following is more common in a typical company environment?
When it comes to data management, analysis and business methods can be looked at separately. How are these two groups alike and how are they different?
Explain why we need different ‘data models’ for transaction processing systems (operational data characteristics) and data warehouses (analytics data, or decision support data characteristics). Give examples of how data is different. please explain difference between these
To contrast unstructured and organized data, utilize examples. In a business setting, which kind is more prevalent?
Define a data warehouse and explain its purpose in the context of business intelligence.