Database - inkqubo yolawulo data

Ezi ngeenxa zonke kuthi. Baya kuza ngokusebenzisa amajelo eendaba, elinde kuba nathi emsebenzini, kwizithuthi zikawonke, nkqu ekhitshini. Ekubeni wonke umntu mihla lijongene rhoqo isixa esikhulu ulwazi analo abaziphethe ngayo ezahlukeneyo izenzo: ukuba Ukuqokelela ivenkile, ukukhetha izinto ezininzi eziyimfuneko, uhlobo, uze ulungise nangezinye iindlela, susa. Zokusebenzisa inkqubo, kunye ledatha sele ziphuhlisiwe. Ngokuqwalasela ingongoma ngembono sedata - inkqubo ukuhlela data.

Yintoni database

Le database ithathwa ukuba abe uluhlu lubekwa ulwazi. Umzekelo enjalo ilayibrari sedata ezibekwe ngayo ukukhonza. Ezincwadini zakhe akholisa zibekwe ngendlela ethile ngesihloko, umbhali okanye ngokuxhomekeke mbandela. Ngokwemveli, intshumayelo data lula, sebenzisa ifomu itafile. Iiseli babekwa amanani ayo, umbhalo, imifanekiso kunye nezinye izinto. A ngokweekholamu nezintlu ziqulathe ezinye iimpawu, nto leyo eyenzeka odolo. Umba obaluleke kakhulu yokwakhiwa olufanelekileyo database ukufumana iseti iimpawu ziqhelekilyo kwisifundo esithile. Oko kukuthi, kuxhomekeke amaxabiso ezi mpawu ezahlulwa iimeko kushishino ngalunye.

Yintoni a DBMS

Database - ethile inkqubo ledatha. Isibakala sokuba ukuba ezi nkcukacha aziphelelanga ngokwaneleyo nje ukufumana kubo kufuneka gqolo ukuvelisa ezinye imisebenzi. Kuqala kwinto zonke, ulwazi olukhoyo wayalela ukuba igcinwe. Yaye kwixesha elizayo ufuna njani zingafumaneka kule data ngokukhawuleza, nto leyo ifuna umsebenzisi ngethuba elithile kwi imeko yangoku. Ukuza kuthi ga ngoku, inkqubo yolawulo kufuneka abe ezithile algorithms yokuhluza, kwakunye nokwazi ukusebenzisa iintlobo okucoca ulwelo. Le datha kuyimfuneko ke ukuba wongeze, ucime, hlela, njalo-njalo. Ukuze kube lula ukusebenza iindidi lolwazi, kuyimfuneko ukuba nkqubo kuya kuvumela abasebenzisi ukuba ukwakha Khetha umbuzo ngendlela uluhlu, "ukwazi" ukuzalisekisa ezi izicelo ngokukhawuleza stably. Nokwakha eyiyo kule database inika lonke yaye amandla idatha khusalekileyo esuka kusebenziso olungavumelekanga kunye nezinye izixhobo imisebenzi efunekayo.

Kungani MySQL

I SQL yam - inkqubo yolawulo database zonxulumelwano. Ukunxulumana umnxeba loo isiseko apho ulwazi imelwe ngohlobo iitafile ezahlukeneyo, izinto ezo futhi wokuzimela. Ukusuka nabanye oovimba Oku kwahlukile ezinye iimpawu ezingundoqo, oko kukuthi:

- multithreading, okt ngexesha elifanayo kule nkqubo nga ukubaleka imibuzo ezininzi;

- elula zolwakhiwo server;

- inkqubo yokhuseleko oluthembekileyo equka isakhiwo bhetyebhetye zokuvula kunye namalungelo;

- ukukwazi ukusebenzisa data zombini ezinzileyo kunye nobude variable;

- inkqubo yokugcina umgangatho esekelwe phezu nomthamo;

- ithuba ukwamkelwa ukuya izitshixo-16 kule theyibhile.

Kukho nezinye iiyantlukwano ezibalulekileyo, njengoko yokuba kwiziko ledatha kukho eluncedo ukulungisa ezitafileni.

I SQL yam, njengokuba ledatha, kube yinkqubo elula neqondakalayo evumela ukuba enze yonke imisebenzi eyimfuneko kwi data.