Chapter 6 Designing conventional data warehouses Copyright 2008

  • Slides: 14
Download presentation
Chapter 6 Designing conventional data warehouses Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi

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 &

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

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

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

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

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

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

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

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

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

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 ©

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 ©

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 ©

Fig. 6. 13. Steps in the analysis/source-driven approach for conventional data warehouses Copyright © 2008 Elzbieta Malinowski & Esteban Zimányi 14