Muchikamu chakapfuura, ndakataura nezvekutanga kweDATA VAULT, yakatsanangura zvinhu zvikuru zveDATA VAULT uye chinangwa chavo. Izvi hazvigone kutorwa semusoro weDATA VAULT sekuneta; zvinodikanwa kutaura nezve matanho anotevera mukushanduka kweDATA VAULT.
Uye mune ino chinyorwa ini ndichatarisisa nezve kuvandudzwa kweDATA VAULT uye shanduko kuenda kuBHUSINESS DATA VAULT kana kungoti BUSINESS VAULT.
Zvikonzero zvekuonekwa kwe BUSINESS DATA VAULT
Izvo zvinofanirwa kucherechedzwa kuti DATA VAULT, nepo iine mamwe masimba, haina kunze kwekukanganisa kwayo. Chimwe chezvakaipira izvi kunetsa pakunyora mibvunzo yekuongorora. Mibvunzo ine nhamba yakakosha yeJOINs, iyo kodhi yakareba uye yakaoma. Uyewo, iyo data inopinda DATA VAULT haiiti chero shanduko, saka, kubva kune imwe nzvimbo yebhizimisi, DATA VAULT mufomu yayo yakachena haina kukosha kwakakwana.
Kwaive kubvisa zvikanganiso izvi iyo DATA VAULT nzira yakawedzerwa nezvinhu zvakaita se:
- PIT (point in time) matafura;
- BRIDGE matafura;
- PREDEFINED DERIVATIONS.
Ngatitarisei zvakanyanya pachinangwa chezvinhu izvi.
PIT matafura
Kazhinji, bhizinesi rimwe chete (HUB) rinogona kunge riine data rine mareti akasiyana ekuvandudza, semuenzaniso, kana isu tichitaura nezve data rinoratidza munhu, tinogona kutaura kuti ruzivo nezve nhamba yefoni, kero kana email ine yakakwira yekuvandudza pane kutaura, zita rizere, ruzivo rwepasipoti, chimiro chewanano kana murume kana murume.
Naizvozvo, kana uchisarudza satellite, iwe unofanirwa kurangarira yavo yekuvandudza frequency. Nei zvichikosha?
Kana iwe ukachengeta hunhu neakasiyana mareti ekuvandudza mutafura imwechete, iwe uchafanirwa kuwedzera mutsara patafura pese paunowanzo chinjwa hunhu hunovandudzwa. Mhedzisiro ndeyekuwedzera kwe diski nzvimbo uye kuwedzera kwemubvunzo wekuita nguva.
Zvino zvatave tapatsanura ma satellite nekudzokorora frequency, uye tinokwanisa kurodha data mazviri takazvimiririra, isu tinofanirwa kuve nechokwadi chekuti tinogona kugashira data razvino. Zvirinani, pasina kushandisa zvisina kufanira maJOIN.
Rega nditsanangure, semuenzaniso, iwe unofanirwa kuwana zvazvino (maererano nezuva rekupedzisira update) ruzivo kubva kumasatelliti ane akasiyana mareti ekuvandudza. Kuti uite izvi, hauzongoda chete kuita JOIN, asi zvakare kugadzira akati wandei mibvunzo (yega yega setiraiti ine ruzivo) nekusarudzwa kweiyo yakanyanya kukwidziridzwa zuva MAX (Kugadziridza Zuva). Nega yega JOIN itsva, kodhi yakadai inokura uye nekukurumidza inova yakaoma kunzwisisa.
Iyo PIT tafura yakagadzirirwa kurerutsa mibvunzo yakadai; PIT matafura anozadzwa panguva imwe chete nekunyora data nyowani kuDATA VAULT. PIT tafura:
Nekudaro, isu tine ruzivo nezve kukosha kwedata kune ese satellite panguva imwe neimwe panguva. Tichishandisa maJOIN kutafura yePIT, tinogona kubvisa zvachose mibvunzo yakavharirwa, nemasikirwo nemamiriro ezvinhu ekuti PIT inozadzwa mazuva ese uye pasina mikaha. Kunyangwe paine mapeji muPIT, unogona kuwana yazvino data chete uchishandisa imwe nested mubvunzo kuPIT pachayo. Muvhunzo mumwe chete nested uchagadzirisa nekukurumidza kupfuura mibvunzo yakavharirwa kune yega yega setiraiti.
BRIDGE
Matafura eBRIDGE anoshandiswawo kurerutsa mibvunzo yekuongorora. Nekudaro, izvo zvinosiyana nePIT inzira yekurerutsa uye nekumhanyisa zvikumbiro pakati peakasiyana hubs, zvinongedzo nemasatellite avo.
Tafura yacho ine makiyi ese anodiwa eese satellite, ayo anowanzoshandiswa mumibvunzo. Uye zvakare, kana zvichidikanwa, makiyi ebhizinesi ane hashed anogona kuwedzeredzwa nemakiyi muchimiro chemavara kana mazita emakiyi achidikanwa pakuongorora.
Icho chokwadi ndechekuti pasina kushandisa BRIDGE, mukuita kwekugamuchira data iri mumasatelliti ari emhando dzakasiyana hubs, zvichave zvakafanira kuita JOIN kwete chete yemasatelliti pachawo, asiwo yezvisungo zvinobatanidza hubs.
Kuvapo kana kusavapo kweBRIDGE kunotemerwa nekugadziriswa kwekuchengetedza uye kukosha kwekukwiridzira kumhanya kwemubvunzo wekuita. Zvakaoma kuuya nemuenzaniso wepasi rose weBRIGE.
PREDEFINED DERIVATIONS
Imwe mhando yechinhu inotiswededza pedyo neBUSINESS DATA VAULT matafura ane pre-calculated indicators. Matafura akadaro akakosha chaizvo kune bhizinesi; ane ruzivo rwakaunganidzwa zvinoenderana nemirairo yakapihwa uye anoita kuti ive nyore kuwana.
Nezvekuvaka, ZVINOTAURWA ZVAKAITWA ZVINHU hazvisi chimwe chinhu kunze kweimwe satellite yeimwe hub. Iyo, senge setiraiti yenguva dzose, ine kiyi yebhizinesi uye zuva rekugadzira rekodhi mune satellite. Apa ndipo panoperera kufanana kwacho, zvisinei. Kuwedzera kuumbwa kwehunhu hweiyo "specialized" satellite inotarwa nevashandisi vebhizinesi zvichienderana neanonyanya kufarirwa, pre-akaverengerwa zviratidzo.
Semuenzaniso, hubhu ine ruzivo nezve mushandi inogona kusanganisira satellite ine zviratidzo zvakaita se:
- Minimum muhoro;
- Maximum muhoro;
- Avhareji yemuhoro;
- Cumulative total of accrued wages, etc.
Zvine musoro kuisa PREDEFINED DERIVATIONS muPIT tafura yehubhu imwe chete, ipapo unogona kuwana nyore zvidimbu zve data zvemushandi pazuva rakasarudzwa.
ZVISANGANO
Sezvinoratidzwa nemaitiro, kushandiswa kweDATA VAULT nevashandisi vebhizinesi kwakaoma nezvikonzero zvakati wandei:
- Kodhi yemubvunzo yakaoma uye yakaoma;
- Kuwanda kweJOINs kunokanganisa kuita kwemibvunzo;
- Kunyora mibvunzo yekuongorora kunoda ruzivo rwakatanhamara rwekugadzira dhizaini.
Kurerutsa kuwana data, DATA VAULT inowedzerwa nezvimwe zvinhu:
- PIT (point in time) matafura;
- BRIDGE matafura;
- PREDEFINED DERIVATIONS.
Next Ini ndinoronga kuudza, mumaonero angu, chinhu chinonyanya kufadza kune avo vanoshanda neBI. Ini ndicharatidza nzira dzekugadzira chokwadi matafura uye dimension matafura akavakirwa paDATA VAULT.
Zvinhu zvechinyorwa zvinobva pa:
- pamusoro Kenta Graziano, iyo, kuwedzera kune tsanangudzo yakazara, ine mifananidzo yemuenzaniso;
- Bhuku: "Kuvaka Scalable Data Warehouse ine DATA VAULT 2.0";
- Chirevo .
Source: www.habr.com