What are Online Transaction Processing (OLTP) systems?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are Online Transaction Processing (OLTP) systems?
Rating:
Online Transaction Processing (OLTP) systems are required in a distributed environment to execute queries in real-time. Examples of OLTP systems include satellite launching systems, inventory management systems etc. OLTP systems should be configured to eliminate skewness in the execution of queries. Skewness here refers to a situation in which some computers in a system are heavily loaded with queries, whereas others have hardly any query to execute. OLTP systems should also be scalable to meet the increasing demands of users.
Rating:
Was this information helpful?
Other articles
- What is direct path loading?
- What is user global area (UGA)?
- What is a request queue?
- What is a locally managed tablespace?
- What is resource plan directive?