{"id":12501,"date":"2018-12-06T11:28:02","date_gmt":"2018-12-06T16:28:02","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=12501"},"modified":"2018-12-06T12:40:38","modified_gmt":"2018-12-06T17:40:38","slug":"data-wrangling-oracle-dv","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/","title":{"rendered":"Data Wrangling for Oracle Visualization Desktop"},"content":{"rendered":"

Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for informational outcomes.\u00a0What seems to make this BI software unique is its ability to create slideshow presentations from its different visualizations.\u00a0<\/span><\/p>\n

Like other BI tools, Oracle DV must establish a connection with file or database table sources.\u00a0Rather than directly read a file or database table, Oracle DV creates its own datasets from the raw data for use in numerous projects with different visuals and aggregations.<\/span><\/p>\n

I found that this creation process is the most time consuming aspect in the use of Oracle DV. And, extra process time can also occur from dataset read and aggregation failures. These issues are common during normal operation but are unpredictable as to when or why they happen. I had the same failures occur in both large and small data sets using the same aggregation but they would not appear every time. These issues can normally be fixed by reloading or \u201crefreshing\u201d the dataset or aggregation. It takes about the same amount of time to reload the data as it did to create, thus effectively doubling the total process time.<\/span><\/p>\n

So as with most other BI and analytic tools on the market, it was apparent that pre-wrangling, blending, or otherwise preparing data outside of DV would be beneficial. My goal for this article is to compare the relative time-to-display in Oracle DV using both native processing capabilities and external\u00a0SortCL program<\/a><\/span>\u00a0jobs in the\u00a0IRI CoSort<\/a><\/span>\u00a0data processing package. SortCL is also the default manipulation engine in the\u00a0IRI Voracity<\/a><\/span>\u00a0data management (data integration, governance, wrangling) platform. The short answer is that again, yes, in volume, external\u00a0wrangling is better<\/a><\/span>.<\/span><\/p>\n

Test Environment<\/span><\/strong><\/h2>\n

I tested CSV files of various sizes and tables from an Oracle 11 database on a Windows 64 bit environment. My test files contained three transaction items: department, store number, and the sales by that store and department. This is meant to simulate data for a department store where sales are tallied by department and by store.<\/span><\/p>\n

Pre-Processing in CoSort<\/span><\/strong><\/h2>\n

To read and wrangle data in CSV and other sources using SortCL is fairly simple. I used\u00a0IRI Workbench<\/a><\/span>\u00a0to create a project and SortCL task to sort and aggregate a CSV data set containing sales information; i.e., to produce a result set that contained the total sales for each store.<\/span><\/p>\n

To create my SortCL job —\u00a0which serializes as a text-based .scl script — I ran the \u2018new sort job\u2019 wizard in IRI Workbench. The wizard prompts me to select my input data, auto-create its metadata, define the sort key(s), and define the output, where I specify my aggregation rule to the target sales column to sum the sales for each store. After the script is built, I can run it in or outside Workbench; it uses the command-line\u00a0sortcl*<\/span>\u00a0executable.<\/span><\/p>\n

My final job script and output data are shown in this Workbench screenshot:<\/p>\n

\"\"<\/a><\/strong><\/p>\n

The steps to read and process data from database tables are just as simple as they are for flat files. The only difference is that your database needs to be connected via ODBC and JDBC for SortCL and Workbench to interact with the tables, respectively. In such cases, a script might contain these source specification lines instead:<\/p>\n

\/INFILE=”SCOTT.FIVEMILTABLE;DSN=Oracle64;”<\/em><\/p>\n

\/PROCESS=ODBC<\/em><\/p>\n

Pre-Processing in Oracle DV<\/span><\/strong><\/h2>\n

Here are the steps to create a visualization in Oracle DV. To begin, a data source must be selected to create a dataset.<\/span><\/p>\n

\"\"<\/a><\/p>\n

From here, you can select a file or table from a variety of database and storage applications. In my example, I am selecting a CSV file. After my file is selected, Oracle will create a dataset from it, which can also be edited before being used in a project.<\/p>\n

\"\"<\/a><\/p>\n

After this page is completed, the data set is now ready to use in a project. Creating a new project asks which dataset you would like to use:<\/p>\n

\"\"<\/a><\/p>\n

Relative Speed Tables<\/span><\/strong><\/h2>\n

Following are the results of my simple data wrangling tests for both CoSort and Oracle DV. These tables show the time differences to sort and total the same data sets at different input volumes; i.e., before their summary results render visually in Oracle DV.<\/span><\/p>\n

For Oracle DV, the time needed to create the dataset is also included in the total process time, as that is required to perform any aggregation, visualization, or other process.<\/span><\/p>\n

As stated, \u201crefreshing\u201d is often necessary for Oracle DV to work correctly. Without refreshing, aggregations will not run, and the visualization will not display properly. However, the need to refresh is infrequent, and varies in duration when reading files. For this reason, refreshes were not included in the total time I allotted for Oracle DV.<\/span><\/p>\n

My results show that CoSort SortCL is up to three times faster than Oracle DV at reading flat files. It also shows that Oracle DV fails to read past a certain size.<\/span><\/p>\n

\"csv<\/a><\/p>\n

\"csv<\/a><\/p>\n

In my next round of tests, I used an Oracle XE database source table of various row sizes to see how both programs\u00a0would\u00a0fare. Unlike the previous exercise, the refresh times are included in the total time for Oracle DV, as it consistently needs a refresh\u00a0every\u00a0<\/span>time a dataset is created.<\/span><\/p>\n

After the initial refresh of a dataset from a database table, another refresh will normally not be needed for future projects. However, if any changes are made to the original table, the Oracle DV dataset will need to be refreshed again.<\/span><\/p>\n

What these results show is that Oracle reads the data faster using OCI than CoSort SortCL does using ODBC at first — though that should change with the addition of IRI Fast Extract (FACT<\/a><\/span>), which I did not use. Like before, beyond a certain volume Oracle DV\u00a0could not process the data, while CoSort performance scaled linearly.<\/p>\n

\"jdbc<\/a><\/p>\n

Big Data Breakdown(s)<\/span><\/strong><\/h2>\n

Through my experiments, I found that Oracle DV struggles with large input data volumes. Reading files around 1.5 GB\u00a0was where Oracle DV began to slow down, and broke down on files larger than 2.5 GB on my computer. Files larger than that caused a runtime error to be displayed after about 5-6 minutes.<\/span><\/p>\n

As file sizes came closer to the 2.5 GB limit, the visualizer began to have issues using the datasets in a project. Projects sometimes failed to correctly read in a data set and required a \u201crefresh\u201d of the data set. Refreshes may also be needed when visualizations or tables fail to display. Though\u00a0they normally fixed the problem, refreshes can just as long to complete as creating the original dataset. Thus refreshes can effectively double if not triple the total time Oracle DV takes to prepare source data, sort and aggregate it in this case, for display.<\/span><\/p>\n

In my largest example of 100 million rows (2.5GB), it took Oracle DV 5m:10s to read in the CSV file and create its data source. Once I created my project and set my data source, I used the store and sales rows to create a table showing the summary of sales for each store.\u00a0It took close to another five minutes to reload the source data so that those results could be displayed.\u00a0<\/span>That’s over a total of ten minutes to complete, compared to SortCL which took just under two minutes to do it once.<\/span><\/p>\n

As for database table reads, Oracle DV was only faster until a certain point, and fails to process or read any table larger than 2GB. Database table reads\u00a0also\u00a0have an\u00a0issue\u00a0where the created dataset must be reloaded in order to work properly. However, once the dataset is refreshed, another one will not be needed\u00a0unless the source database table is modified.
\n<\/span><\/p>\n

Conclusion<\/span><\/strong><\/h2>\n

The\u00a0SortCL<\/a><\/span>\u00a0program in\u00a0IRI CoSort<\/a><\/span>\u00a0or\u00a0Voracity<\/a><\/span>\u00a0can improve the reliability of, and the time to display in, Oracle DV by processing larger data sources externally. \u00a0As my simple comparisons demonstrate, SortCL took only seconds to sort, aggregate, and write its results into a file\u00a0or table that Oracle DV\u00a0can display, whereas Oracle DV always took longer, and failed in volume.<\/span><\/p>\n

A best practice for BI architects with high volume data sources is to employ a high-performance data wrangling tool to handle these preparatory workloads ahead of time. In other words, use a fast, fit-for-purpose data manipulation program like SortCL externally, and\u00a0then\u00a0<\/span>analyze the results in the visualization tool you prefer.<\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for informational outcomes.\u00a0What seems to make this BI software unique is its ability to create slideshow presentations from its different visualizations.\u00a0 Like other BI tools, Oracle DV must establish a connection with file<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":115,"featured_media":12509,"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":[32,1,776],"tags":[109,52,1164,1370,1371,359,1163,789,850,1382,75,50,1380,1381,1378,1379,68,72],"class_list":["post-12501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-data-transformation2","category-etl","tag-bi-tools","tag-business-intelligence-2","tag-data-blending","tag-data-display","tag-data-graphics","tag-data-preparation","tag-data-wrangling","tag-iri-voracity","tag-iri-workbench","tag-obiee","tag-odbc","tag-oracle","tag-oracle-bi","tag-oracle-data-visualizer","tag-oracle-dv","tag-oracle-dvd","tag-sortcl","tag-workbench"],"acf":[],"yoast_head":"\nData Wrangling for Oracle Visualization Desktop - IRI<\/title>\n<meta name=\"description\" content=\"Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for\" \/>\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\/business-intelligence\/data-wrangling-oracle-dv\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Wrangling for Oracle Visualization Desktop\" \/>\n<meta property=\"og:description\" content=\"Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-06T16:28:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-06T17:40:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1040\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Craig Schein\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Craig Schein\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/\"},\"author\":{\"name\":\"Craig Schein\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/803e7bda27760374008e0dee86eee2bd\"},\"headline\":\"Data Wrangling for Oracle Visualization Desktop\",\"datePublished\":\"2018-12-06T16:28:02+00:00\",\"dateModified\":\"2018-12-06T17:40:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/\"},\"wordCount\":1412,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png\",\"keywords\":[\"BI tools\",\"business intelligence\",\"data blending\",\"Data Display\",\"Data Graphics\",\"data preparation\",\"data wrangling\",\"IRI Voracity\",\"IRI Workbench\",\"OBIEE\",\"ODBC\",\"Oracle\",\"Oracle BI\",\"Oracle Data Visualizer\",\"Oracle DV\",\"Oracle DVD\",\"SortCL\",\"Workbench\"],\"articleSection\":[\"Business Intelligence (BI)\",\"Data Transformation\",\"ETL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/\",\"url\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/\",\"name\":\"Data Wrangling for Oracle Visualization Desktop - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png\",\"datePublished\":\"2018-12-06T16:28:02+00:00\",\"dateModified\":\"2018-12-06T17:40:38+00:00\",\"description\":\"Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png\",\"width\":1920,\"height\":1040,\"caption\":\"Oracle DV charts\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Wrangling for Oracle Visualization Desktop\"}]},{\"@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\/803e7bda27760374008e0dee86eee2bd\",\"name\":\"Craig Schein\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd64a949f0641d95a87230cabec062d5?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd64a949f0641d95a87230cabec062d5?s=96&d=blank&r=g\",\"caption\":\"Craig Schein\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/craigs\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Wrangling for Oracle Visualization Desktop - IRI","description":"Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for","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\/business-intelligence\/data-wrangling-oracle-dv\/","og_locale":"en_US","og_type":"article","og_title":"Data Wrangling for Oracle Visualization Desktop","og_description":"Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for","og_url":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/","og_site_name":"IRI","article_published_time":"2018-12-06T16:28:02+00:00","article_modified_time":"2018-12-06T17:40:38+00:00","og_image":[{"width":1920,"height":1040,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png","type":"image\/png"}],"author":"Craig Schein","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Craig Schein","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/"},"author":{"name":"Craig Schein","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/803e7bda27760374008e0dee86eee2bd"},"headline":"Data Wrangling for Oracle Visualization Desktop","datePublished":"2018-12-06T16:28:02+00:00","dateModified":"2018-12-06T17:40:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/"},"wordCount":1412,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png","keywords":["BI tools","business intelligence","data blending","Data Display","Data Graphics","data preparation","data wrangling","IRI Voracity","IRI Workbench","OBIEE","ODBC","Oracle","Oracle BI","Oracle Data Visualizer","Oracle DV","Oracle DVD","SortCL","Workbench"],"articleSection":["Business Intelligence (BI)","Data Transformation","ETL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/","url":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/","name":"Data Wrangling for Oracle Visualization Desktop - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png","datePublished":"2018-12-06T16:28:02+00:00","dateModified":"2018-12-06T17:40:38+00:00","description":"Oracle Data Visualization Desktop, Oracle DV or DVD for short, is business intelligence (BI) software that can organize, aggregate, and visualize data for","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png","width":1920,"height":1040,"caption":"Oracle DV charts"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/data-wrangling-oracle-dv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Wrangling for Oracle Visualization Desktop"}]},{"@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\/803e7bda27760374008e0dee86eee2bd","name":"Craig Schein","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd64a949f0641d95a87230cabec062d5?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd64a949f0641d95a87230cabec062d5?s=96&d=blank&r=g","caption":"Craig Schein"},"url":"https:\/\/www.iri.com\/blog\/author\/craigs\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/12\/Oracle_DV_pretty.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/12501"}],"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\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=12501"}],"version-history":[{"count":15,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/12501\/revisions"}],"predecessor-version":[{"id":12529,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/12501\/revisions\/12529"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/12509"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=12501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=12501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=12501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}