Category Archives: data modeling

Data Modeling Concepts

Oftentimes organizations assign the DBA group the responsibility for data modeling, in addition to the more conventional physical database management tasks that are well-known DBA responsibilities. Of course, that does not mean that DBAs are well-trained in data modeling, nor does it … Continue reading

Posted in data, data modeling, DBA | Leave a comment

On DBA Tools, Utilities, Suites and Solutions

“Vendor speak” can be a difficult thing to decipher. And that is particularly true within the realm of DBA tools vendors. It would be easier if every vendor followed the same terminology… but, of course, they do not. And there is … Continue reading

Posted in backup & recovery, change management, data modeling, performance, tools | 1 Comment

A Brief Introduction to Data Normalization

Normalization is a series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redundancy and the chances of data becoming inconsistent. A table is … Continue reading

Posted in data modeling, database design, normalization | 5 Comments

Models Should Form the Basis of Database and Application Development

One of the biggest challenges facing today’s organizations is ensuring the right information reaches the right people so data is used appropriately and accurately. In the age of Big Data and analytics, there is even more data being churned out … Continue reading

Posted in analytics, Big Data, data modeling, NoSQL | 1 Comment

Surrogate Keys or Natural Keys?

If you’ve worked with relational database systems for any length of time you’ve probably participated in a discussion (argument?) about the topic of today’s blog post… surrogate keys. A great debate rages within the realm of database development about the use … Continue reading

Posted in data, data modeling, Data Quality, database design | 7 Comments

Inside the Data Reading Room: Late Summer 2013 Edition

Hello data reader… and welcome to the latest edition of Inside the Data Reading Room. Regular readers of this blog know that Inside the Data Reading Room is a semi-regular feature of this blog with the goal of introducing and reviewing new and classic … Continue reading

Posted in Big Data, book review, books, data integration, data modeling, Data Quality | 3 Comments

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