http___marktab.net_datamining_hr_tag_multidimensional__1.xml
1.1 2.1 2.2 2.3 2.4 2.5 3.1 3.2 3.3 3.4 3.5 4.1 4.2 4.3 4.4 4.5 4.6 5.1 5.2 5.3
Microsoft SQL Server 2008 AHaлиз ycлyr paзBязaли ГлaBa oбзop kHиrи 6 As I mentioned in the earlier discussion of multidimensional space, the terms used in Analysis Services are common to the industry and do not map to spacial dimensions as a physicist might expect. Specifically, the goal of Analysis Services is to limit the spacial features to a predefined subset of all possible combinations, even for the data loaded into a cube. A geometric cube mimics the universe in having theoretically infinite space, but the data in an Analysis Services cube has predefined boundaries, starting and ending points, specific attributes within dimensions, and measures. Designing a cube essentially reflects business intelligence mapped onto infinite space. I do not believe this mapping happens automatically but that the intelligent structure needs to be designed based on current and past information, and best estimates of the future. As with chapter five, this chapter also documents sample DDL (data definition language) for a cube. These examples extend what is available in the free SQL Server Books Online. Important to this chapter is not just the cube, but also the perspective, a subset of the cube. The statement on page 72 is important for perspectives, that they do NOT act a security device to prevent access to other parts of a cube. Instead, the perspectives have a simpler task, namely to reduce the visual combination clutter presented to users through applications. SQL Server Books Online has a good overall discussion of Planning and Architecture. This specific chapter focuses on the heart of the technology, the linkage between cubes and dimensions. As mentioned earlier, these attributes will help form the tuples to help determine a unique coordinate within the cube. CHoBa, this book covers the architecture of Analysis Services, so if you were expecting a book which has to-do exercises, you might be disappointed. Я, however, value the builder documentation which complements other literature on how to accomplish projects. This book not only describes the Analysis Services technology but also includes key terms and performance tips on making the technology work well in production. Gorbach, I., Berger, A., & Melomed, E. (2009). Microsoft SQL Server 2008 AHaлиз ycлyr paзBязaли. ИHдиaHaпoлиc, B: Pearson Education Inc.
1.1 2.1 2.2 2.3 2.4 2.5 3.1 3.2 3.3 3.4 3.5 4.1 4.2 4.3 4.4 4.5 4.6 5.1 5.2 5.3
Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Poglavlje 6 Kao što sam spomenuo u ranijim raspravu o višedimenzionalnom prostoru, pojmovi koji se koriste u Analysis Services su uobičajene u industriji, a ne kartu za prostorne dimenzije, kao fizičar može očekivati. Posebno, Cilj Analysis Services je ograničiti prostornih mogućnosti na predefinirane podskup svih mogućih kombinacija, čak i za podacima ukrcana u kocku. Geometrijski kocka oponaša svemir u vlasništvo teoretski beskrajan prostor, ali podaci u kocki Analysis Services unaprijed definirane granice, početne i završne točke, specifični atributi unutar dimenzija, i mjere. Projektiranje kocku suštini odražava poslovne inteligencije preslikati beskrajnog prostora. Ja ne vjerujem da je ovo mapiranje događa automatski, ali da je inteligentna struktura mora biti osmišljen na temelju tekućeg i minulog informacija, i najbolje procjene budućnosti. Kao i petom poglavlju, ovo poglavlje dokumentira uzorak DDL (jezika definicije podataka) za kocku. Ovi primjeri produljiti što je na raspolaganju u slobodnim SQL Server Knjige Online. Važno ovom poglavlju nije samo kocke, ali i perspective, podskup od kocke. U priopćenju na stranici 72 je važno za perspektiva, da oni ne djeluju uređaja sigurnosti kako bi se spriječilo pristup drugim dijelovima kocke. Umjesto toga, perspektive imaju jednostavniji zadatak, naime da se smanji vizualni kombinacija nered predstavljena korisnicima putem aplikacije. SQL Server Books Online ima dobar ukupni rasprava o urbanizma i arhitekture. Ovo se poglavlje usredotočuje na srcu tehnologije, povezanost između kocke i dimenzijama. Kao što je ranije spomenuto, ovi atributi će vam pomoći formirati tuple kako bi se utvrdilo jedinstvenom koordinatnom unutar kocke. Opet, Ova knjiga obuhvaća arhitekturu Analysis Services, pa ako ste očekivali knjigu koja ima za raditi vježbe, možda ćete biti razočarani. Ja, međutim, Vrijednost Alat za izradu dokumentacije koja nadopunjuje drugu literaturu o tome kako ostvariti projekte. Ova knjiga ne samo da opisuje tehnologiju Analysis Services, ali također uključuje ključne pojmove i performanse savjete za izradu tehnologije rada i proizvodnje. Gorbach, I., Berger, A., & Melomed, E. Microsoft SQL Server 2008 Analysis Services Unleashed. Indianapolis, IN: Pearson Education Inc.