Analysis Of Multidimensional Data Using Various Methods

Analysis Of Multidimensional Data Using Various Methods Nikhil Deshmukh Abstract Data is exponentially increasing every year, business wants to analyze data more accurately and efficiently. Analyzing huge amounts of data is tedious tasks that involve considerable challenges, commitments and organizational expense. This paper provides an overview of different methods and tools to analyze data in the data warehouse. We will analyze the six dimensional data using both relational database and multidimensional method and compare the performance by calculation using actual data. Keywords- Data Warehouse; Analysis; OLAP; Relational; Multidimensional. Data warehouses contain data consolidated from several databases and are large in magnitude (sometimes in terabytes). Data warehouses are used mainly for decision ssupport applications and provide the summarized data than detailed, individual records for analyzing purpose. Some organizations are using data marts because data warehouse construction is a complicated process. Data marts contain information in the form of subsets for any specific department. On data warehouse and data marts, different data analytical methods can be used. In section II, two methods of data analysis is explained first is conventional query method or using simple SQL and second method is Multidimensional analysis and its different types. In the next section we have shown the incapability of conventional query method by taking the real world example and by comparing the performance of both on the basis of time taken to execute the operation and disk space used. A. Query and Reporting These are data query tools, this type of tool formulate stand alone query and after analyzing statically it gives result in the form of graphs. Such type of tools does not support multidimensional analysis and can execute only simple queries, they do not offer aggregation and consolidation concepts. These tools are optimum to generate request like How many number of articles do we have in the stock [1]. That is why these types of tools are called soft analysis tools. B. Multidimensional analysis In multidimensional database data is stored in the form of array table which allows fast visual representation of accumulated data. Sometimes it is necessary to model data multidimensional for complex analysis and visualization, especially in decision support system. Multidimensional view or structure can be considered as cubes, we can also call it cubes within cubes where each side of the cube is a dimension as shown in the fig (A) [4] To analyze multidimensional data OLAP (On-line analytical processing) is used. Types of OLAP are Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP), Hybrid OLAP (HOLAP) and Spatial OLAP (SOLAP). 1) OLAP: This type of server enables analysts to deep dive into performance through variety of view of the data. It shows multidimensional phase of the business data through different views. OLAP operations include Pivot (change of orientation of the multidimensional view), slice and dice (selection and projection), rollup (increasing or decreasing the aggregation level) along one or more dimensions. Conceptual model of OLAP stress on aggregation as one of the key operation e.g., computing the total production by each state (or by each month) and give the ranking accordingly. Some important characteristics of OLAP is summarization, projected data, fast interactive analysis, multidimensional view, Frequently changing business model and medium to large data sets. [2] 2) MOLAP: Multidimensional OLAP directly supports the multidimensional view of the data through storage engine. This provides very good indexing properties and speed but bad utilization of space, especially in case of sparse data; example is ESSBASE (ARBOR). [4][7] 3) ROLAP: Relational OLAP are the intermediate server sits between backend server and client. It supports multidimensional OLAP query on-the-fly. It utilizes transaction and scalability feature of relational system but mismatch between both queries can create performance issue. [4][6] 4) HOLAP: Combination of MOLAP and ROLAP is HOLAP. ROLAP server gives better performance when data is not very dense and performance of MOLAP improves when data is dense. Many vendors such as Speedware and Microsoft are thus using HOLAP, storing dense regions of the cube using MOLAP and storing the rest using a ROLAP approach [3]. 5) SOLAP: This is the category of OLAP which explores the data related to space (spatial data).SOLAP integrates concept from Geographic information system (GIS) and OLAP. It is a visual platform built especially to support fast and convenient temporal analysis and analysis of data following a multidimensional approach consist of different aggregations levels available in the form of graph and tabular display. [5] To illustrate we will take 6 dimensional business model of Beverage Company. The relational schema consists of a Fact table and one table per dimension. It contains one row for each Channel (6 members), Product (1500), Market (100), Time (17), Scenario (8) and Measures (50). A simple OLAP scenario in which we need to get the actual profit and compare with the budget.[8] A. Relational Approach The number of rows in fact table is = product of dimensions =122 million, with 80 % sparsity no of rows is 24 million. If we assume 4k block size total size id 17 GB including joins. To retrieve variance between actual and budget 6 ways joins and 17 I/O will be used which will take approximate 237 hours of I/O time. This process should be repeated for all the values, It is clearly impractical to do this with relational approach.[8] B. Multidimensional Approach We will use the same model with Multidimensional database such as ESSBASE. In the Beverage company example a block will consist of time*scenario*measure*8 bytes per cell = 55k with 80% sparsity block size will be 10 GB. 55k with 80% sparsity block size will be 10 GB.s C. Comparison Table -1: Performance comparison between relational and multidimensional approach [8] Relational approach Multidimensional approach Improvement in performance Disk Space (GB) 17 10.2 1.7 The calculation of variance (Hours) 237 2 110 After calculation on 6 dimensional business model using both the approaches it can be concluded that conventional relational data base approach takes more time and disk space than multidimensional approach. It is not feasible for relational approach where requirement is complex and many dimensions have been used because of the high operating cost of processing different joins and restriction across huge number of tables. In such cases multidimensional approach should be used, Query tools can only be used in case of simple database requirements. In this paper we also looked up at the different types of multidimensional analysis methods. References       M.-P. Nachouki, V. Lambert, R. Lehn, Data warehousing tools architecture: from multidimensional analysis to data mining, vol. 00, no. , pp. 636, 1997 Surajit Chaudhuri, Umeshwar Dayal, An overview of data warehousing and OLAP technology ACM SIGMOD Record: Volume 26 Issue 1, March 1997 Kaser, Owen, Lemire, Daniel, Attribute value recording for efficient Hybrid OLAP, Information Sciences, 2006, Volume 176, Issue 16 S. Chaudhuri; U. Dayal; V. Ganti, Database technology for decision support systems IEEE Year: 2001, Volume: 34, Issue: 12 Rosa Matias; Joao Moura-Pires Spatial On-Line Analytical Processing (SOLAP): A Tool the to Analyze the Emission of Pollutants in Industrial Installations portuguese conference on artificial intelligence 2005 Agrawal S. et.al. On the Computation of Multidimensional Aggregates Proc. of VLDB Conf., 1996. S. Sarawagi, User Adaptive Exploration of OLAP Data Cubes, Proc. VLDB Conf., Morgan Kaufmann, San Francisco, 2000, pp. 307-316. George Colliat, OLAP, relational, and multidimensional database systems,ACM SIGMOD Record: Volume 25 Issue 3, Sept. 1996

