Unit 1: Introduction to Data Warehouse and Mining

On this page, you will find Most important and Mostly asked previous year questions in your b tech semester exam from unit 1 Introduction to Data Warehouse and Mining of the subject Data Warehouse and Mining. 


  1. What do you mean by data warehouse? Discuss its key features with suitable examples.
  2. Write the concept of building data warehouse.
  3. Briefly explain important approaches to build the data warehouse.
  4. Write and explain the components of data warehouse.
  5. Explain the various physical structure of data warehouse.
  6. What do you mean by parallelism? Write different types of database parallelism.
  7. Write a difference between data warehouse and operational database.
  8. Write a difference between OLTP and OLAP.
  9. Describe various schemas of multidimensional data models.
  10. Write a note on Shared-disk architecture, Distributed memory architecture and Shared-nothing architecture.
  11. Describe datacubes with suitable example.
  12. What is multidimensional data model ? How we convert tables and spreadsheets to data cubes? Convert 2D tables into 3D data cubes.
  13. What are the difference between the three main types of data warehouse usage: information processing , analytical processing and data mining? Briefly explain.
  14. Write a note on process architecture.
  15. Draw and explain 3-tier architecture of data warehouse model.
  16. Describe the concept of hierarchy.
  17. Describe the basic operations performed on data cube.
  18. What is data mart ? Explain its role in data warehousing.