Data wharehousing Essay Example | Topics and Well Written Essays - 2500 words

Data whargonhousing - Essay ExampleThis is a concept of OLAP in the first place used when its macrocosm related to data mining. This is possible through pre-aggregation, an aspect of relativeal databases in that they not only urge on the creation of tables, however also can manipulate them together with the data they contain. Pre-aggregation in connection with OLAP basically explains how factual information, in this sense data that has been collected can be used to come up with probability estimations used for distribution (Kozielski & Wrembel, 2009). Data mining is a concept that has been confused with OLAP for a while. These ii terms, though different have been used synonymously to refer to the other. However, these are two similar but different terms when viewed critically. Data mining is a data knowledge discovery mechanism that aims at identifying, from a family of data, influences of useful and important data that may have been ignored, classifies the data in relation t o the whole set and associates it to its class. This data analysis concept focuses mainly on dividing the existing data into vitiated manageable sets, as regards their relationship. On the other hand, OLAP focuses on addition of more data to a pool that is already in existence. This is made possible since OLAP gives data a multi-dimensional approach, creating summaries in different dimensions that are then added up to the original data, making it more comprehensive A general rendering associated with OLAP is that which describes it as computer software put in place to create a platform in which the user interacts easily with a complex database accessed online and is able to prompt the database for a service which n return provides a report in a form understandable to him/her. However, there are many other definitions attached to this concept. Its frightening that approximately people even used the full name of the acronym as a definition, but this is solo questionable since i t does not give gist of what the concept is or what it refers to. The most commonly used definitions are listed below (Becker, 2002). First, there is what we can call the popular definition. Its a precise and interesting definition of OLAP as set of many spreadsheets in a package. This is just but a typical meaning, mainly used to people who have little or no knowledge in information technology. Its truthful OLAP is used in spreadsheets to enhance the view of data, but its certainly not a set or group of spreadsheets. Secondly, OLAP has been popularly defined as a report given or presented with some extra information attached to it. This is adopted from the way OLAP works, by presenting data from different dimensions with diverse interpretations. In this case, OLAP allows the database users to scan through different perspectives of an issue. Lastly, there is the technical definition attached to OLAP. It describes on-line analytical process as enhanced, friendly browsing of similar, multidimensional data. When a user prompts a query to the software, it may earn up to less than a minute to give an output, hence its attribution as a lush software. It also does this in levels with a set of new data for each level. MegaSave uses data marts, tools used in presenting data and facts in multi-dimensions. The best definition, therefore, for such a scenario is the last one. This is so because so far,