{"id":279,"date":"2015-10-01T10:28:22","date_gmt":"2015-10-01T08:28:22","guid":{"rendered":"http:\/\/blogs.uct.ac.za\/cancerphd\/?p=279"},"modified":"2015-10-02T10:05:25","modified_gmt":"2015-10-02T08:05:25","slug":"rubbish-in-rubbish-out-database-management-as-a-tool-for-research","status":"publish","type":"post","link":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/","title":{"rendered":"\u201cRubbish in, rubbish out\u201d"},"content":{"rendered":"
\n

\u201cRubbish in, rubbish out\u201d: Database management as a tool for research<\/span><\/h2>\n<\/blockquote>\n

<\/h1>\n

\"DLM\"<\/a><\/h1>\n

When it comes to understanding an interpreting research data, the rule of thumb is \u201crubbish in, rubbish out.\u201d This was the sentiment expressed by database manager Annemie Stewart from the Clinical Research Centre (CRC) at the recent Database management workshop hosted by the CRC and the Cancer PhD mentorship program. The workshop provided an outline of database planning, demonstrated the fundamentals of database design and provided a practical overview on using Microsoft Access to develop and manage research databases.<\/p>\n

\u00a0Trained as a basic scientist, the management of data in my experience typically involved generating, processing and storing data for analysis. Developing into multidisciplinary scientist, I am now more aware than ever that the quality of research depends not only on the collection of data, but also on accurately maintaining data. Data is an invaluable resource which should be used for the benefit of a wider research community.<\/p>\n

Effective data management is key to generating high-quality, statistically sound and reliable data. A well maintained database can be used to generate a plethora of novel research questions and provides opportunities of using existing data to inform new studies and collaborations. A number of software tools are available for data management, each with their own strengths and weaknesses. It is up to the researcher to understand what the various software options offer, and choose the system best suited for their purposes. Regardless of the choice of software or scientific field, responsible data management is important in all phases of research, from planning and data collection to data analysis and dissemination.<\/p>\n

I am interested to learn more about your experiences using databases in research to understand the strengths and pitfalls of the various software platforms available. Please feel free to contribute or leave a comment.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u201cRubbish in, rubbish out\u201d: Database management as a tool for research When it comes to understanding an interpreting research data, the rule of thumb is \u201crubbish in, rubbish out.\u201d This … Continue reading \u201cRubbish in, rubbish out\u201d<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ngg_post_thumbnail":0,"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\n\u201cRubbish in, rubbish out\u201d - Postgraduate Cancer Research Initiative (CRI) blog<\/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:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u201cRubbish in, rubbish out\u201d - Postgraduate Cancer Research Initiative (CRI) blog\" \/>\n<meta property=\"og:description\" content=\"\u201cRubbish in, rubbish out\u201d: Database management as a tool for research When it comes to understanding an interpreting research data, the rule of thumb is \u201crubbish in, rubbish out.\u201d This … Continue reading \u201cRubbish in, rubbish out\u201d →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/\" \/>\n<meta property=\"og:site_name\" content=\"Postgraduate Cancer Research Initiative (CRI) blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-01T08:28:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-10-02T08:05:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png\" \/>\n<meta name=\"author\" content=\"Vedantha\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vedantha\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/\",\"url\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/\",\"name\":\"\u201cRubbish in, rubbish out\u201d - Postgraduate Cancer Research Initiative (CRI) blog\",\"isPartOf\":{\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png\",\"datePublished\":\"2015-10-01T08:28:22+00:00\",\"dateModified\":\"2015-10-02T08:05:25+00:00\",\"author\":{\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/#\/schema\/person\/91d198dd24efeab70ec3133abeacc631\"},\"breadcrumb\":{\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#primaryimage\",\"url\":\"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png\",\"contentUrl\":\"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u201cRubbish in, rubbish out\u201d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/#website\",\"url\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/\",\"name\":\"Postgraduate Cancer Research Initiative (CRI) blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/#\/schema\/person\/91d198dd24efeab70ec3133abeacc631\",\"name\":\"Vedantha\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/de309c9ffeb7e213c25a312dd435f41c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/de309c9ffeb7e213c25a312dd435f41c?s=96&d=mm&r=g\",\"caption\":\"Vedantha\"},\"url\":\"https:\/\/blogs.uct.ac.za\/cancerphd\/author\/01440770\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u201cRubbish in, rubbish out\u201d - Postgraduate Cancer Research Initiative (CRI) blog","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:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/","og_locale":"en_GB","og_type":"article","og_title":"\u201cRubbish in, rubbish out\u201d - Postgraduate Cancer Research Initiative (CRI) blog","og_description":"\u201cRubbish in, rubbish out\u201d: Database management as a tool for research When it comes to understanding an interpreting research data, the rule of thumb is \u201crubbish in, rubbish out.\u201d This … Continue reading \u201cRubbish in, rubbish out\u201d →","og_url":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/","og_site_name":"Postgraduate Cancer Research Initiative (CRI) blog","article_published_time":"2015-10-01T08:28:22+00:00","article_modified_time":"2015-10-02T08:05:25+00:00","og_image":[{"url":"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png"}],"author":"Vedantha","twitter_misc":{"Written by":"Vedantha","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/","url":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/","name":"\u201cRubbish in, rubbish out\u201d - Postgraduate Cancer Research Initiative (CRI) blog","isPartOf":{"@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#primaryimage"},"image":{"@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#primaryimage"},"thumbnailUrl":"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png","datePublished":"2015-10-01T08:28:22+00:00","dateModified":"2015-10-02T08:05:25+00:00","author":{"@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/#\/schema\/person\/91d198dd24efeab70ec3133abeacc631"},"breadcrumb":{"@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#primaryimage","url":"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png","contentUrl":"http:\/\/blogs.uct.ac.za\/cancerphd\/wp-content\/uploads\/2015\/10\/DLM-300x267.png"},{"@type":"BreadcrumbList","@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/2015\/10\/rubbish-in-rubbish-out-database-management-as-a-tool-for-research\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blogs.uct.ac.za\/cancerphd\/"},{"@type":"ListItem","position":2,"name":"\u201cRubbish in, rubbish out\u201d"}]},{"@type":"WebSite","@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/#website","url":"https:\/\/blogs.uct.ac.za\/cancerphd\/","name":"Postgraduate Cancer Research Initiative (CRI) blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.uct.ac.za\/cancerphd\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/#\/schema\/person\/91d198dd24efeab70ec3133abeacc631","name":"Vedantha","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/blogs.uct.ac.za\/cancerphd\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/de309c9ffeb7e213c25a312dd435f41c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/de309c9ffeb7e213c25a312dd435f41c?s=96&d=mm&r=g","caption":"Vedantha"},"url":"https:\/\/blogs.uct.ac.za\/cancerphd\/author\/01440770\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/posts\/279"}],"collection":[{"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":13,"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/posts\/279\/revisions"}],"predecessor-version":[{"id":295,"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/posts\/279\/revisions\/295"}],"wp:attachment":[{"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/categories?post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.uct.ac.za\/cancerphd\/wp-json\/wp\/v2\/tags?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}