OLAP Architecture

OLAP Architecture (continued)

• Designed to use both operational and data warehouse data

• Defined as an “advanced data analysis environment that supports decision making, business modeling, and an operation’s research activities”

• In most implementations, data warehouse and OLAP are interrelated and complementary environments

Comments

Popular posts from this blog

Suppose that a data warehouse consists of the four dimensions; date, spectator, location, and game, and the two measures, count and charge, where charge is the fee that a spectator pays when watching a game on a given date. Spectators may be students, adults, or seniors, with each category having its own charge rate. a) Draw a star schema diagram for the data b) Starting with the base cuboid [date; spectator; location; game], what specific OLAP operations should perform in order to list the total charge paid by student spectators at GM Place in 2004?

Explain Parallel Efficiency of MapReduce.

Short Note on Security Architecture of E-governance