(See related pages)
This chapter provides the foundation for an emerging form of databases, called data warehouses, being used increasingly for decision support. After this chapter, the student should have acquired the following knowledge and skills:
|
|
|
Explain conceptual differences between operational databases and data warehouses. |
|
|
|
Understand architectures to apply data warehouse technology in organizations. |
|
|
|
Understand the representation and manipulation of data cubes. |
|
|
|
Apply relational data modeling and manipulation for multidimensional data. |
|
|
|
Explain data quality issues and the role of extraction, transformation, and loading tools when maintaining a data warehouse. |
|
|
|
Gain insight about the complex process of refreshing a data warehouse. |