Datawarehouse

OLAP OLAP stands for Online Analytical Processing. OLAP is a softw be tool used to interactively crease data stored in a date wargonhouse or a date mart in a fast, coherent and commensurate manner. OLAP data is stored in a 3-dimensional database mannequin which enables the user to charge different dimensions with columns and rows which produces easily noticeable trends and patterns this pot be considered as information while OLTP (online transactional processing) when used for querying lonesome(prenominal) produces atomic data. The need for OLAP arises from mart analysis and business challenges which invite query-centric database schemas that atomic number 18 naturally multi-dimensional and array-oriented (Berson & axerophthol; Smith, 1997) usually these business question require the retrieval of capacious number of records from large data sets and summarize them. The output of these queries qualification look similar to multidimensional spreadsheet. These operatio ns can be performed a relational database with an rise to power method much(prenominal) as SQL but they have numerous limitations in scathe of memory, speed, facilities etc. (Decisions, 2002) The questions answered by an OLAP system are business questions and conduct several dimensions for example in the fictitious character of MEGA SAVE, What is the disparity between the regions in terms of sale in the come through calendar calendar month?

Or how fast the products are pitch in each city in each month? Main Features of OLAP There are several usages associated with OLAP the following are the approximately common and beneficial features 1. applicationing: This feature of OLAP involves mean from one level of detai! l to another level; near OLAP tools provide an interface in which users can perform this working class by a single click. There are triplet types of drilling (Hammergren & Simon, 2009) Drill Down: means dislodge magnitude the level of detail for example pitiable from regions to counties Drill Up: is the opposite of drill down for example moving from eld to weeks Slicing and dicing: is a capability of OLAP which enables users...If you want to gravel a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay