Page 99 - DCAP208_Management Support Systems

Management Support Systems

Notes Multidimensional Analysis: It is the ability to manipulate information by a variety of relevant
categories or “dimensions” to facilitate analysis and understanding of the underlying data.
OLAP Tools: It is a set of software products that attempt to facilitate multidimensional analysis.

6.8 Review Questions

1. Explain the concept of data warehousing.
2. Discuss the characteristics of data warehouse.
3. Discuss the use of data mart and operational data store.
4. Analyze the differences between operational databases and data warehouses.

5. Elucidate the major components of a data warehousing process.
6. Describe the Architecture of Data Warehouse.
7. Discuss the steps included in Two-Layer Architecture of data warehouse.

8. Discuss the factors that are to be considered when choosing one of the architectures of data
warehouse.
9. Illustrate the steps included in the development of data warehouse.

10. Discuss the security issues involved in data warehousing.
Answers: Self Assessment

1. Data warehouse 2. Staging Area
3. Star Schema 4. ETL (Extract, Transform and Load)
5. Data repository 6. Single-layer
7. Primary 8. Data marts

9. Independent 10. Data Acquisition
11. Documentation 12. Testing
13. Transition 14. Data warehouse administrator (DWA)
15. Decision-making

6.9 Further Readings

Books Daniel Power, 2002, Decision Support Systems: Concepts and Resources for Managers,
Greenwood Publishing Group
Efraim Turban, 1995, Decision Support and Expert Systems: Management Support
Systems, Prentice Hall
Harry Katzan, 1984, Management Support Systems, Van Nostrand Reinhold
Company

K. Sarukesi, 2004, Decision Support Systems, PHI Learning Pvt. Ltd.

92 LOVELY PROFESSIONAL UNIVERSITY