









Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Detail Summery about Data Warehouse Security, SECURITY, User Access Hierarchy , Backup and Recovery, Testing the data warehouse, References .
Typology: Study notes
1 / 16
This page cannot be seen from the preview
Don't miss anything!
November 25, 2014 Data Mining: Concepts and 1
November 25, 2014 Data Mining: Concepts and 2
November 25, 2014 Data Mining: Concepts and Techniques 4 User Access Hierarchy Detailed Sales data Detailed Customer Data Summariz ed sales data Reference Data Administrators Senior Analyst Administer Administer Sales Marketing Data Warehouse Inc. Analyst Analyst Analyst Analyst Analyst Analyst Analyst
November 25, 2014 Data Mining: Concepts and 5
November 25, 2014 Data Mining: Concepts and 7
November 25, 2014 Data Mining: Concepts and 8
November 25, 2014 Data Mining: Concepts and 10 Tuning the Data Warehouse Tuning the data warehouse deal with the measures such as Average query response times scan rates I/O throughput rates Time used per query (fixed or ad-hoc) No. of users in the group Whether they use adhoc queries frequently or occasionally at unknown intervals or at regular or predictable times The average / maximum size of query they tend to run The peak time of daily usage The more unpredictable the load, the larger the queries, or the greater the number of users the bigger the tuning task. Memory usage per process
November 25, 2014 Data Mining: Concepts and 11 Testing the data warehouse (^) Three levels of testing Unit testing : each development unit is tested on its own Integration testing : the separate development units that make up a component of DWH application are tested to ensure that they work together. System Testing :the whole DWH application is tested together. The components are tested to ensure that they work properly together, that they don’t cause system bottlenecks. (^) Developing the Test Plan Test Schedule – metrics for estimating the amount of time required for testing Data Load How will the data be generated? Where will the data be generated? How will the generated data be loaded? Will the data be correctly skewed?
November 25, 2014 Data Mining: Concepts and 13
November 25, 2014 Data Mining: Concepts and 14 Chapter 3: Data Warehousing and OLAP Technology: An Overview
November 25, 2014 Data Mining: Concepts and 16