Monthly Archives: November 2011

Choosing a DBMS

Posted on November 28, 2011 by craig@craigsmullins.com

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 | 21 Comments

An Introduction to Database Design: From Logical to Physical

Posted on November 19, 2011 by craig@craigsmullins.com

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 | 17 Comments