{"id":27059,"date":"2018-09-11T07:52:07","date_gmt":"2018-09-11T12:52:07","guid":{"rendered":"https:\/\/plantbreedingsoftware.guru\/?p=48"},"modified":"2025-08-12T09:13:35","modified_gmt":"2025-08-12T09:13:35","slug":"data-standardization-the-crux-of-a-functioning-relational-database","status":"publish","type":"blog","link":"https:\/\/agronomix.com\/pt\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/","title":{"rendered":"Data Standardization: The Crux of a Functioning Relational Database"},"content":{"rendered":"

Imagine you are at your computer early in the morning, coffee in hand and running a query on all the crosses made in the past five years with genotype AG12ca5. The result is 20 crosses. You know that can\u2019t be right; there should be upward of 50. So you run the query again only to get the same result.<\/span><\/p>\n

This is where the nuances of data standardization become absolutely critical. After doing some digging and running additional queries using other characteristics, it was found that AG12ca5\u00a0was entered\u00a0into the\u00a0database\u00a0three different ways (AG12ca5, AG12cz5, AG12C5), either intentionally or unintentionally.<\/span><\/p>\n

If you don\u2019t standardize certain points of data, a functioning relational database is simply not possible. I like to say \u201cgarbage in equals garbage out\u201d when we are talking about the integrity of databases, and a relational database is dependent on quality data.<\/span><\/p>\n

It takes time, planning and consensus up front to work through the details. How should we notate trait names? Is it yield or grain yield? Hectares or bushels? It\u2019s not uncommon for some teams to take several days to come up with the naming convention they want to use; it really is an investment in the future.<\/span><\/p>\n

Once the naming conventions have been determined and there\u2019s\u00a0consensus\u00a0among those working in the database, it\u2019s important to have a system of checks and balances to keep the integrity of the database. For instance, a breeder maybe trying to enter AG12ca5 but their finger accidentally hits the 4 key. The database should alert you that this is a \u201cnew\u201d genotype and ask if that\u2019s what you really want to do. At that point, you\u2019ll be able to correct your mistake.<\/span><\/p>\n

It\u2019s a way of validating the information, and this type of feature is absolutely essential in keeping a highly functioning relational database. A rigorous detection system must be a part of the software. It\u2019s simply not an option.<\/span><\/p>\n

I hear stories all the time from breeders who are new to a plant breeding program and are sorting through 15 years of data on different spreadsheets, in different formats and where the trait names have changed. These are the types of situations that keep plant breeders up at night; they truly are nightmares to deal with and make sense of.<\/span><\/p>\n

Consistency is key. Consistency from breeder to breeder, consistency from year to year and consistency within crop species. As companies do more work in more locations, the need for uniformity increases.<\/span><\/p>\n

\"Shunsuke<\/p>\n

Every piece of data coming into that system must be scrutinized and interrogated upfront, or you risk losing that uniformity and thus, your functionality. Yes, it can be tedious but it will cost you if these measures aren\u2019t done.<\/span><\/p>\n

No matter the system, be diligent and take the time to standardize your data, and then work to keep it that way. Your breeders will be thankful you did, and so will your bottom line due to the increased efficiency, minimized duplication and improved analytical plus decision-making power given to your breeders.<\/span><\/p>\n

\n

First published on SeedWorld.com, March 2017<\/p>\n

Find out how AGROBASE Generation II\u00ae can help your plant breeding program: here<\/a><\/p>\n

\n

Dr Dieter Mulitze is Founder and CEO of Agronomix Software Inc.<\/a> – developers of the leading plant breeding software for breeders and variety testers used around the world.<\/i><\/p>","protected":false},"author":3,"featured_media":32611,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false},"tags":[40,69,35,71,70,33,34],"class_list":["post-27059","blog","type-blog","status-publish","has-post-thumbnail","hentry","tag-agtech","tag-dieter-mulitze","tag-genovix","tag-in-the-press","tag-insiders","tag-plant-breeding","tag-software"],"acf":[],"yoast_head":"\nData Standardization: The Crux of a Functioning Relational Database - Agronomix<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/agronomix.com\/pt\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Standardization: The Crux of a Functioning Relational Database\" \/>\n<meta property=\"og:description\" content=\"The nuances of data standardization become absolutely critical. If you don\u2019t standardize certain points of data, a functioning relational database is simply not possible.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/agronomix.com\/pt\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Agronomix\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T09:13:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/data-standardization.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1700\" \/>\n\t<meta property=\"og:image:height\" content=\"640\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/\",\"url\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/\",\"name\":\"Data Standardization: The Crux of a Functioning Relational Database - Agronomix\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/agronomix.com\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/data-standardization.jpg\",\"datePublished\":\"2018-09-11T12:52:07+00:00\",\"dateModified\":\"2025-08-12T09:13:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/agronomix.com\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/data-standardization.jpg\",\"contentUrl\":\"https:\\\/\\\/agronomix.com\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/data-standardization.jpg\",\"width\":1700,\"height\":640},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/data-standardization-the-crux-of-a-functioning-relational-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/agronomix.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Standardization: The Crux of a Functioning Relational Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/agronomix.com\\\/#website\",\"url\":\"https:\\\/\\\/agronomix.com\\\/\",\"name\":\"Agronomix\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/agronomix.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Standardization: The Crux of a Functioning Relational Database - Agronomix","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/agronomix.com\/pt\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/","og_locale":"pt_BR","og_type":"article","og_title":"Data Standardization: The Crux of a Functioning Relational Database","og_description":"The nuances of data standardization become absolutely critical. If you don\u2019t standardize certain points of data, a functioning relational database is simply not possible.","og_url":"https:\/\/agronomix.com\/pt\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/","og_site_name":"Agronomix","article_modified_time":"2025-08-12T09:13:35+00:00","og_image":[{"width":1700,"height":640,"url":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/data-standardization.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/","url":"https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/","name":"Data Standardization: The Crux of a Functioning Relational Database - Agronomix","isPartOf":{"@id":"https:\/\/agronomix.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/#primaryimage"},"image":{"@id":"https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/#primaryimage"},"thumbnailUrl":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/data-standardization.jpg","datePublished":"2018-09-11T12:52:07+00:00","dateModified":"2025-08-12T09:13:35+00:00","breadcrumb":{"@id":"https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/#primaryimage","url":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/data-standardization.jpg","contentUrl":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/data-standardization.jpg","width":1700,"height":640},{"@type":"BreadcrumbList","@id":"https:\/\/agronomix.com\/blog\/data-standardization-the-crux-of-a-functioning-relational-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/agronomix.com\/"},{"@type":"ListItem","position":2,"name":"Blog","item":"https:\/\/agronomix.com\/blog\/"},{"@type":"ListItem","position":3,"name":"Data Standardization: The Crux of a Functioning Relational Database"}]},{"@type":"WebSite","@id":"https:\/\/agronomix.com\/#website","url":"https:\/\/agronomix.com\/","name":"Agronomix","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/agronomix.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"}]}},"_links":{"self":[{"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/blog\/27059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/users\/3"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/media\/32611"}],"wp:attachment":[{"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/media?parent=27059"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/tags?post=27059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}