Essay --

From Poverty to Powerhouse: Michael Oher’s Story Michael Oher was from an all-black neighborhood located in the third poorest zip code in the country. By the time he was a sophomore, he’d been to 11 different schools, he couldn’t read or write, and he had a GPA of 0.6. In his first-grade year alone, he missed 41 days of school and ended up repeating both the first and the second grade; he didn’t even go to the third grade. Oher was one of the thousands of children that have been identified as having four or more of the at-risk factors mentioned by the National Center of Education and Statistics (NCES). According to the NCES, poverty and race are high on the list of things that negatively affect students’ ability to succeed at school. Other risk factors include changing schools multiple times and being held back from one or more grades. Oher’s biography, The Blind Side by Michael Lewis, proves how socioeconomic status impacts a child’s academic success because placed in perspective, educati on is not as important as the hardships of reality. Before explaining how The Blind Side depicted the effects of socioeconomic status on Michael Oher’s education, it is important to make clear what it means to â€Å"prove.† According to Oxford Dictionaries, â€Å"prove† means â€Å"to demonstrate one’s abilities or courage† (â€Å"Prove† 1.5). The Merriam Webster Dictionary gave other definitions including â€Å"to show that (someone or something) has a particular quality or ability (â€Å"Prove† 1); â€Å"to test the worth or quality of, specifically: to compare against a standard† (â€Å"Prove† 2b), and â€Å"to show oneself to be worthy or capable of† (â€Å"Prove† 4). All of the above definitions of â€Å"prove† have a form of the words â€Å"quality† or â€Å"ability† in them. An example of this is when... ...nomic status. In 2012, 26.5 million (13.7 percent) of people ages 18-64 were in poverty. Also in 2012, 16.1 million (21.8 percent) children under the age of 18 were in poverty. The hardships this creates causes education to suffer. It has to take a backseat to finding food or a place to sleep. These children’s families are at-risk for dropping out of school compared to higher socioeconomic students. That number is going to continue to grow with the current rate of population growth. In contrast, children from higher socioeconomic families do better in school. When the Tuohy’s brought Michael into their life, his opportunities for education improved. What happened to Michael Oher was unique because of his special abilities, his courage, and the help from the Toughy’s. Michael’s story shows how socioeconomics can impact students’ academic success. Appendix

