Category Archives: database design

The Lifecycle of Data

Most data is not static. No, data has a life in which it changes, is used for perhaps multiple purposes, and gets moved all over the place. So it makes sense to think about the lifecycle of your data at … Continue reading

Posted in archive, compliance, data, database design, information, operational, reference data, tools | 1 Comment

Database Capacity Planning

Most database implementations are anything but static. Once deployed, databases are queried, updated, loaded, unloaded, reorganized, and data is deleted and inserted from them on an ongoing basis. And data may be replicated to and from the database on a … Continue reading

Posted in capacity planning, database design, DBA | 1 Comment

Optimizing Database Performance, part 4: File Placement and Page Sizing

Portions of this tip were excerpted from my book Database administration: The complete guide to DBA practices and procedures (2nd edition). The first , second , and third parts of this series are also available. Today we start by discussing file placement and data … Continue reading

Posted in database design, DBA, performance | 3 Comments

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

Database Consistency Models

Just a short blog post today to point folks to a very well-written article on database consistency models titled On the Futility of Custom Consistency Models (posted on the Hacking, Distributed blog by Emin Gün Sirer). This blog post does a very … Continue reading

Posted in data, data integrity, Data Quality, database design | 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

View Usage Advice

One of the most fertile grounds for disagreement between database professionals is the appropriate usage of views. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach. When properly implemented and managed, views … Continue reading

Posted in database design, SQL, views | 4 Comments

The 7 Types of Database Design Reviews

A little more than two years ago I wrote about The Importance of Database Design Reviews here on this blog. The general idea of that post is that reviewing the scope and content of a database implementation before it moves … Continue reading

Posted in database design, indexing, normalization, performance, SQL | 11 Comments

DBA: Development Versus Production

There are many different ways to look at database administration. It can be done by task, by discipline, by DBMS, by server, and so on. But one useful way to look at DBA is in terms of the type of … Continue reading

Posted in availability, backup & recovery, change management, database design, DBA, SQL | 3 Comments

Top Ten Steps to Building the Right Indexes

One of the more vexing problems with relational database development is designing appropriate indexes. Perhaps the most important thing you can do to assure optimal application performance when accessing data in a relational/SQL database is to create correct indexes for … Continue reading

Posted in data, database design, indexing, SQL | Tagged | 2 Comments