Active Server Pages (ASP), On Line Analytical Processing (OLAP), data warehouses, and data marts are all part of a three tier architecture. The three tier architecture is used to analyze and extract data from databases. This process makes uses databases more efficient and allows for the data to be analyzed in a strategic manner.
OLAP is an acronym for On Line Analytical Processing. OLAP is used to provide answers to queries in a multidimensional database. OLAP provides rapid execution of queries and does this by treating each data attribute as a dimension.
OLAP uses MDX (MultiDimensional Expressions) to access and define multidimensional data (Hernandez, 2006). MDX is a similar scripting language to SQL but it is used for retrieving data from multidimensional objects.
A Data warehouse is a repository of integrated information, available for queries and analysis (Wikipedia, 2006). The data stored in the data warehouse may have come from many different sources, but by......
Join Now or Login to view the rest of this paper.
Approximate Word Count: 1326
Approximate Pages: 6 (260 words per double-spaced page) |