Free Narrative Essays - Beauty is Only Skin Deep :: Personal Narrative Essays

Beauty is Only Skin Deep, Ugly Goes to the Bone I am not easily recognized, or rather, I am easily ignored. My style of dress is a cardigan and jeans, or when it's warmer, a T-shirt and jeans. Occasionally I'll wear khakis. I am a very unnoticeable 5'3'' and have eaten just enough chocolate to have a round face and figure. With all of this in mind, when I tapped the shoulder of the up-to-the-minute girl lip-locked with her boyfriend-of-the-day, I was not greeted with a warm smile. I frequently disturbed this couple, since my locker was in Make-Outville. It is interesting, however, that I am the first (technically third, I suppose) to find out what new couple has gotten together. As I was pondering why our lockers are neon orange when our school colors are red and black, I exaggerated the act of dropping each book into the metal box to enjoy the humor of the "you-only-wish-you-could-have-what-I-have" look from the heavily outlined eyes behind me. The irony is - I don't want that. No, I am not a nerd in denial; that is just not what I want. Exchanging saliva with a different guy every week and making sure I look just like Jennifer Love Hewitt or any other three-name girl is not my top priority. Sorry to disappoint you Miss "I can't believe I had to buy a size 3," but you're a little conceited to think everyone wants to be just like you. I'll tell you what I want: I want to go to college. I want to get good grades. I want everyone to be nice. I want a cure for Alzheimer's so my grandmother and my family can have Grandfather back. I want to get to my locker without being scrutinized. Oh my goodness, what an outcast I am. What a nerd! Whatever is the matter with me? I like boys. Simply because I choose to search for someone who makes me happy (and that just happens to take a while) does not automatically prove that I live an "alternate lifestyle." Sorry to disappoint you; I apologize for taking away today's lunchtime conversation. I will tell you what I want in a boy. I want him to open doors for me. Old-fashioned or not, I appreciate that greatly. I want him to be my best friend. I want to be able to go to him with anything and for him to care about what I say.

Building Community on the Net :: Internet Web Cyberspace Essays

Building Community on the Net All sorts of reasons have been advanced in recent years to explain the decline of community in America, from the way we design our neighborhoods to the increased mobility of the average American to such demographic shifts as the movement of women into the labor force. But the onslaught of television and other electronic technologies is usually cited as the main culprit. As Harvard sociologist Robert Putnam observes, these technologies are increasingly "privatizing our leisure time" and "undermining our connections with one another and with our communities."[1] In his essay "The Strange Disappearance of Civic America," Putnam draws a direct parallel between the arrival of television and the decline of what he calls "social capital" -- the social networks, trust, and norms of reciprocity that are the essence of healthy communities. As he points out, a "massive change in the way Americans spend their days and nights occurred precisely during the years of generational civic disengagement."[2] It follows that computers, VCRs, virtual reality and other technologies that, like television, "cocoon" us from our neighbors and communities exacerbate the loss of social capital. With the advent of computer networks and "virtual communities," however, some feel that electronic technologies can actually be used to strengthen the bonds of community and reverse America's declining social capital. Advocates stress that electronic networks can help citizens build organizations, provide local information, and develop bonds of civic life and conviviality. While the claims are no doubt overstated in many cases, as they always are when new technologies are involved, there is growing evidence that this may be the case, particularly in local community networks. The social and political ramifications of electronic networking has become a favorite topic of speculation in recent years. Cover stories, conferences, books, Web sites, and radio and television programs devoted to the subject have grown exponentially. In looking over the burgeoning literature on the political uses of the Net, I find that most of it falls into three general categories: 1) questions of democratic culture and practice, such as the pros and cons of direct democracy, issues of privacy and social control, and the changing nature of public opinion; 2) how on-line petitioning, electronic voting, information campaigning and other forms of "netactivism" can promote politics more narrowly defined; and 3) the implications of networking technologies for communities. This paper leaves aside the first two categories[3] and focuses specifically on the third: whether computer networks can be used to strengthen and enhance the bonds of community.

