ACID Transactions

Data Integrity

Easily switch between complete transaction control for absolute data integrity to no transaction durability for performance, over the same data.

ACID Compliance

Recovery of all committed transactions from any software or hardware failure not involving storage media damage is fully automatic.

OLTP Performance

Balance performance and integrity needs for high-performance on-line transaction processing controls. Flexible FairCom DB transaction options means you don’t completely sacrifice either.

Data Integrity

Your business IS your data. Avoid the risk of data loss as only a transactional database model can provide. Complete ACID compliant transaction control is your safest technique to ensure consistent and recoverable data. FairCom DB supports fast, configurable transaction processing along with automatic recoverability when necessary.

ACID

ACID is a proven model guaranteeing database integrity. Unlike many NoSQL solutions, FairCom DB provides ACID guarantees on both NoSQL AND SQL transactions, concurrently. Each FairCom DB transaction, whether NoSQL or SQL, meets these four characteristics to ensure data integrity and consistency:

Atomicity

A transaction should be completed in its entirety or not at all. If a transaction aborts in the middle, all operations up to that point should be undone completely.

Consistency

A transaction should transform a database from one consistent state to another consistent state.

Isolation

Each transaction should occur independently of other transactions occurring at the same time.

Durability

Committed transactions should be fully recoverable in all but the most extreme circumstances. Write-ahead logs provide absolute data durability until data is eventually written into permanent data and index files.

FairCom DB Transaction Processing Models

Full Transaction Processing

tranproc_graphs_transaction_process

Full Transaction Processing provides for complete data integrity with full ACID compliance. For maximum flexibility, FairCom DB allows you to create your files under full transaction processing, and access them later without transaction logging. This can greatly enhance the performance of many back-office administrative tasks where recoverability is not necessary.

Deferred Logging

tranproc_graphs_deferred_loging

Deferred Log Sync Transaction processing allows transaction updates to remain cached in file system buffers for very brief periods. This short and configurable data sync-to-disk delay can provide transaction throughput performance gains of up to 300%. For applications tolerable of minute transaction loss up front performance rewards can be huge.

PreImage Transactions

tranproc_graphs_preimage_transactions

PreImage Transaction Processing provides high-speed, guaranteed atomic transactions without transaction logging. Although no protection from catastrophic failure is provided, those environments that can provide other means of recovery enjoy all the other benefits of transaction management, including full commit and rollback, with a relatively small increase in processing overhead.

No Transaction Support

tranproc_graphs_no_transaction_support

No Transaction Processing is the simplest transaction level of all. It is never necessary to place a file under transaction management. A database administrator may, with the proper security authorization, reduce a previously transaction-managed file to the non-managed level. This provides the ability to perform efficient batch-style processing upon files whose data integrity can be protected by other means during the batch updates.

Automatic Recovery

Write-Ahead Logs for Data Durability

FairCom’s transaction management system maintains transaction log files recording information necessary to recover from unexpected problems. A chronological series of platform-optimized transaction logs are maintained during the operation of the server. Should an event occur that halts FairCom DB server processing, these logs are replayed on the next FairCom DB restart, fully restoring your database to a consistent state up to and including the last committed transaction. Not only are index rebuilds avoided, but relational integrity between tables is also preserved when atomic transactions are used. Recovery is fully automatic requiring no administrative attention for truly unattended operations. At the end of recovery, FairCom DB is ready‑to‑run.

Prevent Deadlocks

Sophisticated Locking

FairCom DB employs sophisticated locking techniques to prevent deadlocks and ensure maximum concurrency and throughput. With a variety of locking techniques available, FairCom provides maximum flexibility for handling nearly any application data access requirement.

Flexible Transactions

Savepoints and Rollbacks on NoSQL

For complex transactions, you sometimes need more flexibility than simply committing or aborting all your valuable work. Savepoints allow developers to establish checkpoints within transactions, and, depending on conditions later in the transaction, roll back work performed to a prior point while keeping the remaining transaction open.

TRY IT FOR YOURSELF

Explore How FairCom DB Can Achieve Your Goals

×