Oracle Database: izici eziyinhloko we-Oracle

Ukuthuthukiswa okusheshayo we Information Society kwaholela ekwakhekeni of ubuchwepheshe obehlukene eyenzelwe imisebenzi ethize. A eqhulwini sasithi isidingo ukuklama izindlela ezintsha ukugcina futhi sicubungula esiningi idatha usebenzisa hardware.

Isixazululo yenkinga kwaba ukudalwa database (DB) njengendlela yokuthola isitoreji idatha kanye data base nohlelo lokuphatha (DBMS) njengoba processing indlela.

Uyini DBMS

Database management system - amathuluzi software zisetshenziselwa ukwakha database, kanye phequlula, ukusesha, futhi ulwazi lwabo olusha nje egcinwe. Amasethi wedatha ilawulwa iqoqo kwezilimi isofthiwe. Ekusebenteni, database ngokuvamile lisetshenziswa ukudalwa zezokwazisa.

Namuhla kukhona izinketho eziningana for ngabaphathi semininingwane izinhlelo ukuthi ukuhlukanisa kokubili ukusebenza kanye nezidingo kukhompyutha. Njengoba izibonelo DBMS yesimanje kungabangela Oracle Database, okuyinto Kuzoxoxwa, MySQL, Finyelela, SQL Server, Fox Pro.

Naphezu kokuhlukahluka database, bahlukene zibe izinhlobo ezimbili: multi-umsebenzisi futhi siqu.

Multi-User izinhlelo

Lezi amapulatifomu zenzelwe ukwenza imisebenzi eziyinkimbinkimbi ku computer anamandla. abantu abaningi ukusebenza okufanayo isimiso esinjalo, ngakho-ke inezigaba eziningana, ikakhulukazi:

• nucleus e memory;
• iseva;
• esingenamkhawulo izinhlelo iklayenti ukuthi enze imisebenzi lihlelwe umsebenzisi.

Ngo isimiso esinjalo isebenzisa computer eyodwa eyinhloko esetshenziswa njengoba iseva futhi igcine idatha kanye amantongomane. isixazululo enjalo inikeza ukufinyelela ukhululekile database ikhasimende. Ngaphezu kwalokho, i-database ezifana lula kakhulu ukulungiswa amaphutha. High speed ukuthumela idatha kwenza ukusebenza kahle. Amaklayenti bangaxhumana uhlelo nge iyiphi inethiwekhi. Lezi yizinto ezimbalwa nje izinzuzo semininingwane multi-yomsebenzisi, lapho Database Oracle.

izinhlelo siqu

Lolu hlobo yakhelwe izicelo ezincane ukuziphilisa. Lezi izinhlelo ezibekwe phezu computer bese uxhumana umsebenzisi. I database kanye nohlelo ngokwayo zigcinwa disk efanayo.

Kuze kube yimanje, onjiniyela lwalezi nhlelo Ungeze ikhono usebenza isimo senhlalo. Nokho, kulesi simo kuba nezici ezibaluleke kakhulu emsebenzini ngamunye. Lezi zitholakala kuseva; Wonke amakhasimende kudingeka ukufaka isicelo futhi ikhophi uhlelo uqobo. Kodwa lokhu isixazululo kudala izinkinga lapho izinguquko idatha. Ukufinyelela isizinda kuleli cala futhi nzima. Umsebenzisi ngamunye usebenza eceleni, futhi uhlelo lwakhe amaphutha awabonakali namanye amakhasimende. Uma ungamvimbi ke ukufinyelela kanyekanye kuyoba yinkinga.

Ukuze uthole ukwaziswa okwengeziwe mayelana Oracle

Kuyini Database Oracle? Kwaphela iminyaka eminingi, yolwazi kusuka Oracle inikeza abasebenzisi nge induduzo esiphezulu, ukuphepha, ukusebenza eliphezulu kanye nokwethembeka. Uhlelo ubonisa kahle ngokwaso futhi ngamunye sici kubalulekile kwikhasimende. Iningi emikhulu zezokwazisa ngeke akwenze ngaphandle ukusetshenziswa le database.

Ubuchwepheshe buyashintsha ngokushesha okukhulu, futhi imikhiqizo efanayo njalo izimfuno ezintsha. Isitoreji kanye nokuxhumana idatha ezingeni efanele ukunikeza izinhlelo eziningana. Kodwa database Oracle uhlala ehamba phambili, sibonga ngcono njalo.

imphawu letibalulekile uhlelo

Lokhu database iqoqo izingxenye software, amandla okuyinto kwanele inhlangano yephrojekthi yanoma yimuphi yinkimbinkimbi. zoom kahle evuthiwe kusho ungakwazi ukugcina isibalo esingenamkhawulo Imininingwane yolwazi. Kusebenta jikelele inikeza ikhono basebenzisane idatha kunoma iyiphi inombolo amaklayenti. Imikhawulo kungenzeka nje izinsiza hardware. I onjiniyela ukusebenza uhlelo konke okuhle iseva ubuchwepheshe, okwenza lo msebenzi ngokusebenzisa ekahle Inthanethi.

Isici esibalulekile salo Oracle futhi isekela kuzingxenyekazi eziningi. Linux, i-Windows, noma iyiphi enye nhlelo zokusebenzisa kuzovumela semininingwane ukuhlela ngempumelelo. Kuhle kokusho, nezinqubomgomo ukufuduka. Inguquko ukuba izinguqulo olusha ihlelwe elula kakhulu, isimiso esikhethekile ngeke ukudlulisa idatha kusuka kumasistimu.

