Isingeniso Semininingwane, i-SQL, ne-Microsoft Access
Phezulu, i- database ingase ibonakale njengepredishithi; ine idatha ehlelwe kukholomu nemigqa. Kodwa yilapho ukufana kufinyelela khona ngoba i-database inamandla kakhulu.
Yini Ongayenza I-Database?
I-database idinga ukusebenza okubanzi. Isibonelo, umnyango wokuthengisa ungasheshe uphishe futhi uthole bonke abasebenzi abathengisayo abaye bazuza inani elithile lokuthengisa esikhathini esithile.
I-database ingabuyekeza amarekhodi amaningi-ngisho nezigidi noma amarekhodi amaningi. Lokhu kuyoba usizo, isibonelo, uma ufuna ukwengeza amakholomu amasha noma ukusebenzisa i-patch yedatha yohlu oluthile.
Uma i-database isobudlelwane , yiziphi izinqolobane eziningi, zingakwazi ukurekhoda amarekhodi etafuleni ezahlukene. Lokhu kusho ukuthi ungakha ubuhlobo phakathi kwamatafula. Isibonelo, uma uxhumanisa ithebula lamathenda ngetafula le-oda, ungathola yonke imiyalo yokuthenga etafuleni le-oda ukuthi ikhasimende elilodwa kusuka kuthebula lamakhasimende liye lacutshungulwa, noma liphinde lilungise ukubuyisela kuphela lawo ma-oda asetjenziswa ngesikhathi esithile - noma cishe noma yiluphi uhlobo lwenhlanganisela ongayicabanga.
I-database ingenza izibalo eziyinkimbinkimbi emathebula amaningi. Isibonelo, ungabhala izindleko ezitolo eziningi zokuthengisa, kufaka phakathi konke okungahle kwenzeke, futhi inani lokugcina.
I-database ingafakazela ukuhambisana nokuthembeka kwedatha, okusho ukuthi kungakugwema ukuphindaphindiwe nokuqinisekisa ukunemba kwedatha ngokuklama kwayo kanye nochungechunge lwezinkinga.
Kuyini Ukwakhiwa Kwemininingwane?
Elula, i-database yenziwe ngamatafula aqukethe amakholomu nemigqa. Idatha ihlukaniswe ngezigaba zibe amatafula ukuze ugweme ukuphindaphindiwe. Isibonelo, ibhizinisi lingase libe netafula labasebenzi, elinye lamakhasimende kanye nelinye lemikhiqizo.
Umugqa ngamunye etafuleni ubizwa ngokuthi irekhodi, futhi iseli ngalinye liyinsimu. Insimu ngayinye (noma ikholomu) ingahle yenzelwe ukubamba uhlobo oluthile lwedatha, njengenombolo, umbhalo noma usuku. Lokhu kuphoqelelwa uchungechunge lwemithetho ukuqinisekisa ukuthi idatha yakho inembile futhi iyathembeka.
Amatafula ku-database ehlobene nabo ahlanganiswe ngesikhiye. Lena i-ID etafuleni ngayinye ekhomba ngokulingana umugqa. Ithebula ngalinye linamakholomu oyinhloko oyinhloko , futhi noma yiliphi itafula elidinga ukuxhumanisa kulelo tafula lizoba nekholomu yangaphandle yekhiye elizobaluleka ngalo elikhiye lokuqala letafula.
I-database izofaka amafomu ukuze abasebenzisi bakwazi ukufaka noma ukuhlela idatha. Ngaphezu kwalokho, kuyoba nesakhiwo ukukhiqiza imibiko evela kudatha. Umbiko ungumphendvulo wombuzo othiwa umbuzo ku-database-khuluma. Ngokwesibonelo, ungase uphendule le database ukuze uthole imali engenayo yenkampani esikhathini esithile. I-database izobuyisela kuwe umbiko ngolwazi lwakho oluceliwe.
Imikhiqizo Yedatha Yedivamile
I-Microsoft Access ingenye yamapulatifomu egciniwe edatshulwa emakethe namuhla. Ihamba nge-Microsoft Office futhi iyahambisana nayo yonke imikhiqizo yeHhovisi. Iqukethe ama-wizard nokusetshenziswa okulula okukusebenzisa okukuqondisa ekuthuthukisweni kwedatha yakho. Amanye amarekhodi edeskithophu ayatholakala, kufaka phakathi i-FileMaker Pro, i-LibreOffice Base (okuyikho mahhala) neDathayli Enhle.
Uma ucubungula i-database yebhizinisi eliphakathi kuya kwelikhulu, ungase uthande ukucabangela imininingwane yevava esekelwe kuLimi Olufundwayo Oluhlelekile (SQL) . I-SQL yiyona ejwayelekile kakhulu yolwazi lwama database futhi lisetshenziswe yolwazi oluningi namuhla.
Ulwazi lwesiphakelalwazi olufana ne-MySQL, i-Microsoft SQL Server, ne-Oracle lunamandla kakhulu - kodwa lubiza futhi lungeza nge-curve yokufunda.