OLAP versus data warehousing (1 Viewer)

[saleemMSMS]

whats the difference between this 2 terms ?
i.e OLAP versus data warehousing ??

c'mon this is not home work so i'm specially saying this to "some people" who usually make "idiotic" comments when they cannot find answers...

i'm just curious thats why asked.. so if u know, please share.. thanx

 

[georgedwilkinson]

I assume you just want general discussion on this since just about anybody can do a quick google and get more than we could possibly type here.


Data warehousing is this whole nebulous field of managing decision support data. OLAP is a sub-category of data warehousing. In my mind, OLAP is the sibling to OLTP which is where normalization is so important.

Does that help? I'm sure other people have opinions and helpful insights.

 

[dportas]

A Data Warehouse is a database that is subject-oriented (rather than designed to service an application), time-variant, integrated (presents a single consistent view of the enterprise) and non-volatile. Data Warehouses are a central component of most Business Intelligence solutions.

OLAP is a type of technology also used in Business Intelligence, frequently in conjunction with a Data Warehouse.