Dab tsi yog database purging?
Dab tsi yog database purging?

Video: Dab tsi yog database purging?

Video: Dab tsi yog database purging?
Video: XENGYANG - NWS YOG DAB TSIS (WHAT'S MEANS) [Official Music Audio] 2024, Kaum ib hlis
Anonim

Kev tshem tawm yog tus txheej txheem ntawm freeing qhov chaw nyob rau hauv lub database los yog delete cov ntaub ntawv uas tsis tas yuav tsum tau los ntawm lub system. Cov tshem tawm txheej txheem tuaj yeem ua raws li lub hnub nyoog ntawm cov ntaub ntawv lossis hom ntaub ntawv. Txheej txheem Archive. Archiving yog cov txheej txheem ntawm thaub qab cov ntaub ntawv tsis siv neeg uas yuav raug tshem tawm thaum lub sijhawm tshem tawm txheej txheem.

Kuj paub, dab tsi yog cov ntaub ntawv purging hauv SQL Server?

Kev tshem tawm cov ntaub ntawv yog rho tawm cov ntaub ntawv uas koj tsis xav tau lawm. Hauv SQL Server 2000, los yog qhov tseeb hauv ib qho twg database system, thawj kauj ruam yog kom paub tseeb tias koj muaj ib daim qauv ntawm nws, vim hais tias tej zaum koj yuav xav rov qab rau ib hnub. Muaj ntau txoj hauv kev kom paub tseeb tias koj muaj daim ntawv luam ntawm koj tus kheej cov ntaub ntawv.

Ib yam li ntawd, kev tshem tawm ua dab tsi hauv Oracle? Thaum muab DROP TABLE nqe lus hauv Oracle , koj ua tau qhia cov PURGE kev xaiv. Cov PURGE kev xaiv yuav ntxuav lub rooj thiab nws cov khoom nyob ntawm seb lawv ua tsis tshwm nyob rau hauv lub recycle bin. Kev pheej hmoo ntawm kev qhia txog qhov PURGE kev xaiv yog uas koj yuav tsis muaj peev xwm rov qab tau lub rooj.

Tom qab ntawd, txoj haujlwm tshem tawm yog dab tsi?

Muaj nuj nqi. Tshem tawm ib lossis ntau dua hauj lwm nyob rau hauv cov kab lus teev tseg, suav nrog kev tshem tawm tus txoj haujlwm tso zis, thiab tshem tawm tag nrho cov kab ntawm nws los ntawm qhov system. Yog tias txoj hauj lwm yog nquag, tos kom nws ua tiav nws cov haujlwm tam sim no, ces tshem tawm nws los ntawm qhov system.

Dab tsi yog archive hauv database?

Cov ntaub ntawv khaws cia yog cov txheej txheem ntawm kev txav cov ntaub ntawv uas tsis nquag siv rau cov khoom siv sib cais kom khaws cia mus ntev. Cov ntaub ntawv cov ntaub ntawv muaj cov ntaub ntawv qub uas tseem ceeb rau lub koom haum lossis yuav tsum tau khaws cia rau yav tom ntej siv lossis kev tswj hwm kev ua raws li cov laj thawj.

Pom zoo: