Haɓaka DATA VAULT da canzawa zuwa BASINESS DATA VAULT

A cikin labarin da ya gabata, na yi magana game da tushen DATA VAULT, na bayyana mahimman abubuwan DATA VAULT da manufarsu. Ba za a iya la'akari da wannan batu na DATA VAULT a matsayin gajiya ba; ya zama dole a yi magana game da matakai na gaba a cikin juyin halittar DATA VAULT.

Kuma a cikin wannan labarin zan mayar da hankali ne akan bunkasa DATA VAULT da kuma canza sheka zuwa KASUWANCI DATA VAULT ko kuma kawai BUSINESS VAULT.

Dalilan bayyanar BUSINESS DATA VAULT

Ya kamata a lura cewa DATA VAULT, yayin da yake da wasu ƙarfi, ba tare da lahani ba. Ɗaya daga cikin waɗannan rashin amfani shine wahalar rubuta tambayoyin nazari. Tambayoyi suna da adadi mai mahimmanci na JOINs, lambar tana da tsayi kuma tana da wahala. Har ila yau, bayanan da ke shigar da DATA VAULT ba su da wani canji, don haka, daga mahangar kasuwanci, DATA VAULT a cikin tsari mai tsabta ba shi da cikakkiyar ƙima.

Don kawar da wadannan kurakuran ne aka fadada tsarin DATA VAULT da abubuwa kamar:

• PIT (maki a lokaci) tebur;
• Tables na GADO;
• SAFARKIN SANARWA.

Bari mu dubi manufar wadannan abubuwan.

PIT Tables

Yawanci, mahaɗan kasuwanci ɗaya (HUB) na iya ƙunsar bayanai tare da ƙimar sabuntawa daban-daban, misali, idan muna magana game da bayanan da ke siffanta mutum, muna iya cewa bayanin lambar waya, adireshi ko imel yana da ƙimar sabuntawa fiye da faɗin, cikakken suna, bayanan fasfo, matsayin aure ko jinsi.

Don haka, lokacin tantance tauraron dan adam, yakamata ku tuna da mitar sabuntawarsu. Me yasa yake da mahimmanci?

Idan kun adana sifofi tare da ƙimar sabuntawa daban-daban a cikin teburi ɗaya, dole ne ku ƙara jere zuwa tebur duk lokacin da aka sabunta sifa mafi akai-akai. Sakamakon shine haɓaka sararin faifai da haɓaka lokacin aiwatar da tambaya.

Yanzu da muka raba tauraron dan adam ta hanyar sabunta mita, kuma muna iya loda bayanai a cikin su daban-daban, ya kamata mu tabbatar da cewa za mu iya karɓar bayanai na zamani. Mafi kyau, ba tare da amfani da JOIN ɗin da ba dole ba.

Bari in bayyana, alal misali, kuna buƙatar samun bayanai na halin yanzu (bisa ga ranar sabuntawa ta ƙarshe) daga tauraron dan adam waɗanda ke da ƙimar sabuntawa daban-daban. Don yin wannan, kuna buƙatar ba kawai don yin JOIN ba, har ma don ƙirƙirar tambayoyin gida da yawa (na kowane tauraron dan adam mai ɗauke da bayanai) tare da zaɓin matsakaicin kwanan wata sabuntawa MAX (Update Date). Tare da kowane sabon JOIN, irin wannan lambar tana girma kuma cikin sauri ya zama da wahala a fahimta.

An tsara teburin PIT don sauƙaƙa irin waɗannan tambayoyin; An cika allunan PIT a lokaci guda tare da rubuta sabbin bayanai zuwa DATA VAULT. Teburin PIT:

Don haka, muna da bayanai game da dacewar bayanai ga duk tauraron dan adam a kowane lokaci a lokaci. Yin amfani da JOINs zuwa teburin PIT, za mu iya kawar da tambayoyin gida gaba ɗaya, ta halitta tare da yanayin cewa PIT yana cika kowace rana kuma ba tare da gibi ba. Ko da akwai gibi a cikin PIT, zaku iya samun sabbin bayanai kawai ta amfani da tambaya guda ɗaya zuwa PIT kanta. Tambaya guda ɗaya za ta aiwatar da sauri fiye da tambayoyin da aka yi wa kowane tauraron dan adam.