Atticus As A Model Parent :: essays research papers

In To Kill a Mockingbird, Harper Lee suggests that Atticus is a model parent. Atticus gives guidance to Jem and Scout, and he treats them with fairness and honesty. He tries to bring them up as best he can as a single parent. Atticus is always guiding Jem and Scout with advice so that they will become more compassionate people. Atticus sets a good example for the children when Mr Ewell confronts him. Even though he is provoked and insulted, Atticus simply has a â€Å"peaceful reaction†. This shows the children never to get into fights with people when they are upset about something. Atticus shows children about courage and all the forms it appears in. When Jem is told to read for Ms Dubose and she dies, Atticus explains to Jem about her morphine addiction, and how she died â€Å"free†. This shows Jem that courage isn’t always where you expect to find it, and that if you have some compassion, you see people for who they really are. The most important piece of advice he gives his children is that â€Å"you never really understand a person until you consider things from his point of view†¦ until you climb into his skin and walk around in it.† This is important for the childre n to know, because it helps them to be more caring people, and they use this advice throughout the novel. Atticus treats everyone with fairness. He always hears both sides of the story. He does this after Scout has gotten into a fight with Francis Hancock. After a time Atticus hears Scout’s side of the story and realises that it wasn’t totally Scout’s fault. Scout also tells Uncle Jack that when she and Jem get into fights Atticus stops to hear both sides of the argument before placing the blame, if any. When he is confronted by awkward issues Atticus never tries to hide or cover up the truth. He tells Uncle Jack at Finches landing that when a child asks you something, â€Å"answer him, for goodness sake.† After Atticus is confronted by the mob outside the county jail, he doesn’t try to pretend that they weren’t there to hurt him. He admits that Mr Cunningham might have â€Å"hurt me a little.† When Scout asks Atticus if they are poor, the usual response would be to say no, so as not to scare Scout.

Sugar Gradient Lab Report

Sugar Gradient Lab Procedure: 1. Get out 5 separate cups or beakers and fill them ? full with water in each. 2. Number each of the cups 1 through 5. And color accordingly with food dye: †¢Cup 1- 2 drops of yellow †¢Cup 2- 2 drops of red †¢Cup 3- 2 drops of green †¢Cup 4- 2 drops of yellow and 1 drop of red †¢Cup 5- 2 drops of blue 3. Add: †¢1 scoop of sugar in Cup 1 †¢2 scoops of sugar in Cup 2 †¢3 scoops of sugar in Cup 3 †¢4 scoops of sugar in Cup 4 †¢8 scoops of sugar in Cup 5 4.Mix each cup until the sugar is dissolved completely and the food dye in mixed in well. 5. Take a pipette and fill it with the substance in Cup 5. 6. Drop 10-20 drops down the side of the inside of a test tube (you may need to refill the pipette to accomplish this). 7. Rinse the pipette out in the sink. Flush the pipette out several times. 8. Take a pipette and fill it with the substance in Cup 4. 9. Drop 10-20 drops slowly down the side of the inside of th e same test tube. 0. Rinse the pipette out in the sink. Flush the pipette out several times. 11. Repeat steps 8-10 with Cups (IN THIS ORDER): 3,2, and 1. 12. Wait about 2 minutes for the water to settle. Discussion: The property used in the Sugar Gradient to create the solutions that did not mix and created layers was density. Aqueous solutions of sugar, water, and food coloring were used which means that the sugar and food coloring were mixed in the water and looked like part of the water.This is also a â€Å"homogeneous mixture† because it appeared the same throughout (both on the visual level and particle level). The reason the sugar particles could not be seen in the mixture was because the sugar broke down and got smaller. Also the reason the food coloring looked lighter after the sugar was mixed in was because the particle spread apart more. Overall, the lab was based on the density of the aqueous solution which depended on the amount of sugar dissolved in the water.

