June 18, 2013

Post: Data mart or data warehouse?

… historical data warehouse, but they also build data marts for OLAP analysis from the warehouse data. A different approach is to build a relational warehouse from multiple data marts, or the so-called bottom-up approach to data warehousing…

Post: Intro to OLAP

…In multidimensional analysis samples representing a particular measure are compared or broken down into different dimensions. For example, in a …the difference between data marts and data warehouses. The former are usually used for OLAP analysis, but they can be fundamentally related to a warehouse.

Post: Shard-Query turbo charges Infobright community edition (ICE)

… common OLAP/DW data model, since it typically represents a data mart. See also: “Data mart or data warehouse?”. As it is the most common data model, it is… use common query features like BETWEEN or IN. It is also possible to spread your data over multiple machines, scaling out to…