1032:
1042:
1052:
75:(OLAP), which is generally characterized by much more complex queries, in a smaller volume, for the purpose of business intelligence or reporting rather than to process transactions. Whereas OLTP systems process all kinds of queries (read, insert, update and delete), OLAP is generally optimized for read only and might not even support other kinds of queries. OLTP also operates differently from
107:(ATM) for a bank is an example of a commercial transaction processing application. Online transaction processing applications have high throughput and are insert- or update-intensive in database management. These applications are used concurrently by hundreds of users. The key goals of OLTP applications are availability, speed, concurrency and recoverability (
111:). Reduced paper trails and the faster, more accurate forecast for revenues and expenses are both examples of how OLTP makes things simpler for businesses. However, like many modern online information technology solutions, some systems require offline maintenance, which further affects the cost-benefit analysis of an online transaction processing system.
153:
Online transaction process concerns about concurrency and atomicity. Concurrency controls guarantee that two users accessing the same data in the database system will not be able to change that data or the user has to wait until the other user has finished processing, before changing that piece of
149:
Online transaction processing (OLTP) involves gathering input information, processing the data and updating existing data to reflect the collected and processed information. As of today, most organizations use a database management system to support OLTP. OLTP is carried in a client-server system.
119:
An OLTP system is an accessible data processing system in today's enterprises. Some examples of OLTP systems include order entry, retail sales, and financial transaction systems. Online transaction processing systems increasingly require support for transactions that span a network and may include
94:
to offer strong consistency in large-scale heterogeneous systems. Whereas OLTP is associated with short atomic transactions, OLEP allows for more flexible distribution patterns and higher scalability, but with increased latency and without guaranteed upper bound to the processing time.
162:
To build an OLTP system, a designer must know that the large number of concurrent users does not interfere with the system's performance. To increase the performance of an OLTP system, a designer must avoid excessive use of indexes and clusters.
30:
system used in transaction-oriented applications, such as many operational systems. "Online" refers to that such systems are expected to respond to user requests and process them in real-time (process transactions). The term is contrasted with
170:
Rollback segments: Rollback segments are the portions of database that record the actions of transactions in the event that a transaction is rolled back. Rollback segments provide read consistency, rollback transactions, and recovery of the
213:
monitors and the multi-threaded server: A transaction processing monitor is used for coordination of services. It is like an operating system and does the coordination at a high level of granularity and can span multiple computing
120:
more than one company. For this reason, modern online transaction processing software uses client or server processing and brokering software that allows transactions to run on different computer platforms in a network.
154:
data. Atomicity controls guarantee that all the steps in a transaction are completed successfully as a group. That is, if any steps between the transaction fail, all other steps must fail also.
185:
Discrete transactions: A discrete transaction defers all change to the data until the transaction is committed. It can improve the performance of short, non-distributed transactions.
87:
55:
it denotes an atomic change of state, whereas in the realm of business or finance, the term typically denotes an exchange of economic entities (as used by, e.g.,
642:
134:
For even more demanding decentralized database systems, OLTP brokering programs can distribute transaction processing among multiple computers on a
625:
637:
56:
421:
191:
size: The data block size should be a multiple of the operating system's block size within the maximum limit to avoid unnecessary I/O.
178:
that contains one or more tables that have one or more columns in common. Clustering tables in a database improves the performance of
220:: Partition use increases performance for sites that have regular transactions while still maintaining availability and security.
1076:
1035:
249:
Benchmarking
Transaction and Analytical Processing Systems: The Creation of a Mixed Workload Benchmark and its Application
708:
597:
298:
257:
131:
optimization tactics to facilitate the processing of large numbers of concurrent updates to an OLTP-oriented database.
1081:
1055:
761:
51:
The term "transaction" can have two different meanings, both of which might apply: in the realm of computers or
1012:
659:
123:
In large applications, efficient OLTP may depend on sophisticated transaction management software (such as IBM
325:
951:
139:
108:
103:
OLTP has also been used to refer to processing in which the system responds immediately to user requests. An
494:
226:: With database tuning, an OLTP system can maximize its performance as efficiently and rapidly as possible.
72:
32:
946:
977:
696:
446:
397:
900:
890:
666:
373:
36:
349:
201:
statements should be tuned to use the database buffer cache to avoid unnecessary resource consumption.
987:
720:
470:
104:
91:
936:
590:
560:
1017:
972:
649:
210:
992:
746:
60:
52:
1045:
982:
864:
834:
703:
654:
425:
217:
188:
8:
1002:
895:
880:
807:
632:
997:
941:
910:
859:
751:
691:
583:
204:
518:
817:
671:
253:
63:.) OLTP may use transactions of the first type to record transactions of the second.
40:
1007:
854:
844:
812:
135:
76:
915:
885:
839:
620:
570:
247:
223:
175:
967:
905:
849:
822:
715:
676:
80:
575:
273:
1070:
786:
771:
194:
776:
756:
422:"ISelfSchooling - What is cluster table - Index Cluster and Hash Cluster"
143:
166:
The following elements are crucial for the performance of OLTP systems:
920:
829:
791:
766:
565:
179:
781:
736:
606:
128:
27:
547:(architectural and application shifts affecting OLTP performance)
686:
681:
544:
566:
Transaction
Processing: Concepts & Techniques Management
741:
124:
35:(OLAP) which instead focuses on data analysis (for example
550:
198:
555:
374:"Online Transaction Processing vs. Decision Support"
326:"Application and System Performance Characteristics"
46:
252:. Berlin: Springer Science & Business Media.
1068:
605:
591:
598:
584:
556:Transaction Processing Performance Council
57:Transaction Processing Performance Council
299:"What is OLTP? The backbone of ecommerce"
241:
239:
86:In addition, OLTP is often contrasted to
320:
318:
207:of space to tables and rollback segments
1069:
350:"Database VLDB and Partitioning Guide"
296:
236:
90:(OLEP), which is based on distributed
579:
315:
274:"Online Event Processing - ACM Queue"
471:"Data Blocks, Extents, and Segments"
1051:
245:
66:
13:
495:"Tuning the Database Buffer Cache"
14:
1093:
538:
157:
1050:
1040:
1031:
1030:
519:"Transaction processing monitor"
138:. OLTP is often integrated into
71:OLTP is typically contrasted to
1041:
511:
487:
463:
47:Meaning of the term transaction
439:
414:
390:
366:
342:
290:
266:
1:
297:Heller, Martin (2022-02-18).
230:
140:service-oriented architecture
20:Online transaction processing
398:"Managing Rollback Segments"
73:online analytical processing
33:online analytical processing
7:
1077:Database management systems
607:Database management systems
114:
10:
1098:
1013:Object–relational database
1026:
988:Federated database system
960:
929:
873:
800:
729:
721:Blockchain-based database
613:
551:IBM CICS official website
174:Clusters: A cluster is a
105:automated teller machine
88:online event processing
61:commercial transactions
16:Type of database system
1082:Transaction processing
1018:Transaction processing
973:Database normalization
916:Query rewriting system
211:Transaction processing
98:
993:Referential integrity
53:database transactions
983:Distributed database
218:Partition (database)
1003:Relational calculus
881:Concurrency control
447:"Transaction Modes"
998:Relational algebra
942:Query optimization
747:Armstrong's axioms
246:Bog, Anja (2013).
205:Dynamic allocation
41:management systems
1064:
1063:
672:Wide-column store
667:Document-oriented
1089:
1054:
1053:
1044:
1043:
1034:
1033:
1008:Relational model
978:Database storage
855:Stored procedure
600:
593:
586:
577:
576:
533:
532:
530:
529:
515:
509:
508:
506:
505:
491:
485:
484:
482:
481:
467:
461:
460:
458:
457:
443:
437:
436:
434:
433:
424:. Archived from
418:
412:
411:
409:
408:
394:
388:
387:
385:
384:
370:
364:
363:
361:
360:
346:
340:
339:
337:
336:
322:
313:
312:
310:
309:
294:
288:
287:
285:
284:
270:
264:
263:
243:
77:batch processing
67:Compared to OLAP
1097:
1096:
1092:
1091:
1090:
1088:
1087:
1086:
1067:
1066:
1065:
1060:
1022:
968:Database models
956:
925:
911:Query optimizer
886:Data dictionary
869:
840:Transaction log
796:
752:Codd's 12 rules
725:
655:Column-oriented
621:Object-oriented
609:
604:
545:H-Store Project
541:
536:
527:
525:
517:
516:
512:
503:
501:
493:
492:
488:
479:
477:
469:
468:
464:
455:
453:
445:
444:
440:
431:
429:
420:
419:
415:
406:
404:
396:
395:
391:
382:
380:
372:
371:
367:
358:
356:
348:
347:
343:
334:
332:
324:
323:
316:
307:
305:
295:
291:
282:
280:
272:
271:
267:
260:
244:
237:
233:
224:Database tuning
160:
117:
101:
69:
49:
26:) is a type of
17:
12:
11:
5:
1095:
1085:
1084:
1079:
1062:
1061:
1059:
1058:
1048:
1038:
1027:
1024:
1023:
1021:
1020:
1015:
1010:
1005:
1000:
995:
990:
985:
980:
975:
970:
964:
962:
961:Related topics
958:
957:
955:
954:
949:
944:
939:
937:Administration
933:
931:
927:
926:
924:
923:
918:
913:
908:
906:Query language
903:
898:
893:
888:
883:
877:
875:
871:
870:
868:
867:
862:
857:
852:
847:
842:
837:
832:
827:
826:
825:
820:
815:
804:
802:
798:
797:
795:
794:
789:
784:
779:
774:
769:
764:
759:
754:
749:
744:
739:
733:
731:
727:
726:
724:
723:
718:
713:
712:
711:
701:
700:
699:
689:
684:
679:
674:
669:
664:
663:
662:
652:
647:
646:
645:
640:
630:
629:
628:
617:
615:
611:
610:
603:
602:
595:
588:
580:
574:
573:
568:
563:
558:
553:
548:
540:
539:External links
537:
535:
534:
510:
486:
462:
438:
413:
389:
365:
341:
314:
289:
265:
259:978-3642380709
258:
234:
232:
229:
228:
227:
221:
215:
208:
202:
192:
186:
183:
172:
159:
158:Systems design
156:
116:
113:
100:
97:
81:grid computing
68:
65:
48:
45:
15:
9:
6:
4:
3:
2:
1094:
1083:
1080:
1078:
1075:
1074:
1072:
1057:
1049:
1047:
1039:
1037:
1029:
1028:
1025:
1019:
1016:
1014:
1011:
1009:
1006:
1004:
1001:
999:
996:
994:
991:
989:
986:
984:
981:
979:
976:
974:
971:
969:
966:
965:
963:
959:
953:
950:
948:
945:
943:
940:
938:
935:
934:
932:
928:
922:
919:
917:
914:
912:
909:
907:
904:
902:
899:
897:
894:
892:
889:
887:
884:
882:
879:
878:
876:
872:
866:
863:
861:
858:
856:
853:
851:
848:
846:
843:
841:
838:
836:
833:
831:
828:
824:
821:
819:
816:
814:
811:
810:
809:
806:
805:
803:
799:
793:
790:
788:
787:Surrogate key
785:
783:
780:
778:
775:
773:
772:Candidate key
770:
768:
765:
763:
760:
758:
755:
753:
750:
748:
745:
743:
740:
738:
735:
734:
732:
728:
722:
719:
717:
714:
710:
707:
706:
705:
702:
698:
695:
694:
693:
690:
688:
685:
683:
680:
678:
675:
673:
670:
668:
665:
661:
658:
657:
656:
653:
651:
648:
644:
641:
639:
636:
635:
634:
631:
627:
624:
623:
622:
619:
618:
616:
612:
608:
601:
596:
594:
589:
587:
582:
581:
578:
572:
569:
567:
564:
562:
559:
557:
554:
552:
549:
546:
543:
542:
524:
520:
514:
500:
496:
490:
476:
472:
466:
452:
448:
442:
428:on 2014-05-14
427:
423:
417:
403:
399:
393:
379:
378:Microsoft.com
375:
369:
355:
351:
345:
331:
327:
321:
319:
304:
300:
293:
279:
278:queue.acm.org
275:
269:
261:
255:
251:
250:
242:
240:
235:
225:
222:
219:
216:
212:
209:
206:
203:
200:
196:
193:
190:
187:
184:
181:
177:
173:
169:
168:
167:
164:
155:
151:
147:
145:
141:
137:
132:
130:
126:
121:
112:
110:
106:
96:
93:
89:
84:
82:
78:
74:
64:
62:
58:
54:
44:
42:
38:
34:
29:
25:
21:
526:. Retrieved
522:
513:
502:. Retrieved
498:
489:
478:. Retrieved
474:
465:
454:. Retrieved
450:
441:
430:. Retrieved
426:the original
416:
405:. Retrieved
401:
392:
381:. Retrieved
377:
368:
357:. Retrieved
353:
344:
333:. Retrieved
329:
306:. Retrieved
302:
292:
281:. Retrieved
277:
268:
248:
195:Buffer cache
165:
161:
152:
148:
144:Web services
133:
122:
118:
102:
85:
70:
50:
23:
19:
18:
1056:WikiProject
947:Replication
835:Transaction
777:Foreign key
757:CAP theorem
704:Multi-model
571:HPE NonStop
561:OLTP Schema
182:operations.
1071:Categories
921:Query plan
874:Components
792:Unique key
709:comparison
643:comparison
633:Relational
626:comparison
528:2018-05-07
504:2018-05-07
499:Oracle.com
480:2018-05-07
475:Oracle.com
456:2018-05-07
451:Oracle.com
432:2014-05-14
407:2018-05-07
402:Oracle.com
383:2018-05-07
359:2018-05-02
354:Oracle.com
335:2018-05-02
330:Oracle.com
308:2022-09-27
283:2019-05-30
231:References
142:(SOA) and
109:durability
92:event logs
930:Functions
865:Partition
692:In-memory
650:Key–value
303:InfoWorld
171:database.
127:) and/or
1036:Category
952:Sharding
808:Relation
782:Superkey
737:Database
730:Concepts
214:devices.
129:database
115:Overview
37:planning
28:database
1046:Outline
845:Trigger
801:Objects
136:network
860:Cursor
818:column
687:NewSQL
523:C2.com
256:
197:size:
176:schema
850:Index
813:table
716:Cloud
682:NoSQL
677:Graph
614:Types
189:Block
901:ODBC
891:JDBC
830:View
767:Null
762:CRUD
742:ACID
697:list
660:list
638:list
254:ISBN
180:join
125:CICS
79:and
39:and
24:OLTP
896:XQJ
823:row
199:SQL
99:Use
59:or
43:).
1073::
521:.
497:.
473:.
449:.
400:.
376:.
352:.
328:.
317:^
301:.
276:.
238:^
146:.
83:.
599:e
592:t
585:v
531:.
507:.
483:.
459:.
435:.
410:.
386:.
362:.
338:.
311:.
286:.
262:.
22:(
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.