Continuing my analysis of Oracle Apps R12. This time, the actual files on the server. There are over 1/2 million…
More analysis of the Oracle Applications R12 sample database, VIS.
LOTS of: Objects, Packages, Triggers by Table, and Source Code
The schema, APPS owns: 51284 PACKAGE BODies, 32991 VIEWS, 4183 TRIGGERs
There are over 57 million lines of source code in the APPS schema alone!
I did some initial schema analysis on Oracle Apps R12 sample database, VIS.
VIS uses hardly any primary keys, many non unique indexes, and a LOT of package and triggers.
Lots of potential for data integrity and tuning issues.
Reviews of some really useful PC performance testing software that I’ve been very pleasantly surprised by.
Over the past few years, I’ve stopped using the Update statement, and started using the Merge statement for updates instead. …
Why Is Your Software Such Crap??!!! Yes, I do expect your software to work. Don’t you? I expect it to be not just easy to use, but obvious to use. The simple business needs to be, simple. Not complex.
If you work with databases, you must look at the data.
How complex is your company’s application !?
Steve Jobs knows a lot about effective design! He’s a minimalist and constantly reducing things to their simplest level. It’s not simplistic. It’s simplified. Steve is a systems designer. He simplifies complexity.
The databases I work with deal with structured data. But so much of what I consume online is totally unstructured. Most ironic.