Q1. Describe the system development life cycle in the Data warehouse environment. How it is distinct from the classical SDLC?
Q2. Illustrate the problems related with the naturally evolving architecture?
Q3. Examine the concept which metadata is similar to a nerve center. Explain how the concept applies to the data warehouse atmosphere.
Q4. How is the different kind of models applied to the architected atmosphere?
Q5. In data warehouse technology, a multiple dimensional view can be implemented through a relational database technique (ROLAP) or by a multidimensional database method (MOLAP) or by a hybrid data method (HOLAP).
a) In brief explain each implementation method.
b) For each method, describe how each of the given functions might be implemented:
i) The generation of a data warehouse (comprising aggregation)
ii) Roll-up
iii) Drill-down
iv) Incremental updating
Which implementation methods do you prefer and explain why?