Subsetting
Txo cov ntaub ntawv los tsim ib qho me me, tus neeg sawv cev ntawm cov ntaub ntawv sib raug zoo thaum tswj xyuas kev ncaj ncees
Kev Taw Qhia Subsetting
Subsetting yog dab tsi?
Txo tus naj npawb ntawm cov ntaub ntawv los tsim ib tus neeg sawv cev me me ntawm cov ntaub ntawv sib txheeb nrog kev khaws cia kev ncaj ncees
Vim li cas cov koom haum siv subsetting?
Ntau lub koom haum muaj qhov chaw tsim khoom nrog cov ntaub ntawv loj heev thiab tsis xav tau cov ntaub ntawv loj heev hauv qhov chaw sim tsis tsim khoom. Li no, database subsetting yog siv los tsim ib tug me me, sawv cev subset ntawm ib tug loj relational database nrog khaws cia referential kev ncaj ncees. Cov koom haum siv cov kev teeb tsa me me rau kev sim cov ntaub ntawv los txo cov nqi, ua kom nws tswj tau thiab txhim kho sai thiab kho.
Txo cov infrastructure thiab suav cov nqi
Cov ntaub ntawv ntau dhau tuaj yeem ua rau muaj kev tsim vaj tsev siab thiab kev suav cov nqi, uas tsis tsim nyog rau kev sim cov ntaub ntawv hauv qhov chaw tsis tsim khoom. Nrog subsetting peev xwm, koj tuaj yeem yooj yim tsim cov subsets me me ntawm koj cov ntaub ntawv los txo koj cov nqi.
Tswj tau cov ntaub ntawv xeem los ntawm testers thiab developers
Kev tswj cov ntaub ntawv loj loj hauv qhov chaw tsis tsim khoom tsim teeb meem rau cov neeg sim thiab cov tsim tawm. Cov ntaub ntawv me me thiab yog li tswj tau ntau dua cov ntaub ntawv xeem, ua kom muaj txiaj ntsig zoo rau kev sim thiab cov txheej txheem txhim kho, thaum kawg ua kom zoo rau tag nrho lub voj voog ntawm lub sijhawm thiab cov peev txheej.
Kev ntsuas cov ntaub ntawv ceev dua thiab kev saib xyuas
Cov ntaub ntawv me me ua kom yooj yim dua thiab yooj yim dua teeb tsa thiab kev saib xyuas ntawm qhov chaw sim tsis tsim khoom. Qhov no yog qhov tshwj xeeb tshaj yog nyob rau hauv complex IT toj roob hauv pes thiab thaum nquag hloov pauv hauv cov ntaub ntawv qauv xav tau kev hloov kho tshiab thiab kho tshiab kom ntseeg tau tias cov neeg sawv cev ntawm cov ntaub ntawv xeem.
Kev ntseeg ncaj ncees yog dab tsi thiab vim li cas nws tseem ceeb?
Referential kev ncaj ncees yog ib lub tswv yim hauv kev tswj cov ntaub ntawv uas ua kom muaj kev sib xws thiab raug ntawm cov ntxhuav hauv cov ntaub ntawv sib raug zoo. Kev lees paub ncaj ncees yuav ua kom ntseeg tau tias txhua tus nqi uas sib haum rau "Tus Neeg 1" ntawm "Table 1" sib raug rau tus nqi raug ntawm "tus neeg 1" hauv "Table 2" thiab lwm lub rooj sib txuas.
Kev tswj hwm kev ncaj ncees yog qhov tseem ceeb rau kev tswj xyuas kev ntseeg siab ntawm cov ntaub ntawv xeem hauv cov ntaub ntawv sib txheeb raws li ib feem ntawm qhov chaw tsis tsim khoom. Nws tiv thaiv cov ntaub ntawv tsis sib xws thiab xyuas kom meej tias kev sib raug zoo ntawm cov ntxhuav muaj txiaj ntsig thiab txhim khu kev qha rau kev sim thiab kev tsim kho software.
Cov ntaub ntawv xeem nyob rau hauv ib puag ncig kev sib raug zoo database yuav tsum khaws cia kev ncaj ncees rau kev siv tau. Kev tuav pov hwm kev ncaj ncees hauv qhov chaw tsis tsim khoom, xws li siv rau kev sim thiab kev tsim kho software, yog qhov tseem ceeb rau ntau yam:
Subsetting, tsis yooj yim li "tsuas yog rho tawm cov ntaub ntawv"
Subsetting tsis yooj yim li tsuas yog rho tawm cov ntaub ntawv, raws li tag nrho cov kab hauv qab thiab sab saud muaj feem cuam tshuam nrog cov rooj sib txuas yuav tsum tau muab faib ua feem kom khaws cia kev ncaj ncees. Subsetting xyuas kom meej tias tsis tsuas yog cov ntaub ntawv nyob rau hauv lub hom phiaj lub rooj yog deleted, tab sis kuj hais tias tej ntaub ntawv nyob rau hauv lwm yam kev sib txuas lus muaj feem xyuam rau cov deleted cov ntaub ntawv los ntawm lub hom phiaj lub rooj yog deleted. Qhov no ua kom ntseeg tau tias kev ncaj ncees ntawm kev xa mus thoob cov rooj, databases thiab cov tshuab tau khaws cia ua ib feem ntawm kev tshem tawm cov ntaub ntawv.
Txo cov ntaub ntawv ntim los ntawm kev tshem tawm "Tus Neeg X" los ntawm "Table Y", tag nrho cov ntaub ntawv ntsig txog "Tus Neeg X" hauv "Table Y" yuav tsum raug muab tshem tawm, tab sis kuj tseem yuav tsum tau muab tshem tawm tag nrho cov ntaub ntawv ntsig txog "Tus Neeg X" nyob rau hauv lwm cov dej ntws los sis nqes nqes (cov lus A, B, C thiab lwm yam) yuav tsum tau muab tshem tawm.
Txo cov ntaub ntawv ntim los ntawm kev tshem tawm "Richard" los ntawm "Cov Neeg Siv Khoom" lub rooj, tag nrho cov ntaub ntawv ntsig txog "Richard" hauv "Cov Neeg Siv Khoom" yuav tsum raug muab tshem tawm, tab sis kuj tseem muaj cov ntaub ntawv hais txog "Richard" nyob rau hauv lwm lub rooj sab saud lossis nqes nqes (cov lus them nqi, rooj teeb meem, Table Coverage thiab lwm yam) yuav tsum yog. tshem tawm.
Acros rooj
Subsetting ua haujlwm hla cov rooj
Nyob rau hauv databases
Subsetting ua haujlwm thoob plaws databases
Acros Systems
Subsetting ua haujlwm nyob rau hauv cov kab ke
Koj puas muaj lus nug?
Tham nrog peb tus kws tshaj lij
Kuv tuaj yeem siv sub-setting li cas?
Proportional subsetting
Koj tuaj yeem teeb tsa lub tshuab Syntho kom hloov pauv cov ntaub ntawv sib raug zoo thiab kom ntseeg tau tias tag nrho "cov rooj sib txuas" raug hloov raws li "Table Table".
- Lub hom phiaj: Cov neeg siv tuaj yeem txhais lub hom phiaj lub rooj raws li pib taw tes rau subsetting.
- Cov neeg siv tuaj yeem ua piv txwv txhais tau tias yuav hloov "Table Neeg Mob" rau 5% lossis rau 500k cov ntaub ntawv tsis yog 10.000k cov ntaub ntawv.
- Cov rooj sib txuas: Cov no yog tag nrho cov rooj sib txuas ncaj qha lossis tsis ncaj nraim rau "Table Table". Kev sib txuas ntawm cov rooj yuav ncaj qha, xws li lub hom phiaj cov lus teev cov kev ua xua uas hais txog cov neeg mob cov lus los ntawm kev sib raug zoo txawv teb chaws, lossis tsis ncaj, xws li lub hom phiaj lub rooj xa mus rau cov neeg mob lub rooj, uas tig mus rau lub tsev kho mob lub rooj.
- Subsetting xyuas kom meej tias tag nrho cov ntaub ntawv hais txog cov ntaub ntawv deleted nyob rau hauv lub "Patient Table" kuj yuav raug muab tshem tawm. Hauv qhov piv txwv, subsetting kom ntseeg tau tias nyob rau hauv ib qho "Txuas Table" tsuas yog cov ntaub ntawv uas cuam tshuam nrog 5% (500k recors) thiab tag nrho lwm cov ntaub ntawv ntsig txog 95% (10.000k - 500k = 9.500k cov ntaub ntawv) raug tshem tawm. los tsim ib tus neeg sawv cev me me ntawm cov ntaub ntawv sib raug zoo nrog kev khaws cia kev ncaj ncees
Subsetting raws li kev cai lag luam
Ntxiv rau qhov kev faib ua feem sib faib, qhov twg koj teev ib feem pua ntawm cov ntaub ntawv rho tawm, peb lub peev xwm siab heev tso cai rau koj los txiav txim siab cov pab pawg hom phiaj rau subsetting. Piv txwv li, koj tuaj yeem teev cov txheej txheem suav nrog lossis tsis suav nrog cov subsets tshwj xeeb, muab kev yooj yim dua thiab tswj cov txheej txheem rho tawm cov ntaub ntawv
- Cov neeg siv khoom hnub nyoog qis dua 60 xyoo thiab laus dua 30 xyoo thiab
- Als Txiv neej cov neeg muas zaub
Txuag koj cov ntaub ntawv qhia txog hluavtaws tam sim no!
- Cov ntaub ntawv hluavtaws yog dab tsi?
- Vim li cas cov koom haum siv nws?
- Tus nqi ntxiv cov ntaub ntawv hluavtaws cov neeg siv khoom
- Yuav pib li cas
