Transactions may also occur in other environments, for example between an organisation and its staff (HR applications), in marketing, production control and elsewhere. An example of a transaction would be processing a customer order and all the ancillary requirements that go along with that, such as decrementing inventory, arranging shipping, placing manufacturing orders and so on. Relational database management systems (DBMSs) were originally designed to support transaction processing. Transaction processing databases are databases that have been designed specifically to optimise the performance of transaction processing, which is often referred to as OLTP (online transaction processing). ![]() While theoretically transaction processing is a subset of event processing the integrity considerations described above mean that it is treated as a separate function. Transaction processing is designed to maintain database integrity (the consistency of related data items) in a known, consistent state.Ī transaction, a typical example of which would be a customer order, consists of a series of events (accepting the order, allocating stock and so forth) that are treated as a whole. Transaction processing means dividing information processing up into individual, indivisible operations, called transactions, that complete or fail as a whole a transaction can’t remain in an intermediate, incomplete, state (so other processes can’t access the transaction’s data until either the transaction has completed or it has been “rolled back” after failure). ![]() This page has been archived, please visit the Operational Databases page for related content.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |