top of page
  • Writer's picturekyle Hailey

Future of Cloud Computing and Relational Databases

I was talking to someone from Amazon who indicated that Amazon is moving more and more processing away from Oracle into the middle tier and object oriented databases with the idea being to reduce usage of Oracle as well as to remove data processing delay times. The time it takes me as a consumer to put an order in can be reduced if Amazon just at takes all my information and says “purchase complete” and then process all the data and mails me later if anything goes wrong.

Taking this idea farther, there are a lot of cases where processing doesn’t have to immediately be transactional. The transactional can be delayed in a lot of cases.

One accutely relevant recent example has been the recent naked shares scandal which helped sink the US banks much faster and deeper. These naked shares are when brokerage houses sell shares of a company that they don’t really have. Normally a brokerage house would be transactional about buying and selling, but in this case the brokerage house can sell without actually owning the stock and buy the stock later. If the risk of this kind of inconsistency is smaller than the overhead a slower more expensive system insures consistency then why not go with the inconsistency?

Of course in the case of the brokerage scandal the inconsistency might have been intentional and if so and if regulated would bring back a transactional system. There will always be the requirement for transactional systems guaranteeing the usage of relational databases.

Interesting article on the subject (including quotes from me)

4 views0 comments

Recent Posts

See All

Taking the black art out of SQL tuning

Nice article on DB Optimizer: Taking the black art out of SQL tuning by Martin Heller Embarcadero DB Optimizer 2 takes a methodical approach to SQL query analysis and optimization November 9, 2009


bottom of page