Yini ongakhetha for database kukhona?

I Onjiniyela ukunikeza abasebenzisi nge amane okukhethwa kukho ohlelweni:

• Edishini Ejwayelekile;
• lite;
• Edition Enterprise;
• -Edishini Siqu.

Lokhu kuhlukaniswa kutholakala hhayi kuphela e-Oracle Database. Lwakamumva zifana kakhudlwana komunye nomunye. Umahluko omkhulu e ukusebenza ingxenye, for indlela ngayinye kukhona indlela ehlukile.

I-edishini Ejwayelekile

Kakhulu inguqulo ethandwayo, ukusebenza kuyinto ukuyaphi. Ngokuvamile isetshenziswa ukudala izinhlelo abambalwa amakhasimende. Lena indawo enhle isengezo senethiwekhi ezimele, ibhizinisi elincane, nokunye. D. Kodwa enhlanganweni enkulu, futhi inesikhala ngoba Standard Edition, uma kuziwa ezindaweni akude. Intengo le nguqulo ye-Oracle Database kuyehla, kanti amandla akhona kungaba okwanele ukusebenza ngempumelelo.

Oracle Lite

Le nguqulo elula kakhulu futhi engasindi kohlelo. Kungcono ulisebenzise kumadivayisi eselula, ama-laptops, nokunye. D. Easy ukuvumelanisa ulwazi kufezwa ngokusebenzisa interface ezivamile. ukuthuthukiswa Isicelo Kwenziwa ngendlela evamile.

Enterprise Edition

The best version database Oracle nge wonke amathuba akhona. Loluhlelo amathuba unlimited futhi likuvumela ukuhlela ngokuphelele noma iyiphi iphrojekthi. Kulokhu, it kuncike kuphela ihadiwe enamandla. Inguqulo eqoqwe okungcono isitoreji ubuchwepheshe bese uxhumana ulwazi. Iseva semininingwane uzokwazi emsebenzini ngaphandle kokuma, sibonga scalability okukhulu. Ezahlukene amathuluzi kusiza isipele idatha yakho futhi ababuyisele lapho kudingeka. Kunikezwa izinkulumo ezizuzisayo nanini ngililahle.

-Edishini Siqu

I-Oracle Database iklayenti uphelele ukusetshenziswa noma ukuqeqeshwa siqu. Ukusebenza luyoba olwanele ukudala izinhlelo kanye nokusebenzisa kwabo okwengeziwe ku izinguqulo eziningi-Windows. Badlala indima ebalulekile, isb. A. E-NT noma "2000" atholakale wonke amathuba, futhi 95/98 / ME ongakhetha anqunyelwe ngenxa yesimo yesistimu yokusebenza.

Izici version 11g

Ingabe abasebenzisi njalo unezinkinga ukufakwa database, futhi inguqulo 11g, le nqubo iye lula kakhulu. Ngaphezu kwalokho, kuye kwaba kuwusizo kakhudlwana ukuba hhayi kuphela yokuqala kodwa futhi yezilungiselelo ezikhethekile. Uhlelo zizosebenza ngaphezulu uma elungiselelwe umsebenzi edingekayo, futhi ku-Oracle Database 11g, lesi sici yakhelwe kahle.

Futhi ngcono ukunciphisa izindlela. Ngokufaka ISIZINDA entsha ehlukuzweni ingafinyelela ukusebenza Amazing isivinini kanye ukukhiqiza iseva. Asikho isidingo ukumisa uhlelo noma ubhale ngokuphelele kubo. Ukuzinza isicelo is hhayi kahle ngisho noma ukwehluleka ISIZINDA ngabanye.

Uyithola kanjani i-database?

On the website esemthethweni ungalanda version efanele kohlelo, futhi kuyohlale kunje ikhambi abanekhono kunabo. On Ikhasinkomba, uzodinga kuphela ukuba ahlole futhi uqinisekise isivumelwano selayisense, bese ukhetha uhlelo lokusebenza.

Isinyathelo lokugcina ukugunyazwa kusayithi. Uma kungekho iphrofayli, ungakwazi kalula ukudala futhi ungene ngemvume. Ukuba khona kwe-akhawunti akuyona kuphela amandla, kodwa futhi ewusizo. Ngaphezu semininingwane thwebula page, abasebenzisi ngeke ukufinyelela kwamanye amathuba ezithakazelisayo.

Ukufaka Oracle 11g

Indlela ukufaka Oracle Database 11g-Windows 7? DBMS is zahlanganiswa ngo ingobo yomlando ukuthi liyadingeka unzip emva ukulanda.

Okulandelayo, kufanele wenze lokhu okulandelayo:

1. Kufolda DISK1 ukuvula ifayela ukufakwa ngokuthi Setup.exe.
2. Dlulisa isikrini sokwamukela.
3. Vumelana ilayisensi.
4. Khetha indawo ukuze ufake uhlelo (kodwa kungcono ukushiya indlela ejwayelekile).
5. Dala i-akhawunti nomqondisi.
6. Hlola lokhu imininingwane bese uqinisekisa uhlu kubo.

Ukufakwa silula, futhi zonke izenzo enembile. Kuyaphawuleka ukuthi hhayi kuphela ku-Windows kulula ngakho wamisa database kusuka Oracle. Linux kanye nazo zonke ezinye izinhlelo zokusebenzisa futhi akavumi ukuba izinkinga, njengoba ngaphezulu inqubo ukuthunyelwa uyefana.