Transaction System

A transaction is a logical, atomic unit of work that contains one or more SQL statements. All Oracle transactions comply with the basic properties of a database transaction, known as ACID properties. ACID is an acronym for the following:

Atomicity - All tasks of a transaction are performed or none of them are. There are no partial transactions.

Consistency - The transaction takes the database from one consistent state to another consistent state.

Isolation - The effect of a transaction is not visible to other transactions until the transaction is committed

Durability - Changes made by committed transactions are permanent. After a transaction completes, the database ensures through its recovery mechanisms that changes from the transaction are not lost.

The transaction systems or online system is that the interactions between the user and the system. The user is the one to perform a complete business transaction through the short interactions in the response time that required for each interaction. A lot of transaction using of online system for business, each generation the technology is upgrading. Before we have transaction in business is few’ but this time and more time to comes our generation is improvement. Today’s a lot of transaction in business using online system deference companies’ used the internet to promote their products and services to serve the consumer.

Posted By: Sarah Jean Icoy