Ukwenza le database: iindlela nezisombululo ezikhoyo

Eli nqaku lichaza inkqubo ukuba badwelisi benkqubo lalibizwa ngokuthi "nokudalwa ledatha." Sicacisa ukuba kakhulu usoloko udiniwe. Ngcono, Kakade ke, abantu Andinaxesha simahla kula "ehlathini" akayi. Kulula kakhulu ukuba ukushiyela oku iingcali ezixakekileyo. Kaloku, namhlanje intanethi igcwele kwiintengiso ezinjalo. Umzekelo, kukho uthungelwano kokutshintshiselana abazisebenzelayo okanye umsebenzi ofanayo, unako lula ukufumana amanqaku kwi wanana. Ukuze wenze oku kufuneka ufake isicelo yokusekwa inkqubo efana inqaku eqhelekileyo, ezichaza umsebenzi kuyimfuneko.

Yintoni ukudaleka database? Kukho ezimbini iintlobo sedata: desktop kwaye uhanjiselo-server. Ukudala desktop oovimba kufuneka iprogram efana Access. Uya kuba nako ukufumana kuyo nayiphi na isuti ofisi lula. Ukufikelela ngoku uvelisa ngokuqinileyo yamaseko-Office, Microsoft kunye nezinye nabadali abaninzi abandwendweli ofisi. Yona ke imodeli client-server, umfuziselo elula lingaphunyezwa imikhosi 'uqeqesho »program Ugcino. Ezinkulu database namhlanje zibhalwa Oracle kunye Fox Visual Pro. La maqonga software baxhotyiswe isixhobo womzobo ukwenza izicelo alungiswa kwiziko ledatha ngezigidi lemiqolo 500 000 no-1 million okanye amashumi.

Cinga iqonga kakhulu ubenomtsalane senkqubo angaphambili Ugcino-6.0. Sithi ngoko nangoko ukuba indalo le iziko ledatha e Ugcino - ukuba nje abafumana iifayile * .db okanye * BDB, nokufakela kwi PC, wasele kunye matshini. Ngoko ke, ngo Ugcino 6.0 kudala ifayile kwindawo subroutine ibekwe main menu IDE, Umhla Base Desktop 6.0.

nawe Apha uza kufumana zonke izixhobo ufuna ukwenza i fayile database, injongo yaso kunye nohlobo pre-yokuzaliswa. Qaphela ukuba iya kufumaneka indalo kunye nokusebenza kuphela ezo fayile apho umqhubi ifakiwe eqongeni. Umzekelo, ukusebenza kunye nohlobo Visual Fox Pro 9.0 kuyimfuneko ukufaka ngaphezulu umqhubi kwinkqubo yokusebenza lwangaphandle.

Ngokumalunga database, wadala Ugcino-6.0, ngaphandle kwavumela wayo iqonga inkqubo nomsebenzi, le ngxaki iya kusonjululwa ngokufaka kunye nokuqwalasela software Data Base Engine 6.0 iphakheji (BDE).

Ngoko ke, ukuba sele uzimisele ukusebenza udidi lwefayile Kwezimvo, ngoko ukubhala nkqubo kulawulo oluthile kwi hard drive yakho, ngoko ke kufuneka abhalise izicwangciso ezisebhokisini Data Base Engine 6.0, eziquka iindlela zefayile, iimpawu zabo, kunye negama ledatha. Esi sikimu isebenza xa uhambisa udale iinkqubo kwenye ikhompyutha.

Bokupakisha i Data Base Engine 6.0 kufuneka ifakwe kwikhompyutha apho ufake Ugcino 6.0 enzelwe ikhowudi umatshini.

Ukudala database kwi Ugcino 6.0 automated ngokwaneleyo. Le program iyevakala ukugcina idatha ifayile database ifunyenwe yi Ungayixhola ezimbalwa. Apha, ubunzima ephambili ilele ekuphunyezweni iifom sedata zonxulumelwano. Ngaloo ndlela PDNF 3 zinokuphunyezwa ngokubeka iitafile ezimbini DBGRID. Kwaye ke ukulungiselela iintlobo ezahlukeneyo kweengxelo QReport - oku libali ayiqalisi abafuni ukuyichukumisa. Kwanele ukuba bathi, kungcono ukumisela i ikhowudi inkqubo ayincedi siyifake esisengobozini njengoko nganye akhawunti yomsebenzisi abantu abangawaziyo * SQL, kuya kufuneka ukuba zahlelwa kwakhona ...

Ukufikelela ukudala uvimba lweenkqubo kwisuti ofisi ayikho nzima. Ukuya kwiprogram, ufumana ufikelelo izixhobo ezifunekayo ukwenza okanye uhlele uvimba ikhona. Apha akukho mfuneko ukuba sizame kakhulu ukwenza ingxelo okanye uhlobo entsha projekthi. Yonke kugqitywa phantse ungaziva. Ngenxa yoko, ukuba ukuseka uqhagamshelwano phakathi iitafile usebenzisa isixhobo womzobo ukuba phantse omnye touch unako ukuqhagamshelana kwiqhosha iitheyibhile ozifunayo ezimbini ezifunekayo.

Eli nqaku lithetha kuphela ukudaleka ledatha ngoqeqesho kunye desktop phakheji. Ngokumalunga iinkqubo esinzulu, ngaphandle ulwazi ngobukho la maqonga awusoze ukusombulula ingxaki balawula zolwazi ezinkulu.