
databases enginemadhye pravesh

pravesh databases engine (auphis exes connectivity engine kinwa ess aanee purvi microsoft jett databases engine, microsoft jett engine kinwa fakt jett) heey eka databases engine aahe jyavar microsoftchi anek utpadane tayar kelee gelee aahet. jetchi pahili aavrutti 1992 madhye vikasit karnyat aalee hotee, jyat teen modules hote, jyancha vapar databases hatalanyasathi keela jaau shakato.
jett mhanje 'sanyukt engine tantradnyan'. microsoftcha pravesh aanee drushya moolbhut vapar kinwa tyanche antarnihit databases engine mhanoon jetcha vapar keela aahe. tathapi, samanya vaparasathi, pratham microsoft desktop engine (emm. ess. dii. eae.) neey, nantar ess. kyu. ell. server expressne, tyachi jaaga ghetali aahe. mothya databases garjansathi, jett databases microsoftchya pramukh ess. kyu. ell. server databases utpadanat (kinwa microsoftchya bhashet, "up-size") upgraded kele jaau shakatat.
sampidan aanee encryption chaloo asalelya paach abj reecord ms jett (laal) detabesasathi sumare eka terrabyte disk storage spacechi aavashyakta asate. tyat samanyatah shekado * asatat.emm. dii. bii. files.
vastukala.
jett, relational databases management systemcha (aar. dii. bii. emm. ess.) bhag asalyane, relational detabasemadhye ferfar karnyas anumati dete. heey ekach interfaces pradan karate jeey itar software microsoft detabasemadhye pravesh karnyasathi vaparu shakatat aanee suraksha, sandarbhatmak akhandata, vyavhar prakriya, anukramanika, nond aanee prushth lock aanee deta pratikrutisathi samarthan pradan karatat. nantarchya aavrutyanmadhye, ess. kyu. ell. kweri chalvanyasathi, varn mahitee unicode swarupat sathavanyasathi, databases drushye tayar karnyasathi aanee microsoft ess. kyu. ell. servers dvi-dishatmak pratikruti tayar karnyasathi engine vadhavanyat aale aahe.
jett karnyasathi teen modules aaheth eka mhanje "native jett aisam driver", eka dynamic link library (dii. ell. ell.) jee (yadruchchik pravesh) file system api vaparoon microsoft exes databases fayali (emm. dii. bii.) thet hatalu shakate. aanakhi eka modulemadhye 'aisam driverse', dii. ell. ell. aahet, jeey jetchya aavruttinusar, aay. ess. aii. emm. detabesachya vividh anukramit anukramik pravesh paddhati, tyapaiki exbase, paradox, bii. treave aanee foxpro, yamadhye pravesh karnyas anumati detat. antim module mhanje 'deta exes objects' (daao) dii. ell. ell... daao eka api pradan karate jeey programmersna konatihi programming bhasha vaparoon jett detabasemadhye pravesh karnyas anumati dete.
bandist.
jett anek vaparkartyanna ekach velee detabasemadhye pravesh karanyachi parvanagi dete. jevha anek vaparkarte detabesachi samaan nond kinwa prushth sampadit karnyacha prayatna karatat tevha tee mahitee dooshit kinwa avaidh honyapasoon rokhanyasathi jett locking dhoran vaparte. konatahi ekulata eka vaparkarta keval tyaa databases nondi (mhanje detabasemadhil vastoo) sudharit karoo shakato, jyasathi vaparkartyane lock lagoo keela aahe, joou lock sodalya jaiparyant recordmadhye vishesh pravesh deto. aavrutti 4 purvichya jett aavrutyanmadhye, prushth lock model vaparale jaate aanee jett 4 madhye, reecord lock model vaparale jaate. microsoft databases deta "prushthe" madhye sanghatit kele jaatat, jeey nishchit-lambiche (jett 4 chya aadhi 2 keey. bii., jett 4 madhye 4 keey. bii.) deta sanrachana asatat. deta chull lambichya "nondinmadhye" sangrahit keela jaato joou ekapeksha qamee kinwa adhik prushthanparyant asoo shakato. prushth lock karnyache model vaiyaktik nondinaivaji prushthe lock karoon karya karate, jyacha arth jaree qamee sansadhan-gahan asala taree jevha vaparkarta eka nond lock karato, tevha tyach prushthavaril itar serve nondi samparshvikpane lock kelya jaatat. parinami, jaree konatahi vaparkarta tyanna pravesh karat nasla aanee tyanna lock karanyachi aavashyakta nasali taree, itar konatahi vaparkarta samparshvikpane lock kelelya nondinmadhye pravesh karoo shakat nahee. jett 4 madhye, reecord locking model samparshvik lock kadhoon takte, jenekarun vaparat nasalelya pratyek reecord upalabdh asel.
lock karnyasathi microsoft done yantrana vaparteh "nirashavadi lock" aanee "aashavadi lock". nirashavadi kulupbandisaha, kulupband karanyachi vinanti kelyavar lagech abhilekh kinwa prushth bund kele jaate, tarr aashavadi kulupbandisaha, sampadit reecord jatan hoiparyant kulupband honyas vilamb hoto. aashavadi locks sangharsh honyachi shakyata qamee asate, kaaran reecord keval thodya kalavadhisathi lock keela jaato. tathapi, aashavadi locks ekhadyala khatri deta yet nahee qee adyayavat yashasvi hoil kaaran dusra vaparkarta pratham reecord lock karoo shakato. nirashavadi locks, ekada lock midalyanantar adyayavat yashasvi honyachi hummy dilee jaate. itar vaparkartyanna tyanche badal karnyasathi kuloop sodalya jaiparyant pratiksha karavi lagel. lock sangharsh, jyasathi ektar vaparkartyala pratiksha karavi lagate kinwa vinanti ayashasvi hote (sahasa velechya samaptinantar), heey nirashavadi lockingmadhye adhik samanya aahet.
vyavhar prakriya.
jett hii kshamata asalelya databases pranalinsathi vyavhar prakriyes samarthan dete. (oo. dii. bii. see. pranalinmadhye eka-stariy vyavhar prakriya asate, tarr virodhabhasasarkhya anek aay. ess. aii. emm. pranali vyavhar prakriyela samarthan dett naheet.) vyavhar hii detabasemadhye kelya jaananya karyanchi eka malika aahe jee ektritpane kelee jaane aavashyak aahe-yala anuta mhanatat aanee hii eka aaml (anuta, susangatata, vilgikaran aanee tikaupana) aahe, jyaa sankalpana databases vyavasthapan pranalichi pramukh vyavhar prakriya vaishishtye manalya jaatat. vyavhar prakriya karya karnyasathi (jett 3 paryant), programmerla vyavhar hatane suru karane, vyavharat karnyasathi aavashyak asaleli karye karane aanee nantar vyavhar karane (jatan karane) aavashyak asate. vyavhar hoiparyant, badal keval smrutimadhye kele jaatat aanee pratyakshat discover lihile jaat naheet. swatantra databases adyayavat karnyapeksha vyavharanche anek fayade aahet. eka mukhya fayda mhanje vyavharadarmyan samasya udbhavalyas vyavhar sodoon dile jaau shakatat. yala vyavhar mage karane kinwa fakt mage ghene asey mhanatat aanee teey vyavhar suru honyapurvi databases nondichi sthitee tantotant tyaa rajyat punarsthapit karate. jarr pranali ayashasvi jhalyas, anoo asane aavashyak asalelya adyayavat kramanchya madhyabhagi, vyavhar detabesachi sthitee susangat thevanyas dekhil anumati detat. keval kahee adyatane detabasemadhye lihoon thevanyachi shakyata nahee; ektar serve yashasvi hotil kinwa databases pranali punha suru jhalyavar badal radd kele jaatil. oo. dii. bii. see. chya inn-memory dhoranasah, vyavharanmule nonditil anek adyatane purnapane smrutimadhye ghadatat, shevati fakt eka mahagadi disk lihili jaate.
jett 3 madhye antarnihit vyavharanna samarthan denyat aale hote. heey asey vyavhar aahet jeey detabesashi shevatcha vyavhar kelyanantar aapoaap suru hotat. jevha ess. kyu. ell. dii. emm. ell. nivedan jaaree kele gele tevha jetmadhye antarnihit vyavhar jhaale. tathapi, asey aadhalun aale qee 32-biit khidkyanmadhye (windows 95, windows 98) yacha kamgirivar nakaratmak parinam jhaala, mhanoon jett 3.5 madhye microsoftney ess. kyu. ell. dii. emm. ell. vidhane kelee tevha antarnihit vyavhar kadhoon takale.
detachi akhandata.
jett heey astitvatil akhandata aanee sandarbhatmak akhandatechi amalbajavani karate. jett purvanirdharitapane sandarbhatmak akhandata bhang karananya nondit konatahi badal rokhel, parantu jett databases tyaeivaji sandarbhatmak akhandata rakhanyasathi prasar nirbandh (cascading adyatane aanee cascading hatvane) vaparu shakatat.
jett heey "vyavasay niyam" (jyanna "nirbandh" asehi mhanatat) kinwa table kinwa stambhat konata deta thewala jaau shakato yachee amalbajavani karnyasathi konatyahi stambhala lagoo honanya niyamanna dekhil samarthan dete. udaharanarth, eka niyam lagoo keela jaau shakato joou sadhyachya tarikh aanee velechya aadhi asalelya tarikh _ logg kelelya stambhat tarikh pravisht karanyachi parvanagi dett nahee, kinwa eka niyam lagoo keela jaau shakato joou lokanna keval sankhyatmak kshetrat sakaratmak moolya pravisht karnyas bhag padato.
suraksha.
jett detabasemadhye pravesh prati vaparkarta staravar keela jaato. vaparkartyachi mahitee vegalya pranali detabasemadhye thewali jaate aanee pranalitil pratyek vastuvar pravesh niyantrit keela jaato (udaharanarth tabledware kinwa kveridvare). jett 4 madhye, microsoftney karyapranali lagoo kelee jee databases prashasakanna ess. kyu. ell. aadeshandvare suraksha seet karanyachi parvanagi dete, vaparkarta tayar qaraa, joda, badala, drop qaraa aanee gut drop qaraa. yaa aadeshancha upasanch haah ansi sql 92 manakacha aahe aanee teey anudan/radd karnyachya aadeshannahi lagoo hotat. jevha jett 2 sodale gele, tevha suraksha dekhil daodware programmatically seet kelee jaau shakat hotee.
prashna.
prashna hii yantrana aahe jee jett detabasemadhun deta punarprapt karnyasathi vaparte. teey microsoft kyubemadhye (udaharanarth kweri), microsoft access ess. kyu. ell. vindodvare kinwa access besikchya deta access objects (daao) bhashedvare paribhashit kele jaau shakatat. tyanantar heey ess. kyu. ell. nivad vidhanat rupantarit kele jaatat. tyanantar prashna sankalit keela jaato-yaat prashnanche vishleshan karane (vakyarachana tapasani aanee databases tablemadhye prashna vicharanyasathi stambh nishchit karane samavisht aahe), nantar antargat jett prashna object swarupat rupantarit kele jaate, jeey nantar tochnize kele jaate aanee vrukshasarkhya sanrachanet sanghatit kele jaate. jett 3 madhye nantar microsoft rushmore kweri optimization tantradnyanacha vapar karoon heey anukulit kele jaatat. tyanantar prashna karyanvit keela jaato aanee parinam anuprayogakade kinwa jyaa vaparkartyane mahitichi vinanti kelee aahe tyaa vaparkartyakade parat pathavale jaatat.
jett prashnasathi punarprapt kelela deta dynesetmadhye pathavato. haah detacha sanch aahe joou gatishilpane detabesashi jodala gela aahe. prashna nikal tatpuratya taktyat sathavanyaivaji, jithe deta vaparkartyadvare thet adyayavat keela jaau shakat nahee, dynesset vaparkartyala dynesetmadhye asalela deta pahanyachi aanee adyayavat karanyachi parvanagi deto. asha prakare, jarr vidyapithachya vyakhyatene tyanchya assignmentmadhye vishishtata prapt kelelya serve vidyarthyanna prashna vicharale aanee tyaa vidyarthyachya nondit truti aadhalali, tarr tyanna fakt dynesetmadhil deta adyayavat karanyachi aavashyakta asel, joou vidyarthyanchya databases recordla tatpuratya tablemadhye prashna nikal sanchayit kelyanantar vishisht adyayavat prashna pathvanyachi aavashyakta naan thevata svayamchalitapane adyayavat karel.
itihas.
jetchi suruvat 1992 madhye eka antarnihit deta pravesh tantradnyan mhanoon jhaali jee microsoft antargat databases utpadan vikas prakalpatoon aalee, jyache code siras aahe. siras haah visual besik kodachya purv-prakashan aavruttitun vikasit karnyat aala hota aanee microsoft accessche databases engine mhanoon vaparla gela hota. tyaveli microsoftsathi kaam karnare toney goodue mhanatat
"heey mhanane vajavipane achook asel qee tyaa tappyaparyant jett heey tyaa sanghache naav hote jyala ghatak sanghapeksha praveshasathichya dii. bii. engine modulesver kaam karnyasathi niyukt kele gele hote. vhee. bii. [visual besik] 3 sathee tyanna mulat teey praveshatoon fadoon teey vhee. bii. varr kalam karave lagale. mhanunach tyanna vhee. bii. 3 madhye tyaa serve jett/oo. dii. bii. see. samasya aalya aahet."
jevha pravesh 2 jaaree karnyat aala tevha jett adhik ghatak banale kaaran pravesh oo. dii. bii. see. vikaskanni oo. dii. bii. see. chalak tayar karnyasathi jett kodache kahee bhag vaparale. eka retrophit pradan karnyat aala hota jyamule drushya moolbhut 3 vaparkartyanna pravesh 2 madhye jaaree kelele adyayavat jett vaparanyachi parvanagi midali.
jett 2 hii anek gatishil jodaleli library (dii. ell. ell. ess.) mhanoon prakashit karnyat aalee hotee, jee microsoftchya pravesh detabessarkhya anuprayog softwaredware vaparali gelee hotee. khidkyanmadhil dii. ell. ell. heey samanya kodache "library" aahet jeey ekapeksha jaast anuprayogandware vaparale jaau shakatat-code thevun jeey ekapeksha jaast anuprayog samanya librarykhali vapartat jeey yapaiki pratyek anuprayog swatantrapane code dekhbhal vaparu shakatat, qamee kele jaate aanee anuprayoganchi karyakshamta vadhate, qamee vikas prayatnansah. jett 2 madhye teen dii. ell. ell. hoteh jett dii. ell. ell., deta exes objects (daao) dii. ell. ell. aanee anek bahya aay. ess. aii. emm. dii. ell. ess. jett dii. ell. ell. neey too konatya prakarchya detabasemadhye pravesh karat hota aanee tyachi vinanti kashee karayachi heey nirdharit kele. jarr deta srot emm. dii. bii. file (microsoft access swaroop) asel tarr too thet deta filewar vachel aanee lihiel. jarr mahiticha srot bahya asel, tarr too tyachi vinanti purn karnyasathi yogya oo. dii. bii. see. chalkala bolawell. daao dii. ell. ell. haah eka ghatak hota jyacha vapar programmer jett engineshee interfaces karnyasathi karoo shakat hote aanee pramukhyane visual besik aanee access besik programardware vaparla jaat asey. aay. ess. aii. emm. dii. ell. ess. haah modulescha eka sanch hota jyane jetala aay. ess. aii. emm. aadharit teen detabasemadhye pravesh karanyachi parvanagi dileeh exbase, paradox aanee bii. treave. jett 2 chee jaaga jett 2 neey ghetali, jyat samaan databases rachana parantu bhinn locking dhorane vaparali gelee, jyamule teey jett 2 shhee visangat jhaale.
jett 3 madhye anek sudharana samavisht hotya, jyat sathavanukicha aakar qamee karnari naveen nirdeshank rachana aanee atyant nakkal kelele nirdeshank tayar karnyasathi lagnara vel, nirdeshank prushthanvaril vachan kuloop kadhoon takane, prushth punarvaparasathi eka naveen yantrana, eka naveen sankshipt paddhat jyasathi databases compact karane parinami nirdeshank samooh-nirdeshank swarupat sangrahit kele jaat hote, jetchya vachan-pudhe kshamata sudharanyasathi eka naveen prushth vatap yantrana, sudharit hatvinyachi karye jee prakriya vegwan karate, multithreading (teen dhage pudhe vachanyasathi, mage lihinyasathi aanee cashey dekhbhal karnyasathi vaparale gele hote), antarnihit vyavhar (vaparkartyanna enginela hatane suru karnyasathi aanee detabasemadhye vyavhar karnyas soochana dyavi lagali nahee), eka naveen kram engine, lamb moolye (jase qee memo kinwa binary deta prakar) vegalya tablemadhye sangrahit kelee gelee, aanee dynamic buffering (jetschi pahili gatimanpane vatap kelee gelee hotee aanee buffer dhoranat kiman eka buffer badal karnyasathi kiman eka buffer dhoran vaparale gele hote), buffer dhoranat badal karnyasathi kiman eka buffer dhoran vaparale gele hote. jett 3 neey databases pratikrutisathi dekhil parvanagi dilee.
jett 3 chee jaaga jett 3 neey ghetali, jee samaan databases rachana vaparte, parantu lock karanyachi vegvegali dhorane, jyamule tee jett 3 shhee visangat hote.
jett 4 neey anek atirikt vaishishtye aanee sudharana midavalya.
access 2000 teey access 2010 paryantchya microsoft access aavrutyanmadhye eka 'upsising wizard' samavisht hote, jeey jett detabesla 'samaan table structure, deta aanee mool detabesachya itar anek vaishishtyansah ess. kyu. ell. servervaril samatulya databases' madhye 'upsise' (upgraded) karoo shakate. ahwal, prashna, macrow aanee suraksha yaa sadhanadvare hatalali gelee navhati, yacha arth assa qee jarr anuprayog yaa jett vaishishtyanvar mothya pramanat avalambun asel tarr kahee hatane badal karanyachi aavashyakta bhasali asatee.
jett 4 databases enginechi swatantra aavrutti haah microsoft deta exes ghatakancha (emm. dii. aii. see.) eka ghatak hota aanee windows 2000 pasoon vindochya pratyek aavruttit samavisht keela gela hota. jett databases engine keval 32-biit hote aanee teey vindochya 64-biit aavruttyankhali moolatah chaalat navhate. yacha arth assa qee sthanik 64-biit anuprayog (jase qee ess. kyu. ell. sarvharchya 64-biit aavrutya) oo. dii. bii. see., ole dii. bii. kinwa itar konatyahi margane emm. dii. bii. fayalimadhye sangrahit kelelya detamadhye pravesh karoo shakale naheet, keval madhyavarti 32-biit software (vaah 64 madhye chalanare) jeey 64-biit clientsathi proxy mhanoon kaam karat hote.
2007 salapasoon, praveshamadhye jetchi karyalay-vishisht aavrutti samavisht aahe, jyala suruvatila "auphis exes connectivity engine" (ess. aii.) mhanatat, parantu jyala aata "exes databases engine" mhanatat (tathapi, ms-exes sallagar aanee ms-accessmadhye tadnya asalele vhee. bii. aii. vikasak yala "ess. databases engine" mhanoon sambodhanyachi shakyata jaast aahe). heey engine jett enginechya mageel aavrutyanshi magas-susangat hote, tyamule teey (vachoo aanee lihu shakat hote.emm. dii. bii.) purvichya pravesh aavruttyanmadhil files. tyane eka naveen purvanirdharit file swaroop sadar kele, (.aii. see. dii. bii.), jyamule praveshasathi anek sudharana jhalya, jyat bahumulyankit kshetra, sanlagnata deta prakar aanee memo kshetranmadhil itihasacha magova yasarkhya jatil deta prakarancha samavesh aahe. tyane suraksha badal aanee guptalekhan sudharana dekhil aanalya aanee microsoft windows sharepoint seva 3 aanee microsoft auphis outlook 2007 saha ekikaran saksham kele. teey swatantrapane prapt kele jaau shakate.
microsoft access 2010 madheel engine access 1, access 2, kamal 1-2-3 aanee virodhabhas fayalisathi samarthan bund kele. pravesh 2010 chee 64-biit aavrutti aanee tyacha utkrusht chalak/pradata sadar karnyat aala, joou sarat jetchi 64-biit aavrutti pradan karato. chalak haah vindo operating systemcha bhag nahee, parantu punarvitaranyogya mhanoon upalabdh aahe.
microsoft access 2013 madheel engine access 95, access 97 aanee exbase fayalisathi samarthan bund kele aanee tyane pratikrutisathi samarthan dekhil bund kele. 
microsoft access 2016 chee aavrutti 1608 neey exbase fayalisathi samarthan punarsanchayit kele aanee aavrutti 1703 neey mothya sankhyene deta prakar sadar keela.
deta access tantradnyanachya drushtikonatun, jett heey microsoftdware eka avahelit tantradnyan manale jaate, parantu microsoft axescha bhag mhanoon microsoft esala samarthan dett aahe.
susangatata.
microsoft keval microsoft vindojsathi jett chalak pradan karate aanee jett detabesesasathi truteey paksh software samarthan jawaljawal keval vindojvar aadhalate. tathapi, mukt srot prakalp aahet jeey linuxs itar platformwar jett databases kaam karnyas saksham karatat. visheshtah, emm. dii. bii. sadhane aanee tyache jackses tasech yuu. keey. access navache khoop vistarit jaava poort.