{"id":13188,"date":"2021-12-07T20:31:53","date_gmt":"2021-12-08T01:31:53","guid":{"rendered":"https:\/\/carleton.ca\/scs\/?page_id=13188"},"modified":"2021-12-07T20:31:53","modified_gmt":"2021-12-08T01:31:53","slug":"tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis","status":"publish","type":"page","link":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/","title":{"rendered":"TR-07-02: Parallel ROLAP Data Cubes Performance Comparison and Analysis"},"content":{"rendered":"

Carleton University
\nTechnical Report<\/a> TR-07-02
\nJanuary 26, 2007<\/p>\n

Parallel ROLAP Data Cubes Performance Comparison and Analysis<\/h2>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Wei Shi, Qi Deng, Boyong Liang<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n

Abstract<\/h3>\n

The pre-computation of data cubes is critical to improving the response time of On-Line Analytical Processing (OLAP) systems and can be instrumental in accelerating data mining tasks in large data warehouses.<\/p>\n

In order to meet the need for improved performance created by growing data sizes, parallel solutions for generating the data cube are becoming increasingly important. This Project Report reports the test result of building and querying data cube between large parallel database: DB2 and Panda system. We have investigated two large parallel databases: DB2 and Oracle 9i.<\/p>\n

Under the default setup of DB2 and Panda system, we tested the performance of building a cube in both Panda system and DB2 and also some data cube queries. We mainly studied the Partition difference between Panda system and DB2, then analyze the reason of the test result after the serious study of these two systems.<\/p>\n

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

Carleton University Technical Report TR-07-02 January 26, 2007 Parallel ROLAP Data Cubes Performance Comparison and Analysis Wei Shi, Qi Deng, Boyong Liang Abstract The pre-computation of data cubes is critical to improving the response time of On-Line Analytical Processing (OLAP) systems and can be instrumental in accelerating data mining tasks in large data warehouses. In […]<\/p>\n","protected":false},"author":49,"featured_media":0,"parent":12385,"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-07-02: Parallel ROLAP Data Cubes Performance Comparison and Analysis - School of Computer Science<\/title>\n<meta name=\"description\" content=\"Carleton University Technical Report TR-07-02 January 26, 2007 Parallel ROLAP Data Cubes Performance Comparison and Analysis Wei Shi, Qi Deng, Boyong\" \/>\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-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/\" \/>\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-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/\",\"url\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/\",\"name\":\"TR-07-02: Parallel ROLAP Data Cubes Performance Comparison and Analysis - School of Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/carleton.ca\/scs\/#website\"},\"datePublished\":\"2021-12-08T01:31:53+00:00\",\"dateModified\":\"2021-12-08T01:31:53+00:00\",\"description\":\"Carleton University Technical Report TR-07-02 January 26, 2007 Parallel ROLAP Data Cubes Performance Comparison and Analysis Wei Shi, Qi Deng, Boyong\",\"breadcrumb\":{\"@id\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/#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 2007\",\"item\":\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"TR-07-02: Parallel ROLAP Data Cubes Performance Comparison and Analysis\"}]},{\"@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-07-02: Parallel ROLAP Data Cubes Performance Comparison and Analysis - School of Computer Science","description":"Carleton University Technical Report TR-07-02 January 26, 2007 Parallel ROLAP Data Cubes Performance Comparison and Analysis Wei Shi, Qi Deng, Boyong","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-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/","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-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/","url":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/","name":"TR-07-02: Parallel ROLAP Data Cubes Performance Comparison and Analysis - School of Computer Science","isPartOf":{"@id":"https:\/\/carleton.ca\/scs\/#website"},"datePublished":"2021-12-08T01:31:53+00:00","dateModified":"2021-12-08T01:31:53+00:00","description":"Carleton University Technical Report TR-07-02 January 26, 2007 Parallel ROLAP Data Cubes Performance Comparison and Analysis Wei Shi, Qi Deng, Boyong","breadcrumb":{"@id":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/tr-07-02-parallel-rolap-data-cubes-performance-comparison-and-analysis\/#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 2007","item":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-2007\/"},{"@type":"ListItem","position":5,"name":"TR-07-02: Parallel ROLAP Data Cubes Performance Comparison and Analysis"}]},{"@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_image_type":"none","banner_button":"no"},"_links":{"self":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/13188"}],"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=13188"}],"version-history":[{"count":1,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/13188\/revisions"}],"predecessor-version":[{"id":13189,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/13188\/revisions\/13189"}],"up":[{"embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/12385"}],"wp:attachment":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/media?parent=13188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}