Select Page

The DMAIC Roadmap: A Core Tool in the Six Sigma Approach

Author: Chuck Ezell | 3 min read | January 23, 2014

As we’ve discussed, Six Sigma is a set of techniques and tools for process improvement originally developed for assuring quality by decreasing manufacturing defects. It has evolved into a scientific method for project development.

When an organization that follows Six Sigma undertakes a project, it uses a system known as DMAIC as a framework. DMAIC allows a team to develop the project from its inception. It is sufficiently flexible to be applied to performance tuning.

What is DMAIC?

As Craig Gygi, Bruce Williams, and Neil DeCarlo, authors of Six Sigma for Dummies explain, it is “a formalized problem-solving process of Six Sigma.” The five steps can be easily applied to any business procedure. These five steps are:

  1. Define: Set the context and objectives for your improvement project.
  2. Measure: Determine the baseline performance and capability of the process or system you’re improving.
  3. Analyze: Use data and tools to understand the cause-and-effect relationships in your process or system.
  4. Improve: Develop the modifications that lead to a validated improvement in your process or system.
  5. Control: Establish plans and procedures to ensure that your improvements are sustained.

Each of these steps is equally important in the Six Sigma process. When you assign more importance to one step, you risk giving short shrift to another. The “Control” step is a prime example since it often is overlooked by project managers who would like to wrap up and move on (however, that’s a conversation best left to another post).

How does DMAIC apply to database management?

Defining a problem is not always so simple. A way to think about this is to identify improvements that you or the customer — not always an external entity, but perhaps a department or group your organization is supporting — wants as a result of this process. What goals should be met with this project? Do you want fewer data entry errors? Should queries be returned faster?

How do you measure the improvements you’re striving for? You need to outline exactly what data needs to be measured and find the tools or applications that are able to collect data and measure the results.

“Analyze” is a critical step in DMAIC, but no more important than any other in this process. Analysis allows performance to be stripped to its essence. How does the actual performance of the database or some aspect of the database, for example, differ from that of the target? Is there room for improvement? Should the process be changed? Does the process affect data output? How can improvements be reached?

The “Improve” step drives the quest for quality forward. What solutions can help improve the targeted process? Testing is an integral part of this DMAIC stage. As we know, testing is very important to make sure a performance-tuning effort doesn’t trigger a cascade of unintended consequences.

“Control” is an essential part of the process. The project must be monitored to see if changes have taken root as outlined, and that the entire project is indeed moving forward successfully. This might be making sure that policies and procedures for data entry are adhered to, that a new tool is effective, or that training for a new project is successful. A project is not simply checked off as “finished,” but steps are taken to ensure results are maintained.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

PostgreSQL vs. Oracle: Let’s Compare

Discover some key differences between PostgreSQL vs Oracle that can help you make an informed decision when deciding on a database management system.

Vijay Muthu | March 30, 2021

Oracle RMAN Backup and Recovery with Restore Points

Oracle restore points are useful for benchmark testing. Find out how you can use Oracle’s Recovery Manager (RMAN) tool to create and use restore points.

Cindy Putnam | May 3, 2019

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.