esbes

esbes hii eka bahuayami databases vyavasthapan pranali (emm. dii. bii. emm. ess.) aahe jee vishleshanatmak anuprayog tayar karnyasathi eka vyaspeeth pradan karate. esbesachi suruvat arber softwareche utpadan mhanoon jhaali, jeey 1998 madhye hyperian softwaremadhye villin jhaale. oracle corporation 2007 madhye hyperian solutions corporation vikat ghetale. 2005 chya uttaradhaparyant ibmne esbesachi om aavrutti aavrutti olap server mhanoon dekhil vikali.
databases sanshodhak eae. eff. kodane shvetpatrakat 'online vishleshanatmak prakriya' (olyap) haah shabd tayar keela
jyane vishleshanatmak pranalinsathi baaraa niyam nishchit kele (sambandhatmak model paribhashit paribhashit tyachya purvichya prasiddha baaraa niyamanchya sanchacha eka sanket). computervorldne prakashit kelele heey shwetpatra, esbes vaishishtyanchya sandarbhat kahise spasht hote aanee jevha nantar heey aadhalale qee coded heey arbor softwaredware prayojit kele gele hote, tevha computervorldne pepper mage ghetala.
online vyavhar prakriya" (oo. ell. tii. pii.) chya ulat, olap vyavharanaivaji manvi prashnanvar prakriya karnyasathi anukool databases tantradnyan paribhashit karate. yaa abhimukhatache parinam asey hote qee bahuayami databases tyanchya kamgirichya aavashyaktanvar aar. dii. bii. emm. ess. (vyavhar prakriya kamgiri parishad (tii. pii. see.)) peksha bhinn mapdandanchya sanchavar (vishleshanatmak kamgiri benchmark, aii. pii. bii.-1) kendrit hote.
2005 madhye hyperionne tyachya anek utpadananche punarnamkaran kele, jyamule esbesla hyperian pranali 9 buy + vishleshanatmak sevanche adhikrut naav midale, parantu naveen navakade vyavsayikanni mothya pramanat durlaksh kele. esbes brand nantar vipanan uddeshansathi adhikrut utpadanachya navavar parat karnyat aala, parantu server softwarene oraclechya business intelligence foundation suut (bii. aay. eff. ess.) utpadanat samavisht hoiparyant "vishleshanatmak seva" heey shirshak dharan kele.
august 2005 madhye, 'information aij' masikane netscape, blackberry, gugal, virtualization, voice over ip (voip), linux, xml, pentium processor aanee aii. dii. ess. ell. saha mageel 10 varshatil 10 sarvat prabhavshali tantradnyan navkalpananpaiki eka mhanoon esbesache naav dile. sampadak kennie massiver mhanaleh "hyperian esbes heey bahu-aayami databases tantradnyan hote jeey online vishleshanatmak prakriya vyavasay guptachar nakashavar thevate. yamule anek pratispardhi olap utpadane aanee kotyavadhi olap cubes tayar honyas chalana midali aahe.
itihas aanee prerana.
kamal 1-2-3 aanee microsoft axel yasarkhya spreadsheetshee sambandhit scalability samasyanche nirakaran karnyasathi esbes moolatah vikasit karnyat aala hota. kharey tarr, paytant covering (aata kalbahya jhalele) esbes asha pranalichi garaj spasht karnyasathi preranadayi udaharan mhanoon spreadsheetcha vapar karate.
yaa sandarbhat, 'bahu-aayami' mhanje spreadsheet swarupat aarthik mahitiche pratinidhitva karane. eka vishisht spreadsheet stambh shirshakansah veleche antar aanee pankti shirshakanvar khatyanchi nave pradarshit karoo shakate. udaharanarth,
udaharanarth, jarr ekhadya vaparkartyala pradeshanusar hii moolye vibhajit karayachi asateel, tarr yamadhye samanyatah yaa taktachi anek spreadsheetwar nakkal samavisht asateh
yaa sanrachanechya paryayi pratinidhitvasathi trimiteey spreadsheet greedchi aavashyakta asel, jyamule 'vel', 'khaate' aanee 'pradesh' hii parimane aahet yaa kalpanela janm milel. pranalimadhye pudhil parimane jodali jaat asalyane, bahu-aayami mulyanche yogya pratinidhitva karnari spreadsheet rakhane khoop katheen hote. esbes sarkhya bahuayami databases, kiman sankalpanatmakdrushtya, bahuayami "hypercube" madhye astitvat asalelya mulyansathi deta stoar pradan karatat.
sparcity.
parimananchi sankhya aanee aakar jasjasa vadhat jaato, tasatase bahuayami detabesachya vikaskanna detachya bhautik pratinidhitvat tantrik samasyanna adhikadhik samore jaave lagate. samaja vareel udaharan "grahak" aanee "utpadan" pariman jodanyasathi vistarit kele gele hoteh
jarr bahuayami databasene pratyek sambhavya mulyasathi sathavanukichi jaaga aarakshit kelee asel, tarr tyala 2,400,000,000 (4 × 4 × 3 × 10,000 × 5,000) peshi sathvavya lagtil. jarr software pratyek selala 64-biit floating point moolya mhanoon mapp karat asel, tarr heey sumare 17.9 gb (agadi 19.2 gb) chya memarichya garajechya barobariche aahe. vyavharat, arthat, arthpurn moolye asalelya 'grahak' aanee 'utpadan' chya sanyoganchi sankhya hii ekoon jaagecha eka lahansa upasanch asel. bahuayami jaganchya yaa gunadharmala sparcity mhanatat.
ektrikaran.
olap pranali samanyatah pratyek aayamachya sadasyanna eka kinwa adhik shrenibaddha karoon pratyek aayamanmadhye tapashilanchya anek staranchi vyavastha karatat. udaharanarth, veleche pariman, "ekoon vel" pasoon suru houn anek varshe, nantar chaturthansh, nantar mahinyanmadhye vibhagalela eka padanukram mhanoon darshavile jaau shakate. khatyache pariman 'napha' pasoon suru houu shakate, jeey 'mahasool' aanee 'kharch' ityadinmadhye vibhagale jaate.
vareel udaharanat, jarr "utpadan" heey vaiyaktik utpadan skasache pratinidhitva karat asel, tarr vishleshakanna "utpadan gut", "utpadan kutumb", "utpadan shreni" ityadi ektrit karoon ahwal dyayacha asoo shakato. tyachpramane, "grahak" sathee, naisargik ektrikaran bhaugolik sthan kinwa udyoganusar grahakanchi vyavastha karoo shakate.
input detachya sanchadvare soochit kelelya ekoon mulyanchi sankhya aashcharyakarakpane mothee houu shakate. jarr grahak aanee utpadanache pariman kharey tarr sahaa 'pidhya' khol asel, tarr 36 (6 × 6) ekoon moolye ekach deta pointne prabhavit hotat. asey aahe qee jarr hii serve ektrit moolye sathvayachi asateel tarr aavashyak jaageche praman serve ektrit parimananchya kholichya gunakaranusar asate. mothya detabesesasathi, yamule prabhavi sathavan aavashyakta ektrit kelya olakhalya detachya aakarachya kityekashe putt asoo shakatat.
block storage (esbes analytics).
aavrutti 7 pasoon, esbesne done "sathavan paryayanna" samarthan dile aahe jeey mothya bahuayami jaganche pratinidhitva karnyasathi aavashyak asalelya bhautik smrutee aanee disk jaageche praman qamee karnyasathi sparcitycha fayda ghetat. esbes paytant mool paddhatiche varnan karate, jyacha uddesh jawalun sambandhit moolye shodhanyasathi aavashyak vel naan vadhavta aavashyak asalelya bhautik smrutiche praman qamee karane haah aahe. paryayi sathavan paryayanchya parichayasah, vipanan samagreene yala block storage paryay (esbes bii. ess. oo.) mhatale, jyala nantar esbes vishleshan mhanoon sambodhale gele.
thodakyat sangayache tarr, esabesasathi vikaskane parimananna "ghan" kinwa "viral" asey tagg karane aavashyak aahe. pranali nantar hypercubeche pratinidhitva karnyasathi detachi "blocks" madhye vyavastha karate, jithe pratyek blockmadhye "ghan" parimananni banaleli bahu-aayami rachana asate aanee tyaa blockmadheel pratyek sambhavya peshisathi jaaga vatap kelee jaate. sparcitycha vapar keela jaato kaaran pranali keval aavashyakatenusarach block tayar karate. vareel udaharanat, samaja vikaskane "khaatee" aanee "vel" yanna "ghan" aanee "pradesh", "grahak" aanee "utpadan" yanna "viral" asey tagg kele aahe. jarr, samaja, deta asalele pradesh, grahak aanee utpadanache 12,000 sanyojan asel, tarr keval 12,000 block tayar kele jaatil, pratyek block khaate aanee veleche pratyek sambhavya sanyojan sanchayit karnyasathi puresa motha asel. tyamule sathavalelya peshinchi sankhya 192000 (4 × 4 × 12000) aahe, jyasathi 2 gigabpeksha qamee memory (achook 1,536 emm. bii.) aavashyak aahe, tasech yogya khand shodhanyasathi vaparlya jaanarya nirdeshankacha aakar.
kaaran databases hii amalbajavani front-end sadhananpasun lapavato (i.eae.astitvat nasalelya peshinmadhun deta punarprapt karnyacha prayatna karnara ahwal keval "null" moolye pahato), sampoorn hypercube naisargikaritya navigate keela jaau shakato aanee konatyahi peshimadhye parasparsanvadipane moolye loaded karane shakya aahe.
ganana engine.
vaparkarte esusbases bii. ess. oo. madhye ganana asha prakare nirdisht karoo shakatatah
pahili paddhat (pariman ektrikaran) jodanidware kinwa vaja karnyasathi, gunakar karnyasathi, vibhajit karnyasathi kinwa durlaksh karnyasathi padanukramachya shakhanna nivadak tagg karoon antarbhutpane hote. tasech, yaa ektrikaranacha parinam detabasemadhye sangrahit keela jaau shakato kinwa maganinusar gatishilpane ganana kelee jaau shakate-sadasyanna "sangrahit" kinwa "gatishil calc" mhanoon tagg karane aavashyak aahe."konati paddhat vaparayachi aahe heey nirdisht karnyasathi.
dusari paddhat (sangrahit ganana) pratyek ganana kelelya pariman sadasyachya viruddha sootra vaparte jevha esbes tyaa sadasyachi ganana karato, tevha parinam deta mulyapramanech tyaa sadasyachya viruddha sangrahit keela jaato.
tisari paddhat (gatishil ganana) sangrahit gananepramanech agadi tyach swarupat nirdisht kelee jaate, parantu jevha vaparkarta tyaa sadasyane sambodhit kelelya moolyat pravesh karato tevha parinamachi ganana karate; pranali ashee ganana keleli moolye sangrahit karat nahee.
chauthi paddhat (ganana lipi) esbes ganana enginesathi vishisht prakriyatmak programming bhasha vaparte. yaa prakarchi ganana hypercubemadhil konatyahi deta mulyavar karya karoo shakate aanee mhanoon ashee ganana karoo shakate jee eka sadhee sootra mhanoon vyakt kelee jaau shakat nahee.
varr varnan kelyapramane ektrit mulyanchi ganana kinwa sangrahit ganananchi ganana suru karnyasathi ganana script dekhil karyanvit karane aavashyak aahe-yaa prakarchya gananechi amalbajavani karnyasathi antarnirmit ganana script (jyala "purvanirdharit ganana" mhanatat) vaparali jaau shakate.
ekoon sathavan (udyam vishleshan).
jaree block storage punarprapti velevar parinam naan karata sathavan aavashyaktanna prabhavipane qamee karate, parantu mothya anuprayoganmadhye ekoon detachya upcharat tyala maryada aahet, jyamule jyamule sanchayan enginecha parichay hoto, jyala ekoon sanchayan paryay (esbes asso) kinwa agadi alikade, entreprise analytics mhanatat. haah sathavan paryay detabesla ess. kyu. ell. server vishleshan sevansarkhya olap detabessarkhe adhik vagnyas bhag padato.
deta loaded jhalyanantar, esbes asso konatihi ekoon moolye sathavat nahee, parantu tyaeivaji maganinusar tyanchi ganana karate. mothya detabesesasathi, jethe hii moolye nirman karnyasathi lagnara vel gairsoyicha tharoo shakato, databases pratyek parimanatil eka ektrit patalipasoon banalelya eka kinwa adhik ektrit "drushye" pratyakshat aanoo shakato (udaharanarth, databases serve sanyojananchi ganana karoo shakato grahakanchya grahakanchya pidhisah utpadanachya pachvya pidhisah), aanee nantar jithe shakya asel tithe yaa drushye itar ektrit moolye tayar karnyasathi vaparali jaatat. hii prakriya anshatah svayanchalit asoo shakate, jithe prashasak diskchya kitee jaaga vaparlya jaau shakatat heey nirdisht karato aanee databases pratyaksh vaparanusar drushye tayar karato.
yaa drushtikonat eka mothee kamatarata aahe qee ghanala gananechya uddeshane ekach motha hypercube mhanoon manale jaau shakat nahee, kaaran ekoon moolye thet niyantrit kelee jaau shakat naheet, mhanoon front-end sadhananmadhun mage lihine maryadit aahe aanee mdx abhivyakti mhanoon vyakt karata naan yenari jatil ganana shakya nahee.
ganana engine.
esbes asso hii ganana asha prakare nirdisht karoo shakateh
pahili paddhat (pariman ektrikaran) mulat esbes bii. ess. oo. dware vaparlya jaanarya algoridamchi nakkal karate.
dusari paddhat (gatishil ganana) pariman sadasyanchya viruddha mdx abhivyaktinche moolyankan karate.
vaparkarta interfaces.
bahutek esbes vaparkarte smart view mhanoon olakhalya olakhalya microsoft excelsathi (purvi kamal 1-2-3 dekhil) edd-indware esbes detasah kaam karatat. esusbases add-inn heey microsoft excelsathi eka manak plugin aahe aanee eka atirikt menu tayar karate jyacha vapar esusbases detabesashi jodanyasathi, deta punarprapt karnyasathi kinwa lihinyasathi aanee kyoobchya parimananna navigate karnyasathi ("zoom inn", "pivat", ii.).
2005 madhye, hyperionne hyperian visual explorer (etch. vhee. eae.) navache visualization tool deu kele jeey zanki softwareche eka oo. eae. emm. hote. vaparkartyanna sambandh aanee olap databaseshi sanvad sadhanyachya naveen margancha tapas karnyasathi sarkar-prayojit sanshodhan prakalp mhanoon stanford vidyapithat zanki softwarechi suruvat jhaali. hyperian aanee zanki yanni ektritpane moolbhootpane zanki softwarechya pahilya aavrutya tayar kelya jyaa visheshtah bahuayami (olyap) detabesesasathi tayar kelya gelya hotya. 2007 madhye hyperionchya adhigrahanantar lagechach aurekalne zanki softwares oo. eae. emm. vyavastha twarit bund kelee.
itar bahutek suprasiddha vishleshan vikrete esabesasathi aadharasah vaparkartyala tond denare anuprayog pradan karatat aanee tyat samavisht aahet;
hyperionchya aadhichya prastavanna khalee dilelya navanpramane naveen nave midalih
api see, visual besik aanee javasathi upalabdh aahet aanee parlasathi embedded scripting samarthan upalabdh aahe. vishleshan protocolsathi pramanit ex. emm. ell. emm. dii. ex. bhasha vaparoon esusbases deta strotanchi chaukashi karoo shakate.
2007 madhye, oracle corporation oracle business intelligence entreprise edition plasmadhye hyperian buy tools ektrit karnyas suruvat kelee.
prashasakeey interfaces.
anek manak interfaces esbes anuprayoganche vyavasthapan karoo shakatatah
dhaganchi bhet.
2017 pasoon, esbes claude heey oracle analytics claude (oac) chaa bhag mhanoon upalabdh aahe, jeey vishleshanancha eka sanch aahe jyamadhye ahwal aanee dashboard, deta visualization, inline deta tayari aanee mobile yancha samavesh aahe.
spardhak.
bajaratil olap, esbes (hollap/mollap) chya vishleshanatmak utpadananmadhye anek mahattvapoorn pratispardhi aahet, tyapaiki sapp bii. pii. see., microsoft ess. kyu. ell. server microsoft vishleshan seva (mollap, hollap, rollap), aay. bii. emm. cognos (rollap), aay. bii. emm./cognos/applix tii. emm. 1 (mollap), oracle olap (rollap/mollap), microstraty (rollap) aanee exazolution (rollap) yancha samavesh aahe.
esbases vareel spardhkanpaiki serve heterogenous relational (microsoft ess. kyu. ell. server, oracle, aay. bii. emm. dii. bii./2, terradata, access ii.) vapartat heey dekhil lakshat ghya.) kinwa gair-sambandhit deta sourcing (axel, majkoor fayali, see. ess. vhee. fayali ii.)) aurekal olap vagalata, jeey keval aurekal relational sourcing vaparu shakate, chaukoni bhaganna (tathye aanee aayami mahitee) puravanyasathi.
esbesachi niryat aanee/kinwa utpadan sthalantar.
 done paryay esbes cubes itar swarupanmadhye niryat karoo shakatatah

