{"id":657,"date":"2012-03-03T19:46:09","date_gmt":"2012-03-03T19:46:09","guid":{"rendered":"http:\/\/www.websitedesignwebsitedevelopment.com\/?p=657"},"modified":"2014-03-19T09:13:59","modified_gmt":"2014-03-19T09:13:59","slug":"how-the-parallel-star-join-works","status":"publish","type":"post","link":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/","title":{"rendered":"How the parallel star join works?"},"content":{"rendered":"<h2>How the parallel star join works?<\/h2>\n<p>(<a title=\"A Case for Parallelism in Data Warehousing and OLAP\" href=\"http:\/\/www.websitedesignwebsitedevelopment.com\/wp-content\/uploads\/2012\/03\/10.1.1.51.1504.pdf\">Download<\/a> Reference Research Paper)<\/p>\n<p><span style=\"text-decoration: underline;\">Star Join Works Involving:<\/span><\/p>\n<p>i) JDI (Join DataIndexing)<br \/>\nii) i-th dimension tables<br \/>\niii) Use of conventional relational approach<\/p>\n<p><span style=\"text-decoration: underline;\">As the situation is a process so described to the point as follows:<\/span><\/p>\n<p>They proposed and demonstrated the implementation by partitioning the table into sub-tables. For example the SALES table sub-divided into further 7 tables and SALES table still associated with fact table. Its dimensional key the primary key of SALES table is linked with the foreign key which exists in fact table helps to locate the desired row or column partitioned.<br \/>\nParallel star join demonstration describes that by dividing the tables in fact table and dimension tables enhance the query performance but by sub-dividing the dimension tables according to the rest of dimension tables add a lot in it.<\/p>\n<p><span style=\"text-decoration: underline;\">e.g.<\/span><br \/>\nIn research paper SALES table although was divided into further 7 tables but still one attribute was associated for the related dimension table too. We can get exact idea of star join working by that query<\/p>\n<p>SELECT TIME.Year, TIME.Month, average(SALES.Discount)<br \/>\nFROM TIME, SALES<br \/>\nWHERE TIME.TimeKey = SALES.shipDate<br \/>\nGROUP BY TIME.Year, TIME.Month<\/p>\n<p>Conventional relational approach is used. As I mentioned before that although dimension tables are sub-divided into further small tables but still the association among dimension tables is maintained. Like in this query the tables TIME and SALES are presented in association by implementing through the primary key\/foreign key relationship linking the ShipDate and TimeKey. The approach as used with join and DataIndexing so in research paper it is called as JDI. If we use the approach DataIndexing without star join so it will be BDI, Basic DataIndexing.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How the parallel star join works? (Download Reference Research Paper) Star Join Works Involving: i) JDI (Join DataIndexing) ii) i-th dimension tables iii) Use of conventional relational approach As the situation is a process so described to the point as follows: They proposed and demonstrated the implementation by partitioning the table into sub-tables. For example [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[54],"tags":[],"class_list":["post-657","post","type-post","status-publish","format-standard","hentry","category-data-warehouse"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How the parallel star join works<\/title>\n<meta name=\"description\" content=\"How the parallel star join works\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How the parallel star join works\" \/>\n<meta property=\"og:description\" content=\"How the parallel star join works\" \/>\n<meta property=\"og:url\" content=\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/\" \/>\n<meta property=\"og:site_name\" content=\"AndroidBubble Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pages\/Website-Design-Website-Development\/172363336135453\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-03T19:46:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-03-19T09:13:59+00:00\" \/>\n<meta name=\"author\" content=\"Fahad\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fahad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/\"},\"author\":{\"name\":\"Fahad\",\"@id\":\"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/0a833b633f744c3a5e0de7c9a94e71f7\"},\"headline\":\"How the parallel star join works?\",\"datePublished\":\"2012-03-03T19:46:09+00:00\",\"dateModified\":\"2014-03-19T09:13:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/\"},\"wordCount\":290,\"articleSection\":[\"Data Warehouse\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/\",\"url\":\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/\",\"name\":\"How the parallel star join works\",\"isPartOf\":{\"@id\":\"https:\/\/androidbubble.com\/blog\/#website\"},\"datePublished\":\"2012-03-03T19:46:09+00:00\",\"dateModified\":\"2014-03-19T09:13:59+00:00\",\"author\":{\"@id\":\"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/0a833b633f744c3a5e0de7c9a94e71f7\"},\"description\":\"How the parallel star join works\",\"breadcrumb\":{\"@id\":\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/androidbubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Website Development\",\"item\":\"https:\/\/androidbubble.com\/blog\/category\/website-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Software Engineering Perspective\",\"item\":\"https:\/\/androidbubble.com\/blog\/category\/website-development\/software-engineering-perspective\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Data Warehouse\",\"item\":\"https:\/\/androidbubble.com\/blog\/category\/website-development\/software-engineering-perspective\/data-warehouse\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"How the parallel star join works?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/androidbubble.com\/blog\/#website\",\"url\":\"https:\/\/androidbubble.com\/blog\/\",\"name\":\"AndroidBubble Blog\",\"description\":\"Articles &amp; Posts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/androidbubble.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/0a833b633f744c3a5e0de7c9a94e71f7\",\"name\":\"Fahad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/afab5bcad71955d142a69df1758e6710aed4ab9cc2b5da28c54a7c3f39801b73?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/afab5bcad71955d142a69df1758e6710aed4ab9cc2b5da28c54a7c3f39801b73?s=96&d=mm&r=g\",\"caption\":\"Fahad\"},\"sameAs\":[\"http:\/\/www.androidbubbles.com\/\",\"https:\/\/x.com\/phpFlex\"],\"url\":\"https:\/\/androidbubble.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How the parallel star join works","description":"How the parallel star join works","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:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/","og_locale":"en_US","og_type":"article","og_title":"How the parallel star join works","og_description":"How the parallel star join works","og_url":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/","og_site_name":"AndroidBubble Blog","article_publisher":"https:\/\/www.facebook.com\/pages\/Website-Design-Website-Development\/172363336135453","article_published_time":"2012-03-03T19:46:09+00:00","article_modified_time":"2014-03-19T09:13:59+00:00","author":"Fahad","twitter_misc":{"Written by":"Fahad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/#article","isPartOf":{"@id":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/"},"author":{"name":"Fahad","@id":"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/0a833b633f744c3a5e0de7c9a94e71f7"},"headline":"How the parallel star join works?","datePublished":"2012-03-03T19:46:09+00:00","dateModified":"2014-03-19T09:13:59+00:00","mainEntityOfPage":{"@id":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/"},"wordCount":290,"articleSection":["Data Warehouse"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/","url":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/","name":"How the parallel star join works","isPartOf":{"@id":"https:\/\/androidbubble.com\/blog\/#website"},"datePublished":"2012-03-03T19:46:09+00:00","dateModified":"2014-03-19T09:13:59+00:00","author":{"@id":"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/0a833b633f744c3a5e0de7c9a94e71f7"},"description":"How the parallel star join works","breadcrumb":{"@id":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/androidbubble.com\/blog\/website-development\/software-engineering-perspective\/data-warehouse\/how-the-parallel-star-join-works\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/androidbubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Website Development","item":"https:\/\/androidbubble.com\/blog\/category\/website-development\/"},{"@type":"ListItem","position":3,"name":"Software Engineering Perspective","item":"https:\/\/androidbubble.com\/blog\/category\/website-development\/software-engineering-perspective\/"},{"@type":"ListItem","position":4,"name":"Data Warehouse","item":"https:\/\/androidbubble.com\/blog\/category\/website-development\/software-engineering-perspective\/data-warehouse\/"},{"@type":"ListItem","position":5,"name":"How the parallel star join works?"}]},{"@type":"WebSite","@id":"https:\/\/androidbubble.com\/blog\/#website","url":"https:\/\/androidbubble.com\/blog\/","name":"AndroidBubble Blog","description":"Articles &amp; Posts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/androidbubble.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/0a833b633f744c3a5e0de7c9a94e71f7","name":"Fahad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/androidbubble.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/afab5bcad71955d142a69df1758e6710aed4ab9cc2b5da28c54a7c3f39801b73?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/afab5bcad71955d142a69df1758e6710aed4ab9cc2b5da28c54a7c3f39801b73?s=96&d=mm&r=g","caption":"Fahad"},"sameAs":["http:\/\/www.androidbubbles.com\/","https:\/\/x.com\/phpFlex"],"url":"https:\/\/androidbubble.com\/blog\/author\/admin\/"}]}},"views":412,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/posts\/657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/comments?post=657"}],"version-history":[{"count":4,"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/posts\/657\/revisions"}],"predecessor-version":[{"id":1652,"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/posts\/657\/revisions\/1652"}],"wp:attachment":[{"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/media?parent=657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/categories?post=657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/androidbubble.com\/blog\/wp-json\/wp\/v2\/tags?post=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}