Tying Together Olap, Datawarehouses, Datamarts, and 3-Tier ArchitectureEssay Preview: Tying Together Olap, Datawarehouses, Datamarts, and 3-Tier ArchitectureReport this essayWrite a short paper explaining OLAP, Data Warehouse and Data Mart, and Three-tier architecture.I read several articles before I completely understood what OLAP really meant. First, I found a definition that sounded fairly simple at this address on the web,
FAST means that the system is targeted to deliver most responses to users within about five seconds, with the simplest analyses taking no more than one second and very few taking more than 20 seconds.
ANALYSIS – targeted for the user, this analysis should be able to cope with the business logic, statistical analysis used in the application, and should be kept simple.
SHARED – All security requirements should be done by the system, even down to the cell level. Concurrent update locking, at an appropriate level, should be used if multiple write access is used.
MULTIDIMENSIONAL – this is the key requirement in the FASMI test. The system must provide a multidimensional conceptual view of the data, including full support for hierarchies and multiple hierarchies.
INFORMATION is all of the data and derived information needed, wherever it is and however much is relevant for the application.The FASMI test seems to be an understandable definition of the goals OLAP is meant to achieve.Data Warehouse and Data MartTo be competitive today, a business has to consolidate and aggregate data, so that they can leverage their information. They must take their data from production systems and place it in a centralized data warehouse or data mart for users to use. The can use that data for better customer service, do analysis for reporting or problem solving. Another reason to use Data Warehouses and Data Marts is for data mining. A Data Mart can be used at either end of the data mining process.