Bayanan Bayani na DATA VAULT

A baya labarai, An gabatar da mu ga tushen DATA VAULT, fadada DATA VAULT zuwa yanayin da ya dace don bincike, da kuma samar da BASINESS DATA VAULT. Lokaci ya yi da za a kawo ƙarshen jerin tare da labarin na uku.

Kamar yadda na sanar a baya wallafe, wannan labarin za a duƙufa ne ga batun BI, ko kuma wajen shirya DATA VAULT a matsayin tushen bayanai don BI. Bari mu dubi yadda ake ƙirƙira gaskiya da tebur mai girma kuma ta haka ne za mu ƙirƙiri makircin tauraro.

Lokacin da na fara nazarin kayan yaren Ingilishi a kan batun ƙirƙirar marts na bayanai akan DATA VAULT, na ji cewa tsarin yana da rikitarwa. Tun da labaran suna da girma mai ban sha'awa, akwai nassoshi game da canje-canje a cikin kalmomin da suka bayyana a cikin hanyar Data Vault 2.0, kuma an nuna mahimmancin waɗannan kalmomi.

Duk da haka, bayan da aka zurfafa cikin fassarar, ya bayyana a fili cewa wannan tsari ba shi da wahala sosai. Amma watakila za ku sami ra'ayi na daban.

Don haka, bari mu kai ga batun.

Girma da teburin gaskiya a cikin DATA VAULT

Mafi wahalar fahimta:

• An gina teburin aunawa akan bayanai daga cibiyoyi da tauraron dan adam;
• An gina teburin gaskiya akan bayanai daga hanyoyin haɗin gwiwa da tauraron dan adam.

Kuma wannan a bayyane yake bayan karanta labarin game da Bayanan Bayani na DATA VAULT. Hubs suna adana maɓallai na musamman na abubuwan kasuwanci, tauraron dan adam na yanayin halayen abubuwan kasuwanci suna da alaƙa da lokaci, tauraron dan adam da ke da alaƙa da haɗin gwiwar ma'amaloli suna adana halayen lambobi na waɗannan ma'amaloli.

A nan ne ka'idar ta ƙare.

Amma, duk da haka, a ganina, ya zama dole a lura da wasu ra'ayoyi guda biyu waɗanda za su iya bayyana a cikin kasidu game da hanyoyin DATA VAULT:

• Raw Data Marts - nunin bayanan "raw";
• Bayanin Marts - nunin bayanai.

Manufar "Raw Data Marts" tana nufin nunin nunin da aka gina akan bayanan DATA VAULT ta hanyar yin JOINs masu sauƙi. Hanyar "Raw Data Marts" tana ba ku damar sassauƙa da sauri fadada aikin sito tare da bayanan da suka dace da bincike. Wannan hanyar ba ta haɗa da yin hadaddun sauye-sauyen bayanai da aiwatar da ka'idojin kasuwanci kafin sanya shi a cikin kantin sayar da kayayyaki ba, duk da haka, bayanan "Raw Data Marts" ya kamata ya zama mai fahimta ga mai amfani da kasuwanci kuma ya yi niyya don zama tushen ƙarin canji, misali, tare da kayan aikin BI.

Manufar "Bayanin Marts" ya bayyana a cikin tsarin Data Vault 2.0, ya maye gurbin tsohuwar manufar "Data Marts". Wannan canjin ya samo asali ne saboda sanin aikin aiwatar da tsarin bayanai don gina rahotanni a matsayin canza bayanai zuwa bayanai. Tsarin Bayanin Marts, da farko, yakamata ya samar da 'yan kasuwa bayanan da suka dace da yanke shawara.

Ma'anar ma'anoni na zahiri suna nuna sauƙaƙan abubuwa guda biyu:

1. Abubuwan nuni kamar "Raw Data Marts" an gina su akan danyen (RAW) DATA VAULT, ma'ajiyar da ke ƙunshe da mahimman ra'ayoyi kawai: HUBS, LINKS, SATELLITES;
2. "Bayanai Marts" an gina su ta amfani da abubuwan KASUWANCI: PIT, BRIDGE.

Idan muka kalli misalan adana bayanai game da ma'aikaci, za mu iya cewa nunin nunin da ke nuna lambar wayar ma'aikaci na yanzu (mai inganci a yau) nuni ne na nau'in "Raw Data Marts". Don ƙirƙirar irin wannan nunin, ana amfani da maɓallin kasuwancin ma'aikaci da aikin MAX (), wanda aka yi amfani da shi akan sifa ta kwanan wata ta tauraron dan adam (MAX(SatLoadDate)). Lokacin da ya wajaba don adana tarihin canje-canjen halayen a cikin kantin sayar da kayayyaki - ana amfani da shi, kuna buƙatar fahimtar daga wane kwanan wata wayar ta dace, maɓalli na farko na irin wannan tebur zai zama tarin maɓallin kasuwanci da kwanan wata. loda zuwa tauraron dan adam, kuma an ƙara filin kwanan ƙarshen lokacin dacewa.

Ƙirƙirar wurin ajiya wanda ke adana bayanan yau da kullun don kowane sifa na tauraron dan adam da yawa da aka haɗa a cikin cibiyar, misali, lambar waya, adireshi, cikakken suna, ya haɗa da amfani da tebur na PIT, ta hanyar shiga wanda yana da sauƙin samun duk kwanan wata da suka dace. Ana kiran nunin nunin irin wannan a matsayin "Bayanai Marts".

Duk hanyoyin biyu sun dace da ma'auni da gaskiya.

Don ƙirƙirar gaban kantuna waɗanda ke adana bayanai game da mahaɗa da cibiyoyi da yawa, ana iya amfani da damar shiga teburin BRIDGE.

Da wannan labarin na kammala jerin abubuwan akan manufar DATA VAULT; Ina fatan bayanin da na raba zai kasance da amfani wajen aiwatar da ayyukan ku.

Kamar koyaushe, a ƙarshe, ƴan hanyoyin haɗi masu amfani:

• Mataki na ashirin Kenta Graziano, wanda, ban da cikakken bayanin, ya ƙunshi zane-zane na samfurin;

• Littattafai: "Gina Ma'ajiyar Bayanan Bayanai tare da DATA VAULT 2.0";
• Labari "Bayanan Rubutun Bayanai";
• Labari "Haɓaka DATA VAULT da canzawa zuwa KASUWANCI DATA VAULT".

source: www.habr.com