Oracle Database: iimpawu eziyintloko Oracle

Uphuhliso ngokukhawuleza Information Society kubangele kuphuhliso lobugcisa ezahlukeneyo ezilungiselelwe imisebenzi ethile. Okuphambili kwakusekho imfuneko yokuyila iindlela ezintsha yokugcina nokuhoywa izixa ezikhulu data usebenzisa zekhompyutha.

Isisombululo ingxaki yaba kukudala iziko ledatha (DB) njengendlela yokugcina iinkcukacha kunye neenkqubo zolawulo base data (DBMS) njenge ndlela processing.

Yintoni a DBMS

inkqubo sedata yolawulo - ngothotho lwezixhobo software ezisetyenziswa ukudala kuvimba, kwakunye lokukhangela, khangela, kwaye nokuhlaziya iinkcukacha yazo. iisethi zedatha lilawulwa iseti yeelwimi kunye software. Ukuziqhelisa, database luqhele ukusetyenziswa kwendalo lweenkqubo zolwazi.

Namhlanje kukho iindlela ezininzi kwiinkqubo zolawulo database ukuba ukwahlula ukusebenza kunye neemfuno kwi computer. Njengoko imizekelo DBMS mihla kunokubangela Oracle Database, nto leyo eza kuxutyushwa ngakumbi, I SQL yam, Access, Kumncedisi we SQL, Fox Pro.

Nangona kwiyantlukwano weenkcukacha, bahlukene ngeentlobo ezimbini: multi-umsebenzisi ne zobuqu.

Iinkqubo Multi-User

La maqonga ziyilelwe ukwenza imisebenzi ezintsonkothileyo kwiikhompyutha anamandla. Abantu abaninzi basebenza ngokunxuseneyo kwinkqubo enjalo, ngoko ke iqulathe izinto eziliqela, kunye nokunye okunninzi ingakumbi:

• nucleus kwi memory;
• iseva;
• i esingenakubalwa leenkqubo abaxumi ukuba enze imisebenzi ebekwe ngabasebenzisi.

Xa nkqubo usebenzisa enye yeekhompyutha ephambili esetyenziswa njengomncedisi kwaye igcina idata kunye kernel. Loo isisombululo inikeza unikezelo emnandi kuvimba umthengi. Ukongeza, uvimba ezinjalo lula kakhulu kukulungiswa iimpazamo. High speed ukudluliselwa data yenza nokusebenza kakuhle. Izigulana ukunxibelelana kunye nenkqubo nge na network. Ezi nje ngamanye amancedo sedata multi-umsebenzisi, apho Database Oracle.

iinkqubo zakho

Olu hlobo ilungiselelwe izicelo ezincinane-scale. Le nkqubo ibekwe kwiikhompyutha buqu kwaye banxibelelane umsebenzisi. Le database kunye nenkqubo ngokwayo zigcinwa kwi diski efanayo.

Ukuza kuthi ga ngoku, ngabaqulunqe ezi nkqubo wongeze ubuchule zisebenza kwimo engqongileyo lenethiwekhi. Noko ke, kule meko ke iimpawu ebaluleke kakhulu emsebenzini nganye. Ezi akhiwe kumncedisi; Bonke abathengi kufuneka ukuba ufake isicelo kwaye ikopi yale nkqubo ngokwayo. Kodwa lo sisombululo kubangela iingxaki xa utshintsho data. Ukufikelela kwi siseko kule meko nalo nzima. Umsebenzisi ngamnye isebenza ngokwahlukileyo, yaye kwinkqubo yakhe iimpazamo alubonakali nezinye iinkonzo. Ukuba ukuvala, ngoko ukungena ngaxeshanye ziya kuba yingxaki.

Ukuze ufumane inkcazelo engakumbi malunga Oracle

Yintoni na Database Oracle? Iminyaka emininzi, ikhonkco Oracle ibonelela abasebenzisi yintuthuzelo eliphezulu, ukhuseleko, ukusebenza eliphezulu kunye nokuthembeka. Le nkqubo ibonisa ngokupheleleyo ngokwayo yaye ngamnye msebenzi wayo kubalulekile ukuba client. Iinkqubo zolwazi ngomlinganiselo omkhulu kakhulu akakwazi ukwenza ngaphandle ukusetyenziswa kwale ledatha.

Technology uguquguquka ngokukhawuleza kakhulu, kwaye iimveliso ezifana njalo neemfuno ezintsha. Ukugcinwa kunye nentsebenziswano kunye data kwi kwinqanaba elifanelekileyo ukunika iinkqubo eziliqela. Kodwa database Oracle uhlala kukukhokela, enkosi ukuphuculwa rhoqo.

Iimpawu eziphambili zale nkqubo

Le database yingqokelela yeekhomponenti software, amandla leyo ezaneleyo lokuququzelela projekthi nawuphi xaka. zoom kuphuhliswa-kakuhle kuthetha ukuba uyakwazi ukugcina inani esinganasiphelo ulwazi. Ukusebenza jikelele inikeza ikhono basebenzisane data kuyo naliphi inani iinkonzo. Ingase nje izibonelelo zekhompyutha. Ababhekisi phambili Siphumeze kwinkqubo konke okusemandleni umncedisi ubugcisa, ngokwenza umsebenzi ngokusebenzisa ezifanelekileyo Internet.

Into ebalulekileyo Oracle kwakhona inkxaso amaqonga ezininzi. Linux, Windows, okanye nawuphi na omnye asebenza iinkqubo kuzakuvumela ledatha lokuhlela ngempumelelo. Kufanelekile ukuba sikhankanye, kunye nemigaqo yokufuduka. Akulula xa uqeqeshelwa ukuba iinguqulelo ukuhlaziywa amalungiselelo elula kakhulu, inkqubo ekhethekileyo iya ukudlulisela data evela kwezinye iinkqubo.

