Isingeniso kwiNgcaciso, i-SQL kunye ne-Microsoft Access
Ephezulu, i- database ingabonakala ngathi i-spreadsheet; ine idatha ilungiselelwe kwiikholam kunye nemigca. Kodwa yilapho ukufana kufuma kuba i-database inamandla kakhulu.
Yintoni onokuyenza i-Database?
Isiseko sedatha sisebenza ngokubanzi. Ngokomzekelo, isebe lokuthengisa linokukhawuleza ukukhangela kwaye lifumane bonke abasebenzi abathengisayo abaye bafezekisa inani elithile lokuthengisa ngexesha elithile.
I-database ingahlaziya iirekhodi ngobuninzi-nokuba zigidi okanye ezinye iirekhodi. Oku kuya kuba luncedo, umzekelo, ukuba ufuna ukufaka iikholomu ezintsha okanye ukusebenzisa i-patch yedatha ethile.
Ukuba isiseko sedatha, esona sineenkcukacha ezidityanisiweyo, ziyakwazi ukurekhoda kwiirekhodi ezahlukeneyo. Oku kuthetha ukuba unokudala ubudlelwane phakathi kweetable. Ngokomzekelo, ukuba udibanisa itafile yabathengi ngetafile ze-Orders, ungayifumana yonke i-oda yokuthenga kwi-tafile ye-Orders ukuba umthengi omnye kwiithebula zabaxhasi aqhutywe, okanye aphinde ahlambulule ukuba abuyisele kuphela loo miyalelo elandelwa ngexesha elithile - okanye phantse nayiphi na inxalenye yentlanganiso onokuyicinga.
Isiseko sedatha singenza izibalo ezixineneyo kwiithayibhile ezininzi. Ngokomzekelo, unokuluhlu lweendleko kwiindawo ezininzi zokuthengisa, kuquka onke amanqaku angaphantsi kwee-totals, kwaye ngoko ke inani lokugqibela.
Isiseko sedatha singabambelela ubungqina obuhambelanayo kunye nedatha, oko kuthetha ukuba kunokuphepha ukuphindaphinda nokuqinisekisa ukuchaneka kwedatha ngokuyilwa kwayo kunye nohlu lweengxaki.
Yintoni Ukwakhiwa kwedatha?
Kwizinto ezilula, i-database yenziwe ngamacwecwe anemiqolo kunye nemiqolo. Idatha ihlukaniswe ngamacandelo kwitafile ukuze kuphephe ukuphindaphinda. Ngokomzekelo, ishishini linokuba netafile kubasebenzi, enye yabathengi kunye nomnye weeMveliso.
Umqolo ngamnye kwitafile kuthiwa irekhodi, kunye neeseli nganye yintsimi. Intsimi nganye (okanye ikholomu) ingaqwalaselwa ukuba ibambe uhlobo oluthile lwedata, njengenombolo, itekisi okanye umhla. Oku kukunyanzeliswa ngoluhlu lwemithetho ukuqinisekisa ukuba idatha yakho ilungile kwaye iyathembeka.
Iitheyibhile kwiziko lovimba bezonxibelelwano zidibaniswe ngundoqo. Le yesazisi kwitheyibhile nganye echaza ngokuthe ngqo umqolo. Itafile nganye inekholamu ephambili yintloko , kwaye nayiphina itafile efuna ukudibanisa kule tafile iya kuba nekholamu yangaphandle yowunikelo lwalo oluya kufana nelona litshixo lokuqala.
I-database iya kufaka iifom ukwenzela ukuba abasebenzisi bangene okanye bahlele idatha. Ukongeza, kuya kuba nesibonelelo sokuvelisa iingxelo ezivela kwiinkcukacha. Ingxelo nje impendulo yombuzo, obizwa ngokuba ngumbuzo kwi-database-thetha. Ngokomzekelo, unokwenza umbuzo kwiziko leenkcukacha ukuze ufumane inkcitho engenayo yenkampani kwixesha elithile. Idatha iya kubuya kuwe ingxelo ngeenkcukacha zakho eziceliwe.
Iimveliso eziSebenzi eziDatha
Ukufikelela kweMicrosoft ngenye yezona ziqonga ezidumileyo kwiimarike namhlanje. Ihamba ngeMicrosoft Office kwaye iyahambelana nayo yonke imveliso ye-Ofisi. Iquka idilesi kunye nokusetyenziswa okulula okukukhokelela ekuphuhlisweni kwedata yakho. Ezinye i- desktop yolwazi nazo ziyafumaneka, kufaka phakathi iFayileMaker Pro, i-LibreOffice Base (ekhululekile) kunye neData eliCacisayo.
Ukuba ucinga ngedatha yecandelo elide ukuya kwishishini elikhulu, unokufuna ukuqwalasela isiseko sedatha esekelwe kwiLwimi yoCwangciso oluCwangcisiweyo (SQL) . I-SQL yilwimi oluqhelekileyo yolwimi kwaye lisetyenziswe lulwazi oluninzi namhlanje.
I-Server yolwazi njenge-MySQL, iMicrosoft SQL Server, kunye ne-Oracle inamandla kakhulu-kodwa ixabisa kwaye ingaza ne-curve yokufunda.