In our last post on cloud architectures, I covered a simple one-node Oracle Transportation Management instance on Amazon Web Services using EC2. This OTM cloud hosting configuration is well-suited to a development environment and is a very inexpensive option for teams that have on-staff database administration skills. For teams that do not have the
As I mentioned on Monday, I'll be starting a series of posts on Oracle Transportation Management (OTM) in the cloud. In the first stage of these posts, I'll be covering the set of feasible architectures given the infrastructure offerings at Amazon Web Services. And, as you might expect, we'll be starting with the simplest
I wanted to update readers to let them know of an upcoming post series on Oracle Transportation Management (OTM) in the cloud. Oracle Transportation Management is a powerful solution for businesses or 3PLs that need to take control of their supply chain planning and execution. While many organizations continue to run OTM in a
Ars had a great write-up a few weeks ago about the huge hash resource starvation attack that was uncovered awhile back (when I say awhile back, I mean from 2003). The press has been focused on the impact for a relatively small number of the affected vendors; this is not only somewhat unfair, but also leads
If you've ever worked under the hood with OTM, you'll know that there's some pretty serious normalization. As I recently explained, deleting a single order can involve traversing over a hundred tables. So, what does this network of table relationships look like? After some quick SQL and a few minutes in Gephi, we get
Did you find this post useful? Does your organization need Oracle services? We can help. Working with Oracle databases can be daunting to developers and analysts who lack a deep understanding of relational models and SQL. One excellent example of a mystifying pitfall is the dreaded ORA-02292: integrity constraint error. This error often
