(OR) b) Discuss star schema keys in detail. 14 a) Identify the classes of users who will use information, in detail. (OR) b) What are hyper cubes? How do they apply in an OLAP system? 15 a) Write notes on ( i ) Genetic algorithm ( ii ) Neural networks. (iii ) Drill-down and Roll-ups. (OR) b) List five common provisions to be found in a good security policy. Part C Answer any TWO questions: 2 x 20 = 40 16 a) Discuss the components of data ware house in its three major areas. b) Explain the 4 parallel server options. List the benefits, features and limitations of each. 17 a) What are hyper cubes? How do they apply in OLAP system? b) State any two underlying methods for information delivery to satisfy the requirements of all types of users. 18 a) Describe the physical design step activities. b) Determine the major activities during data warehouse deployment.
(OR) b) Discuss star schema keys in detail. 14 a) Identify the classes of users who will use information, in detail. (OR) b) What are hyper cubes? How do they apply in an OLAP system? 15 a) Write notes on ( i ) Genetic algorithm ( ii ) Neural networks. (iii ) Drill-down and Roll-ups. (OR) b) List five common provisions to be found in a good security policy. Part C Answer any TWO questions: 2 x 20 = 40 16 a) Discuss the components of data ware house in its three major areas. b) Explain the 4 parallel server options. List the benefits, features and limitations of each. 17 a) What are hyper cubes? How do they apply in OLAP system? b) State any two underlying methods for information delivery to satisfy the requirements of all types of users. 18 a) Describe the physical design step activities. b) Determine the major activities during data warehouse deployment.