There are more formal definitions of these properties, such as ACID.) (These are very informal descriptions of atomicity and consistency. Consistency means that transactions always leave the data in a valid state. In a traditional RDBMS, this rollback happens automatically if a transaction cannot be completed.
If a transaction cannot be completed, the database system must roll back any steps that were already done as part of that transaction.
Atomicity means that an entire transaction always succeeds or fails as one unit of work, and is never left in a half-completed state. Transactions typically need to be atomic and consistent. Transactional events, which represent the transactions themselves, typically contain a time dimension, some numerical values, and references to other data. These interactions are typically business transactions, such as payments received from customers, payments made to suppliers, products moving through inventory, orders taken, or services delivered. Transactional data is information that tracks the interactions related to an organization's activities. OLTP systems record business interactions as they occur in the day-to-day operation of the organization, and support querying of this data to make inferences. The management of transactional data using computer systems is referred to as online transaction processing (OLTP).
0 kommentar(er)
