This flashcard is just one of a free flashcard set. See all flashcards!
6
Online Analytical Processing (OLAP)
• Supports multidimensional data analysis
–Viewing data using multiple dimensions
–Each aspect of information (product, pricing, cost, region, time period) is different dimension
–Example: How many washers sold in the East in June compared with other regions?
• OLAP enables rapid, online answers to ad hoc queries
Practical:
OLAP supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions. Each aspect of information— product, pricing, cost, region, or time period—represents a different dimension. OLAP enables users to obtain online answers to ad hoc questions such as these in a fairly rapid amount of time, even when the data are stored in very large databases, such as sales figures for multiple years
–Viewing data using multiple dimensions
–Each aspect of information (product, pricing, cost, region, time period) is different dimension
–Example: How many washers sold in the East in June compared with other regions?
• OLAP enables rapid, online answers to ad hoc queries
Practical:
OLAP supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions. Each aspect of information— product, pricing, cost, region, or time period—represents a different dimension. OLAP enables users to obtain online answers to ad hoc questions such as these in a fairly rapid amount of time, even when the data are stored in very large databases, such as sales figures for multiple years
