Books for you

OLTP Basics | 203
Well-defined performance requirements
OLTP systems are central to core business operations, so users must be able to
depend on a consistent response time. OLTP systems often involve Service Level
Agreements that state the expected response times.
High availability
These systems are typically deemed mission-critical with significant costs resulting
from downtime.
Scalability
The ability to increase transaction volumes without significant degradation in
performance allows OLTP systems to handle fluctuations in business activity.
In short, OLTP systems must be able to deliver consistent performance at any time,
regardless of system load. Anything that affects these core systems can produce a
ripple effect throughout your entire organization, affecting both revenue and
profitability.
Online versus batch
Online transaction processing implies direct and conversational interaction between
the transaction processing system and its users. Users enter and query data using
forms that interact with the backend database.


Pages:
428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452