Ngokusekelwe esigabeni esingezansi, yiziphi ezinye zezinto ezibalulekile okufanele zicatshangelwe lapho kuklanywa uhlelo lwe-OLTP?
Context:Ukwakhiwa kwezinhlelo Ukuze kwakhiwe uhlelo lwe-OLTP, umklami kumelwe azi ukuthi inani elikhulu labasebenzisi ngesikhathi esisodwa aliphazamisi ukusebenza kohlelo. Ukuze kwandiswe ukusebenza kohlelo lwe-OLTP, umklami kumelwe agweme ukusetshenziswa ngokweqile kwezinkomba namaqoqo.  Izakhi ezilandelayo zibalulekile ekusebenzeni kwezinhlelo ze-OLTP:  Izingxenye zokuhlehla Izingxenye zokubuyisa emuva yizingxenye zedatha eziqopha izenzo zokuthengiselana uma kwenzeka ukuthi ukuthengiselana kubuyiselwe emuva. Izingxenye zokubuyisa emuva zinikeza ukuvumelana kokufundwa, ukuthengiselana kokubuyisa emuva, nokubuyiselwa kwedatha. Amaqoqo Iqoqo liyisikimu esiqukethe itafula elilodwa noma amaningi anekholomu elilodwa noma amaningi afanayo. Ukuhlanganisa amatafula abe ngamaqoqo ku-database kuthuthukisa ukusebenza kwemisebenzi yokuhlanganisa. Ukuthengiselana okuhlukile Ukuthengiselana okuhlukanisiwe kuhlehlisa zonke izinguquko kudatha kuze kube yilapho ukuthengiselana kuzibophezele. Ingathuthukisa ukusebenza kwezinto ezimfushane, ezingatshalaliswa. Usayizi webhulokhi Ubukhulu bebhulokhi ledatha kufanele bube yiziningi zobukhulu bebhulokhi yohlelo lokusebenza ngaphakathi komkhawulo ophakeme ukuze kugwenywe i-I/O engadingekile. Usayizi we-buffer Izitatimende ze-SQL kufanele zilungiswe ukuze zisebenzise i-database buffer cache ukuze kugwenywe ukusetshenziswa kwemithombo okungadingekile. Ukwabiwa kwesikhala ngokuguquguqukayo kumatafula nezingxenye zokuhlehla Abaqaphi bokucubungula ukuthengiselana kanye nesiphakeli se-multi-thread I-monitor yokucubungula ukuthengiselana isetshenziselwa ukuxhumanisa izinsizakalo. Kufana nesistimu yokusebenza futhi kwenza ukuxhumanisa ezingeni eliphezulu le-granularity futhi kungahlanganisa amadivayisi amaningi wekhompyutha. Ukuhlukanisa (idatha) Ukusebenzisa ukwahlukanisa kwandisa ukusebenza kwamasayithi anokuthengiselana okuvamile kuyilapho kusalondolozwa ukutholakala nokuvikeleka. Ukuhlela i-database Ngokulungiswa kwedatha, uhlelo lwe-OLTP lungakhuphula ukusebenza kwalo ngendlela ephumelelayo futhi esheshayo ngangokunokwenzeka.
Umklami wesistimu ye-OLTP kufanele aqinisekise ukuthi inani labasebenzisi abahambisanayo aliphazamisi ukusebenza kwesistimu. Ezinye izakhi ezibalulekile zihlanganisa rollback izingxenye (okuyinto ukurekhoda izenzo ukuthengiselana ukuvumela rollback uma kunesidingo); amaqoqo (idatha schema okuyinto ngcono ukusebenza imisebenzi ujoyine); ukuthengiselana ehlukile (kuqinisekisa idatha ayishintshiwe kuze ukuthengiselana is uzibophezele, okuyinto ngcono ukusebenza); block usayizi (kunciphisa engadingekile I / O ngokuqinisekisa idatha block usayizi kuyinto kaningi usayizi uhlelo lokusebenza block); buffer usayizi isilondolozi (lapho SQL izitatimende zilungiselelwe ukusebenzisa isilondolozi isilondolozi, kubalekela ukusetshenziswa okungadingekile); ukwabiwa ashukumisayo isikhala amatafula kanye rollback izingxenye; ukuthengiselana ukucubungula Abaqaphi (esetshenziselwa ukuxhumanisa amasevisi, esebenza njengenhlangano uhlobo uhlelo lokusebenza ukuthi ungakwazi span amadivayisi amaningi Computing); izingxenye (ukusebenzisa izingxenye ngcono ukusebenza ngenkathi kulinganiswa ukutholakala kanye nokuvikeleka); kanye database tuning (ukuvumela uhlelo OLTP ukwandisa ukusebenza yayo ngokushesha futhi kahle).