The trend in recent years has been to decrease reliance on the DBMS (database management system). Using this approach, all code and logic gets moved to the middle tier. The database becomes nothing more than “a place to store persistent…
And the #1 killer of performance in a web application is…
OK, sure, if you write a query that takes 10 minutes, then your performance is going to be terrible. But of all the systems I have seen, usually there is somebody around who can both detect a long running query…
Tagged with: Application server, Database, Multitier architecture, Servers, thick database, web application development
Posted in BLOG, Consulting, Development
Posted in BLOG, Consulting, Development
Using UML Class Diagrams as a Data Modeling Tool
I have the dubious honor of having written the first ever book about UML data modeling (Oracle8 Database Design Using UML Object Modeling – 1998 Oracle Press). It was written to support the then new object extensions in Oracle8. Of course, no…
Tagged with: Class diagram, Data model, Oracle Designer, UML
Posted in BLOG, Consulting, Development
Posted in BLOG, Consulting, Development
The Software Architect’s Manifesto
We should insist on tools that support good architecture and allow us to build quality systems. There is no reason why systems built today should be harder to build than they were years ago. Just because we moved to the…
Tagged with: Architecture, Database, Database design, Software development
Posted in BLOG, Consulting, Development, Resources
Posted in BLOG, Consulting, Development, Resources
Tree Navigation in Web apps
Anyone can make a tree display, but tree navigation involves much more. What you really want on a tree includes all of the following: 1. Only load nodes that are necessary. 2. Provide the option to reload every time the tree…
Tagged with: PL/SQL, tips, web application development
Posted in BLOG, Code tips, Consulting, Development
Posted in BLOG, Code tips, Consulting, Development
Definition of business rules
First we need to recognize that the Business Rules Forum (BRF) folks see rules as pretty big things. Ron Ross talks about the possibility of 1000 or more rules in an ERP. I think of those as analysis rules. The more detailed implementation…
Tagged with: BRIM, Business rule, FAQ, Natural language
Posted in BLOG, Consulting, Development, Resources
Posted in BLOG, Consulting, Development, Resources
