If transactions execute serially??”one after the other??”their use of ACID properties
can be relatively easily guaranteed. Each transaction starts with the consistent state
of the previous transaction and, in turn, leaves a consistent state for the next transaction.
Concurrent usage introduces the need for sophisticated locking and other
coordination mechanisms to preserve the ACID properties of concurrent transactions
while delivering throughput and performance. Chapter 8 covered Oracle??™s
handling of locking and concurrency in depth.
What Does OLTP Mean?
Online transaction processing can be defined in different ways: as a type of computing
with certain characteristics, or as a type of computing in contrast to more
traditional batch processing.
General characteristics
Most OLTP systems share some of the following general characteristics:
High transaction volumes and large user populations
OLTP systems are the key operational systems for many companies, so these systems
typically support the highest volume and largest communities of any
systems in the organization.
Pages:
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451