Data Taxonomy / Schema Design

Data quality is largely a factor of what rules have been defined for creating new records and what systems have been put in place for adherence to those rules. Most companies struggle due to a deficiency in one or both of these, which leads to data elements like item descriptions or data classification taxonomy become subjective and prone to inconsistencies or errors.

With distributed plants and locations, material data is thereby subject to individual or organizational preferences, creating a fractured dataset that may be inconsistent, incomplete, duplicated or inadequate.

Over the years, we have developed a rich and comprehensive MRO data classification taxonomy (aka data dictionary), which covers over 5000 commodities, and is suitable for multiple industries. Based on our own internal taxonomy, we also develop custom data taxonomy for clients if needed.

Once the taxonomy is established for a client, that forms the foundation for an initial data cleansing and enrichment program, as well as serves as the basis for an ongoing data governance system.

The taxonomy typically has three main elements:

  • Noun – A broad grouping for a set of products. Examples of Nouns are belt, fasteners, pumps, bearings, etc.
  • Modifier – A sub classification for each Noun, based on the type of product, application or other similar criteria that helps uniquely identify a sub group. As an example, for the Noun “BELT”, the modifiers would be TOOTHED, V, FLAT, SAFETY, etc.
  • Attributes – Specific characteristics of a product, that serve as specifications for the item. Examples of Attributes for a BELT would be TYPE, NUMBER OF RIBS, MATERIAL, THICKNESS, INNER CIRCUMFERENCE, etc.
Taxonomy Example Taxonomy Example

Here’s an example of how 3 different inventory managers have created 3 different descriptions for the exact same item

Inventory Manager Purchase description
Peter (Site 1) SWITCH, PRESSURE 3 BAR 250 VAC: -25 C TO + 70°C SIEMENS XMLB002A2S11
Sam (Site 2) MONITOR, PRESSURE XMLB002A2S11 3 BAR 250 VAC -25 C TO + 70°C SIEMENS
Rob (Site 3) CONTACT, PRESSURE (SIEMENS); PRESSURE: 3 BAR 250 VAC XMLB002A2S11 -25 C TO + 70°C
Learn more about OptimizeMRO

OptimizeMRO has a proprietary readymade MRO taxonomy, as well as deep expertise in industry-standard taxonomies such as UNSPSC, eCl@ss, etc. Based on your industry and business purpose, our MDM Specialists can suggest the most suitable taxonomy for your company, or customize a standard taxonomy based on your specific needs.

Read More about Readymade MRO Taxonomy

A well-structured MRO Data Taxonomy is crucial to provide a reliable and scalable structure for the MRO materials database. Implementing a good MRO taxonomy enables accurate classification of materials into different commodity groups, so intelligent decisions can be supported by analytical data.

Read More about Benefits of MRO Data Taxonomy

Get answers for all your questions relating to MRO Data Taxonomy / Schema. We help you design a perfect taxonomy that matches your supply chain and specific to your industry.

Read More about Taxonomy / Schema FAQs
Talk to an MRO Taxonomy specialist today!
Call Now Button