{"id":49003,"date":"2011-01-17T08:02:59","date_gmt":"2011-01-17T05:02:59","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=49003"},"modified":"2021-11-24T06:03:07","modified_gmt":"2021-11-24T03:03:07","slug":"data-integration-performance-issues","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/","title":{"rendered":"The Origins of Performance Issues when Integrating Data"},"content":{"rendered":"<p><center><small>(<a href=\"https:\/\/www.slideshare.net\/mrm0\/open-source-solutions-managing-analyzing-and-delivering-business-information\" rel=\"noopener noreferrer\" target=\"_blank\">Featured image credit<\/a>)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#How_do_DI_performance_issues_occur\" >How do DI performance issues occur?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#Areas_of_performance_improvement\" >Areas of performance improvement<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"How_do_DI_performance_issues_occur\"><\/span>How do DI performance issues occur?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div id=\"attachment_63627\" style=\"width: 150px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/David-Linthicum1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-63627\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/04\/David-Linthicum1-150x150.png\" width=\"140\" height=\"140\" class=\"size-thumbnail wp-image-63627\" \/><\/a><p id=\"caption-attachment-63627\" class=\"wp-caption-text\"><small>David Linthicum<\/small><\/p><\/div>\n<p>It\u2019s been written so much about the challenges of data integration (DI), so when an integration initiative at an enterprise starts working, at last, everybody sighs happily. However, they miss at least one thing to worry about\u2014it\u2019s performance.<\/p>\n<p>What\u2019s wrong with performance, you say. Well, according to <a href=\"https:\/\/www.linkedin.com\/in\/davidlinthicum\/\" rel=\"noopener noreferrer\" target=\"_blank\">David Linthicum<\/a>, a computing and application integration expert, there are two main data integration performance <a href=\"https:\/\/web.archive.org\/web\/20091028045212\/http:\/\/www.ebizq.net\/blogs\/linthicum\/2009\/09\/addressing_data_integration_pe.php\" rel=\"noopener noreferrer\" target=\"_blank\">issues<\/a>:<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">The first occurs due to the organic data growth. Being a common issue for both real-time and batch data integration model, it results in the system failing to get and deliver the needed data on time, providing undesirable latencies.<\/li>\n<li>The second issue is a result of bad data integration <a href=\"https:\/\/www.altoros.com\/blog\/when-developing-system-architectures-think-about-data-integration\/\">architecture<\/a>. This happens when core data integration performance requirements have been poorly formulated or misunderstood. The mistake leads to wrong technology or approach selection.<\/li>\n<\/ul>\n<p>What\u2019s so dramatic about it? The answer is, because someone starts a data integration initiative to have a better view and access to data needed for business. If this information doesn\u2019t appear in target systems when it is requested by a decision-maker, the goal of a data integration initiative is not achieved.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/10\/2003-tdwi-survey-etl-performance-features.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/10\/2003-tdwi-survey-etl-performance-features-1024x625.png\" width=\"720\" class=\"aligncenter size-large wp-image-64954\" \/><\/a><small>Reliability, latencies, and throughput are the top criteria for DI performance (<a href=\"http:\/\/download.101com.com\/tdwi\/research_report\/2003ETLReport.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Areas_of_performance_improvement\"><\/span>Areas of performance improvement<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>According to a TDWI <a href=\"http:\/\/download.101com.com\/tdwi\/research_report\/2003ETLReport.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">report<\/a>, <i>&#8220;there are many variables that affect throughput\u2014the complexity of transformations, the number of sources that must be integrated, the complexity of target data models, the capabilities of the target database,&#8221;<\/i> etc.<\/p>\n<p>Here are the main check points to see if a DI solution\u2019s performance still fits your corporate standards.<\/p>\n<p><strong>Data transformation schemas<\/strong> deal with both data structure and content. If data mappings are not as well-organized as possible, then a single <a href=\"https:\/\/www.altoros.com\/blog\/etl-whats-in-abbreviation\/\">transformation<\/a> may take twice as long. Mapping problems can cause small delays that add up. The solution to the transformation issue is to make sure that data maps are written as efficiently as possible. You can compare your data integration solution to the similar ones to understand if the data transformation runs with the required speed.<\/p>\n<p>This is where performance testing can help a lot in finding bottlenecks and fixing them in the first place.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/12\/testing-a-data-warehouse-project.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/12\/testing-a-data-warehouse-project-1024x788.png\" width=\"720\" class=\"aligncenter size-large wp-image-63479\" \/><\/a><small>The areas of testing for a data warehouse project (<a href=\"https:\/\/www.amazon.com\/Data-Integration-Blueprint-Modeling-Architecture\/dp\/0137084935\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p><strong>Environment<\/strong> can also suspend your data integration processes. You have to make sure that the operating system, runtime, etc., work properly. <i>&#8220;No matter how much horsepower a system possesses, if its runtime environment is unstable, overall performance suffers,&#8221; <\/i>a TDWI report says.<\/p>\n<p><strong>Network bandwidth and traffic<\/strong>\u2014in many cases, the performance is hindered not by the data integration tool itself, but by the size of the network you use. To avoid this issue, you need to calculate the predicted performance under various loads and make sure you use the fastest network available for your data integration budget.<\/p>\n<p><b>Custom SQL queries<\/b>, when used, are also the points where latencies may occur. Review them once in a while, test, and fix accordingly.<\/p>\n<p><b>Source and target connections<\/b>, as well as other endpoints, are prone to performance issues. Probably, you may need to optimize the performance of the systems being integrated, if they harm throughput.<\/p>\n<p>Besides, explore the possibilities for <a href=\"https:\/\/www.altoros.com\/blog\/application-consolidation-to-simplify-data-integration-on-business-value\/\">app consolidation<\/a> (to streamline workflows) or <a href=\"https:\/\/www.altoros.com\/blog\/data-federation-vs-data-integration\/\">data federation<\/a> (if this approach is enough for your business needs).<\/p>\n<p>In case you use <b>ODBC connections<\/b>, read our <a href=\"https:\/\/www.altoros.com\/blog\/improving-data-integration-with-odbc\/\">article<\/a> on how to improve their performance, as well.<\/p>\n<p>Finally, there are many other areas of possible bottlenecks, but, if there&#8217;s only one thing to mention as a conclusion, <b>caching<\/b> of data you use frequently may help in many scenarios. Analyze your workflows and address redundancy.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/12\/types-of-testing-in-a-data-warehouse-project.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/12\/types-of-testing-in-a-data-warehouse-project-1024x746.png\" width=\"720\" class=\"aligncenter size-large wp-image-63478\" \/><\/a><small>The types of testing for a data warehouse project (<a href=\"https:\/\/www.amazon.com\/Data-Integration-Blueprint-Modeling-Architecture\/dp\/0137084935\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p>Data integration solution reminds a car: it can run fast but become slow if not properly tuned and taken care of. As we become more dependent upon data integration, our ability to understand and optimize the performance issues will make a substantial difference.<\/p>\n<p>So, plan data integration architecture properly and keep an eye on performance.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Further_reading\"><\/span>Further reading<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/when-developing-system-architectures-think-about-data-integration\/\">When Developing System Architectures, Think About Data Integration<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/application-consolidation-to-simplify-data-integration-on-business-value\/\">Steps to Consolidate Apps and Data to Cut Operational Costs<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/improving-data-integration-with-odbc\/\">Improving Database Integration with ODBC<\/a><\/li>\n<\/ul>\n<hr\/>\n<p><center><small>The post is written by <a href=\"https:\/\/www.altoros.com\/blog\/author\/olga\/\">Olga Belokurskaya<\/a><br \/>\nwith contributions from <a href=\"https:\/\/www.altoros.com\/blog\/author\/alex\/\">Alex Khizhniak<\/a> and <a href=\"https:\/\/www.altoros.com\/blog\/author\/ekaterina\/\">Katherine Vasilega<\/a>.<\/small><\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(Featured image credit)<\/p>\n<p>&nbsp;<\/p>\n<p>How do DI performance issues occur?<\/p>\n<p id=\"caption-attachment-63627\" class=\"wp-caption-text\">David Linthicum<\/p>\n<p>It\u2019s been written so much about the challenges of data integration (DI), so when an integration initiative at an enterprise starts working, at last, everybody sighs happily. However, they miss at least one thing to worry about\u2014it\u2019s performance.<\/p>\n<p>What\u2019s wrong with [&#8230;]<\/p>\n","protected":false},"author":81,"featured_media":63303,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[7],"tags":[960,895],"class_list":["post-49003","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-and-opinion","tag-data-integration","tag-research-and-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The Origins of Performance Issues when Integrating Data | Altoros<\/title>\n<meta name=\"description\" content=\"Companies often overlook performance, only to find out later that their BI systems fail to deliver critical data on time. So, let&#039;s explore where to improve.\" \/>\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.altoros.com\/blog\/data-integration-performance-issues\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Origins of Performance Issues when Integrating Data | Altoros\" \/>\n<meta property=\"og:description\" content=\"(Featured image credit) &nbsp; How do DI performance issues occur? David Linthicum It\u2019s been written so much about the challenges of data integration (DI), so when an integration initiative at an enterprise starts working, at last, everybody sighs happily. However, they miss at least one thing to worry about\u2014it\u2019s performance. What\u2019s wrong with [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-17T05:02:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-24T03:03:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/solving-performance-problems.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1395\" \/>\n\t<meta property=\"og:image:height\" content=\"1074\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Olga Belokurskaya\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olga Belokurskaya\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/\"},\"author\":{\"name\":\"Olga Belokurskaya\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#\\\/schema\\\/person\\\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"headline\":\"The Origins of Performance Issues when Integrating Data\",\"datePublished\":\"2011-01-17T05:02:59+00:00\",\"dateModified\":\"2021-11-24T03:03:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/\"},\"wordCount\":738,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/solving-performance-problems.png\",\"keywords\":[\"Data Integration\",\"Research and Development\"],\"articleSection\":[\"News\\\/Opinion\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/\",\"name\":\"The Origins of Performance Issues when Integrating Data | Altoros\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/solving-performance-problems.png\",\"datePublished\":\"2011-01-17T05:02:59+00:00\",\"dateModified\":\"2021-11-24T03:03:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#\\\/schema\\\/person\\\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/solving-performance-problems.png\",\"contentUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/solving-performance-problems.png\",\"width\":1395,\"height\":1074},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-performance-issues\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Origins of Performance Issues when Integrating Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/\",\"name\":\"Altoros\",\"description\":\"Insight\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#\\\/schema\\\/person\\\/b4c29d31973f82a70fcb5e68c5aa5b60\",\"name\":\"Olga Belokurskaya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Olga-Belokurskaya-96x96.jpg\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Olga-Belokurskaya-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Olga-Belokurskaya-96x96.jpg\",\"caption\":\"Olga Belokurskaya\"},\"description\":\"Olga Belokurskaya is a writer with a long history of working in the information technology and services industry. She has broad expertise in writing news and articles on cloud computing, data integration, and software product development. Olga is adept at holding interviews with business owners and representatives. In addition, she has experience working as an interpreter and communications specialist.\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/author\\\/olga\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Origins of Performance Issues when Integrating Data | Altoros","description":"Companies often overlook performance, only to find out later that their BI systems fail to deliver critical data on time. So, let's explore where to improve.","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.altoros.com\/blog\/data-integration-performance-issues\/","og_locale":"en_US","og_type":"article","og_title":"The Origins of Performance Issues when Integrating Data | Altoros","og_description":"(Featured image credit) &nbsp; How do DI performance issues occur? David Linthicum It\u2019s been written so much about the challenges of data integration (DI), so when an integration initiative at an enterprise starts working, at last, everybody sighs happily. However, they miss at least one thing to worry about\u2014it\u2019s performance. What\u2019s wrong with [...]","og_url":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/","og_site_name":"Altoros","article_published_time":"2011-01-17T05:02:59+00:00","article_modified_time":"2021-11-24T03:03:07+00:00","og_image":[{"width":1395,"height":1074,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/solving-performance-problems.png","type":"image\/png"}],"author":"Olga Belokurskaya","twitter_misc":{"Written by":"Olga Belokurskaya","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#article","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/"},"author":{"name":"Olga Belokurskaya","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"headline":"The Origins of Performance Issues when Integrating Data","datePublished":"2011-01-17T05:02:59+00:00","dateModified":"2021-11-24T03:03:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/"},"wordCount":738,"commentCount":0,"image":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/solving-performance-problems.png","keywords":["Data Integration","Research and Development"],"articleSection":["News\/Opinion"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/","url":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/","name":"The Origins of Performance Issues when Integrating Data | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/solving-performance-problems.png","datePublished":"2011-01-17T05:02:59+00:00","dateModified":"2021-11-24T03:03:07+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/solving-performance-problems.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/solving-performance-problems.png","width":1395,"height":1074},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/data-integration-performance-issues\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Origins of Performance Issues when Integrating Data"}]},{"@type":"WebSite","@id":"https:\/\/www.altoros.com\/blog\/#website","url":"https:\/\/www.altoros.com\/blog\/","name":"Altoros","description":"Insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.altoros.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60","name":"Olga Belokurskaya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","caption":"Olga Belokurskaya"},"description":"Olga Belokurskaya is a writer with a long history of working in the information technology and services industry. She has broad expertise in writing news and articles on cloud computing, data integration, and software product development. Olga is adept at holding interviews with business owners and representatives. In addition, she has experience working as an interpreter and communications specialist.","url":"https:\/\/www.altoros.com\/blog\/author\/olga\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=49003"}],"version-history":[{"count":38,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49003\/revisions"}],"predecessor-version":[{"id":65082,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49003\/revisions\/65082"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/63303"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=49003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=49003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=49003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}