Category Archives: data modeling

A Question on Logical Modeling and Normalization

I received the following question and thought I’d answer it on the blog: Question: I work in a data-modeling environment with the responsibility of logically modeling (LM) data for mainframe and server databases. LM for the OLTP systems are done … Continue reading

Posted in data modeling, normalization | 8 Comments

Thoughts on Data Quality

Data quality is an elusive goal. The more we try to keep accurate records in database systems, the more it seems that at least some of that data is just plain wrong. Why is this so? Speed to market issues … Continue reading

Posted in change management, data, data modeling, Data Quality, tools | 4 Comments

On Design, the Internet, and Taming the Hostile Database

When DBAs are involved in designing databases that need to support Internet-enabled applications it seems that common sense and data management knowledge frequently fly out the window. Why is this? In today’s post we will investigate the impact of e-business … Continue reading

Posted in data, data modeling, DBA, enterprise computing | 2 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

The Many Different Types of DBAs

Although DBAs, at a high level, are tasked with managing and assuring the efficiency of database systems, there are actually many different DBAs. Some focus on logical design; others focus on physical design; some DBAs specialize in building systems and … Continue reading

Posted in data modeling, DBA | 4 Comments

Data Modeling Concepts Every DBA Should Know

Organizations often force the DBA to take on the job of data modeling. Unfortunately, that does not mean that the DBAs are always well-trained in data modeling, nor does it mean that DBAs are best suited to take on the … Continue reading

Posted in data modeling, DBA | Tagged | 6 Comments