Data Analysis and OLAP Online Analytical Processing (OLAP) Interactive analysis of data,allowing data to be summarized and viewed in different ways in an online fashion(with negligible delay) Data that can be modeled as dimension attributes and measure attributes are called multidimensional data. Measure attributes measure some value can be aggregated upon e.g.the attribute number of the sales relation Dimension attributes define the dimensions on which measure attributes (or aggregates thereof)are viewed e.g.the attributes item name,color,and size of the sales relation Database System Concepts-5th Edition,Aug 26,2005 18.5 @Silberschatz,Korth and SudarshanDatabase System Concepts - 5 18.5 ©Silberschatz, Korth and Sudarshan th Edition, Aug 26, 2005 Data Analysis and OLAP Online Analytical Processing (OLAP) Interactive analysis of data, allowing data to be summarized and viewed in different ways in an online fashion (with negligible delay) Data that can be modeled as dimension attributes and measure attributes are called multidimensional data. Measure attributes  measure some value  can be aggregated upon  e.g. the attribute number of the sales relation Dimension attributes  define the dimensions on which measure attributes (or aggregates thereof) are viewed  e.g. the attributes item_name, color, and size of the sales relation