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…
Data Articles
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…
Modeling Realities: Communicating Consensus
Conflict in life is inevitable. Get more than one person in a room to discuss a subject and varying points…
Components of a Data Warehouse
Overall Architecture The data warehouse architecture is based on a relational database management system server that functions as the central…