Select Page

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

Author: Chuck Ezell | | 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

8 Things Every Beginner Oracle DBA Should Know

A checklist of eight critical skills and areas an entry-level Oracle DBA should be familiar with to succeed on the job.

Patrick Gates | November 30, 2016

Oracle Database Extended Support Deadlines: What You Need to Know

If you’re confused about Oracle’s extended support deadlines, you are not alone. Here’s an overview of what’s in store for 11g through 19c.

Steve Thompson | January 19, 2021

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.

CONTACT US

Work for Us

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

EXPLORE JOBS