Zolemba za data DATA VAULT

M'mbuyomu zolemba, tawona zoyambira za DATA VAULT, kukulitsa DATA VAULT kuti ikhale yodziwika bwino, ndikupanga BUSINESS DATA VAULT. Yakwana nthawi yoti titsirize mndandanda ndi nkhani yachitatu.

Monga ndidalengeza m'mbuyomu zofalitsa, nkhaniyi idzayang'ana pa mutu wa BI, kapena m'malo mwake kukonzekera kwa DATA VAULT monga gwero la deta la BI. Tiyeni tiwone momwe tingapangire matebulo owona ndi miyeso ndikupanga schema ya nyenyezi.

Nditayamba kuphunzira chilankhulo cha Chingerezi pamutu wopanga ma data pa DATA VAULT, ndidamva kuti ntchitoyi inali yovuta. Popeza zolembazo ndi zazitali kwambiri, pali maumboni okhudza kusintha kwa mawu omwe adawonekera mu njira ya Data Vault 2.0, kufunikira kwa mawuwa kukuwonetsedwa.

Komabe, atafufuza za kumasulira, zinaonekeratu kuti njirayi si yovuta kwambiri. Koma mungakhale ndi maganizo osiyana.

Ndipo kotero, tiyeni tifike ku mfundo.

Makulidwe ndi zowona mu DATA VAULT

Zambiri zovuta kuzimvetsa:

• Matebulo oyezera amapangidwa pazidziwitso zochokera ku ma hubs ndi ma satellite awo;
• Zowona zenizeni zimamangidwa pazomwe zimachokera ku maulalo ndi ma satellite awo.

Ndipo izi ndizodziwikiratu mutawerenga nkhaniyi Zofunikira za DATA VAULT. Ma Hub amasunga makiyi apadera azinthu zabizinesi, ma satelayiti omwe amakhala ndi nthawi yokhazikika azinthu zabizinesi, ma satelayiti omangidwa ku maulalo othandizira kugulitsa amasunga manambala azinthu izi.

Apa ndi pamene chiphunzitsocho chimathera.

Koma, komabe, m'malingaliro anga, ndikofunikira kuzindikira mfundo zingapo zomwe zingapezeke m'nkhani za njira ya DATA VAULT:

• Raw Data Marts - ziwonetsero za data "yaiwisi";
• Information Marts - ziwonetsero zazidziwitso.

Lingaliro la "Raw Data Marts" - limatanthawuza ma marts omangidwa pamwamba pa data ya DATA VAULT pochita ma JOIN osavuta. Njira ya "Raw Data Marts" imakulolani kuti muzitha kusinthasintha komanso mwamsanga kuwonjezera ntchito yosungiramo katundu ndi chidziwitso choyenera kusanthula. Njirayi siyimaphatikizapo kuchita zosintha zovuta za data ndikuchita malamulo abizinesi musanayike kutsogolo kwa sitolo, komabe, deta ya Raw Data Marts iyenera kumveka kwa wogwiritsa ntchito bizinesi ndipo iyenera kukhala maziko osinthika, mwachitsanzo, ndi zida za BI. .

Lingaliro la "Information Marts" lidawonekera mu njira ya Data Vault 2.0, lidalowa m'malo mwa lingaliro lakale la "Data Marts". Kusintha kumeneku kumachitika chifukwa cha kukwaniritsidwa kwa ntchito yogwiritsira ntchito chitsanzo cha deta kuti afotokoze ngati kusintha kwa deta kukhala chidziwitso. Dongosolo la "Information Marts", choyamba, liyenera kupatsa bizinesiyo chidziwitso choyenera kupanga zisankho.

M'malo mwake matanthauzo a verbose amasonyeza mfundo ziwiri zosavuta:

1. Zowonetsera zamtundu wa "Raw Data Marts" zimamangidwa pa VAULT yaiwisi (RAW) DATA VAULT, malo osungira omwe ali ndi mfundo zokhazokha: HUBS, LINKS, SATELLITES;
2. Zowonetsa "Information Marts" zimamangidwa pogwiritsa ntchito zinthu za BUSINESS VAULT: PIT, BRIDGE.

Ngati titembenukira ku zitsanzo zosungira zambiri za wogwira ntchito, tinganene kuti malo ogulitsira omwe akuwonetsa nambala yafoni (yapano) ya wogwira ntchitoyo ndi malo osungiramo zinthu zamtundu wa "Raw Data Marts". Kuti mupange chiwonetsero chotere, kiyi yabizinesi ya wogwira ntchito ndi MAX() ntchito yomwe imagwiritsidwa ntchito pakuwonetsa tsiku la satellite (MAX(SatLoadDate)) amagwiritsidwa ntchito. Zikafunika kusunga mbiri yakusintha kwazomwe zikuwonetsedwa - zimagwiritsidwa ntchito, muyenera kumvetsetsa kuti foni idasinthidwa mpaka liti, kuphatikiza kiyi yabizinesi ndi tsiku lokwezera ku satellite. idzawonjezera kiyi yoyamba pa tebulo loterolo, gawo la tsiku lomaliza la nthawi yovomerezeka likuwonjezeredwa.

Kupanga malo osungiramo zinthu zakale omwe amasunga zidziwitso zaposachedwa pamtundu uliwonse wa ma satelayiti angapo omwe akuphatikizidwa mu hub, mwachitsanzo, nambala yafoni, adilesi, dzina lathunthu, kumatanthauza kugwiritsa ntchito tebulo la PIT, lomwe limakhala losavuta kufikira masiku onse. za kufunika. Zowonetsa zamtunduwu zimatchedwa "Information Marts".

Njira zonse ziwirizi ndizogwirizana ndi miyeso komanso zenizeni.

Kuti mupange malo osungiramo zinthu zomwe zimasunga zambiri zamalumikizidwe angapo ndi ma hubs, mwayi wopita kumatebulo a BRIDGE ungagwiritsidwe ntchito.

Ndi nkhaniyi, ndimaliza kuzungulira kwa lingaliro la DATA VAULT, ndikuyembekeza kuti zomwe ndagawana zidzakuthandizani pakukwaniritsa ntchito zanu.

Monga nthawi zonse, pomaliza, maulalo angapo othandiza:

• Nkhani Kenta Graziano, yomwe, kuwonjezera pa kufotokozera mwatsatanetsatane, ili ndi zithunzi zachitsanzo;

• Bukhu: "Kumanga Malo Osungiramo Zinthu Zowonongeka ndi DATA VAULT 2.0";
• Nkhani "Data Vault Basics";
• Nkhani "Kupanga DATA VAULT ndikusintha kupita ku BUSINESS DATA VAULT".

Source: www.habr.com