What is Knowledge and Can it Be Managed
As the decade, and indeed, the millenium begins to draw to a close, the promise of technology is prevalent in…
Craig Mullins
Using Check Constraints to Simulate Domains
All of the popular RDBMS products provide table check constraints: Oracle, Informix, DB2, Sybase, and Microsoft SQL Server. Check constraints…
Tools for a Comprehensive Database Environment – Part 2
In the second of two parts, this article addresses database tools that focus on the analysis, reporting, and utilities of…
Tools for a Comprehensive Database Environment – Part 1
There are five major RDBMS products: Oracle, IBM DB2, Microsoft SQL Server, Sybase SQL Server, and Informix.
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…
Capability Maturity Model from a Data Perspective
The following outline maps the five levels of maturity to the manner in which organizations manage data — effectively outlining…
Denormalization Guidelines
Normalization is the process of putting one fact in one appropriate place. This optimizes updates at the expense of retrievals.…