 dhiguva paeraa aadhaaramga , OLTP  vyvasta rupakalpanalo pariganinchavalasina konni keelaka ansaalu emti ?
 systams design 
OLTP  sistom ‌ nu roopondhinchadaaniki ,  peddha sankhyalo ekakaala viniyogadaarulu sistom paniteerutho jokyam chesukorani desiner tappanisariga telusukovali . OLTP  sistom paniteerunu penchadaaniki ,  ooka desiner tappanisariga indices ‌ lu mariyu cluster ‌ l adhika viniyoganni nivaarinchaali .

OLTP  vyavasthala paniteeruku krindhi ansaalu keelakamainavi :

 roll ‌ byaak vibhagalu 
 roll ‌ byaak vibhagalu databases yokka bhaagaalu ,  ivi lavadevini venakki teeskunna sandarbhamlo lavadevila caryalanu rikard chestaayi .  roll ‌ byaak vibhagalu reed sthiratvam ,  roll ‌ byaak lavadhevilu mariyu databases recoveryni andistaayi .
 clusterlu 
 cluster anede okati ledha anthakante ekuva niluvu varusalanu kaligi unna okati ledha anthakante ekuva pattikalanu kaligi umdae schema .  databases ‌ loo pattikalanu clustering cheeyadam cherika kaaryakalaapaala paniteerunu meruguparusthundi .
 vivikta lavadhevilu 
 vivikta laavaadhevee anede lavadeveeki kattubadi umdae varku detaku sambamdhinchina anni maarpulanu vaayidaa vesthundi .  idi chinna ,  pampinhii cheyani lavadevila paniteerunu meruguparusthundi .
 black parimaanam 
 anavasaramina  I/O ni nivarinchadaniki deetaa black parimaanam garista parimitiloo opeerating sistom yokka black parimaanamlo bahulamgaa vundali .
 baffer kash parimaanam 
SQL  state ‌ ment ‌ lu anavasaramina vanarula viniyoganni nivarinchadaniki databases baffer kash ‌ ni upayoginchadaaniki tune cheyale .
 pattikalu mariyu roll ‌ byaak vibhagalaku dynamic sdhalam ketaayimpu 
 laavaadhevee prosessing monetarlu mariyu bahulha - thread sarvar 
 sevala samanvayam choose laavaadhevee prosessing maniter upayoginchabadutundi .  idi opeerating sistom lantidi mariyu adhika stayi graanulaaritiilo samanvayaanni chesthundu mariyu bahulha computing parikaraalanu vistarinchagaladu .
 vibhajana  ( databases )
 vibhajana upyogam labhyata mariyu bhadratanu konasagistune sadarana laavaadheveelanu kaligi unna cyte ‌ l paniteerunu penchutundi .
 databases tuning 
 databases tuning ‌ thoo , OLTP  sistom dani paniteerunu saadhyamainanta samardhavanthamgaa mariyu vaegamgaa penchutundi .
OLTP  sistom roopakartha ekakaalika viniyogadharula sanka sistom paniteeruku antharaayam kaliginchakundaa chooskovali .  konni keelaka amsaalaloo roll ‌ byaak vibhagalu unnayi  ( avasaramaite roll ‌ byaak ‌ ni enable cheyadanki lavadevila caryalanu rikard chesthundu );  cluster ‌ lu  ( zaayin aapareshan ‌ l paniteerunu merugupariche deetaa schema );  vivikta lavadhevilu  ( lavadhevilu jarigee varku deetaa marchabadadani nirdhaaristundi ,  idi paniteerunu meruguparusthundi );  black parimaanam  ( deetaa black parimaanaanni opeerating sistom black parimaanam yokka bahulamgaa nirdhaarinchadam dwara anavasaramina  I/O ni taggistundi );  baffer kash parimaanam  ( baffer kash ‌ ni upayoginchadaaniki  SQL  state ‌ ment ‌ lu tune cheyabadinappudu ,  idi anavasaramina viniyoganni nivaaristundi );  pattikalu mariyu roll ‌ byaak vibhagalaku sdhalam yokka dynamic ketaayimpu ;  lavadevila prosessing monetarlu  ( sevala samanvayam choose upayoginchabadutundi ,  bahulha computing parikaraalanu vistarinchagala opeerating sistom rakamgaa panichestundi );  databases vibhajanalu  ( vibhajanalanu upayoginchadam valana labhyata mariyu bhadratanu samatulyam chestunnappudu paniteeru perugutundhi );  mariyu databases tuning  (OLTP  sistom dani paniteerunu samardhavanthamgaa mariyu vaegamgaa penchukoovadaaniki anumatistundi ).