M'nkhani yapitayi, ndinayankhula za zofunikira za DATA VAULT, zomwe zinalongosola zinthu zazikulu za DATA VAULT ndi cholinga chawo. Izi sizingaganizidwe kuti ndi mutu wa DATA VAULT ngati watopa; ndikofunikira kuyankhula za masitepe otsatirawa pakusinthika kwa DATA VAULT.
Ndipo m'nkhaniyi ndikambirana za chitukuko cha DATA VAULT ndi kusintha kwa BUSINESS DATA VAULT kapena kungoti BUSINESS VAULT.
Zifukwa zowonekera kwa BUSINESS DATA VAULT
Tiyenera kudziwa kuti DATA VAULT, ngakhale ili ndi mphamvu zina, ilibe zovuta zake. Chimodzi mwazovuta izi ndizovuta polemba mafunso owunikira. Mafunso ali ndi ma JOIN ambiri, nambala yake ndi yayitali komanso yovuta. Komanso, deta yomwe imalowa mu DATA VAULT sichimasinthidwa, choncho, kuchokera ku bizinesi, DATA VAULT mu mawonekedwe ake oyera alibe phindu lililonse.
Zinali kuti zithetse zolakwika izi kuti njira ya DATA VAULT idakulitsidwa ndi zinthu monga:
- PIT (point in time) matebulo;
- BRIDGE matebulo;
- ZOMWE ZOMWE ZINACHITIKA.
Tiyeni tione bwinobwino cholinga cha zinthu zimenezi.
PIT tables
Nthawi zambiri, bizinesi imodzi (HUB) imatha kukhala ndi data yokhala ndi mitengo yosinthira yosiyana, mwachitsanzo, ngati tikulankhula za munthu, titha kunena kuti zambiri za nambala yafoni, adilesi kapena imelo zili ndi zosintha zambiri kuposa kunena, dzina lathunthu, zambiri za pasipoti, momwe banja kapena jenda.
Chifukwa chake, posankha ma satelayiti, muyenera kukumbukira kuchuluka kwawo kosinthika. Chifukwa chiyani kuli kofunikira?
Ngati mumasunga zosintha zomwe zili ndi mitengo yosinthika yosiyana patebulo lomwelo, muyenera kuwonjezera mzere patebulo nthawi iliyonse pomwe zomwe zimasinthidwa pafupipafupi zimasinthidwa. Zotsatira zake ndikuwonjezeka kwa malo a disk ndi kuwonjezeka kwa nthawi yofunsa mafunso.
Tsopano popeza tagawa ma satelayiti mosintha pafupipafupi, ndipo titha kuyikamo data pawokha, tiyenera kuonetsetsa kuti titha kulandira zidziwitso zaposachedwa. Bwino, popanda kugwiritsa ntchito JOIN zosafunikira.
Ndiroleni ndikufotokozereni, mwachitsanzo, muyenera kupeza zidziwitso zaposachedwa (malinga ndi tsiku lomwe zasinthidwa komaliza) kuchokera ku ma satellite omwe ali ndi mitengo yosinthira yosiyana. Kuti muchite izi, simudzangofunika JOIN, komanso kupanga mafunso angapo (pa satellite iliyonse yomwe ili ndi chidziwitso) ndikusankha tsiku lomaliza la MAX (Tsiku Losintha). Ndi JOIN iliyonse yatsopano, nambala yotere imakula ndipo mwachangu imakhala yovuta kumvetsetsa.
Gome la PIT lidapangidwa kuti lizifufumitsa mafunso otere; matebulo a PIT amadzazidwa nthawi imodzi ndikulemba zatsopano ku DATA VAULT. tebulo la PIT:
Chifukwa chake, tili ndi chidziwitso chokhudzana ndi kufunikira kwa ma satellites onse panthawi iliyonse. Pogwiritsa ntchito ma JOIN pa tebulo la PIT, titha kuthetseratu mafunso omwe ali zisa, mwachibadwa ndi momwe PIT imadzazidwa tsiku lililonse komanso popanda mipata. Ngakhale pali mipata mu PIT, mutha kupeza zambiri zaposachedwa pogwiritsa ntchito funso limodzi lokhazikika ku PIT yomwe. Funso limodzi lokhazikitsidwa lidzakonzedwa mwachangu kuposa mafunso omwe ali pa satellite iliyonse.
BRIDGE
Matebulo a BRIDGE amagwiritsidwanso ntchito kupeputsa mafunso owunikira. Komabe, chomwe chimasiyana ndi PIT ndi njira yochepetsera ndikufulumizitsa zopempha pakati pa ma hubs osiyanasiyana, maulalo ndi ma satellite awo.
Gome ili ndi makiyi onse ofunikira a ma satelayiti onse, omwe amagwiritsidwa ntchito nthawi zambiri pamafunso. Kuonjezera apo, ngati kuli kofunikira, makiyi a bizinesi a hashed akhoza kuwonjezeredwa ndi makiyi amtundu wa malemba ngati mayina a makiyi akufunika kuti afufuzidwe.
Chowonadi n'chakuti popanda kugwiritsa ntchito BRIDGE, polandira deta yomwe ili m'ma satelayiti omwe ali m'mabwalo osiyanasiyana, padzakhala kofunika kuti JOIN JOIN osati ma satelayiti okha, komanso maulalo olumikiza ma hubs.
Kukhalapo kapena kusapezeka kwa BRIDGE kumatsimikiziridwa ndi kasinthidwe kosungirako komanso kufunikira kowonjezera kuthamanga kwa mafunso. Ndizovuta kubwera ndi chitsanzo chapadziko lonse cha BRIG.
ZOMWE ZOMWE ZINACHITIKA
Mtundu wina wa chinthu chomwe chimatifikitsa pafupi ndi BUSINESS DATA VAULT ndi matebulo omwe ali ndi zizindikiro zowerengedweratu. Matebulo oterowo ndi ofunikira kwambiri pabizinesi; amakhala ndi zidziwitso zophatikizidwa motsatira malamulo operekedwa ndipo zimapangitsa kuti zikhale zosavuta kuzipeza.
Zomangamanga, ZOPHUNZITSIDWA ZOCHITIKA NDI ZAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI KOPERANI MAPODIKASITI MITU YA NKHANI YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI KOPERANI MAPODIKASITI MITU YA NKHANI YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI KOPERANI MAPODIKASITI MITU YA NKHANI YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI KOPERANI MAPODIKASITI MITU YA NKHANI YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI KOPERANI MAPODIKASYA XNUMX si kanthu kena koma satellite ina ya malo enaake. Ilo, ngati satellite yokhazikika, imakhala ndi kiyi yabizinesi ndi tsiku lopanga zolembedwa mu satelayiti. Apa ndi pamene kufanana kumathera, komabe. Kuphatikizidwanso kwa mawonekedwe a satellite "odziwika" yotere kumatsimikiziridwa ndi ogwiritsa ntchito mabizinesi potengera zizindikiro zodziwika bwino, zowerengeredwa kale.
Mwachitsanzo, malo okhala ndi zambiri za wogwira ntchito atha kukhala ndi satellite yokhala ndi zizindikiro monga:
- Malipiro ochepera;
- Malipiro apamwamba;
- Avereji ya malipiro;
- Malipiro owonjezereka, ndi zina zotero.
Ndizomveka kuphatikizira PREDEFINED DERIVATIONS patebulo la PIT la malo omwewo, ndiye kuti mutha kupeza magawo a data kwa wogwira ntchito mosavuta pa tsiku lomwe mwasankha.
MISONKHANO
Monga momwe zimasonyezera, kugwiritsa ntchito DATA VAULT ndi ogwiritsa ntchito mabizinesi kumakhala kovuta pazifukwa zingapo:
- Khodi yamafunso ndizovuta komanso zovuta;
- Kuchuluka kwa ma JOIN kumakhudza kachitidwe ka mafunso;
- Kulemba mafunso owunikira kumafuna chidziwitso chapadera pamapangidwe osungira.
Kuti muchepetse mwayi wofikira pa data, DATA VAULT imawonjezedwa ndi zinthu zina:
- PIT (point in time) matebulo;
- BRIDGE matebulo;
- ZOMWE ZOMWE ZINACHITIKA.
Ena Ndikukonzekera kunena, mwa lingaliro langa, chinthu chosangalatsa kwambiri kwa iwo omwe amagwira ntchito ndi BI. Ndipereka njira zopangira matebulo owona ndi matebulo amiyeso kutengera DATA VAULT.
Zomwe zili m'nkhaniyi zimachokera pa:
- pa Kenta Graziano, yomwe, kuwonjezera pa kufotokozera mwatsatanetsatane, ili ndi zithunzi zachitsanzo;
- Bukhu: "Kumanga Malo Osungiramo Zinthu Zowonongeka ndi DATA VAULT 2.0";
- Nkhani .
Source: www.habr.com