Chapter 6 Designing conventional data warehouses Copyright 2008
- Slides: 14
Chapter 6 Designing conventional data warehouses Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 1
Fig. 6. 1. Phases in data warehouse design Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 2
Fig. 6. 2. Steps in requirements specification in the analysis-driven approach Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 3
Fig. 6. 3. Steps in requirements specification in the source-driven approach Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 4
Fig. 6. 4. Excerpt from the ER schema for the underlying operational database in the example Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 5
Fig. 6. 5. Multidimensional schema for analysis of publications Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 6
Fig. 6. 6. Multidimensional schema for analysis of conferences Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 7
Fig. 6. 7. Multidimensional schema for analysis of projects Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 8
Fig. 6. 8. A data mart schema obtained by merging the schemas shown in Figs. 6. 5, 6. 6, and 6. 7 Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 9
Fig. 6. 9. Multidimensional schema derived from the ER schema of Fig. 6. 4 Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 10
Fig. 6. 10. Steps in conceptual design in the analysis/source-driven approach Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 11
Fig. 6. 11. Steps in the analysis-driven approach for conventional data warehouses Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 12
Fig. 6. 12. Steps in the source-driven approach for conventional data warehouses Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 13
Fig. 6. 13. Steps in the analysis/source-driven approach for conventional data warehouses Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 14
- Data warehouses generalize and consolidate data in
- Ch 13 database
- Explain the three tier architecture of data warehouse
- Introduction to databases and data warehouses
- Udp to data warehouses
- 2008 2008
- Copyright 2008
- Copyright 2008
- Copyright 2008
- Copyright 2008
- 2008 pearson prentice hall inc
- Copyright 2008
- Copyright 2008
- Sekai technology
- A newly formed business that is usually small