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 unquiesced state?
- What is ALTER SESSION statement?
- What is high water mark?
- What is a hash cluster?
- What is EXPLAIN PLAN statement?