Operational Data: Data quality is one of the key features of enterprise data management. The data obtained from the operational system is low quality data because of the following reasons: Obtaining the data from outside the organization. Redundant storage of data and inconsistent metadata. Problems while entering data due to poor interfaces, manual mistypes of data. The poor quality of the data is not recognized by the organization itself is an issue. Data warehouse: Data warehouse contains the collection of data that are 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.

Question

Want to see the full answer?

Answer 1

Question

Chapter 13, Problem 7RQ

Program Plan Intro

Operational Data:

Data quality is one of the key features of enterprise data management.

The data obtained from the operational system is low quality data because of the following reasons:

Obtaining the data from outside the organization.

Redundant storage of data and inconsistent metadata.

Problems while entering data due to poor interfaces, manual mistypes of data.

The poor quality of the data is not recognized by the organization itself is an issue.

Data warehouse:

Data warehouse contains the collection of data that are 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.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Give three examples of likely problems when operational data is integrated into a data warehouse.While working as a database analyst for a national sales organization,you are asked to be a part of its data warehouse project team.

QUESTION 5 While working as a database analyst for a national sales organization, you are asked to be part of its data warehouse project team. a) Your data warehousing project group is debating whether to create a prototype of a data warehouse before its implementation. The project group members are especially concerned about the need to acquire some data warehousing skills before implementing the enterprise- wide data warehouse. What would you recommend? Explain your recommendations. b) Suppose you are selling the data warehouse idea to your users. How would you define multidimensional data analysis for them? How would you explain its advantages to them? c) Explain how online transaction processing (OLTP) systems differ from data warehousing systems.

Normalization is an important concept for database professionals. Whether you are the designer, database analyst or administrator, it is useful for designing, situation verification as well as performance tuning. What are the basic issues to be aware of before carrying out the normalization process?