{"id":12923,"date":"2021-11-30T19:03:29","date_gmt":"2021-12-01T00:03:29","guid":{"rendered":"https:\/\/carleton.ca\/scs\/?page_id=12923"},"modified":"2021-11-30T19:06:08","modified_gmt":"2021-12-01T00:06:08","slug":"tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system","status":"publish","type":"page","link":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/","title":{"rendered":"TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System"},"content":{"rendered":"

Carleton University
\nTechnical Report<\/a> TR-97-02
\nJanuary 1997<\/p>\n

TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System<\/h2>\n
\n
\n
\n
\n
\n
\n
\n
Yifeng Xu & Sivarama P. Dandamudi<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n

Abstract<\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

Two typical architectures of parallel database systems are the shared-everything and shared-nothing architectures. Shared-everything architecture provides better performance than the shared-nothing architecture but it is not scalable to large system sizes. On the other hand, shared-nothing architecture provides good system scalability but is sensitive to data skew. Hierarchical architectures have been proposed to incorporate the best features of these two architectures (i.e., the shared-nothing and the shared-everything). In this paper, we present a detailed simulation study comparing the performance of the two-level hierarchical architecture with that of the shared-nothing and shared-everything architectures.<\/p>\n

The results from the simulation experiments presented here show that a properly designed hierarchical system can provide performance very close to that of the shared-everything while providing system scalability similar to that provided by the shared-nothing architecture. The results also indicate that, when designing a hierarchical system, the cluster size should be maintained as large as the hardware limitations would allow. Then, the performance of the hierarchical system would be very similar to that of the shared-everything architecture under the system and workload models considered here.<\/p>\n

TR-97-02.pdf<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Carleton University Technical Report TR-97-02 January 1997 TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System Yifeng Xu & Sivarama P. Dandamudi Abstract Two typical architectures of parallel database systems are the shared-everything and shared-nothing architectures. Shared-everything architecture provides better performance than the shared-nothing architecture but it is not scalable to large system sizes. […]<\/p>\n","protected":false},"author":49,"featured_media":0,"parent":12157,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":"","_links_to":"","_links_to_target":""},"yoast_head":"\nTR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System - School of Computer Science<\/title>\n<meta name=\"description\" content=\"Carleton University Technical Report TR-97-02 January 1997 TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System Yifeng\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/\",\"url\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/\",\"name\":\"TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System - School of Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/carleton.ca\/scs\/#website\"},\"datePublished\":\"2021-12-01T00:03:29+00:00\",\"dateModified\":\"2021-12-01T00:06:08+00:00\",\"description\":\"Carleton University Technical Report TR-97-02 January 1997 TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System Yifeng\",\"breadcrumb\":{\"@id\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/carleton.ca\/scs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Research\",\"item\":\"https:\/\/carleton.ca\/scs\/research\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SCS Technical Reports\",\"item\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Technical Reports 1997\",\"item\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/carleton.ca\/scs\/#website\",\"url\":\"https:\/\/carleton.ca\/scs\/\",\"name\":\"School of Computer Science\",\"description\":\"Carleton University\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/carleton.ca\/scs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System - School of Computer Science","description":"Carleton University Technical Report TR-97-02 January 1997 TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System Yifeng","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:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/","url":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/","name":"TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System - School of Computer Science","isPartOf":{"@id":"https:\/\/carleton.ca\/scs\/#website"},"datePublished":"2021-12-01T00:03:29+00:00","dateModified":"2021-12-01T00:06:08+00:00","description":"Carleton University Technical Report TR-97-02 January 1997 TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System Yifeng","breadcrumb":{"@id":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/tr-97-02-performance-evaluation-of-a-two-level-hierarchical-parallel-database-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/carleton.ca\/scs\/"},{"@type":"ListItem","position":2,"name":"Research","item":"https:\/\/carleton.ca\/scs\/research\/"},{"@type":"ListItem","position":3,"name":"SCS Technical Reports","item":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/"},{"@type":"ListItem","position":4,"name":"Technical Reports 1997","item":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1997\/"},{"@type":"ListItem","position":5,"name":"TR-97-02: Performance Evaluation of a Two-Level Hierarchical Parallel Database System"}]},{"@type":"WebSite","@id":"https:\/\/carleton.ca\/scs\/#website","url":"https:\/\/carleton.ca\/scs\/","name":"School of Computer Science","description":"Carleton University","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/carleton.ca\/scs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"acf":{"banner_button":"no","banner_image_type":"none"},"_links":{"self":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/12923"}],"collection":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/comments?post=12923"}],"version-history":[{"count":2,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/12923\/revisions"}],"predecessor-version":[{"id":12927,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/12923\/revisions\/12927"}],"up":[{"embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/12157"}],"wp:attachment":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/media?parent=12923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}