I-Database Instance ingaba ngokuqondile kwiDathayli
Isibonelo se-database sedatha ngokuvamile asiqondwa kahle ngoba sisho izinto ezehlukene kubathengisi abahlukene. Ivame ukusetshenziselwa kakhulu mayelana nokuqaliswa kwedatha ye-Oracle.
Okushiwo Okujwayelekile Ngenkathi Yedatha
Ngokuvamile, isenzakalo se- database sichaza indawo ephelele yedatha, kufaka phakathi isofthiwe ye-RDBMS, isakhiwo setafula, izinqubo ezigcinwe kanye nezinye izinhlelo zokusebenza. Abaphathi baseDatabase bangadala izimo eziningi ze-database efanayo ngezinhloso ezahlukene.
Isibonelo, inhlangano ene database yabasebenzi ingaba nezimo ezintathu ezihlukene: ukukhiqizwa (okusetshenziselwa ukuqukatha idatha ephilayo), pre-production (esetshenziselwa ukuhlola ukusebenza okusha ngaphambi kokukhululwa ekukhiqizeni) nokuthuthukiswa (esetshenziselwa abathuthukisi be-database ukudala ukusebenza okusha ).
I-Oracle Database Instances
Uma une database ye-Oracle , uyazi ukuthi isibonelo se-database sisho into ecacile.
Ngenkathi i-database ngokwalo ihlanganisa yonke idatha yesicelo kanye nemethadatha egcinwe kumafayela ngokomzimba kuseva, isibonelo siyinhlanganisela yesofthiwe kanye nenkumbulo esetshenziselwa ukufinyelela leyo datha.
Isibonelo, uma ungena ngemvume ku-database ye-Oracle, isikhathi sakho sokungena ngemvume yisibonelo. Uma uvala noma uvale ikhompyutha yakho, isibonelo sakho sanyamalala, kodwa i-database - nayo yonke idatha yakho - ihlale ingacacile. Isibonelo se-Oracle singathola idatha eyodwa kuphela ngesikhathi, kuyilapho i-database ye-Oracle ingatholakala ngama-multiple instances.
Izimo ze-SQL Server
Isibonelo se- SQL Server ngokuvamile sisho ukufakwa okuqondile kwe-SQL Server. Akuyona i-database ngokwayo; Kunalokho, kuyisofthiwe esetshenziselwa ukwakha i-database. Ukulondoloza izimo eziningi kungase kube usizo lapho ulawula izinsiza zeseva ngoba isenzakalo ngasinye singalungiselelwa imemori nokusetshenziswa kwe-CPU-into ongenayo ngokwezifiso ngabanye ngaphakathi kwesibonelo se-SQL Server.
Isu Lokubambisana Nesisombululo Nesimo Sokwazisa
Kungase kube usizo ukucabangela isenzakalo esimweni esinomlando wedatha. Lolu hlelo luyimethadatha echaza ukuklama kwedatha nokuthi idatha izohlelwa kanjani. Lokhu kufaka amatafula ayo kanye namakholomu abo kanye nanoma yimiphi imithetho elawula idatha. Isibonelo, ithebula lesisebenzi ku-database lingaba namakholomu egameni, ikheli, i-ID yomsebenzi kanye nezincazelo zemisebenzi. Lona isakhiwo, noma uhlelo, le-database.
Isibonelo se-database siyisithombe esifingqiwe sokuqukethwe okwamanje nganoma isiphi isikhathi, kufaka phakathi idatha ngokwalo kanye nobuhlobo bayo nakweminye idatha ku-database.