… 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
July 12, 2010 By 9 Comments
… business intelligence. (this post) Identifying the differences between a data warehouse, and a data mart. Introduction to MDX queries and the kind of SQL… 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)
May 6, 2011 By 22 Comments
… 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…-350MB of data (23GB raw data, compressed to about 2GB total data. then spread over six servers). Due to ICE limitations, the data was…
Comment: Data mart or data warehouse?
December 16, 2010 By 13 Comments
…A normalized data warehouse schema might contain tables called items, categories and item_category. … large number of joins when many dimensions are involved. A data mart would collapse all of this information into an item dimension… single column? (Yes, I have exactly this problem in my data mart with SCD, and it requires some brutal joins). Your web…
