Isilungiselelo esingaphansi
Nciphisa amarekhodi ukuze udale isethi encane, emele yesizindalwazi esihlobene kuyilapho ugcina ubuqotho obuyinkomba
Isingeniso Isilungiselelo esingezansi
Kuyini ukusetha kabusha?
Nciphisa inani lamarekhodi ukuze udale isethi encane emele yedathabheyisi ehlobene enobuqotho obuyinkomba obulondoloziwe
Kungani izinhlangano zisebenzisa i-subsetting?
Izinhlangano eziningi zinezindawo zokukhiqiza ezinamanani amakhulu edatha futhi azifuni amanani amakhulu edatha ezindaweni zokuhlola ezingakhiqizi. Ngakho-ke, i-subsetting yesizindalwazi isetshenziselwa ukwakha isethi encane, emele yesizindalwazi esikhulu esihlobene esinobuqotho obuyinkomba obulondoloziwe. Izinhlangano zisebenzisa i-sub-setting yedatha yokuhlola ukunciphisa izindleko, ukuyenza ilawuleke kanye nokusetha nokugcinwa ngokushesha.
Yehlisa ingqalasizinda kanye nezindleko zokubala
Umthamo wedatha oweqile ungaholela kungqalasizinda ephezulu nezindleko zokubala, ezingadingeki kudatha yokuhlola ezindaweni ezingakhiqizi. Ngamakhono okusetha kancane, ungakwazi ukudala kalula amasethi amancane edatha yakho ukuze wehlise izindleko zakho.
Idatha yokuhlola elawulekayo ngabahloli nonjiniyela
Ukuphatha amavolumu amakhulu wedatha ezindaweni ezingakhiqizi kubangela izinselele kubahloli nonjiniyela. Idatha yokuhlola emincane futhi ngaleyo ndlela elawuleka kakhudlwana, eyenza kahle kakhulu izinqubo zokuhlola nezokuthuthuka, ekugcineni ithuthukise wonke umjikelezo ngokuya kwesikhathi nezisetshenziswa.
Ukusethwa nokugcinwa kwedatha yokuhlola okusheshayo
Umthamo wedatha emincane usiza ukusethwa okushesha futhi okuqonde kakhudlwana nokugcinwa kwezindawo zokuhlola ezingakhiqizi. Lokhu kusebenza ikakhulukazi ezindaweni eziyinkimbinkimbi ze-IT futhi lapho izinguquko ezivamile ezakhiweni zedatha zidinga ukubuyekezwa okujwayelekile nokuvuselela ukuze kuqinisekiswe ukumelela kwedatha yokuhlola.
Kuyini ubuqotho be-referensi futhi kungani bubalulekile?
Ubuqotho obuyireferensi umqondo ekuphathweni kwesizindalwazi oqinisekisa ukuvumelana nokunemba phakathi kwamathebula kusizindalwazi esihlobene. Ubuqotho bereferensi buzoqinisekisa ukuthi lonke inani elihambisana “noMuntu 1” kokuthi “Ithebula 1” lihambisana nenani elilungile “lomuntu 1” kokuthi “Ithebula 2” kanye nanoma yiliphi elinye ithebula elixhunyiwe.
Ukuphoqelela ubuqotho obuyinkomba kubalulekile ekugcineni ukwethembeka kwedatha yokuhlola kusizindalwazi esihlobene njengengxenye yezindawo ezingakhiqizi. Ivimbela ukungahambisani kwedatha futhi iqinisekisa ukuthi ubudlelwano phakathi kwamathebula bunenjongo futhi buthembekile ekuhlolweni okufanele nokuthuthukiswa kwesofthiwe.
Idatha yokuhlola endaweni egciniwe ehlobene kufanele igcine ubuqotho obuyinkomba ukuze busetshenziswe. Ukugcina ubuqotho obuyinkomba ezindaweni ezingakhiqizi, njengalezo ezisetshenziselwa ukuhlola nokuthuthukiswa kwesofthiwe, kubalulekile ngezizathu ezimbalwa:
Ukusetha okuncane, akulula njengokuthi "susa idatha"
Ukusetha okungaphansi akulula njengokusula idatha, njengoba wonke amathebula ahlobene ahlobene angezansi naphezulu kufanele ahlelwe ngokulinganayo ukuze kulondolozwe ubuqotho obuyinkomba. I-Subsetting iqinisekisa ukuthi akuyona idatha esethebula eliqondiwe kuphela esuswayo, kodwa futhi nokuthi noma iyiphi idatha kunoma yiliphi elinye ithebula elixhunyiwe elihlobene nedatha esusiwe kuthebula okuqondiwe liyasuswa. Lokhu kuqinisekisa ukuthi ubuqotho bereferensi kuwo wonke amathebula, isizindalwazi namasistimu kugcinwa njengengxenye yokususwa kwedatha.
Ukunciphisa ivolumu yedatha ngokukhipha “Umuntu X” kokuthi “Ithebula Y”, wonke amarekhodi ahlobene “Nomuntu X” kokuthi “Ithebula Y” kufanele asuswe, kodwa futhi wonke amarekhodi ahlobene “Nomuntu X” kunoma yiliphi elinye ithebula elihlobene elikhuphuka nomfula noma elehla nomfula (ithebula A, B, C njll.) kufanele futhi asuswe.
Ukunciphisa ivolumu yedatha ngokukhipha okuthi "Richard" kuthebula elithi "Amakhasimende"., wonke amarekhodi ahlobene no-“Richard” kuthebula “leKhasimende” kufanele asuswe, kodwa nawo wonke amarekhodi ahlobene no-“Richard” kunoma yiliphi elinye ithebula elihlobene nomfula noma ezansi nomfula (Ithebula Lokukhokha, Ithebula Lezigameko, Ithebula Lokubhekelela Umshwalense njll.) kufanele futhi kususiwe.
Acros amatafula
I-subsetting isebenza kuwo wonke amathebula
Ama-database e-Acros
Ukusetha okuncane kusebenza kuzo zonke izizindalwazi
Ama-Acros Systems
I-subsetting isebenza kuwo wonke amasistimu
Ingabe unemibuzo?
Khuluma nomunye wochwepheshe bethu
Ngingasisebenzisa kanjani isilungiselelo esingaphansi?
Isilungiselelo esingaphansi esilinganiselwe
Ungakwazi ukumisa i-Syntho Engine ukuze usethe kancane isizindalwazi esihlobene futhi uqinisekise ukuthi wonke “amathebula axhunyiwe” ahlelwa ngokususelwa “Kuthebula Eliqondisiwe”.
- Ithebula eliqondiwe: Abasebenzisi bangachaza ithebula eliqondiwe njengendawo yokuqala yokusetha okungaphansi.
- Abasebenzisi ngokwesibonelo bangachaza ukusetha "Ithebula Lesiguli" ku-5% noma kumarekhodi angu-500k esikhundleni samarekhodi angu-10.000k.
- Amathebula axhunyiwe: Lawa wonke amathebula axhunywe ngokuqondile noma ngokungaqondile “Kuthebula Eliqondisiwe”. Izixhumanisi phakathi kwamathebula zingase ziqonde, njengethebula eliqondiwe elibonisa izinto ezimelene nazo ezibhekisela etafuleni leziguli ngobudlelwano bokhiye bangaphandle, noma ngokungaqondile, njengetafula eliqondiwe elibhekisela etafuleni leziguli, lona elibhekisela etafuleni lesibhedlela.
- I-Subsetting iqinisekisa ukuthi wonke amarekhodi ahlobene nedatha esusiwe ku “Ithebula Lesiguli” nalo lizosuswa. Esibonelweni, isilungiselelo esingaphansi siqinisekisa ukuthi kunoma iyiphi “Ithebula Elixhunyiwe” kunedatha kuphela ehlobene ne-5% (amarekhodi angu-500k) kanye nokuthi yonke enye idatha ehlobene namarekhodi angu-95% (10.000k – 500k = 9.500k) ayasuswa. ukuze udale isethi encane emele isizindalwazi esihlobene esinobuqotho obuyinkomba obulondoloziwe
I-subsetting esekelwe emithethweni yebhizinisi
Ngokungeziwe kusilungiselelo esingaphansi esilinganiselwe, lapho ucacisa khona iphesenti lokukhishwa kwedatha, amandla ethu athuthukile akuvumela ukuthi ucacise iqembu eliqondiwe lokusetha okungaphansi. Ngokwesibonelo, ungacacisa imibandela yokufaka noma yokungafaki amasethi amancane athile, unikeze ukuguquguquka okukhulu nokulawula inqubo yokukhipha idatha.
- Amakhasimende angaphansi kweminyaka engama-60 nangaphezulu kweminyaka engama-30 futhi
- Als Male amakhasimende
Londoloza umhlahlandlela wakho wedatha wokwenziwa manje!
- Iyini idatha yokwenziwa?
- Kungani izinhlangano ziyisebenzisa?
- Inani elengeza amakesi eklayenti edatha yokwenziwa
- Ungaqala kanjani
