{"id":7270,"date":"2014-10-08T09:35:14","date_gmt":"2014-10-08T13:35:14","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=7270"},"modified":"2024-05-20T14:05:07","modified_gmt":"2024-05-20T18:05:07","slug":"database-profiling-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/","title":{"rendered":"Database Profiling in IRI Workbench"},"content":{"rendered":"<p><em><strong>Editors Updates: Q2&#8217;16<\/strong>: In addition to the database profiling wizard in the <a href=\"http:\/\/www.iri.com\/products\/workbench\/discover-data\" target=\"_blank\" rel=\"noopener\">data discovery<\/a> menu group in IRI Workbench described below, IRI has introduced\u00a0robust <a href=\"http:\/\/www.iri.com\/blog\/data-protection\/data-classification-in-iri-workbench\/\">data classification<\/a>\u00a0that enables the application of <a href=\"http:\/\/www.iri.com\/blog\/data-protection\/applying-field-rules-using-classification\/\">field rules<\/a> for multi-source data\u00a0transformation\u00a0and\u00a0protection through data class libraries.\u00a0<strong> Q2&#8217;18<\/strong>: IRI has also introduced a <a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/schema-pattern-search\/\">schema-wide pattern search<\/a> wizard to find PII matching RegEx or literal values in multiple tables at once.<strong> Q2&#8217;19 &amp; Q1&#8217;24<\/strong>: IRI also provides inter\/intra-schema <a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/schema-data-class-search-2\">data class searching<\/a> <\/em>and <em><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/masking-pii-in-a-relational-db-with-fieldshield\/\">masking<\/a> for users IRI FieldShield, DarkShield, or Voracity. IRI has also recently published <a href=\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-profiling-splunk\/\">this article<\/a> to show how the DB profiling results below display in Splunk.<\/em><\/p>\n<p>With\u00a0more data being culled from more\u00a0aspects of business today, easy awareness of its\u00a0content and nature\u00a0is vital to ensuring the quality, quantity, and security\u00a0of these\u00a0collections. Data profiling is the essential discovery process that helps you analyze, classify, cleanse, integrate, mask, and report on data in your\u00a0repositories.<\/p>\n<p>In addition to <a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/using-the-metadata-discovery-wizard\/\" target=\"_blank\" rel=\"noopener\">structured<\/a> and <a href=\"http:\/\/www.iri.com\/blog\/migration\/data-migration\/unstructured-data-data-restructuring-wizard\/\" target=\"_blank\" rel=\"noopener\">unstructured<\/a> data discovery (and metadata definition) wizards, as well as built-in <a href=\"http:\/\/www.iri.com\/blog\/vldb-operations\/er-diagrams-in-iri-workbench\/\" target=\"_blank\" rel=\"noopener\">E-R diagramming<\/a>, the database profiling tool in <a href=\"http:\/\/www.iri.com\/products\/workbench\" target=\"_blank\" rel=\"noopener\">IRI Workbench<\/a> allows you to examine the structure and completeness of relational database data, and validate that the proper data is being stored in the right places. In this article, we will examine this tool, and show how it delivers table-value search results and statistical metadata.<\/p>\n<p>To\u00a0access the Database Profiler, navigate to the table you wish to access in the Data Source Explorer. Right-click on the table and\u00a0mouse over the IRI option. On the menu that appears, select <strong>New Database Profile<\/strong>.<\/p>\n<p>On the first wizard page, set up the location and destination of the job, and select the output of the profile report, as .csv or a .txt file, or both.<\/p>\n<ul>\n<li>the .csv format is useful for importing into new tables and databases, whereas<\/li>\n<li>the .txt format is a pre-formatted report, useful\u00a0for reviewing\u00a0results quickly.<\/li>\n<\/ul>\n<p><strong>Statistical Profiling Information<\/strong><\/p>\n<p>The next\u00a0part of the wizard will appear with\u00a0two tables:<\/p>\n<ol>\n<li>The top table is a list of all tables in the database, with the table that launched the wizard highlighted by default.<\/li>\n<li>This check box allows you a one-click option to scan every table and row in your database. <img loading=\"lazy\" decoding=\"async\" src=\"file:\/\/\/C:\\Users\\sharonh\\AppData\\Local\\Temp\\SNAGHTMLfddf597.PNG\" width=\"36\" height=\"46\" border=\"0\" \/><\/li>\n<li>The bottom table shows the profiling options, followed by the columns of the highlighted table in which you choose to perform the options.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-columnselection-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10753 aligncenter\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-columnselection-1.jpg\" alt=\"db-columnselection\" width=\"557\" height=\"828\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-columnselection-1.jpg 557w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-columnselection-1-202x300.jpg 202w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<p>Click on any table in the list you wish to view and profile.\u00a0The options matrix\u00a0will automatically change to represent the columns of the selected table. There are several ways to handle the viewing options:<\/p>\n<ul>\n<li>For all options, click the top\u00a0check box in the table, labelled All, and all of the metadata\u00a0will be reported.<\/li>\n<li>For basic\u00a0options only (counting and values), select the check box labelled Basics.<\/li>\n<li>For length\u00a0options only (value lengths), select the check box labelled Lengths.<\/li>\n<\/ul>\n<p>If you have many columns in your table and want to select the same option for all of them, click the option name itself, and all of the columns will have that option selected. You can deselect columns within the option.<\/p>\n<p>Once everything is set, click <strong>Finish<\/strong> and then the profile will then be generated for you.<\/p>\n<p><strong>Expression Search<\/strong><\/p>\n<p>A unique choice in the options table is the -Expression Search-. This option allows you to search columns\u00a0against a variety of search options. These options are:<\/p>\n<ul>\n<li>Regular Expressions (Pattern Search). This locates and counts the number of times a value matches the format of a search pattern.<\/li>\n<li>Fuzzy String. This option allows you to search for strings similar to those you enter, and to select or specify search conditions.<\/li>\n<li>Values File. This option allows you to compare a string to every string in a set file\u00a0and count each string that has a match.<\/li>\n<\/ul>\n<p>The Expression Search page has 6 important sections<\/p>\n<ol>\n<li>A Search Type combo box to select the type of search to perform.<\/li>\n<li>The options group that changes depending on the search type selected\n<ul>\n<li>Regular Expression: has two buttons; browse which browses\u00a0the existing regular expressions, and\u00a0Create&#8230; which allows the creation of new regular expressions.<\/li>\n<li>Fuzzy String: has a counting box that specifies the threshold of the fuzzy search (how close the strings have to be to be considered a match), and a combo box to select the fuzzy search algorithm to use.<\/li>\n<li>Values File: has a button Browse&#8230; that lets you search for the set file to use for the value search.<\/li>\n<\/ul>\n<\/li>\n<li>A text box where you will enter the data for your search.<\/li>\n<li>A drop-down list of the tables to which you can apply the expression search.<\/li>\n<li>A drop-down list of the columns\u00a0to which you can apply the expression search.<\/li>\n<li>A table that lists the\u00a0searches you have created that will be performed by the profiler.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10754 aligncenter\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg\" alt=\"db-expression\" width=\"557\" height=\"508\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg 557w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression-300x274.jpg 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<p>To create a regular expression filter:<\/p>\n<ol start=\"1\">\n<li>From the Search Type combo, select <strong>Regular Expression<\/strong>.<\/li>\n<li>Click <strong>Browse<\/strong> to (your library of saved expressions), or click\u00a0<strong>Create\u00a0<\/strong>to specify a\u00a0regular expression to use in searching for a\u00a0columns values.<\/li>\n<li>In the Table menu, select the table that contains the column to filter.<\/li>\n<li>In the Column menu, select the column to which the regular expression should be applied.<\/li>\n<li>Click <strong>Add to Table<\/strong>, and an item will appear in the table below that contains the file name, column name, search source, threshold, and regular expression label\u00a0that make up the filter.<\/li>\n<li>Repeat this process for each column to which you want to add a filter. If you have too many columns to make this process practical, you can still scan multiple columns and tables automatically &#8212; for data matching\u00a0 your pattern(s) across an entire database schema &#8212; using\u00a0<a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/schema-pattern-search\/\">this wizard<\/a> instead.<\/li>\n<\/ol>\n<p>To create a fuzzy string search:<\/p>\n<ol start=\"1\">\n<li>From the Search Type combo, select <strong>Fuzzy String<\/strong>.<\/li>\n<li>Type the string to use for search.<\/li>\n<li>Select the number of results to return (this option will appear when Fuzzy Search is selected).<\/li>\n<li>Select the\u00a0Fuzzy Search Type to use\u00a0(this option will appear when Fuzzy String\u00a0is selected).<\/li>\n<li>In the Table\u00a0menu, select the file \u00a0that contains the column to fuzzy search.<\/li>\n<li>In the Column menu, select the column to which the fuzzy search should be performed.<\/li>\n<li>Click <strong>Add to Table<\/strong>, and an item will appear in the table below that contains the file name, column name, search source, threshold, and the search type of the fuzzy search to be performed.<\/li>\n<li>Repeat this process for each column where you want to perform a fuzzy string search.<\/li>\n<\/ol>\n<p>To create a values file search:<\/p>\n<ol>\n<li>From\u00a0the Search Type combo, select <strong>Values File<\/strong>.<\/li>\n<li>Click <strong>Browse<\/strong> to select a set file that the\u00a0column will be checked against.<\/li>\n<li>In the Table menu, select the table that contains the column to filter.<\/li>\n<li>In the Column\u00a0menu, select the column to which the regular expression should be applied.<\/li>\n<li>Click <strong>Add to Table<\/strong>, and an item will appear in the table below that contains the file name, column name, search source, threshold, and values list search label\u00a0that make up the filter.<\/li>\n<\/ol>\n<p><strong>Referential Integrity Check<\/strong><\/p>\n<p>Another choice in the options table is -Check Referential Integrity-. This options allows the profiler to compare one or more columns to another column, and determine if the columns have referential integrity.\u00a0To use this function, check\u00a0the\u00a0-Check Referential Integrity- boxes on the columns to compare for referential integrity. The Next button will activate and allow you to specify the parameters for the referential integrity check (see below for specifics).<\/p>\n<p>If you selected the Check Referential Integrity option for any of your columns, click <strong>Next<\/strong> to go to the Referential Integrity Check\u00a0page.\u00a0This page has the following features:<\/p>\n<ol>\n<li>Two combo boxes, one to select the table the primary key is in, the other is to specify the primary key column.<\/li>\n<li>Two combo boxes, one to select the table the foreign key is in, the other to specify the foreign key column. There is also a button to add the\u00a0foreign key to a list of foreign keys to compare to the primary key.<\/li>\n<li>A Create Integrity Check button to add the primary and foreign columns to the list below.<\/li>\n<li>A list that stores all of the referential integrity checks that will be performed by the profiler.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-refintegrity.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10755 aligncenter\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-refintegrity.jpg\" alt=\"db-refintegrity\" width=\"557\" height=\"604\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-refintegrity.jpg 557w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-refintegrity-277x300.jpg 277w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/a><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/RefInt.png\"><br \/>\n<\/a>To create a referential integrity check:<\/p>\n<ol>\n<li>In the table combo box under Primary Key Column, select the table that the primary key is in.<\/li>\n<li>In the column combo box under Primary Key Column, select the primary key.<\/li>\n<li>In the table combo box under Foreign\u00a0Key Column, select the table that the foreign\u00a0key is in.<\/li>\n<li>In the column combo box under Foreign\u00a0Key Column, select the foreign\u00a0key.<\/li>\n<li>Click the button Add to Foreign Key List&#8230;<\/li>\n<li>Repeat steps 3-5 for each foreign key to be checked against the primary key<\/li>\n<li>Click the button Create Integrity Check&#8230;<\/li>\n<li>Repeat the above processes for each referential integrity check to perform.<\/li>\n<\/ol>\n<p><strong>Sample Profile Outputs<\/strong><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/output.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7276\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/output-1024x754.png\" alt=\"DataProfile_output\" width=\"630\" height=\"464\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/output-1024x754.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/output-300x221.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/05\/output.png 1087w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">\u00a0<em>.csv displayed in LibreOffice \/ .txt displayed in EditPad Lite<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Editors Updates: Q2&#8217;16: In addition to the database profiling wizard in the data discovery menu group in IRI Workbench described below, IRI has introduced\u00a0robust data classification\u00a0that enables the application of field rules for multi-source data\u00a0transformation\u00a0and\u00a0protection through data class libraries.\u00a0 Q2&#8217;18: IRI has also introduced a schema-wide pattern search wizard to find PII matching RegEx or<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\" title=\"Database Profiling in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":61,"featured_media":10754,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,363,1,776,91,233,29,3],"tags":[55,280,14,366,5,1745,754,1746,1744,755,850,281,88],"class_list":["post-7270","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-quality","category-data-transformation2","category-etl","category-iri-workbench","category-metadata-management","category-test-data","category-vldb-operations","tag-data-analytics","tag-data-discovery","tag-data-masking","tag-data-quality-2","tag-data-transformation","tag-database-profiler","tag-database-profiling","tag-database-statistics","tag-db-profiling-tools","tag-dq","tag-iri-workbench","tag-metadata-management-2","tag-test-data-2"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database Profiling in IRI Workbench - IRI<\/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:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Profiling in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"Editors Updates: Q2&#8217;16: In addition to the database profiling wizard in the data discovery menu group in IRI Workbench described below, IRI has introduced\u00a0robust data classification\u00a0that enables the application of field rules for multi-source data\u00a0transformation\u00a0and\u00a0protection through data class libraries.\u00a0 Q2&#8217;18: IRI has also introduced a schema-wide pattern search wizard to find PII matching RegEx orRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-08T13:35:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-20T18:05:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"557\" \/>\n\t<meta property=\"og:image:height\" content=\"508\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nathan Dymora\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Dymora\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\"},\"author\":{\"name\":\"Nathan Dymora\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa\"},\"headline\":\"Database Profiling in IRI Workbench\",\"datePublished\":\"2014-10-08T13:35:14+00:00\",\"dateModified\":\"2024-05-20T18:05:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\"},\"wordCount\":1491,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg\",\"keywords\":[\"data analytics\",\"data discovery\",\"data masking\",\"data quality\",\"data transformation\",\"database profiler\",\"database profiling\",\"database statistics\",\"DB profiling tools\",\"DQ\",\"IRI Workbench\",\"metadata management\",\"test data\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Quality (DQ&#041;\",\"Data Transformation\",\"ETL\",\"IRI Workbench\",\"Metadata Management\",\"Test Data\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\",\"name\":\"Database Profiling in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg\",\"datePublished\":\"2014-10-08T13:35:14+00:00\",\"dateModified\":\"2024-05-20T18:05:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg\",\"width\":557,\"height\":508},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Profiling in IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa\",\"name\":\"Nathan Dymora\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g\",\"caption\":\"Nathan Dymora\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/nathand\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database Profiling in IRI Workbench - IRI","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.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Database Profiling in IRI Workbench","og_description":"Editors Updates: Q2&#8217;16: In addition to the database profiling wizard in the data discovery menu group in IRI Workbench described below, IRI has introduced\u00a0robust data classification\u00a0that enables the application of field rules for multi-source data\u00a0transformation\u00a0and\u00a0protection through data class libraries.\u00a0 Q2&#8217;18: IRI has also introduced a schema-wide pattern search wizard to find PII matching RegEx orRead More","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2014-10-08T13:35:14+00:00","article_modified_time":"2024-05-20T18:05:07+00:00","og_image":[{"width":557,"height":508,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg","type":"image\/jpeg"}],"author":"Nathan Dymora","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Dymora","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/"},"author":{"name":"Nathan Dymora","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa"},"headline":"Database Profiling in IRI Workbench","datePublished":"2014-10-08T13:35:14+00:00","dateModified":"2024-05-20T18:05:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/"},"wordCount":1491,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg","keywords":["data analytics","data discovery","data masking","data quality","data transformation","database profiler","database profiling","database statistics","DB profiling tools","DQ","IRI Workbench","metadata management","test data"],"articleSection":["Data Masking\/Protection","Data Quality (DQ&#041;","Data Transformation","ETL","IRI Workbench","Metadata Management","Test Data","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/","name":"Database Profiling in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg","datePublished":"2014-10-08T13:35:14+00:00","dateModified":"2024-05-20T18:05:07+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg","width":557,"height":508},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Database Profiling in IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa","name":"Nathan Dymora","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g","caption":"Nathan Dymora"},"url":"https:\/\/www.iri.com\/blog\/author\/nathand\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/10\/db-expression.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/7270"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=7270"}],"version-history":[{"count":41,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/7270\/revisions"}],"predecessor-version":[{"id":17459,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/7270\/revisions\/17459"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/10754"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=7270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=7270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=7270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}