Actaully - they don't. I spent some time working with Oracle at a major installation where they could not come up with a good enough transactional fail secarios because a single mainframe was being replaced by a multiple DB node distributed system.
Oddly - the project failed...
Just because a large company says they do something - does not mean they actually do. Distributed Transcation as said by RDBMS companies actually is 'Distributed as long as nothing goes wrong'.
Distributed Transcation as said by RDBMS companies actually is 'Distributed as long as nothing goes wrong'.
Of course, that's the point of ACID. When something does go wrong, your database will rollback the distributed transaction and throw a scary ORA error rather than commit inconsistent data across the cluster. I've never known a properly configured Oracle system to break ACID.
I build these systems for a living, and I am quite certain that they can be made to work. Oracle is hard to set up, no doubt, but I would never blame it for the failure of a project...
Comments
You are way off the mark here. How do you propose to use a resource lock to solve the distribution problem?
Every major RDBMS that supports ACID compliant distributed transactions does exactly this.
Actaully - they don't. I spent some time working with Oracle at a major installation where they could not come up with a good enough transactional fail secarios because a single mainframe was being replaced by a multiple DB node distributed system.
Oddly - the project failed...
Just because a large company says they do something - does not mean they actually do. Distributed Transcation as said by RDBMS companies actually is 'Distributed as long as nothing goes wrong'.
Distributed Transcation as said by RDBMS companies actually is 'Distributed as long as nothing goes wrong'.
Of course, that's the point of ACID. When something does go wrong, your database will rollback the distributed transaction and throw a scary ORA error rather than commit inconsistent data across the cluster. I've never known a properly configured Oracle system to break ACID.
I build these systems for a living, and I am quite certain that they can be made to work. Oracle is hard to set up, no doubt, but I would never blame it for the failure of a project...