BRIDGE

Hakanan ana amfani da teburin BRIDGE don sauƙaƙe tambayoyin nazari. Koyaya, abin da ya bambanta da PIT shine hanyar sauƙaƙawa da saurin buƙatun tsakanin cibiyoyi daban-daban, hanyoyin haɗin gwiwa da tauraron dan adam.

Teburin ya ƙunshi duk maɓallan da ake buƙata don duk tauraron dan adam, waɗanda galibi ana amfani da su a cikin tambayoyi. Bugu da ƙari, idan ya cancanta, za a iya ƙara maɓallan kasuwanci da aka haɗe da maɓallai a cikin sigar rubutu idan ana buƙatar sunayen maɓallan don bincike.

Gaskiyar ita ce, ba tare da amfani da BRIDGE ba, a cikin tsarin karɓar bayanan da ke cikin tauraron dan adam na cibiyoyin sadarwa daban-daban, zai zama dole a yi JOIN ba kawai tauraron dan adam ba, har ma da hanyoyin haɗin yanar gizon.

Kasancewa ko rashi na BRIDGE an ƙaddara ta hanyar tsarin ajiya da buƙatar haɓaka saurin aiwatar da tambaya. Yana da wuya a zo da misali na duniya na BRIGE.

SAFARKIN SANARWA

Wani nau'in abu kuma wanda ke kusantar da mu zuwa KASUWANCI DATA VAULT, tebur ne mai ɗauke da alamomin da aka riga aka ƙirga. Irin waɗannan tebura suna da mahimmanci ga kasuwanci; suna ɗauke da bayanan da aka tattara bisa ga ƙa'idodin da aka bayar kuma suna sanya shi sauƙin shiga.

A tsarin gine-gine, PRDEFINED DERIVATIONS ba komai bane illa wani tauraron dan adam na wata cibiya. Shi, kamar tauraron dan adam na yau da kullun, ya ƙunshi maɓallin kasuwanci da ranar ƙirƙirar rikodin a cikin tauraron dan adam. Wannan shine inda kamanni ya ƙare, duk da haka. Ƙarin abun da ke ciki na halayen irin wannan tauraron dan adam "na musamman" an ƙaddara ta masu amfani da kasuwanci bisa ga mafi mashahuri, alamun da aka riga aka ƙidaya.

Misali, cibiya mai dauke da bayanai game da ma'aikaci na iya hada da tauraron dan adam mai alamomi kamar:

• Mafi ƙarancin albashi;
• Matsakaicin albashi;
• Matsakaicin albashi;
• Jimlar yawan ma'aikatan da aka tara, da sauransu.

Yana da ma'ana a haɗa PRDEFINED DERIVATIONS a cikin teburin PIT na wannan cibiya, sannan zaka iya samun sassauƙan bayanai ga ma'aikaci a takamaiman kwanan watan da aka zaɓa.

GUDAWA

Kamar yadda aikin ya nuna, amfani da DATA VAULT ta masu amfani da kasuwanci yana da ɗan wahala saboda dalilai da yawa:

• Lambar tambayar tana da rikitarwa kuma tana da wahala;
• Yawan JOINs yana rinjayar aikin tambayoyin;
• Rubuta tambayoyin bincike na buƙatar ƙwararren masaniyar ƙirar ajiya.

Don sauƙaƙe samun damar bayanai, ana ƙara DATA VAULT tare da ƙarin abubuwa:

• PIT (maki a lokaci) tebur;
• Tables na GADO;
• SAFARKIN SANARWA.

Na gaba labarin Ina shirin gaya, a ganina, abu mafi ban sha'awa ga waɗanda ke aiki tare da BI. Zan gabatar da hanyoyi don ƙirƙirar tebur na gaskiya da tebur mai girma bisa DATA VAULT.

Abubuwan labarin sun dogara ne akan:

• a kan wallafe 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";
• Mataki na ashirin Data Vault Basics.

source: www.habr.com