Monthly Archives: November 2011

Choosing a DBMS

One of the questions I get on a regular basis is some variation of “how can I choose what DBMS is the best”… so I’ll try to offer some high-level guidance here. When mainframes dominated enterprise computing, the DBMS architecture … Continue reading

Posted in DB2, enterprise computing | 20 Comments

An Introduction to Database Design: From Logical to Physical

A proper database design cannot be thrown together quickly by novices. What is required is a practiced and formal approach to gathering data requirements and modeling data. This modeling effort requires a formal approach to the discovery and identification of … Continue reading

Posted in data integrity, data modeling, database design, DBA | 16 Comments