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 all we do, see, hear, and
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 enable enhanced …
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 database
Tools for a Comprehensive Database Environment – Part 1
There are five major RDBMS products: Oracle, IBM DB2, Microsoft SQL Server, Sybase SQL Server, and
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 thought and …
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 the structure of a …
Denormalization Guidelines
Normalization is the process of putting one fact in one appropriate place. This optimizes updates at the expense of retrievals. When a fact is stored in only …