资源描述:
《QlikView_Underly_Teq.pdf》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、TheunderlyingtechnologyofQlikViewQlikTech*finallydecidedbothtobecomeaclientand,surelynotcoincidentally,togivememoretechnicaldetailaboutQlikViewthanithadwhenlastwetalkedacoupleofyearsago.Indeed,IgottospendacoupleofhoursonthephonenotjustwithAnthonyDeighton,butalsowithQlikTe
2、ch’sHakanWolge,whowrote70-80%ofthecodeinQlikView1.0,andremainsineffectQlikTech’schiefarchitecttothisday.*Or,asitnowappearstobecalled,QlikTechnologies.Let’sstartwithsomequickreminders:•QlikTechmakesQlikView,awidelypopularbusinessintelligence(BI)toolsuite.•QlikViewisdisting
3、uishedbytheflexibilityofnavigationthroughitsuserinterface.•Tosupportthisflexibility,QlikViewpreloadsalldatayoumightwanttoqueryintomemory.Let’salsodisposeofoneconfusionrightupfront,namelyQlikTech’suseofthewordassociative:•NotwithstandingQlikTech’srepeateduseofphraseslike“Q
4、likView’sunique,patentedin-memoryassociativetechnology,”thereisnothing“associative”aboutQlikView’sdatastructures.•Rather,“associative”isatermthatcanreasonablybeusedtodescribethefunctionalityofQlikView’suserinterface.Inparticular,QlikViewcan“associate”overfieldsthathavethe
5、samename,inthatitmakesiteasyforuserstojoinacrossthem.Withthatoutoftheway,let’sturntosomehighlightsofQlikView’sunderlyingtechnology.Forthemostpart,QlikView’sin-memorydatastructuresarequitesimple.Inparticular:oQlikViewdataisstoredinastraightforwardtabularformat.oQlikViewdat
6、aiscompressedviawhatQlikTechcallsa“symboltable,”butIgenerallycall“dictionary”or“token”compression.oQlikViewtypicallygetsatitsdataviascans.Thereisverylittleinthewayofprecomputedaggregates,indexes,andthelike.Ofcourse,iftheselectionhappenstobeinlinewiththeorderinwhichthereco
7、rdsaresorted,youcangetgreatselectivityinascan.oOneadvantageofdoingtokencompressionisthatallthefieldsinacolumnwindupbeingthesamelength.Thus,QlikViewholdsitsdatainnicearrays,sotheaddressesofindividualrowscanoftenbeeasilycalculated.TogetitsUIflexibility,QlikViewimplicitlyass
8、umesastar/snowflakeschema.Thatis,thereshouldbenomoreandnolessthanonepossiblejoinpathbetweenanypa