{"id":5775,"date":"2014-07-31T09:07:00","date_gmt":"2014-07-31T13:07:00","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=5775"},"modified":"2017-11-07T09:02:00","modified_gmt":"2017-11-07T14:02:00","slug":"offline-reorg-wizard","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/","title":{"rendered":"Using the Offline Reorg Wizard"},"content":{"rendered":"<p>As database table and index sizes increase, data becomes more fragmented\u00a0and\u00a0query response slows.\u00a0To improve database\u00a0operating efficiency, regular table reorganization is required. See <a href=\"http:\/\/www.iri.com\/blog\/vldb-operations\/database-reorgs-why-they-matter\/\" target=\"_blank\" rel=\"noopener\">this article<\/a>\u00a0explaining\u00a0why reorgs matter\u00a0and the material below detailing the wizard&#8217;s\u00a0use.<\/p>\n<p><strong><br \/>\nWhat It Is<\/strong><\/p>\n<p><a href=\"http:\/\/www.iri.com\/products\/workbench\" target=\"_blank\" rel=\"noopener\">IRI Workbench<\/a> &#8212; an\u00a0Eclipse IDE and GUI for all IRI software products &#8212;\u00a0provides a classic (offline) reorg solution\u00a0through a purpose-built wizard. The\u00a0Offline Reorg Wizard\u00a0facilitates the specification and execution of multiple, large-scale reorgs that\u00a0keep\u00a0large\u00a0tables in query (e.g. join) order without taxing the database itself.<\/p>\n<p><strong><br \/>\nWhat It Does<\/strong><\/p>\n<p>The offline reorg wizard builds\u00a0a step-by-step &#8220;Unload-Order-Reload&#8221; process, for one or more tables at once, using constituent products of the IRI Data Manager suite. For large scale reorgs, it specifies the configuration of:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.iri.com\/products\/fact\" target=\"_blank\" rel=\"noopener\">IRI FACT<\/a> for bulk table <a href=\"http:\/\/www.iri.com\/blog\/vldb-operations\/unload-big-data-from-oracle-et-al\/\" target=\"_blank\" rel=\"noopener\">unloads<\/a><\/li>\n<li><a href=\"http:\/\/www.iri.com\/products\/cosort\" target=\"_blank\" rel=\"noopener\">IRI CoSort<\/a> for their reordering<\/li>\n<li>the target database&#8217;s load utility for pre-sorted, bulk <a href=\"http:\/\/www.iri.com\/blog\/vldb-operations\/high-speed-database-loading\/\" target=\"_blank\" rel=\"noopener\">loads<\/a><\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/what-is-odbc\/\" target=\"_blank\" rel=\"noopener\">ODBC<\/a> select and insert options are also available\u00a0for smaller-scale or finer-tuned\u00a0operations.<\/p>\n<p>At the end of the wizard, the job scripts needed to reorg the selected tables\u00a0are created. The jobs\u00a0can run anywhere the chosen tools are licensed, and be invoked from the GUI, command line, or batch script (which\u00a0the\u00a0wizard also produces). Database users are unaffected\u00a0in the offline reorg method, although reloads or\u00a0ODBC updates\u00a0can\u00a0alter tables in use.<\/p>\n<p><strong><br \/>\nHow It Works<\/strong><\/p>\n<p>To start\u00a0the offline reorg wizard in IRI Workbench, navigate to the drop-down list in the FACT menu and select &#8220;New Offline Reorg Job&#8230;&#8221;.<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-23-at-10.59.40-AM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5776\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-23-at-10.59.40-AM.png\" alt=\"Screen Shot 2014-07-23 at 10.59.40 AM\" width=\"248\" height=\"101\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-23-at-10.59.40-AM.png 410w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-23-at-10.59.40-AM-300x121.png 300w\" sizes=\"(max-width: 248px) 100vw, 248px\" \/><\/a><\/p>\n<p>In the first dialog, c<span style=\"font-size: 13px;\">hoose the project folder and name a sub-folder\u00a0to hold\u00a0the reorg\u00a0metadata and sorted results, then\u00a0specify\u00a0the table acquisition (unload) and repopulation (load) method.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-08-01-at-10.25.20-AM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5810\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-08-01-at-10.25.20-AM.png\" alt=\"Screen Shot 2014-08-01 at 10.25.20 AM\" width=\"424\" height=\"349\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-08-01-at-10.25.20-AM.png 1050w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-08-01-at-10.25.20-AM-300x246.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-08-01-at-10.25.20-AM-1024x842.png 1024w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/><\/a><\/p>\n<p>Next is the Data Extraction (unload)\u00a0Stage.\u00a0The\u00a0available database profiles may depend upon what you chose on the previous page in the Extraction field. Select the database from the connection file, and the tables you wish to reorg from those available in the selection window:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.31.34-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5779\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.31.34-PM.png\" alt=\"Screen Shot 2014-07-24 at 12.31.34 PM\" width=\"427\" height=\"353\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.31.34-PM.png 1046w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.31.34-PM-300x247.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.31.34-PM-1024x845.png 1024w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p>Next is the\u00a0Data Loading Stage, where you specify\u00a0the target table&#8217;s details. Choose the connection profile, schema names, and applicable options for the repopulation\u00a0(in this case via Oracle SQL*Loader).\u00a0Click finish to automatically build all the scripts you will need to run the reorg(s).<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.32.52-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5780\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.32.52-PM.png\" alt=\"Screen Shot 2014-07-24 at 12.32.52 PM\" width=\"431\" height=\"361\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.32.52-PM.png 1038w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.32.52-PM-300x251.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.32.52-PM-1024x858.png 1024w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/a><\/p>\n<p>This process produced the files necessary to automatically reorganize only the JOB_TYPES table offline. The unload (FACT .ini), sort (CoSort .scl), and reload (Oracle .ctl) scripts, and ancillary files, are produced along with the batch script necessary to run it all. The .sql files preserve the constraints, and the .flow file\u00a0supports a visual representation of the workflow in a separate view.<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.34.05-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5781\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.34.05-PM.png\" alt=\"Screen Shot 2014-07-24 at 12.34.05 PM\" width=\"224\" height=\"277\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.34.05-PM.png 520w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-07-24-at-12.34.05-PM-243x300.png 243w\" sizes=\"(max-width: 224px) 100vw, 224px\" \/><\/a><\/p>\n<p>When the batch script (FlowBatch.bat) is run, a table\u00a0containing the re-sorted data for loading is produced. Following is a view of the table\u00a0before and after reorganization:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-08-01-at-12.47.50-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5809\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/Screen-Shot-2014-08-01-at-12.47.50-PM.png\" alt=\"Screen Shot 2014-08-01 at 12.47.50 PM\" width=\"492\" height=\"237\" \/><\/a><\/p>\n<p>The number of items is the same, but the reorg wizard sorted the table\u00a0on its primary key by default. You can change the sort key(s)\u00a0in the .scl job (by hand or through the GUI), if you need the table\u00a0reordered on another (lookup) column.<\/p>\n<p>Contact <a href=\"mailto:info@iri.com\" target=\"_blank\" rel=\"noopener\">info@iri.com<\/a> if you have any questions about how this wizard works, or if you need access to a demo or these components of the <a href=\"http:\/\/www.iri.com\/products\/iri-data-manager\" target=\"_blank\" rel=\"noopener\"><em>IRI Data Manager<\/em><\/a> suite.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As database table and index sizes increase, data becomes more fragmented\u00a0and\u00a0query response slows.\u00a0To improve database\u00a0operating efficiency, regular table reorganization is required. See this article\u00a0explaining\u00a0why reorgs matter\u00a0and the material below detailing the wizard&#8217;s\u00a0use. What It Is IRI Workbench &#8212; an\u00a0Eclipse IDE and GUI for all IRI software products &#8212;\u00a0provides a classic (offline) reorg solution\u00a0through a purpose-built<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/\" title=\"Using the Offline Reorg Wizard\">Read More<\/a><\/div>\n","protected":false},"author":44,"featured_media":11818,"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":[91,3],"tags":[490,494,850,495,75,375,491,493,492],"class_list":["post-5775","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-iri-workbench","category-vldb-operations","tag-bulk-unload","tag-data-extraction","tag-iri-workbench","tag-loading-sorted-data","tag-odbc","tag-offline-reorg","tag-pre-sorted-load","tag-reorg-wizard","tag-sql-loader"],"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>Using the Offline Reorg Wizard - 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\/vldb-operations\/offline-reorg-wizard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the Offline Reorg Wizard\" \/>\n<meta property=\"og:description\" content=\"As database table and index sizes increase, data becomes more fragmented\u00a0and\u00a0query response slows.\u00a0To improve database\u00a0operating efficiency, regular table reorganization is required. See this article\u00a0explaining\u00a0why reorgs matter\u00a0and the material below detailing the wizard&#8217;s\u00a0use. What It Is IRI Workbench &#8212; an\u00a0Eclipse IDE and GUI for all IRI software products &#8212;\u00a0provides a classic (offline) reorg solution\u00a0through a purpose-builtRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-31T13:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-07T14:02:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Allison Aguirre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Allison Aguirre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/\"},\"author\":{\"name\":\"Allison Aguirre\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/196d8057adb8838df5bddf4544beb507\"},\"headline\":\"Using the Offline Reorg Wizard\",\"datePublished\":\"2014-07-31T13:07:00+00:00\",\"dateModified\":\"2017-11-07T14:02:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/\"},\"wordCount\":556,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg\",\"keywords\":[\"bulk unload\",\"data extraction\",\"IRI Workbench\",\"loading sorted data\",\"ODBC\",\"offline reorg\",\"pre-sorted load\",\"reorg wizard\",\"SQL Loader\"],\"articleSection\":[\"IRI Workbench\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/\",\"url\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/\",\"name\":\"Using the Offline Reorg Wizard - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg\",\"datePublished\":\"2014-07-31T13:07:00+00:00\",\"dateModified\":\"2017-11-07T14:02:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg\",\"width\":600,\"height\":600,\"caption\":\"big rubix cube\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using the Offline Reorg Wizard\"}]},{\"@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\/196d8057adb8838df5bddf4544beb507\",\"name\":\"Allison Aguirre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0210c89c4e232a0c94809253910d4226?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0210c89c4e232a0c94809253910d4226?s=96&d=blank&r=g\",\"caption\":\"Allison Aguirre\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/allisona\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using the Offline Reorg Wizard - 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\/vldb-operations\/offline-reorg-wizard\/","og_locale":"en_US","og_type":"article","og_title":"Using the Offline Reorg Wizard","og_description":"As database table and index sizes increase, data becomes more fragmented\u00a0and\u00a0query response slows.\u00a0To improve database\u00a0operating efficiency, regular table reorganization is required. See this article\u00a0explaining\u00a0why reorgs matter\u00a0and the material below detailing the wizard&#8217;s\u00a0use. What It Is IRI Workbench &#8212; an\u00a0Eclipse IDE and GUI for all IRI software products &#8212;\u00a0provides a classic (offline) reorg solution\u00a0through a purpose-builtRead More","og_url":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/","og_site_name":"IRI","article_published_time":"2014-07-31T13:07:00+00:00","article_modified_time":"2017-11-07T14:02:00+00:00","og_image":[{"width":600,"height":600,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg","type":"image\/jpeg"}],"author":"Allison Aguirre","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Allison Aguirre","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/"},"author":{"name":"Allison Aguirre","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/196d8057adb8838df5bddf4544beb507"},"headline":"Using the Offline Reorg Wizard","datePublished":"2014-07-31T13:07:00+00:00","dateModified":"2017-11-07T14:02:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/"},"wordCount":556,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg","keywords":["bulk unload","data extraction","IRI Workbench","loading sorted data","ODBC","offline reorg","pre-sorted load","reorg wizard","SQL Loader"],"articleSection":["IRI Workbench","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/","url":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/","name":"Using the Offline Reorg Wizard - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg","datePublished":"2014-07-31T13:07:00+00:00","dateModified":"2017-11-07T14:02:00+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg","width":600,"height":600,"caption":"big rubix cube"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/vldb-operations\/offline-reorg-wizard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using the Offline Reorg Wizard"}]},{"@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\/196d8057adb8838df5bddf4544beb507","name":"Allison Aguirre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0210c89c4e232a0c94809253910d4226?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0210c89c4e232a0c94809253910d4226?s=96&d=blank&r=g","caption":"Allison Aguirre"},"url":"https:\/\/www.iri.com\/blog\/author\/allisona\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/big-rubix-cube.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5775"}],"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\/44"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=5775"}],"version-history":[{"count":21,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5775\/revisions"}],"predecessor-version":[{"id":11819,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5775\/revisions\/11819"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11818"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=5775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=5775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=5775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}