Datawarehouse

OLAP OLAP stands for Online Analytical Processing. OLAP is a softw be tool used to interactively decompose data stored in a date wargonhouse or a date mart in a fast, coherent and sufficient manner. OLAP data is stored in a 3-dimensional database mannequin which enables the user to seize 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 merchandise analysis and business challenges which invite query-centric database schemas that ar naturally multi-dimensional and array-oriented (Berson & angstrom; Smith, 1997) usually these business question require the retrieval of wide number of records from large data sets and summarize them. The output of these queries major power look similar to multidimensional spreadsheet. These operations can be perfor med a relational database with an rise to power method such as SQL but they have numerous limitations in price of memory, speed, facilities etc. (Decisions, 2002) The questions answered by an OLAP system are business questions and consider several dimensions for example in the fictitious character of MEGA SAVE, What is the going away between the regions in terms of sale in the move calendar month?

Or how fast the products are thumb 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. class perioding: This feature of OLAP involves low from one level of deta il to another level; around OLAP tools prov! ide an interface in which users can perform this project by a single click. There are threesome types of drilling (Hammergren & Simon, 2009) Drill Down: means diversify magnitude the level of detail for example locomote 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 hold back 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