Kunyangwe iwe uri kufunga kutamira kune IBM Cognos Analytics paGore, uchida kushandisa madhiraivha eJDBC pachinzvimbo chekuzvarwa dhatabhesi mutengi, kana kungoda kuoneka kwakanyanya mukuita zvine chekuita nemabatiro, kutora Dynamic Query Mode izano rakanaka.
Kana Performance Chikafu Boka, mumwe wevatungamiriri vakavimbika muindasitiri yekushandira chikafu ichangobva kukwidziridzwa kubva kuCognos 10.2.1 kusvika 11.0.12 sechikamu chekuenderera kwavo kwekuvandudza maitiro, vakafunga kuti vaizo gadziridza mapakeji avo kubva kuCQM kuenda kuDQM futi. Sumit Kumar, PFG maneja weIT anoona nezvekuongorora kuburitsa, kuongorora, uye kubvunza, ndiye aiona nezvekufamba kwavo kwepakeji uye akapiwa basa rekukunda chero matambudziko avanogona kusangana nawo panguva iyi.
Bhenefiti Yekutendeuka Kubva kuCQM Kuenda DQM
Performance Kudya Boka zvikonzero zvekutama zvaive zvakawandisa. Imwe yemabhenefiti akakosha ekushandurira Sumit uye PFG seyese yaive kugona kushandisa mishumo ine data kubva kune akawanda mapakeji mukati meiyo imwechete mushumo. Dynamic Query Mode yaizobvumidza Sumit kushandisa mishumo yaive nedata kubva kunzvimbo dzinoverengeka dzenyaya dzakadai sekutengesa, kutenga, uye kuverenga, kunyangwe ivo vari mumapakeji matatu akasiyana zvachose. Inoenderana Query Mode haina kugona uku, saka sarudzo yaive pachena.
Kutendeuka kubva kuCompatible Query Mode kuenda kuDynamic Query Mode kwaizovapawo iwo mukana wekudzora zvakanyanya nguva yekuuraya nguva nekushandisa kubvunzwa kwemubvunzo pane makumi matanhatu neshanu mapurani. Nekutama, Sumit aiziva kuti ivo vaisangoisa chete zvigadziriso kuita kuti kusimudzira kwemangwana kuve nyore asiwo kupawo Performance Chikafu Boka kugona kwekufungidzira analytics mune yavo automatization.
Zvakanakira kutendeuka zvaive pachena, asi ndeapi matambudziko aive mberi?
Mushure mekusarudza gumi nematanhatu eCognos mapakeji ekushandurwa, Sumit akasangana nezvipingamupinyi zvake zvekutanga panguva yekuronga chirongwa uye chikamu chekuuraya.
Kuronga KweProjekiti uye Matambudziko Ekuuraya
wokutanga roadblock Sumit yakatarisana yaive kusarudza pakati peWallfall kana Agile Dhirivhari. Sumit akasarudza iyo yekupedzisira yeCQM yake kuenda kuDQM kutendeuka nekuti zvakamubvumidza kuendesa yega pasuru zvakazvimiririra. Mapakeji akaendeswa apo mishumo yese yakakosha yakamhanya zvinobudirira uye kana mimwe mishumo yepasi-pekutanga yaive nezvikanganiso, vakaendesa pasuru zvakadaro hazvo ndokugadzirisa mishumo gare gare. Izvi zvakavatendera kuendesa kukosha kwebhizimusi kumberi pasina kurasikirwa chero nguva, asi kuti vatambe zvakachengeteka vakachengeta bhajeti remwedzi mumwe kuitira kuti vangangoda rubatsiro rwakawedzerwa kubva kuchikwata chinotsigira chigadzirwa cheBMM.
Zvino izvo Sumit uye Performance Chikafu Boka rakakunda chirongwa chekuronga uye chikamu chekuuraya, yaive nguva yekuti vabate nyaya inotevera: zvehunyanzvi uye zvivakwa zvezvinetso nekuda kwehunhu hwemapakeji muDynamic Query Mode.
"Maererano neSumit, kushandura kubva kuCQM kuenda kuDQM yaive nguva nesimba zvakashandiswa chaizvo. Mushure mekutendeuka, nguva yekuurawa yakaderedzwa ne60% paavhareji! ”
Unyanzvi uye Zvivakwa Zvinonetsa
Dynamic Query Mode inosimbisa yakanakisa maitiro ayo aisarudzika muCompatible Query Mode. Muenzaniso weizvi ungave wekushandisa mahedheni uye maasterisks ane kumberi slash seyakataurwa mutsara, semuenzaniso, '-' vs '/ *'. CQM inogamuchira zvese izvi nepo DQM dzimwe nguva inozvigamuchira uye dzimwe nguva haigamuchire, zvinoenderana nekuiswa. Idzi dzinoita sedzediki nyaya dzinogona kukonzeresa zvikanganiso kana kunyange mishumo yese kutadza. Makomendi mune epamberi mafirita, SQL query uye tsika kuverenga zvakave zvakare kuzivikanwa kukonzera zvikanganiso. A Enzanisa sql mubvunzo chishandiso chakafungidzirwa kuisa fomati kuiswa uye kudzikisira kuitika kwezvikanganiso kubva munzvimbo iyoyo asi kuferefetwa kwakaenderera mberi kuitira kuona zvese zvinoitika. Kuisirwa kwehuwandu hwebasa mune ye data modhi kana dudziro yepakeji zvakare yakagadzira zvikanganiso, asi izvi zvinogona kugadziriswa nekuzvitsiva nebasa rese panzvimbo, kana Sum () vs Total ().
Dynamic Query Mode zvakare inoita zvimwe zvekufungidzira izvo Inoenderana Query Mode haina, zvichikonzera mhedzisiro mhedzisiro kusiana. Kumhanyisa mishumo muCQM vs DQM inogona kukupa iwe mhedzisiro dzakasiyana zvinongoenderana nekuti vanodudzira sei basa. Semuenzaniso, iyo Yese (Yakazara (Yekutengesa)) muCQM inokupa mhedzisiro yakaenzana nekutengesa kwese uye inofuratira iyo yakazara zvakapetwa nepo muDQM isingatarise huwandu hwese, ichikupa mushumo wakasiyana wakabuda. Saizvozvo, nzira nzira dzekuunganidzwa dzinoitwa muCQM vs DQM inosiyanawo. Iwo mafirita pane Akaverengerwa / Aggregate makoramu anogona kutungamira kune akasiyana mhedzisiro zvichienderana nesanganiswa yezvivakwa sarudzo, senge "Asati Aggregation" kana "Mushure meKusunganidzwa".
Mamwe Matambudziko
Dynamic Query Mode inogona kunyorera kwakasiyana mashandiro emabasa anogona kukonzera shanduko mukuburitsa mushumo.
- Rondedzero yemazinga makadhiinari tsananguro inotungamira kuchinjiso mune chakabuda mushumo.
- Kuzivisa kusimbiswa kunogona kuratidza zvikanganiso zvakakura kunyangwe mushure mekunge meseji yambiro yagadziriswa. Yese meseji yambiro inofanira kugadziriswa mushumo musanganisi usati wakuratidza iko kukanganisa chaiko. Kana chirevo chisiri kumhanya uye chingoratidza chete yambiro meseji, iwe unofanirwa kugadzirisa iyo yambiro meseji pamberi pekuti mushumo uburitse kukanganisa kwakakomba uye nekutendera iwe kuti uugadzirise.
- Kupa mishumo nemari hombe yedhata kunogona kukundikana ne "Java kunze kwendangariro" nyaya asi inogona kugadziriswa nekuremadza yemuno caching chivakwa mune mushumo zvivakwa zveavo marepoti, uye zvakare inogona kubatsirwa nekuwedzera yakagadziriswa ndangariro yebvunzo yemubvunzo
- JVM kumisikidzwa inofanirwa kuve yakanyatsogadziriswa zvinoenderana neyakanakisa maitiro kuitira kudzivirira ramangwana matambudziko.
Mhedziso
Sekureva kweSumit, danho rekutama yaive nguva uye simba rakashandiswa zvakanyanya. Mushure mekutendeuka, rondedzero yekuuraya nguva yakaderedzwa ne60% paavhareji! Iye zvechokwadi anokurudzira kushandura mapakeji kubva kuCQM kuenda kuDQM uye nharaunda yako kubva 32-bit kusvika 64-bit.
Tichifunga nezve kutendeuka kubva kuCompatible Query Mode kuenda kuDynamic Query Mode kana ichangotendeuka? Tinoda kuti iwe ugovane ruzivo rwako nesu kana chero matipi uye madiki aungave uine!
Unoda kudzidza zvakawanda? Isu takagamuchira a WEBINAR kwatakakurukura nezvematambudziko akasangana neKutungamira Boka mukutama kwavo kuenda kuDynamic Query Mode. Pindura iyo webinar nekudzvanya apa.
