Yiziphi izitolo idatha design amaphethini
Context:Ukwakheka okuvela phansi kuya phezulu Ngokwe-bottom-up approach, izimakethe zedatha ziqale zakhiwe ukuze zinikeze imibiko kanye namakhono okuhlaziya izinqubo ezithile zebhizinisi. Lezi zimakethe zedatha zingase zihlanganiswe ukuze zenze indawo yokugcina idatha ephelele. Isakhiwo sebhasi yedatha yokugcina idatha ngokuyinhloko siyisicelo "sebhasi", iqoqo lezinhlaka ezihambisanayo namaqiniso ahambisanayo, okuyizinhlaka ezabiwe (ngendlela ethile) phakathi kwamaqiniso ezindaweni ezimbili noma ngaphezulu zedatha.  Ukwakheka okuvela phezulu kuye phansi Indlela ehlehlela phezulu yakhelwe kusetshenziswa imodeli yedatha yebhizinisi ejwayelekile. Idatha "ye-athomu", okungukuthi, idatha esezingeni eliphezulu kakhulu, igcinwa endaweni yokugcina idatha. I-data mart enobukhulu equkethe idatha edingekayo ngezinqubo ezithile zebhizinisi noma iminyango ethile yakhiwa kusuka endaweni yokugcina idatha.  Umklamo we-hybrid Indawo yokugcina idatha (i-DW) ivame ukufana nokwakhiwa kwehabhu ne-spokes. Izinhlelo ezindala ezondla indawo yokugcina impahla ngokuvamile zihlanganisa ukuphathwa kobudlelwano bamakhasimende nokuhlelwa kwezinsiza zebhizinisi, okudala inani elikhulu lemininingwane. Ukuze kuhlanganiswe lezi zindlela ezahlukene zedatha, futhi kube lula inqubo yokulayisha ukuguqulwa kokukhipha, izindawo zokugcina idatha zivame ukusebenzisa isitolo sedatha esisebenzayo, imininingwane evela kuyo ihlaziywa ibe yi-DW yangempela. Ukuze kuncishiswe ukusetshenziswa kwemininingwane ngokweqile, amasistimu amakhulu ngokuvamile agcina imininingwane ngendlela evamile. I-data marts yemibiko ethile ingase yakhiwe phezu kwesitolo sedatha.  I-hybrid DW database igcinwa kwifomu lesithathu elijwayelekile ukuqeda ukubuyiswa kwedatha. Nokho, i- relational database evamile, ayisebenzi emibikweni yezobunhloli kwezamabhizinisi lapho imodeli yobukhulu igcwele khona. Izitolo ezincane zedatha zingathenga idatha kusuka endaweni yokugcina idatha ehlanganisiwe futhi zisebenzise idatha ehlungiwe, ethize yamatafula amaqiniso nezilinganiso ezidingekayo. I-DW ihlinzeka ngomthombo owodwa wolwazi i-data marts engafunda kuwo, ihlinzeka ngolwazi oluningi lwebhizinisi. Ukwakhiwa kwe-hybrid kuvumela i-DW ukuba ithathelwe indawo yindawo yokugcina imininingwane yokuphathwa kwedatha lapho ulwazi olusebenzayo (hhayi static) lungahlala khona.  Izingxenye zokumodela i-vault yedatha zilandela ukwakheka kwehabhu nezikhonkwane. Lesi sitayela sokumodela siyindlela yokwakheka eyingxube, equkethe imikhuba emihle evela kuzo zombili ifomu elijwayelekile lesithathu kanye nesikimu sezinkanyezi. Imodeli yedatha ye-vault akuyona ifomu elijwayelekile lesithathu, futhi iphula eminye yemithetho yayo, kodwa iyisakhiwo esivela phezulu kuya phansi esinokwakheka okuvela phansi kuya phezulu. Imodeli ye-data vault yenzelwe ukuba ibe indawo yokugcina idatha kuphela. Akuhloselwe ukuba kufinyeleleke kumsebenzisi wokugcina, okuthi, uma sekwakhiwe, kusadinga ukusetshenziswa kwendawo yokuthengisa idatha noma indawo yokukhishwa kwesikimu sezinkanyezi ngezinhloso zebhizinisi.
* Indlela Evela Phansi Iya Phezulu: Ukusekela