OLAP, Data Marts and Warehouses, Three-Tier Architecture and ASP :: essays research papers

WEEK 4 INDIVIDUAL PAPEROLAP, DATA MARTS AND WAREHOUSES, THREE-TIER ARCHITECTURE AND ASPDBM405OLAP, Data Marts and Wargonhouses, Three-Tier architecture and ASPOLAPThe term OLAP stands for On-Line Analytical Processing. OLAP is a engineering science used to process info a high performance take for analysis and sh bed in a multidimensional cube of information. The cay thing that both OLAP products squander in common is multidimensionality, but that is non the only requirement for an OLAP product. An OLAP application is targeted to deliver most rejoinders to users within somewhat five seconds, with the simplest analyses taking no more than one second and very few taking more than 20 seconds. Impatient users often move into that a process has failed if results are non received with 30 seconds, and they are apt to implement the 3 finger salute or aggrandisement+Ctrl+Delete unless the system warns them that the report will take longer. Even if they have been warned that it w ill take significantly longer, users are likely to get deflect and lose their chain of thought, so the quality of analysis suffers. This speed is not easy to achieve with tremendous amounts of data, particularly if on-the-fly and ad hoc calculations are required. A wide variety of techniques are used to achieve this goal, including specialized forms of data storage, extensive pre-calculations and specific hardware requirements, but a lot of products are yet fully optimized, so we expect this to be an area of ontogenesis technology. In particular, the SAP Business Warehouse is a full pre-calculation set out that fails as the databases simply get too. Likewise, doing everything on-the-fly is much too slow with large databases, even if the most expensive server is used. Slow query response is consistently the most often-cited technical problem with OLAP products.OLAP is used for mainly for analysis. This gist that the system copes with any business logic and statistical analysis th at is germane(predicate) for the application and the user, and keep it easy enough for the target user. This analysis is through in the applications own engine or in a linked external product such as a spreadsheet. All the required analysis functionality can be provided in an a priori manner for the target users. This could include specific features like time serial publication analysis, cost allocations, currency translation, goal seeking, ad hoc multidimensional structural changes, non-procedural modeling, expulsion alerting, data mining and other application dependent features. The OLAP system implements all the security requirements for confidentiality.