vistaraniy sathavan engine

extensible storage engine (eae. ess. eae.), jyala jett blue asehi mhanatat, heey microsoftche aay. ess. aii. emm. (anukramit anukramik pravesh paddhat) deta storage tantradnyan aahe. eae. ess. eae. haah microsoft exchange server, sakriy nirdeshika aanee windows shodh yancha gabha aahe. windows update client aanee madat aanee samarthan kendrasah anek windows ghatkandware dekhil yacha vapar keela jaato. anukramit aanee anukramik praveshadvare deta sanchayit aanee punarprapt karnyasathi anuprayoganna parvanagi dene haah tyacha uddesh aahe.
eae. ess. eae. vyavharit mahitee adyayavat aanee punarprapti pradan karate. crash punarprapti yantrana pradan kelee jaate jenekarun pranali crash jhalyas dekhil deta susangatata rakhali jaate. eae. ess. eae. madheel vyavhar heey atyant samvarti asatat, jyamule eae. ess. eae. heey server anuprayogansathi yogya tharate. uchch karyakshamatechya detamadhye pravesh sunishchit karnyasathi eae. ess. eae. mahitee husharine sanchayit karate. yavyatirikt, eae. ess. eae. halake aahe jyamule teey sahayyak anuprayogansathi yogya aahe.
eae. ess. eae. runtime (eae. ess. eae. tii.).dii. ell. ell.) windows 2000 pasoon pratyek vindo rilijmadhye pathvanyat aale aahe, windows ex. pii. chya x64 aavrutyansah eae. ess. eae. runtime shipingchya mool x64 aavruttisah aanee windows server 2003. microsoft exchange, 2003 paryant keval 32-biit aavruttisah pathvanyat aale, kaaran teey ekmev samarthit vyaspeeth hote. 2007 chya exchanges, tee 64-biit aavruttisah pathavali jaate.
databases.
databases haah detacha bhautik aanee tarkik gut aahe. eae. ess. eae. databases vindosathi ekach filesarkha disato. antargatpane databases haah 2,4,8,16 kinwa 32 keey. bii. prushthancha sangrah aahe (16 aanee 32 keey. bii. prushth paryay keval windows 7 aanee exchange 2010 madhye upalabdh aahet), jeey santulit bii-trii sanrachanet mandanyat aale aahet. yaa prushthanmadhye detabasemadhye asalelya detache varnan karnyasathi meta-deta, deta swatach, detachya manoranjak kramanna kayam thevanyasathi anukramanika aanee itar mahitee asate. hii mahitee databases filemadhye misalali jaate parantu ektritpane vaparleli mahitee detabasemadhye ektrit thevanyache prayatna kele jaatat. eae. ess. eae. detabasemadhye 8 kilobite aakarachya prushthansathi 232 prushthe kinwa 16 terrabyte deta asoo shakato.
eae. ess. eae. databases heey instains navachya gatanmadhye sanghatit kele jaatat. bahutek anuprayog ekach udaharan vapartat, parantu serve anuprayog anek udaharane dekhil vaparu shakatat. yaa udaharanache mahatva asey aahe qee teey ekach punarprapti logg malikes eka kinwa adhik databaseshi jodate. sadhya, konatyahi velee 6 vaparkartyanchi databases eae. ess. eae. udaharanala jodaleli asoo shakatat. eae. ess. eae. chaa vapar samadhan pratyek vegalya prakriyet 1024 eae. ess. eae. chya ghatana asoo shakatat.
databases portable aahe jyamadhye too eka chaloo asalelya eae. ess. eae. udaharanapasun vegala keela jaau shakato aanee nantar tyach kinwa vegalya chaloo udaharanala jodala jaau shakato. vegale kartana, manak vindo upayuktata vaparoon detabesachi nakkal kelee jaau shakate. databases sakriyapane vaparla jaat asatana tyachi nakkal kelee jaau shakat nahee kaaran eae. ess. eae. databases fayali keval ughadate. vindojdware thet sambodhit karata yenyajogi aay/oo operationsasathi samarthit asalelya konatyahi upkarnavar databases pratyakshapane rahoo shakato.
table.
table haah nondincha eksandh sangrah aahe, jyamadhye pratyek nondit stambhancha samaan sanch asato. pratyek table eka tablechya navadvare olakhale jaate, jyachi vyapti table asalelya detabesashi sambandhit aahe. detabasemadhil tablela vatap kelelya disk jaageche praman heey jevha creatable operations table tayar kele jaate tevha dilelya parameterdware nirdharit kele jaate. deta nirmitila pratisad mhanoon saranya aapoaap vadhatat.
tablemadhye eka kinwa adhik anukramanika asatat. nond kelelya mahitisathi kiman eka samooh nirdeshank asane aavashyak aahe. jevha anuprayogadvare konatahi samooh nirdeshank paribhashit keela jaat nahee, tevha eka krutrim nirdeshank vaparla jaato joou nondi antarbhutichya kalkramanusar nondi karato. nirdeshankanchi vyakhya mahitichya manoranjak kramanna tikavoon thevanyasathi kelee jaate aanee anukramanika kramanusar nondinmadhye anukramik pravesh aanee anukramanika stambh mulyandware nondinmadhye thet pravesh yaa donhi goshtinna anumati dete. eae. ess. eae. madheel samoohbaddha anukramanika dekhil prathamik asane aavashyak aahe, mhanje anukramanika killi adviteey asane aavashyak aahe.
bii + vrukshancha vapar karoon samoohbaddha aanee samoohbaddha nasaleli anukramanika darshavili jaatat. jarr ekhadya incert kinwa adyayavat operationmule prushth overflo jhaale tarr prushth vibhajit kele jaateh eka naveen prushth vatap kele jaate aanee purvichya done sanlagn prushthanmadhye tarkikdrushtya sakhalibaddha kele jaate. heey naveen prushth tyachya tarkik tarkik pratyaksh sanlagn naslyamule, tyat pravesh karane titke karyaksham nahee. eae. ess. eae. madhye eka online sampidan vaishishtya aahe jeey deta punha sampidit karate. jarr ekhade table varanvar adyayavat kele jaane apekshit asel, tarr table kinwa nirdeshank tayar kartana yogya prushth ghanata nirdisht karoon bhavishyatil samavishtinsathi jaaga rakheev thewali jaau shakate. yamule vibhajan karye talhata yetat kinwa pudhe dhakalata yetat.
nondi aanee stambh.
nondi haah stambh mulyancha sambandhit sanch asato. nondi adyayavat karyandvare samavisht kelya jaatat aanee adyayavat kelya jaatat aanee hatavanyachya karyandvare hatavalya jaau shakatat. stambh anukrame sanch stambh aanee punarprapt stambhanchya karyandvare sanchayit aanee punarprapt kele jaatat. dirgh moolya stambh vagalata 8 kilobite prushthansathi nondicha kamal aakar 8110 bites aahe. dirgh majkoor aanee dirgh dviaadhari stambhanche prakar yaa aakar maryadet lakshaniy yogdan dett naheet aanee jevha deta dirgh mulyachya stambhanmadhye sangrahit keela jaato tevha nondi databases prushthachya aakarapeksha khoop motha deta dharan karoo shakatat. jevha dirgh moolya sandarbh nondinmadhye sathavala jaato, tevha keval 9 biteschee nond-mahitee aavashyak asate. hii lamb moolye swatah 2 gigabyte (gb) paryant aakarachi asoo shakatat.
nondi samanyatah eksaman asatat, kaaran pratyek nondimadhye stambhanchya samaan sanchasathi mulyancha sanch asato. eae. ess. eae. madhye, tablesathi anek stambh paribhashit karane dekhil shakya aahe, aanee tarihi dilelya konatyahi nondit keval qamee sankhyetil naun-null stambh moolye asatat. yaa arthane, table heey vividh prakarchya nondincha sangrah dekhil asoo shakate.
eae. ess. eae. heey 1-biit teey 2 jibiparyantchya aakarachya stambh mulyanchya vistrut shrenila samarthan dete. stambhancha yogya prakar nivadane mahatvache aahe kaaran stambhancha prakar anukramanikesathichya kramvarisah tyache anek gunadharm nirdharit karato. khaleel deta prakaranna eae. ess. eae. dware samarthan dile jaateh
nishchit, badalanare aanee tagg kelele stambh.
pratyek eae. ess. eae. table 127 nishchit lambiche stambh, 128 chull lambiche stambh aanee 64,993 tagg kelele stambh paribhashit karoo shakate.
dilelya taktyasathi, stambh donpaiki eka shreneet yetatah jeey ektar pratyek nondinmadhye agadi ekdach ghadatat, kadachit kahee shoonya moolyansah; aanee jeey kvachit ghadatat kinwa jyanchya ekach nondit anek ghatana asoo shakatat. nishchit aanee chull stambh purvichya shreniche aahet, tarr tagg kelele stambh nantarche aahet. done stambh shreninche antargat pratinidhitva vegale aahe aanee stambh shreninmadhil paraspar vinimay samajoon ghene mahatvache aahe. jaree ghataneche moolya shoonya asale tarihi, pratyek nondit samanyatah nishchit aanee chull stambh darshavile jaatat. yaa stambhanna offset tabledware twarit sambodhit kele jaau shakate. tagg kelelya stambhanchya ghatananchya aadhi stambh olakhakarta asato aanee stambh dwaitidware tagg kelelya stambhanchya sanchamadhye shodh ghet asato.
lamb moolye.
stambhanche lamb majkurache prakar aanee lamb dviaadhari heey mothya dviaadhari vastoo aahet. teey lamb moolya id aanee bite offsetdware qee kelelya samoohit nirdeshankapasun vegalya bii + treamadhye sangrahit kele jaatat. eae. ess. eae. yaa stambhansathi parishisht, bite shreni adhilekhan aanee aakar nishchit karnyas samarthan dete. tasech, eae. ess. eae. madhye ekach instance stoar vaishishtya aahe jithe anek nondi ekach mothya dviaadhari vastoocha sandarbh deu shakatat, janoo pratyek nondichi mahitichi swatachi prat asel, mhanje.eae. aantar-nond lock sangharshanshivay. lamb majkuracha kinwa lamb dviaadhari stambh mulyacha kamal aakar 2 gb aahe.
aavrutti, swatah vaadh aanee escro stambh.
pratyek velee jevha haah stambh asalelya nondimadhye adyayavat operationdware sudharana kelee jaate tevha aavrutti stambh svayamchalitapane eae. ess. eae. dware vadhavale jaatat. haah stambh anuprayogadvare nishchit keela jaau shakat nahee, parantu keval vachata yeto. aavrutti stambhanchya anuprayoganmadhye dilelya nondichi inn-memory prat refresh karane aavashyak aahe qee nahee heey nirdharit karnyasathi vaparnyacha samavesh aahe. jarr table recordmadheel moolya cashey kelelya pratitil mulyapeksha jaast asel tarr cashey keleli prat kalbahya asalyache dnyat aahe. aavrutti stambh prakarane lamb asavet.
svayanchalit vadhiche stambh svayamchalitapane eae. ess. eae. dware asha prakare nishchit kele jaatat qee stambhatil moolya tablemadhil pratyek nondinsathi adviteey asate. heey stambh, aavrutti stambhansarkhe, anuprayogadvare nishchit kele jaau shakat naheet. svayanchalit vadhiche stambh keval vachale jaatat aanee adyayavat operationdware tablemadhye naveen reecord ghatale jaate tevha teey svayamchalitapane seet kele jaatat. stambhatil moolya nondichya aayushyasathi sthir rahate aanee pratyek tablever keval eka svayanchalit vadhichya stambhala parvanagi aahe. svayanchalit vadhiche stambh heey lamb kinwa prakarchya chalanache asoo shakatat.
escro collum escroapdate operationdware sudharit kele jaau shakatat. escro kelele adyatane hii sankhyatmak delta operations aahet. escro stambh lamb prakarche asavet. sankhyatmak delta operationschya udaharananmadhye moolyat 2 jodane kinwa moolyatoon 1 vaja karane samavisht aahe. eae. ess. eae. adyayavatchya antim mulyaivaji mulyatil badalacha magova gheto. anek satranmadhye escroapadetdware ekach mulyasathi kelele pratyekat thakbaki badal asoo shakatat kaaran konate vyavhar hotat aanee konate vyavhar mage ghetale jaatat yachee parva naan karata eae. ess. eae. vastavik antim moolya nirdharit karoo shakate. yamule anek vaparkartyanna sankhyatmak delta badal karoon ekach velee stambh adyayavat karanyachi parvanagi milate. paryayipane, databases engine stambhachya shoonya mulyachya nondi mitvoo shakate. asha escro stambhasathi eka samanya vapar mhanje sandarbh counterh anek dhage kulupanshivay moolya vadhavtat/qamee karatat aanee jevha counter shunyavar pohochato, tevha reecord aapoaap hatavala jaato.
anukramanika.
nirdeshank mhanje taktyatil nondinchi satatyapurn kramvari. anukramanika paribhashit kramanusar olinmadhye anukramik pravesh aanee anukramit stambh mulyanvar aadharit thet nond navigation yaa donhisathi vaparlya jaatat. nirdeshankadware paribhashit kelelya kramache varnan stambhanchya shrenichya drushtine, pradhanyachya kramane kele jaate. stambhanchya yaa shrenila anukramanika killi dekhil mhanatat. pratyek stambhala anukramanika vibhag mhanatat. pratyek nirdeshank vibhag tyachya kramvarit yogdananusar ektar chadhatya kinwa utaratya asoo shakato. taktyasathi kitihi anukramanika paribhashit kelya jaau shakatat. eae. ess. eae. anukramanika vaishishtyancha eka samruddha sanch pradan karate.
samoohbaddha anukramanika.
eka nirdeshank samoohbaddha kinwa prathamik nirdeshank mhanoon nirdisht keela jaau shakato. eae. ess. eae. madhye, samoohit nirdeshank adviteey asane aavashyak aahe aanee tyala prathamik nirdeshank mhanoon sambodhale jaate. itar nirdeshankanche varnan samooh nasalele kinwa duyyam nirdeshank mhanoon kele jaate. prathamik nirdeshank duyyam nirdeshankanpeksha vegale asatat, kaaran nirdeshank nond hii swatah nond asate, aanee nondis tarkik nirdeshak nasate. prathamik nirdeshankatil nondishi tarkikaritya jodanyasathi duyyam anukramanikanchya pananvar prathamik killi asatat. aahe shabdant, table bhautikdrushtya prathamik nirdeshank kramane samoohbaddha aahe. prathamik nirdeshank kramanusar anukramanikevina nond keleli mahitee punarprapt karane heey samanyatah duyyam nirdeshank kramanusar kramanusar aakadevaripeksha barech jalad asate. yache kaaran asey qee ekach disk pravesh memarimadhye anek nondi aanoo shakato jyaa velevar jawalun pravesh kelya jaatil. samaan disk pravesh anek nond pravesh karye purn karato. tathapi, prathamik nirdeshank kramane nirdharit kelyapramane, nirdeshankachya madhyabhagi nond samavisht karane, nirdeshankachya shevati jodanyapeksha khoop haloo asoo shakate. tablechi rachana kartana punarpraptichya namunyanviruddha adyayavat varanvartecha kaljipurvak vichar karane aavashyak aahe. jarr taktyasathi konatahi prathamik nirdeshank paribhashit keela gela nasel, tarr databases qee (dii. bii. keey.) nirdeshank navacha eka antarnihit prathamik nirdeshank tayar keela jaato. dii. bii. keey. hii fakt eka adviteey chadhati sankhya aahe jee pratyek velee nond samavisht kelee jaate. parinami, dii. bii. keey. nirdeshankatil nondincha bhautik kram kalkramanusar samavisht kram asato aanee naveen nondi nehmi taktachya shevati jodalya jaatat. jarr ekhadya anuprayogala adviteey nasalelya nirdeshankavar mahitee gola karayachi asel, tarr adviteey nasalelya nirdeshank vyakhyechya shevati svayanchalit stambh jodoon heey shakya aahe.
bahu-moolya stambhanvar anukramanika.
bahu-moolya stambhanvar anukramanika paribhashit kelya jaau shakatat. anukramit stambhasathi anek moolyansah nondinsathi yaa anukramanikanmadhye anek nondi astitvat asoo shakatat. bahu-moolya stambh ekach moolya stambhanchya sanyogane anukramit kele jaau shakatat. jevha done kinwa adhik bahu-moolya stambh ekatra anukramit kele jaatat, tevha bahu-moolya gunadharm keval nirdeshankatil pahilya bahu-moolya stambhasathi sanmanit keela jaato. qamee pradhanya stambhanna eka mulyasarkhe manale jaate.
viral nirdeshank.
anukramanika viral mhanoon dekhil paribhashit kelya jaau shakatat. viral anukramanikanmadhye taktyatil pratyek nondinsathi kiman eka nond nasate. viral nirdeshank paribhashit karnyasathi anek paryay aahet. jevha sampoorn anukramanika killi shoonya asate, jevha konatahi killi vibhag shoonya asato kinwa jevha fakt pahila killi vibhag shoonya asato tevha anukramanikemadhun nondi vagalanyasathi paryay astitvat asatat. anukramanikanmadhye sashart stambh dekhil asoo shakatat. heey stambh kadhihi nirdeshankat disat naheet parantu jevha sashart stambh ektar shoonya kinwa shoonya nasato tevha nondi anukramit houu shakat naheet.
tupal anukramanika.
majkurachya pratyek up-stringsathi kinwa majkurachya lamb stambhasathi eka nond samavisht karnyasathi anukramanika dekhil paribhashit kelya jaau shakatat. yaa anukramanikanna tupal anukramanika mhanatat. tyancha vapar up-taar vyakhyeshi andajansah prashnanna gatee denyasathi keela jaato. tupal anukramanika keval majkurachya stambhansathi paribhashit kelya jaau shakatat. udaharanarth, jarr majkurachya stambhache moolya 'mallah jett blue aavadate' asel aanee nirdeshank kiman 4 varnancha aakar aanee jastit jaast 10 varnanchi lambi asalelya tupalsathi sanrachit keela asel, tarr khaleel up-taar anukramit kelya jaatilah
jaree tupal anukramanika khoop mothee asoo shakatat, taree teey formchya prashnanna lakshaniy gatee deu shakatatah "jett blue" asalelya serve nondi shodha. shodh up-tarala jastit jaast tupal lambichya shodh taranmadhye vibhajit karoon aanee parinam chhedun, teey kamal tupal lambipeksha jaast lambichya up-taransathi vaparale jaau shakatat. teey jastit jaast tupal lambiparyant kinwa kiman tupal lambiitke lahan, anukramanika chhed naan karata, taransathi achook julanisathi vaparale jaau shakatat. eae. ess. eae. madhye anukramanika chhedanbindu karnyabaddal adhik mahitisathi anukramanika chhedanbindu pahaa. jithe shodh string kiman tupal lambipeksha lahan aahe, tithe tupal anukramanika prashnanna gatee deu shakat naheet.
vyavhar.
vyavhar heey prarambhik vyavhar aanee vachanbaddhata kinwa paratfedichya karyandvare maryadit kelelya prakriyeche tarkik ekak aahe. vyavharadarmyan keleli serve adyatane anoo asatat; tee serve ektar ekach velee detabasemadhye disatat kinwa ekahi disat nahee. itar vyavharandvare tyanantarchi konatihi adyatane vyavharasathi adrushya asatat. tathapi, vyavhar keval tyaa darmyan badallela deta adyayavat karoo shakato; anyatha pratiksha naan karata operation ekach velee ayashasvi hote. keval vachanyayogya vyavharanna kadhihi pratiksha karanyachi garaj nahee aanee vyavhar adyayavat karane heey keval ekmekanna vyavhar adyayavat karnyat hastakshep karoo shakate. jeey vyavhar rollbackdware kinwa pranali crashdware sampavale jaatat, teey detabesvar konatehi trace sodat naheet. sarvasadharanpane, deta sthitee prarambhik vyavharapoorvichya sthiteet parat parat parat kelee jaate.
vyavhar 7 staranparyant kele jaau shakatat, eka atirikt star antargat vaparasathi rakheev aahe. yacha arth assa qee sampoorn vyavhar mage ghenyachi garaj naan padata vyavharacha eka bhag mage ghetala jaau shakato; nested vyavharache vachanbaddhata keval prakriyechya eka tappyache yash darshavate aanee bahya vyavhar adyap ayashasvi houu shakato. jevha sarvat bahya vyavhar keela jaato tevhach badal detabesasathi vachanbaddha kele jaatat. yala vyavhar patali 0 kadey vachanbaddha karane asey mhanatat. jevha vyavhar patali 0 varr vachanbaddha hoto, tevha vyavharache varnan karnara deta logvar samkramitpane flush keela jaato jenekarun tyanantarchya pranali crashchya babatitahi vyavhar purn hoil yachee khatri kelee jaate. logg samkramitpane flush kelyane eae. ess. eae. vyavhar tikau hotat. tathapi, kahee prakarananmadhye anuprayog tyanchya adyayavat mahitichi magani karoo ichchito, parantu badal kele jaatil yachee twarit hummy dett nahee. yethe, anuprayog jett _ bitindexleziflus badal karoo shakatat.
eae. ess. eae. bahu-aavrutti navachya samvarti chalan niyantran yantranes samarthan dete. bahu-aavruttimadhye, pratyek vyavhar sampoorn databaseche satatyapurn drushya vicharato, jase vyavhar suru jhaala tyaa velee hote. tyala fakt tyane kelelya adyatane midatat. asha prakare, pratyek vyavhar asey chalate qee, lekhan sangharsh vagalata, pranalivar chalanara haah ekmev sakriy vyavhar aahe. aahe vyavharat aadhich adyayavat kelelya mahitichya aadhare vyavhar badaloo shakato, bahu-aavrutti swatach kramvari lavnyayogya vyavharanchi hummy dett nahee. tathapi, adyayavat mahitivar aadharit asalelya reed detache kulupband karnyasathi keval spasht reecord reed lockcha vapar karoon ichchit asalyas kramvari lavnyayogyata prapt kelee jaau shakate. gatelock operations vachan aanee lekhan donhi lockchi spashtapane vinanti kelee jaau shakate.
yavyatirikt, escro locking mhanoon olakhale jaanare pragat samvarti niyantran vaishishtya eae. ess. eae. dware samarthit aahe. escro locking heey eka atyant samvarti adyayavat aahe jethe sankhyatmak moolya sapeksh paddhatine badalale jaate, mhanje.eae. dusare sankhyatmak moolya jodoon kinwa vaja karoon. escro adyatane agadi tyach detamvareel itar samvarti escro adyataneshi dekhil parasparvirodhi nasatat. heey shakya aahe kaaran samarthit karye parivartaneey aahet aanee swatantrapane vachanbaddha kinwa mage firavali jaau shakatat. parinami, teey samvarti adyayavat vyavharanmadhye hastakshep karat naheet. heey vaishishtya anekada rakhalelya ektrikaranasathi vaparale jaate.
eae. ess. eae. neey deta manipulation operationspasoon deta definition operationsparyant vyavhar shabdarthshastracha vistar keela aahe. tablever nirdeshank jodane aanee ekach velee chaloo asalele vyavhar konatyahi vyavhar lock vadashivay tyach tablemadhye adyayavat karane shakya aahe. nantar, jevha heey vyavhar purn hotat, tevha navyane tayar kelela nirdeshank serve vyavharansathi upalabdh asato aanee tyat itar vyavharanni kelelya nond adyayavat karnyasathi nondi asatat, jyaa adyayavat jhalya tevha nirdeshankachi upasthiti samajoo shakat naheet. nond adyayavat karnyasathi vyavhar yantranekadun apekshit asalelya serve vaishishtyansah deta definition operations kelee jaau shakatat. yaa paddhatimadhye samarthit deta definition operationsmadhye edcolum, deletcolum, creatindex, deletindex, creatitable aanee delete karnyayogya yancha samavesh hoto.
cursor navigation aanee coppy buffer.
cursor haah table indexmadhil tarkik nirdeshak asato. karsarla nondivar, pahilya nondipurvi, shevatchya nondinantar kinwa agadi nondinchya darmyan dekhil thewale jaau shakate. jarr cursor nondichya aadhi kinwa nantar thevalela asel, tarr sadhyachi nond nahee. ekach table nirdeshankat anek cursor asane shakya aahe. anek nondi aanee stambh karye karsarchya sthitivar aadharit asatat. karsarchi sthitee halavanyachya karyadvare kinwa shodh operations anukramanika killi vaparoon thet halavali jaau shakate. cursor dekhil nirdeshankat apurnank sthiteet halavale jaau shakatat. asha prakare, cursor patkan angatha pattichya sthiteet halavata yeto. hii shastrakriya shodh operationchya vegaitkach keela jaato. konatyahi hastakshep samadhan detamadhye pravesh karane aavashyak nahee.
pratyek karsarmadhye naveen nond tayar karnyasathi kinwa vidyaman nond, stambhanusar sudharit karnyasathi eka prat buffer asate. haah eka antargat buffer aahe jyachi samagri sanch stambhanchya karyansah badalali jaau shakate. coppy bufferche badal heey sanchayit kelela deta aapoaap badalat naheet. sadhyachya nonditil majkoor purvatayari operationcha vapar karoon coppy buffermadhye coppy keela jaau shakato aanee adyayavat operation coppy buffermadhil majkoor reecord mhanoon sathavatat. vyavharavar kinwa paratfedivar, tasech navigation operationsvar coppy buffer spashtapane saaf keela jaato. jarr eka astitvat asel tarr, ektar nonditoon kinwa prat buffermadhun stambh mahitee punarprapt karnyasathi punarprapt stambh vaparale jaau shakatat.
prashna prakriya.
eae. ess. eae. anuprayog nehmi tyanchya mahitichi chaukashi karatat. dastaivajacha haah vibhag eae. ess. eae. varr prashna miravanuk tarkshastra lihinyasathi anuprayogansathi vaishishtye aanee tantrache varnan karato.
prakar aanee tatpurati tabley.
eae. ess. eae. tatpuratya sarnyanchya swarupat kramvari lavnyachi kshamata pradan karate. anuprayog kramvarit eka velee eka nond nond prakriyet deta nondi samavisht karato aanee nantar kramvarit eka velee eka nond punarprapt karato. kramvari pratyakshat shevatchya nondichya antarbhav aanee pahilya nondichya punarprapti darmyan kelee jaate. tatpuratya saranya aanshik aanee sampoorn nikal sanchansathi dekhil vaparlya jaau shakatat. hii saranya aadhar sarnyansarkhich vaishishtye deu shakatat, jyat kramvarichya vyakhyeshi vyakhyeshi anukramanika killicha vapar karoon anukramane kinwa thet ranganmadhye navigate karnyachya kshamatecha samavesh aahe. guntaguntichya ektritanchya gananesathi tatpuratya saranya adyayavat dekhil kelya jaau shakatat. jethe ichchit samuchchay haah kramvari prakriyecha naisargik parinam aahe asha kramvarisarkhya vaishishtyasah sadhya samuhanchi ganana svayamchalitapane kelee jaau shakate.
anukramanika samavisht karane.
duyyam anukramanikanmadhun thet stambh mahitee punarprapt karane heey eka mahattvache karyapradarshan anukulan aahe. deta recordmadhye pravesh naan karata, punarprapt stambhanchya karyavaril punarprapt-prati-soochkank dhvajachya madhyamatoon, stambh duyyam anukramaniketun thet punarprapt kele jaau shakatat. anukramanikenusar navigate kartana, nondinpeksha duyyam nirdeshankatun stambh punarprapt karane adhik karyaksham aahe. jarr stambhatil mahitee nonditoon punarprapt kelee gelee asel, tarr prathamik killidware nond shodhanyasathi atirikt navigation aavashyak aahe. yamule diskmadhye atirikt pravesh houu shakato. jevha ekhada nirdeshank aavashyak asalele serve stambh pradan karato tevha tyala covering index mhanatat. lakshat ghya qee taktyat paribhashit kelele stambh prathamik nirdeshank duyyam anukramanikanmadhye dekhil aadhaltat aanee tyachpramane jett _ bitritrivefraumprimbrem vaparoon punarprapt kele jaau shakatat.
anukramanika killi samanyikrut swarupat sangrahit kelya jaatat jyaa anek prakarananmadhye mool stambh mulyanusar vinamulya kelya jaau shakatat. samanyikaran nehmich ulat karata yenyajoge nasate. udaharanarth, majkoor aanee dirgh majkurachya stambhanche prakar vinamulya kele jaau shakat naheet. yavyatirikt, jevha stambh mahitee khoop lamb asate tevha anukramanika killi kapalya jaau shakatat. duyyam anukramaniketun stambh thet punarprapt karata yet naheet asha prakarananmadhye, aavashyak deta punarprapt karnyasathi nond nehmi pravesh keela jaau shakato.
nirdeshank aantarchhed.
prashnanmadhye anekada mahitivaril nirbandhanche sanyojan samavisht asate. upalabdh nirdeshank vaparane heey nirbandhavar prakriya karnyache eka karyaksham sadhan aahe. tathapi, jarr ekhadya prashnamadhye anek nirbandhancha samavesh asel tarr anuprayog bahutekda ekach nirdeshankane purn kelelya sarvat pratibandhatmak vidheykachya sampoorn nirdeshank shrenivar chaalat nirbandhanvar prakriya karatat. avashisht vidhey mhanoon olakhalya olakhalya konatyahi urvarit vidheyavar, abhilekhavarach vidhey lagoo karoon prakriya kelee jaate. hii eka sopee paddhat aahe parantu avashisht vidhey lagoo karnyasathi smrutimadhye nondi aananyasathi anek disk pravesh karanyachi shakyata aahe.
anukramanika chhedanbindu hii eka mahattvachi prashnapranali aahe jyamadhye jatil nirbandhanvar adhik karyakshamatene prakriya karnyasathi anek anukramanika ekatra vaparlya jaatat. keval ekach nirdeshank vaparnyaivaji, anek nirdeshankanvaril nirdeshank shreni ektrit kelya jaatat, parinami nondi khoop qamee pramanat tayar hotat, jyavar konatehi avashisht vidhey lagoo kele jaau shakate. eae. ess. eae. heey aantarchhed operation puravun sope karate. heey operation tyach tablemadhun anukramanikanvaril anukramanikanchya shreni swikarte aanee prathamik killichi tatpurati sarani parat karate jee serve nirdeshank andajanche samadhan samadhan bases table recordver navigate karnyasathi vaparali jaau shakate.
purv-sanlagn table.
join heey samanyikrut table designveril eka samanya operation aahe, jithe tarkikdrushtya sambandhit deta anuprayogat vaparnyasathi punha ekatra aanala jaato. join karane heey mahagade operation asoo shakate kaaran sambandhit deta memarimadhye aananyasathi anek deta praveshanchi aavashyakta asoo shakate. done kinwa adhik tarkik sarnyansathi deta asalelya ekach aadhar saranichi vyakhya karoon kahee prakarananmadhye haah prayatna anukool keela jaau shakato. aadhar saranicha stambh sanch haah yaa tarkik sarnyanchya stambh sanchancha sangam aahe. tagg kelele stambh heey tyanchya bahu-moolya aanee viral moolya asalelya detachya changlya hatalanimule shakya karatat. sambandhit mahitee ekach nondit ekatra sathavali jaat asalyane, tee ekatra pravesh kelee jaate jyamule jodani karnyasathi disk praveshanchi sankhya qamee hote. hii prakriya mothya sankhyene tarkik sarnyanparyant vistarli jaau shakate kaaran eae. ess. eae. 64,993 tagg kelelya stambhanna aadhar deu shakate. anukramanika bahu-moolya stambhanvar paribhashit kelya jaau shakatat, tarihi 'aateel' saranya anukramit karane shakya aahe. tathapi, kahee maryada aahet aanee heey tantra vaparnyapurvi anuprayoganni purv-jodanyacha kaljipurvak vichar keela pahije.
logg aanee crash punarprapti.
eae. ess. eae. chey logg aanee punarprapti vaishishtya pranali crash jhalyas detachi khatrishir akhandata aanee susangatatela samarthan dete. logg karane hii logg filemadhye databases adyayavat karye anavshyakpane nondavanyachi prakriya aahe. logg filechi rachana pranali crash honyachya viruddha khoop majboot aahe. punarprapti hii pranali crash jhalyanantar databases susangat sthiteet punarsanchayit karnyasathi haah logg vaparanyachi prakriya aahe.
vyavhar karye logg kelee jaatat aanee pratyek vyavhar patali 0 paryantchya pratibaddhatechya darmyan logg discover flush keela jaato. yamule punarprapti prakriyela vyavhar patali 0 paryantchya vyavharandvare kelelya adyatane punha karanyachi aanee vyavhar patali 0 paryant naan kelelya vyavharandvare kelele badal purvavat karanyachi parvanagi milate. yaa prakarchya punarprapti yojanela anekada 'roll-forward/roll-backward' punarprapti yojana mhanoon sambodhale jaate. khalee varnan kelelya backup prakriyedvare deta surakshitpane coppy hoiparyant logg rakhoon thewale jaau shakatat kinwa system crashpasoon punarpraptisathi logchi aavashyakta bhasalyashivay lagechach golakar paddhatine punha vaparale jaau shakatat. golakar logging logsathi aavashyak asalelya disk jaageche praman qamee karate parantu madhyam ayashasvi jhalyas deta sthitee punha tayar karnyachya kshamatevar parinam hoto.
backup ghya aanee punarsthapit qaraa.
logg inn karane aanee punarprapti karane dekhil madhyamanchya apayshapasun detache sanrakshn karnyat bhoomika bajavate. jithe eka kinwa adhik detabesachi nakkal kelee jaate, tasech logg fayali asha prakare aadhar detat jyamule detabesachya karyavar parinam hott nahee. backup ghet asatana detabesachi chaukashi aanee adyayavat karane suru thevata yete. backupla 'fuzzy backup' mhanoon sambodhale jaate kaaran detabesacha satatyapurn sanch punarsanchayit karnyasathi backup punarsanchayanacha bhag mhanoon punarprapti prakriya chalvane aavashyak aahe. pravahit aanee chhaya prat backup donhi samarthit aahet.
streaming backup hii eka backup paddhat aahe jithe backup prakriyedarmyan serve ichchit databases fayali aanee aavashyak logg fayalichya pratee tayar kelya jaatat. filechya pratee thet tepmadhye jatan kelya jaau shakatat kinwa itar konatyahi sathavan upkarnavar kelya jaau shakatat. pravahit backups konatyahi prakarchya kriyakalapanna shant karanyachi aavashyakta nahee. backup prakriyedarmyan deta sanchamadhye konatehi deta bhrashtata astitvat naheet yachee khatri karnyasathi databases aanee logg fayali donhi tapasalya jaatat. pravahit backup heey vadhiv backup dekhil asoo shakatat. vadhiv backup mhanje jyachyadvare keval logg fayali coppy kelya jaatat aanee jyaa serve databases alikadchya sthiteet aananyasathi mageel purn backups punarsanchayit kelya jaau shakatat.
chhaya prat backup hii eka naveen uchch gatee backup paddhat aahe. chhaya prat backup heey natyamayaritya jalad asatat kaaran arj shant karnyachya thodya kalavadhinantar prat aksharshah tayar kelee jaate. jasjase detachi pudhil adyatane kelee jaatat, tastashi aabhasi prat pratyakshat yete. kahee prakarananmadhye, chhaya prat backupsathi hardware samarthan mhanje pratyakshat aabhasi pratee jatan karane anavashyak aahe. chhaya prat backup nehmich purn backup asatat.
punarsanchayit karnyacha vapar ekach backup lagoo karnyasathi keela jaau shakato kinwa tyacha vapar eka kinwa adhik vadhiv backups ekach purn backupche sanyojan lagoo karnyasathi keela jaau shakato. pudhe, konatyahi vidyaman logg fayali punha chalavalya jaau shakatat tasech vyavhar patali 0 shhee vachanbaddha asalelya shevatchya vyavharaparyant sampoorn deta sanch punha tayar karnyasathi. mool anuprayogala samarthan denyas saksham asalelya konatyahi pranalimadhye backupchi punarsthapana kelee jaau shakate. teey samaan yantra kinwa samaan yantra sanrachana asanyachi garaj nahee. punarsthapana prakriyecha bhag mhanoon fayalinche sthan badalale jaau shakate.
backup ghya aanee vegvegalya yantrasamagrivar punarsanchayit qaraa.
jevha essent databases tayar keela jaato, tevha bhautik disk kshetracha aakar databases sangrahit keela jaato. bhautik kshetracha aakar satranmadhye susangat rahane apekshit aahe; anyatha, truti nondavali jaate. jevha ekhadya bhautik driveche pratirupan kele jaate kinwa drive pratimevarun vegalya bhautik kshetra aakaracha (pragat swaroop drive) drive) drivemadhye punarsanchayit kele jaate, tevha essent truti nondwell.
hii eka dnyat samasya aahe aanee microsoftkade garam durustya upalabdh aahet. windows vista kinwa windows server 2008 sathee keey. bii. 2470478 pahaa. windows 7 kinwa windows server 2008 2008 sathee keey. bii. 982018 pahaa.
itihas.
jett blue haah moolatah microsoftney microsoft accessmadhye jett reed databases enginesathi sambhavya sudharana mhanoon vikasit keela hota, parantu yaa bhoomiket kadhihi vaparla gela nahee. tyaeivaji, tyacha vapar exchange server, sakriy nirdeshika, file pratikruti seva (eff. aar. ess.), suraksha sanrachana sampadak, pramanpatra seva, windows internet naav seva (vijay) aanee itar microsoft seva, anuprayog aanee windows ghatak yandware keela gela. anek varshanpasun, hii keval microsoftdware vaparali jaanari khajgi api hotee, parantu tevhapasoon tee prakashit api bunley aahe jee konihi vaparu shakate.
march 1989 madhye jevha elon punha microsoftmadhye sameel jhaala tevha deta exes enginever (dii. aii. eae.) kaam suru jhaale. pudhil varshat chaar vikasakanchya chamoone elansathi mothya pramanat isam purn karnyasathi kaam kele. microsoftkade aadhich bii. see. 7 aay. ess. aii. emm. (jett reed) hote, parantu tatkalin naveen client-server architecture kshetrat pravesh mhanoon adhik majboot databases engine tayar karnyasathi deta exes engine (dii. aii. eae.) chaa prayatna suru keela. 1990 chya vasant rutumadhye, bii. see. 7 aay. ess. aii. emm. aanee day. tii. eae. sangh sanyukt engine tantradnyan (jett) prayatna honyasathi sameel jhaale; jhaale; (jett reed) aanee aanee (jett blue) yaa done enginanchya nirmitisathi jababdar, jeey samaan api tapashilanshi (jett api) susangat asateel. israyalachya dhvajachya rangasathi day haah jett nila jhaala. russiachya dhvajachya rangasathi bii. see. 7 isam heey jett reed jhaale. jett blue aanee jett reed ekach api tapashilanusar lihile gele hote, parantu tyanni konatahi aisam code samayik keela nahee. tyanni cuset yaa samanya kweri processorla samarthan dile, joou nantar bii. see. 7 aay. ess. aii. emm. saha jett redcha samanarthi banala.
jett blue pahilyanda 1994 madhye windows aine. tii. 3.5 madheel vijay, dii. etch. see. pii. aanee aata bund jhalelya aar. pii. ell. sevansathi aay. ess. emm. mhanoon pathvanyat aale. 1996 madhye teey microsoft exchangesathi storage engine mhanoon punha pathvanyat aale. atirikt windows sevanni tyanche storage tantradnyan mhanoon jett blue nivadle aanee 2000 paryant vindochi pratyek aavrutti jett blues pathvanyas suruvat jhaali. jett blue sakriy nirdeshikedware vaparla jaat asey aanee too vishvasaniy sanganakeey aadhar (tii. see. bii.) navachya vindo kodachya vishesh sanchacha bhag banala. jett blue vaparnare microsoft anuprayoganchi sankhya vadhatach aahe aanee vindochya aat aanee baher satat satat anuprayog aanee sevandware vapar sulabh karnyasathi jett blue api 2005 madhye prakashit karnyat aale.
microsoft exchangechya web blogchya nondit mhatale aahe qee jett bluemadhye yogdan yogdan vikaskanmadhye samavisht aahe
chean laao, stephen hechach, mathyu belev, ian jose, edward "edee" gilbert, keneth kiin lum, balasubramanian sriram, jonathan leema, andrew goodsell, laurian berchel, andrei marinescu, addam foxman, ivan trindev, spensor loow aanee brett sherley.
janewari 2021 madhye microsoft open soars ess. eae. eae. too anumati emm. aay. tii. parvanyasah githubavar pathvanyat aala hota.
jett redshee tulana qaraa.
jaree teey samaan vanshavalit asale taree jett reed aanee esai madhye prachand farak aahet.

