{"id":680,"date":"2014-09-03T03:20:12","date_gmt":"2014-09-03T03:20:12","guid":{"rendered":"http:\/\/www.w3computing.com\/systemsanalysis\/?p=680"},"modified":"2021-05-18T19:35:01","modified_gmt":"2021-05-18T19:35:01","slug":"data-dictionary","status":"publish","type":"post","link":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/","title":{"rendered":"The Data Dictionary"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data about data (that is, metadata), one that is compiled by systems analysts to guide them through analysis and design. As a document, the data dictionary collects and coordinates specific data terms, and it confirms what each term means to different people in the organization. The <a title=\"Using Data Flow Diagrams\" href=\"http:\/\/www.w3computing.com\/systemsanalysis\/using-data-flow-diagrams\/\">data flow diagrams<\/a> covered before are an excellent starting point for collecting data dictionary entries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One important reason for maintaining a data dictionary is to keep clean data. This means that data must be consistent. If you store data about a man\u2019s sex as &#8220;M&#8221; in one record, &#8220;Male&#8221; in a second record, and as the number &#8220;1&#8221; in a third record, the data are not clean. Keeping a data dictionary will help in this regard.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Automated data dictionaries (part of the CASE tools mentioned earlier) are valuable for their capacity to cross-reference data items, thereby allowing necessary program changes to all programs sharing a common element. This feature supplants changing programs on a haphazard basis, or it prevents waiting until the program won\u2019t run because a change has not been implemented across all programs sharing the updated item. Clearly, automated data dictionaries become important for large systems that produce several thousand data elements requiring cataloging and cross-referencing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Need for Understanding the Data Dictionary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Many database management systems now come equipped with an automated data dictionary. These dictionaries can be either elaborate or simple. Some computerized data dictionaries automatically catalog data items when programming is done; others simply provide a template to prompt the person filling in the dictionary to do so in a uniform manner for every entry.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Despite the existence of automated data dictionaries, understanding what data compose a data dictionary, the conventions used in data dictionaries, and how a data dictionary is developed are issues that remain pertinent for the systems analyst during the systems effort. Understanding the process of compiling a data dictionary can aid the systems analyst in conceptualizing the system and how it works. The upcoming sections allow the systems analyst to see the rationale behind what exists in automated data dictionaries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In addition to providing documentation and eliminating redundancy, the data dictionary may be used to:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Validate the data flow diagram for completeness and accuracy.<\/li><li>Provide a starting point for developing screens and reports.<\/li><li>Determine the contents of data stored in files.<\/li><li>Develop the logic for data flow diagram processes.<\/li><li>Create XML (extensible markup language).<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data about data (that is, metadata), one that is compiled by systems analysts to guide them through analysis and design. As a document, the data dictionary collects and coordinates [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[11],"tags":[],"class_list":["post-680","post","type-post","status-publish","format-standard","category-analyzing-systems-using-data-dictionaries","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The Data Dictionary<\/title>\n<meta name=\"description\" content=\"The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Data Dictionary\" \/>\n<meta property=\"og:description\" content=\"The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/w3computing\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-03T03:20:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-18T19:35:01+00:00\" \/>\n<meta name=\"author\" content=\"w3computing.com\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"w3computing.com\" \/>\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\":\"TechArticle\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/\"},\"author\":{\"name\":\"w3computing.com\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#\\\/schema\\\/person\\\/8395166dc0b94b38a3aeb88dafbd63ce\"},\"headline\":\"The Data Dictionary\",\"datePublished\":\"2014-09-03T03:20:12+00:00\",\"dateModified\":\"2021-05-18T19:35:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/\"},\"wordCount\":428,\"articleSection\":[\"Analyzing Systems Using Data Dictionaries\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/\",\"name\":\"The Data Dictionary\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#website\"},\"datePublished\":\"2014-09-03T03:20:12+00:00\",\"dateModified\":\"2021-05-18T19:35:01+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#\\\/schema\\\/person\\\/8395166dc0b94b38a3aeb88dafbd63ce\"},\"description\":\"The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/data-dictionary\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Systems Analysis\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analyzing Systems Using Data Dictionaries\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/analyzing-systems-using-data-dictionaries\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"The Data Dictionary\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#website\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#\\\/schema\\\/person\\\/8395166dc0b94b38a3aeb88dafbd63ce\",\"name\":\"w3computing.com\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Data Dictionary","description":"The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data","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:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/","og_locale":"en_US","og_type":"article","og_title":"The Data Dictionary","og_description":"The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data","og_url":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/","article_publisher":"https:\/\/www.facebook.com\/w3computing","article_published_time":"2014-09-03T03:20:12+00:00","article_modified_time":"2021-05-18T19:35:01+00:00","author":"w3computing.com","twitter_misc":{"Written by":"w3computing.com","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/#article","isPartOf":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/"},"author":{"name":"w3computing.com","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#\/schema\/person\/8395166dc0b94b38a3aeb88dafbd63ce"},"headline":"The Data Dictionary","datePublished":"2014-09-03T03:20:12+00:00","dateModified":"2021-05-18T19:35:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/"},"wordCount":428,"articleSection":["Analyzing Systems Using Data Dictionaries"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/","url":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/","name":"The Data Dictionary","isPartOf":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#website"},"datePublished":"2014-09-03T03:20:12+00:00","dateModified":"2021-05-18T19:35:01+00:00","author":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#\/schema\/person\/8395166dc0b94b38a3aeb88dafbd63ce"},"description":"The data dictionary is a specialized application of the kinds of dictionaries used as references in everyday life. The data dictionary is a reference work of data","breadcrumb":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/data-dictionary\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Systems Analysis","item":"https:\/\/www.w3computing.com\/systemsanalysis\/"},{"@type":"ListItem","position":2,"name":"Analyzing Systems Using Data Dictionaries","item":"https:\/\/www.w3computing.com\/systemsanalysis\/analyzing-systems-using-data-dictionaries\/"},{"@type":"ListItem","position":3,"name":"The Data Dictionary"}]},{"@type":"WebSite","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#website","url":"https:\/\/www.w3computing.com\/systemsanalysis\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.w3computing.com\/systemsanalysis\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#\/schema\/person\/8395166dc0b94b38a3aeb88dafbd63ce","name":"w3computing.com"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4NNeA-aY","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/posts\/680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/comments?post=680"}],"version-history":[{"count":0,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/posts\/680\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/media?parent=680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/categories?post=680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/tags?post=680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}