Analyze three tiers of data warehouse architecture

Assignment Help Database Management System

Reference no: EM131704544

Assignment: Data Mining and Data Warehousing

Question 1

Compare the following with the help of examples.

(a) Star schema and snowflake schema
(b) Data cleaning and data transformation?
(c) Enterprise warehouse, data mart,and virtual warehouse
(d) OLAP and OLTP

Question 2

a) Explain three tiers of data warehouse architecture.
b) Which methods are used for efficient computations of data cubes.
c) Which algorithm is most appropriate to computeclosed iceberg cubes efficiently?

Question 3

Consider the database containing transaction data as stated in the table below. Use Apriori algorithm to find frequent itemsets where minimum support is 50%.

Transactions	Item Set
I₁	A,B,C
I₂	A,C
I₃	A,D
I₄	B,E,F

Question 4

Discuss candidate generation in Generalized Sequential Pattern (GSP) with the help of an example.

Text Book: Data Mining: Concepts and Techniques by Jiawei Han, Micheline Kamber and Jian Pei, Third Edition.

Reference no: EM131704544

Questions Cloud

How is the carrying amount of the bonds affected by error : Nast incorrectly used the straight-line method instead of the effective-interest method to amortize the discount. How is the carrying amount of bonds affected

Law number for the madatory child abuse reporting : What is the law number for the "Madatory Child Abuse reporting".

Identify the various types of entities : Identify the various types of entities that constitute governmental organizations, and describe the characteristics of other organizations.

Why are these firms not perfectly competitive : Firms like Walmart, Target, and Kmart are often given as examples of competitors. Ironically, these firms are not what an economist would define as perfectly.

Analyze three tiers of data warehouse architecture : Analyze three tiers of data warehouse architecture. Which methods are used for efficient computations of data cubes.

Structuralists and dependency theorists with the conclusions : Please contraste the ideas of Prebisch, Frank, Reinert and various structuralists and dependency theorists with the conclusions of the Schumpeter/Romer.

Detect fraudulent credit card transactions : What type of data analysis technique is used to detect fraudulent credit card transactions?

Arguments from the course readings : Use a model, and extend your discussion beyond the model in line with other arguments from the course readings.

What is the net accounts receivable balance : Write off the defaulted $6,000 balance, What is the net accounts receivable balance at the end of the year after the adjustments have been made

User Account

All Pages