Textbook: Textbook information Data Mining: Concepts and Techniques (Required) Jiawei Han, Micheline Kamber, Jian Pei Morgan Kaufmann; 3rd Edition; 2011 ISBN-10: XXXXXXXXXX ISBN-13: XXXXXXXXXXPrint) |...

1 answer below »
quote .


Textbook: Textbook information Data Mining: Concepts and Techniques (Required) Jiawei Han, Micheline Kamber, Jian Pei Morgan Kaufmann; 3rd Edition; 2011 ISBN-10: 0123814790 ISBN-13: 978-0-12-381479-1 (Print)   |   978-0-12-381480-7 (eBook) Assignment: Please consider the following questions for the discussions in the 4 areas. Note that there are several questions in each area, and while I recommend that you read all of the posts made in each area, there is no need for each student to provide answers to all of the questions. The requirement is one quality post in each of the 4 areas. At least 150 words per area. Please study each topic and make a good answer for each topic. Area 1: Data Warehouse: Basic Concepts (graded) Class, Please consider the following questions for the discussions in this area. Note that there are several questions below, and while I recommend that you read all of the posts made in this area, there is no need for each student to provide answers to all of the questions. Do not only reply to my post, please consider replying also to your classmates. The requirement is one quality post in this area. - What is a data warehouse? - What are some of the differences between operational database systems and data warehouses? - What is the rationale of constructing a separate data warehouse, when online analytical processing could be performed directly on operational databases? - What is a metadata repository and what are some of the elements it should contain? Area 2: Data Warehouse Modeling (graded) Class, Please consider the following questions for the discussions in this area. Note that there are several questions below, and while I recommend that you read all of the posts made in this area, there is no need for each student to provide answers to all of the questions. Do not only reply to my post, please consider replying also to your classmates. The requirement is one quality post in this area. - What do we understand by “multidimensional data model”? What is a “data cube”? - Explain in your own words the following concepts and use an example to illustrate your explanations: snowflake schema, fact constellation, and star schema. - What is a data cube measure? Any examples? - Explain and provide an example of an OLAP operation for multidimensional data. Area 3: Data Warehouse Design and Usage (graded) Class, Please consider the following questions for the discussions in this area. Note that there are several questions below, and while I recommend that you read all of the posts made in this area, there is no need for each student to provide answers to all of the questions. Do not only reply to my post, please consider replying also to your classmates. The requirement is one quality post in this area. - Discuss the steps associated to the design of a data warehouse. - Compare the waterfall and the spiral methods as methodologies to develop a data warehouse. - Compare/contrast the three main types of data warehouse usage: information processing, analytical processing, and data mining. - Please discuss the following statement given on page 155 of our textbook: “among the many different paradigms and architectures of data mining systems, multidimensional data mining is particularly important”. Area 4: Data Generalization (graded) Class, Please consider the following questions for the discussions in this area. Note that there are several questions below, and while I recommend that you read all of the posts made in this area, there is no need for each student to provide answers to all of the questions. Do not only reply to my post, please consider replying also to your classmates. The requirement is one quality post in this area. - Please discuss data generalization and some of the concepts associated to it. - What is attribute-oriented induction? - What is it understood by the “curse of dimensionality”? - Is data cube technology sufficient to accomplish all kinds of concept description tasks for large data sets?
Answered Same DaySep 22, 2021

Answer To: Textbook: Textbook information Data Mining: Concepts and Techniques (Required) Jiawei Han, Micheline...

Neha answered on Sep 27 2021
147 Votes
What is a data warehouse?
A data warehouse is that place where we collect and manage all the data which is collected from different sources to gain meaningful insig
hts for business. The data warehouse is generally used to connect and analyse the data from different sources it behaves as the core of the business intelligence system which is built to analyse and report the data (Inmon, W.H).
It can be defined as a blend of component and technologies which helps to use the data strategically. It is electronic storage where we can store large amount of information and use it for query and analysis instead of processing the transaction. in this process we transform the data into information and provide it to the users to make a difference. The data warehouse can be maintained separately from the operational database of organization not a product it is an environment. We can define it as an architectural construct to manage the information system and it can provide the users for current and historical decision support information.
What do we understand by “multidimensional data model”? What is a “data cube”?
The multidimensional data model is used to store the data in the form of data cube. The data warehousing generally supports 2 dimensional or 3 dimensional cubes. A data cube allows the data to be viewed from different dimensions. A dimension can be defined as entity with respect to which an organization can store the records. For example, if we have sales record then the dimension can allow the store to keep a track of things like then sales of items on the monthly basis and the branches (Nguyen, T.B., Tjoa, A.M. and...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here