Zeziphi iindlela ukuze ledatha?

Ababhekisi phambili ukunikeza abasebenzisi iinketho amane le nkqubo:

• Edition Standard;
• Lite;
• Edition Enterprise;
• Edition Personal.

Le yokuhlela ifumaneka kuphela Database Oracle. Iinguqulelo ziyafana kakhulu omnye komnye. Umahluko omkhulu kule ndawo zemisebenzi, ngokuba khetho ngalinye kukho ukhetho ekhethekileyo.

Standard Edition

Kakhulu version ethandwayo, le ukusebenza luthande ukuba nomnyino. Amaninzi isetyenziswa ukwenza iinkqubo inani elincinane abathengi. Oku iyilungele iqela lokusebenza, amashishini amancinane, njalo njalo. D. Kodwa yentlangano enkulu, kananjalo isithuba Standard Edition, xa kufikwa kwiindawo ezikude. Ixabiso olu guqulelo lwe Database Oracle lifinyele, xa umthamo okhoyo kuba ngokwaneleyo ukusebenza ngempumelelo.

Oracle Lite

Inguqulelo kakhulu elula okulula nkqubo. Kungcono ukuwasebenzisa ngalo iifowuni, laptops, njalo njalo. D. Easy ungqamaniso ulwazi kuyafikelelwa ngokusebenzisa lwenjongano eziqhelekileyo. Uphuhliso Isicelo kwenziwa eziqhelekileyo.

Enterprise Edition

Inguqulelo intle database Oracle kunye onke amathuba akhoyo. Le nkqubo iye amathuba unlimited kwaye likuvumela ukuba ulungise ngokupheleleyo nayiphi na iprojekthi. Kulo mzekelo, kuxhomekeke kuphela iintsimbi enamandla. Version eqokelele ubuchwepheshe best yokugcina ukusebenzisana kunye nolwazi. Umncedisi database iya kuba nako ukusebenza ngaphandle ko ngendlela enenzuzo, kubulelwe scalability kakhulu. uluhlu olubanzi lwezixhobo kunceda backup data yakho uze usibuyisele kuzo xa kuyimfuneko. ulwazi oluxabisekileyo ke akazange aphelelwe.

Edition Personal

I Oracle umxhasi Database ugqibelele oyisebenzisela wena buqu okanye uqeqesho. Ukusebenza iyakwanela ukuyila iinkqubo kunye nokusetyenziswa ngakumbi kwi iinguqulelo ezininzi Windows. Zidlala indima ebalulekileyo, okt. A. Xa NT okanye "2000" ifumaneke kuwo onke amathuba, kunye 95/98 / ME iinketho ziphelela ngenxa yohlobo indlela yokusebenza.

Iimpawu of version 11g

Ngaba rhoqo abasebenzisi kufuneka iingxaki ngofakelo kwe-database, kwaye version 11g, le nkqubo iye lula kakhulu. Ngaphezu koko, kuye lula ngakumbi hayi kuphela original kodwa endaweni ekhethekileyo. Le nkqubo iza kuphumelela ngakumbi ukuba elungiselelwe umsebenzi efunekayo, yaye Oracle Database 11g, lo mba ngendlela eyiyo.

Kwakhona ngcono ukunciphisa iindlela. Ngokudibanisa nodes ezintsha esihlokweni onokufikelela yokusebenza engakholelekiyo nesantya kunye nemveliso yomncedisi. Akukho mfuneko ukuphelisa le nkqubo okanye uyibhale ngokupheleleyo kubo. Nozinzo izicelo kakuhle nokuba ukusilela ezalathelwe uphuhliso ngamnye.

Ungayifumana njani i-database?

Kwi website esemthethweni ungalayisha uguqulelo efanelekileyo kwenkqubo, yaye oko kuya kuhlala sisisombululo abanobuchule. Kwiphepha download le, kuya kufuneka nje ukuba ahlole aze aqinisekise nesivumelwano se layisenisi, uze ukhethe indlela yokusebenza.

Inqanaba lokugqibela le isigunyaziso kwi sayithi. Ukuba akukho iprofayili, ungenza ngokulula ukudala uze ungene ngemvume. Ubukho i akhawunti ayikho kuphela linegunya, kodwa iluncedo. Ukongezelela database download page, abasebenzisi baya kuzuza ukufikelela kwezinye amathuba umdla.

Kufakwa Oracle 11g

Indlela ukufaka Oracle Database 11g kwi-Windows 7? DBMS lupakishwa an archive efunekayo ukuze iziphu emva kokuba uyilayishe ezantsi.

Okulandelayo, kufuneka wenze oku kulandelayo:

1. Kulawulo DISK1 ukuvula ifayile ufakelo ekuthiwa Setup.exe.
2. Gqithisela screen Welcome.
3. Vumelana le mvume.
4. Khetha indawo ukuze ufake i gocr (kodwa kungcono ukushiya umendo standard).
5. Yenza i umlawuli akhawunti.
6. Khangela ezi nkcukacha uze uqinisekise kubo.

Ufakelo ilula kakhulu, yaye zonke neentshukumo enobuchwepheshe. Kubalulekile ukuqaphela ukuba akukho kuphela kwi Windows lula ukucwangcisa i ledatha evela Oracle. Linux kunye nazo zonke ezinye yokusebenza iinkqubo kwakhona musa kunokubangela iingxaki, njengoko inkqubo ngakumbi deployment iyafana.