{"id":27051,"date":"2018-08-24T10:00:13","date_gmt":"2018-08-24T15:00:13","guid":{"rendered":"https:\/\/plantbreedingsoftware.guru\/?p=70"},"modified":"2025-08-12T09:13:36","modified_gmt":"2025-08-12T09:13:36","slug":"relational-database-jargon-or-jewel","status":"publish","type":"blog","link":"https:\/\/agronomix.com\/pt\/blog\/relational-database-jargon-or-jewel\/","title":{"rendered":"Relational Database: Jargon or Jewel?"},"content":{"rendered":"<p><span lang=\"EN-US\" style=\"margin: 0; color: #333333; font-family: 'Georgia', serif;\">Not very long ago data management was overwhelming when handling multiple years of data or even multiple crop portfolios. This might still be the case for breeders who are using software that\u2019s not designed for the task at hand.<\/span><\/p>\n\n\n\n<p><span lang=\"EN-US\" style=\"margin: 0; color: #333333; font-family: 'Georgia', serif;\">As a former breeder, I know it\u2019s more important than ever to easily enter data, compare data and analyses over multiple years, as well as locations, regardless of crop type. I also know that data can accumulate very fast and that is where time management and optimal decision-making can be heightened through proper data management.<\/span><\/p>\n\n\n\n<div class=\"wp-block-image\">\n<figure>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28340\" src=\"https:\/\/genovix.io\/wp-content\/uploads\/2018\/09\/dreamstime_1372001-300x217.jpg\" alt=\"Dreamstime 1372001\" width=\"701\" height=\"507\" srcset=\"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/dreamstime_1372001-300x217.jpg 300w, https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/dreamstime_1372001-768x555.jpg 768w, https:\/\/agronomix.com\/wp-content\/uploads\/2018\/09\/dreamstime_1372001.jpg 800w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><\/p>\n<\/figure>\n<\/div>\n\n\n\n<p><span lang=\"EN-US\" style=\"margin: 0; color: #333333; font-family: 'Georgia', serif;\">This is where a relational database management system excels.\u00a0Now\u00a0what exactly is a relational database management system, or RDBS as it\u2019s known in the tech world? Essentially, it\u2019s a database where all the data is interconnected for the maximum advantage of the breeder.<\/span><\/p>\n\n\n\n<p><span lang=\"EN-US\" style=\"margin: 0; color: #333333; font-family: 'Georgia', serif;\">When it comes to\u00a0plant\u00a0breeding,\u00a0a\u00a0RDBS\u00a0should do be able to perform tasks like:<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li style=\"margin: 0; color: #333333; font-family: 'Georgia', serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span lang=\"EN-US\" style=\"margin: 0; font-family: 'Georgia', serif;\">Link data across generations to see the response to selection. For example, if I\u2019m looking at an F5 population, I can see where it came from with the stroke of a key, and this helps in the selection process.<\/span><\/li>\n<li style=\"margin: 0; color: #333333; font-family: 'Georgia', serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span lang=\"EN-US\" style=\"margin: 0; font-family: 'Georgia', serif;\">Link the parents and their data to every cross and all the generations. For example, if I\u2019m looking at an F4, I should be able to easily view parental data. If one parent is resistant and one is susceptible and all my genotypes are susceptible, somewhere I\u2019ve made a mistake.<\/span><\/li>\n<li style=\"margin: 0; color: #333333; font-family: 'Georgia', serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span lang=\"EN-US\" style=\"margin: 0; font-family: 'Georgia', serif;\">Link DNA information or markers to any genotype in the whole breeding program for legal compliance or improved selection processes.<\/span><\/li>\n<li style=\"margin: 0; color: #333333; font-family: 'Georgia', serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span lang=\"EN-US\" style=\"margin: 0; font-family: 'Georgia', serif;\">Easily pull all the data for a specific genotype or several. When it\u2019s time to register a variety for release, depending on the country, the breeder must provide documentation of where it was planted, all the data associated with those plantings and from which populations it was derived. This alone could save your team two to three weeks of time, depending on the methods currently used.<\/span><\/li>\n<li style=\"margin: 0; color: #333333; font-family: 'Georgia', serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span lang=\"EN-US\" style=\"margin: 0; font-family: 'Georgia', serif;\">Quickly and easily compare hybrids or varieties &#8220;head-to-head&#8221; from hundreds of trials \u2014 crucial in any seed company&#8217;s success for releasing the next superior royalty paying hybrid or variety.<\/span><\/li>\n<\/ul>\n\n\n\n<p><span lang=\"EN-US\" style=\"margin: 0; color: #333333; font-family: 'Georgia', serif;\">A relational database connects data in a way that\u2019s useful and meaningful for a breeder. That helps to increase profits and regain or maintain a competitive edge.<\/span><\/p>\n\n\n\n<p>(<em>First published on SeedWorld.com | July 2016<\/em>)<\/p>\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n<p><em>Dr Dieter Mulitze is Founder and CEO of <a href=\"https:\/\/agronomix.com\/pt\/\">Agronomix Software<\/a> &#8211; leading software for plant breeders and variety testers.<\/em><\/p>","protected":false},"author":3,"featured_media":32619,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false},"tags":[40,36,69,35,71,70,34,62],"class_list":["post-27051","blog","type-blog","status-publish","has-post-thumbnail","hentry","tag-agtech","tag-data-management","tag-dieter-mulitze","tag-genovix","tag-in-the-press","tag-insiders","tag-software","tag-technology"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Relational Database: Jargon or Jewel? - 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\/relational-database-jargon-or-jewel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Relational Database: Jargon or Jewel?\" \/>\n<meta property=\"og:description\" content=\"Data management software for plant breeding has dramatically evolved during the past decade. Systems available in today\u2019s marketplace offer added benefits, such as global access, varying security permissions and data configurations that developers a decade ago only dreamed of. Today\u2019s plant breeding software can give scientists a true competitive edge.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/agronomix.com\/pt\/blog\/relational-database-jargon-or-jewel\/\" \/>\n<meta property=\"og:site_name\" content=\"Agronomix\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T09:13:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/08\/relational-database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"533\" \/>\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\\\/relational-database-jargon-or-jewel\\\/\",\"url\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/relational-database-jargon-or-jewel\\\/\",\"name\":\"Relational Database: Jargon or Jewel? - Agronomix\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/relational-database-jargon-or-jewel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/relational-database-jargon-or-jewel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/agronomix.com\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/relational-database.jpg\",\"datePublished\":\"2018-08-24T15:00:13+00:00\",\"dateModified\":\"2025-08-12T09:13:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/relational-database-jargon-or-jewel\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/agronomix.com\\\/blog\\\/relational-database-jargon-or-jewel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/relational-database-jargon-or-jewel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/agronomix.com\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/relational-database.jpg\",\"contentUrl\":\"https:\\\/\\\/agronomix.com\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/relational-database.jpg\",\"width\":800,\"height\":533},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/agronomix.com\\\/blog\\\/relational-database-jargon-or-jewel\\\/#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\":\"Relational Database: Jargon or Jewel?\"}]},{\"@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":"Relational Database: Jargon or Jewel? - 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\/relational-database-jargon-or-jewel\/","og_locale":"pt_BR","og_type":"article","og_title":"Relational Database: Jargon or Jewel?","og_description":"Data management software for plant breeding has dramatically evolved during the past decade. Systems available in today\u2019s marketplace offer added benefits, such as global access, varying security permissions and data configurations that developers a decade ago only dreamed of. Today\u2019s plant breeding software can give scientists a true competitive edge.","og_url":"https:\/\/agronomix.com\/pt\/blog\/relational-database-jargon-or-jewel\/","og_site_name":"Agronomix","article_modified_time":"2025-08-12T09:13:36+00:00","og_image":[{"width":800,"height":533,"url":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/08\/relational-database.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\/relational-database-jargon-or-jewel\/","url":"https:\/\/agronomix.com\/blog\/relational-database-jargon-or-jewel\/","name":"Relational Database: Jargon or Jewel? - Agronomix","isPartOf":{"@id":"https:\/\/agronomix.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/agronomix.com\/blog\/relational-database-jargon-or-jewel\/#primaryimage"},"image":{"@id":"https:\/\/agronomix.com\/blog\/relational-database-jargon-or-jewel\/#primaryimage"},"thumbnailUrl":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/08\/relational-database.jpg","datePublished":"2018-08-24T15:00:13+00:00","dateModified":"2025-08-12T09:13:36+00:00","breadcrumb":{"@id":"https:\/\/agronomix.com\/blog\/relational-database-jargon-or-jewel\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/agronomix.com\/blog\/relational-database-jargon-or-jewel\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/agronomix.com\/blog\/relational-database-jargon-or-jewel\/#primaryimage","url":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/08\/relational-database.jpg","contentUrl":"https:\/\/agronomix.com\/wp-content\/uploads\/2018\/08\/relational-database.jpg","width":800,"height":533},{"@type":"BreadcrumbList","@id":"https:\/\/agronomix.com\/blog\/relational-database-jargon-or-jewel\/#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":"Relational Database: Jargon or Jewel?"}]},{"@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\/27051","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\/32619"}],"wp:attachment":[{"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/media?parent=27051"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/agronomix.com\/pt\/wp-json\/wp\/v2\/tags?post=27051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}