Database Architectures (Part 1)
This two-part article will help readers have a better understanding of the various database architectures that are available for application…
Data Articles
A Project Model is a Constrained Subset of an Enterprise Model
The material below argues that it is a simplistic understanding of the problem and the Project Model should be defined…
Patterns and the Zachman Framework
John Zachman originally called row one of his framework, “Scope” (1), representing the point of view of the CEO who…
What’s in a Name?
Establishing and enforcing naming conventions is typically one of the first duties to be tackled when implementing new software. Adequate…
Justification for an Enterprise Model
Purpose Models are created not only to represent the business needs of an application but can also depict the business…
Enterprise Information Architecture
The primary objective of an "architected" environment is to deliver higher quality, integrated systems and information at a significantly reduced…
The Warehouse Meets the Web
This article explores the expanding world of Web-enabled OLAP. The shortcomings of traditional client-server OLAP are identified followed by a…
Meta Data the Answer, What Was Question?
Some people talk about meta data all the time as though it holds the answer to ALL questions about managing…
Productivity Paradox
Have computers made us more productive? Have all the installs, upgrades, mips, modems, and migration plans been worth it? Have…
Top Ten Principles of DB Performance Tuning
Now, I would like to share with you some of my personal advice on tuning. These ten principles were discovered…