Why Winter Is Better Than Summer

Mr. ENG4U Due: The Winter Season is the Best Amongst Them All The winter season is the best season amongst the 4 that occur in Canada. The winter season has the most spirit, is the most comfortable, and is the safest health wise. The winter season has holidays that every kid impatiently waits for, and has outdoor pond hockey unlike any other season. Whereas in the summer you’re hot and dehydrated while mosquitoes attack you, and it harder to sleep when it’s hot compared to when it’s cold. No other season has the holiday spirit that is present in the winter.The winter has multiple holidays that everyone looks forward to, Halloween, Thanksgiving, Valentines Day, New Years Eve/Day, and the best of all Christmas. The smell of the ginger bread cookies that the mothers make is the traditional Christmas holiday scent. While the mothers are cooking the older sons are hanging the Christmas lights with their fathers. The mothers and daughters decorating the house and Chris tmas tree while the younger kids are writing up their Christmas wish lists to send to the North Pole.The little girls go out side to build some snowmen while the boys go play some shinny with their friends on the frozen pond. Whereas in the summer there is no pond hockey, no presents, and no holiday spirit. Only unpleasant things await ones presence in the summer. As the summer season comes around, it won’t wont have any presents, ginger bread cookies, frozen pond hockey, or a nice cool night of sleep waiting for you. The winter is the most comfortable and stress-free amongst all the seasons in Canada.When the kids are done building their snowman’s, or finished playing shinny with their friends on the frozen pond, they can go back inside and enjoy a nice hot chocolate (http://ghostlittle. blogspot. ca/2011/05/21-winter-is-better-than-summer. htmlby) the warmth of the roaring fire. In comparison the summer will only have bloodthirsty mosquitoes ready to attack, a scorch ing hot sun ready to dehydrate and burn, and a long hot sleepless night waiting for you.While one builds a snowman in the winter, one will have sand sticking to their burnt sweaty skin in the summer. While one is sitting by the warm fireplace with a hot chocolate in the winter, one will be struggling for cool air from the fan in the summer. When the day comes to an end in the winter, one can enjoy a good night of sleep in the warmth of their beds; where in the summer one truly detests the warmth of their bed, resulting with a long sleepless night.Winter being the most stress-free season for anybody is the reason why it’s the healthiest season. The winter season is the healthiest season for anybody. The increased comfort helps reduce stress, and the holiday spirit and more time spent with your family is another factor that contributes to making people in a more cheerful mood. The main reason why winter is the healthiest season amongst them all is because there are lower amount of sicknesses and diseases compared to the summer.Whereas in the summer one can suffer from dehydration, sun burn from the scorching hot sun, sunstroke, and a fever from when it rains (http://answers. yahoo. com/question/index? qid=20080930065312AAGlbMn) . The human body also can withstand cold temperatures better than it can handle hot temperatures, so the winter is more preferable for ones body. In the winter we never have to face any of these problem, instead one can enjoy the hot chocolate once again by the fireplace with their family members and friends.The winter season is the most enjoyable for one compared to the summer because it is the most comfortable, spirit filled, and the healthiest. Would one rather be suffering from all pain from the bloodthirsty mosquitoes and the red-hot sun? Or would they rather be snuggling with their lovers by the warm fireplace with a hot chocolate at hand? Works Cited http://answers. yahoo. com/question/index? qid=20080930065312AAGlbMn http:/ /ghostlittle. blogspot. ca/2011/05/21-winter-is-better-than-summer. html