Funda ngeSikimu nobudlelwane bazo kulwazi

I-schema yilona isakhiwo semininingwane eqinisekisa ukuthi inhlangano

I-database ye-schema iqoqo lemethadatha echaza ubuhlobo ku-database. I-schema iphinda ichazwe ngokuthi isakhiwo noma isakhiwo se- database esichaza indlela idatha ehlelwe ngayo kumatafula.

I-schema ivame ukuchazwa kusetshenziswa uLimi Olufundwayo Oluhlelekile (SQL) njengochungechunge lwezitatimende ze-CREATE ezingasetshenziselwa ukuphinda ziphishekele i-schema ku-database entsha.

Indlela elula yokucabangela i-schema ukucabanga ngakho njengebhokisi elithatha amatafula, izinqubo ezigcinwe, ukubukwa kanye nalo lonke ulwazi olugciniwe. Umuntu anganika abantu ukufinyelela ebhokisini, nobunikazi bebhokisi lungashintshwa futhi.

Izinhlobo zesimiso sedatha

Kukhona izinhlobo ezimbili zesimiso se-database:

  1. I-database yesimiso se-database inikeza isakhiwo sokuthi ucezu ngalunye lwemininingwane lugcinwa kanjani ku-database.
  2. I-schema enengqondo inikeza isakhiwo kumatafula kanye nobuhlobo phakathi kwedatha. Ngokuvamile, i-schema enengqondo idalwe ngaphambi kwesimiso somzimba.

Ngokuvamile, abaqambi be-database basebenzise imodeli yedatha ukudala i-database yesimiso esekelwe kwisofthiwe ezosebenzisana nedatha.