You know you're being sold something solid if the vendor start talking about multi-phase commit and/or multi-version currency control.
If they just splash you ACID all over as a mantra to tell you their database is reliable, be wary.
For databases that persist to disk, it is for example not possible to do that asynchronously and be ACID. You need, at the very least, to journal every write before confirming the write.
Last but not least, it is not possible to have 100% bulletproof transactions. Even with 2PC, or 3PC. There is always a windows of opportunity for a failure to screw your transaction.
If they just splash you ACID all over as a mantra to tell you their database is reliable, be wary.
For databases that persist to disk, it is for example not possible to do that asynchronously and be ACID. You need, at the very least, to journal every write before confirming the write.
Last but not least, it is not possible to have 100% bulletproof transactions. Even with 2PC, or 3PC. There is always a windows of opportunity for a failure to screw your transaction.