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

Data wharehousing - Essay Example This is a concept of OLAP mainly used when it’s being related to data mining. This is possible through pre-aggregation, an aspect of relational databases in that they not only facilitate the creation of tables, but 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 two 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 pool of data, sets of useful and important data that may have been ignored, classifies the data in relation to the whole set and associates it to its class. This data a nalysis concept focuses mainly on dividing the existing data into small 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 definition associated with OLAP is that which describes it as 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. It’s amazing that some people even used the full name of the acronym as a definition, but this is entirely questionable since it does not give gist of what the concept is or what it refers to. The most com monly used definitions are listed below (Becker, 2002). First, there is what we can call the popular definition. It’s 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 true OLAP is used in spreadsheets to enhance the view of data, but it’s 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 processing as enhanced, friendly browsing of similar, multidimensional data. When a user prompts a query to the softw are, it may take up to less than a minute to give an output, hence its attribution as a fast 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,

Conflicts between perspectives and points of view Essay

Conflicts between perspectives and points of view - Essay Example I always wondered where I was doing the mistake when I studied so well. I used to tell my class fellows to stay awake at nights and study because I was of the point of view that night time allows one to concentrate on the study well. One friend of mine, Joe, always would disagree with me. This was the friend who used to get all straight A’s. I used to make fun of him when he used to tell me that he slept early at night and got a full eight hours sleep before going to college. I would tell him the advantages of studying at night and he would advise me to change my routine and see the difference. I was not ready to change my perspective yet I always wondered how come he was able to get the highest GPA in class when he slept so early until morning. In fact, my mother in her childhood used to study late night and I was following her. But, I should not blame her, as J.K. Rowling states in her article that she does not blame her parents for their point of view because a time comes when children should start making their own decisions rather than gettin g directed by the and then blaming them for wrong consequences. One morning, I failed in getting up for college as I had been studying all night and had fallen asleep just one hour before leaving for college. And that day I had to take a test. I was absent and I missed the test. I was so furious at myself but then again, Joe told me that I would have gotten up right in time if I had fallen asleep at time. That was when I decided to change my routine. I discussed this thing with Joe and he told me that there is a vital role of sleep time and schedule in the student’s academic outcomes. I also went into the library to do a research on this issue and found some journals in which the researchers had concluded that students getting at least eight hours of sleep each night will have higher GPAs than students who get less than eight hours of