{"id":"https://openalex.org/W2103642442","doi":"https://doi.org/10.1109/tkde.2002.1047769","title":"Parallel Star Join+DataIndexes: efficient query processing in data warehouses and OLAP","display_name":"Parallel Star Join+DataIndexes: efficient query processing in data warehouses and OLAP","publication_year":2002,"publication_date":"2002-11-01","ids":{"openalex":"https://openalex.org/W2103642442","doi":"https://doi.org/10.1109/tkde.2002.1047769","mag":"2103642442"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2002.1047769","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2002.1047769","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035863623","display_name":"Anindya Datta","orcid":"https://orcid.org/0000-0001-7966-2944"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"A. Datta","raw_affiliation_strings":["Georgia Institute of Technology Atlanta, GA, USA"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology Atlanta, GA, USA","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077015810","display_name":"Debra VanderMeer","orcid":"https://orcid.org/0000-0002-5930-6667"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"D. VanderMeer","raw_affiliation_strings":["Georgia Institute of Technology Atlanta, GA, USA"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology Atlanta, GA, USA","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047920922","display_name":"Krithi Ramamritham","orcid":"https://orcid.org/0000-0002-2181-0526"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"K. Ramamritham","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5035863623"],"corresponding_institution_ids":["https://openalex.org/I130701444"],"apc_list":null,"apc_paid":null,"fwci":1.1243,"has_fulltext":false,"cited_by_count":21,"citation_normalized_percentile":{"value":0.81834766,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"14","issue":"6","first_page":"1299","last_page":"1316"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9901000261306763,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.9140700101852417},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8469030857086182},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8019884824752808},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.7129425406455994},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6304129958152771},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5261896252632141},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4841971695423126},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.39721137285232544},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.0805564820766449}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9140700101852417},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8469030857086182},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8019884824752808},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.7129425406455994},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6304129958152771},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5261896252632141},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4841971695423126},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.39721137285232544},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0805564820766449},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/tkde.2002.1047769","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2002.1047769","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},{"id":"pmh:oai:dsapce.library.iitb.ac.in:10054/1302","is_oa":false,"landing_page_url":"http://dspace.library.iitb.ac.in/xmlui/handle/10054/1302","pdf_url":null,"source":{"id":"https://openalex.org/S4306400899","display_name":"DSpace (IIT Bombay)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I162827531","host_organization_name":"Indian Institute of Technology Bombay","host_organization_lineage":["https://openalex.org/I162827531"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"},{"id":"pmh:oai:dspace.library.iitb.ac.in:10054/1302","is_oa":false,"landing_page_url":"http://hdl.handle.net/10054/1302","pdf_url":null,"source":{"id":"https://openalex.org/S4306400899","display_name":"DSpace (IIT Bombay)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I162827531","host_organization_name":"Indian Institute of Technology Bombay","host_organization_lineage":["https://openalex.org/I162827531"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.4300000071525574,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W84454396","https://openalex.org/W109127539","https://openalex.org/W206955312","https://openalex.org/W1588885340","https://openalex.org/W1597532222","https://openalex.org/W1821376934","https://openalex.org/W1997020216","https://openalex.org/W2034408574","https://openalex.org/W2039795706","https://openalex.org/W2072764742","https://openalex.org/W2078528123","https://openalex.org/W2086294364","https://openalex.org/W2095075045","https://openalex.org/W2102607950","https://openalex.org/W2108922557","https://openalex.org/W2108971776","https://openalex.org/W2111967617","https://openalex.org/W2120684426","https://openalex.org/W2129885727","https://openalex.org/W2140646908","https://openalex.org/W2142512143","https://openalex.org/W2152815268","https://openalex.org/W2160677885","https://openalex.org/W2999943082","https://openalex.org/W3002580249","https://openalex.org/W3009202437","https://openalex.org/W4205826162","https://openalex.org/W4238594802","https://openalex.org/W4250279381","https://openalex.org/W4289258943","https://openalex.org/W6608378875","https://openalex.org/W6635650928","https://openalex.org/W6672097443"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2872228342","https://openalex.org/W2966529075","https://openalex.org/W2357522326"],"abstract_inverted_index":{"On-line":[0],"analytical":[1],"processing":[2,79,89,202],"(OLAP)":[3],"refers":[4],"to":[5,11,25,37,42,52,127,174],"the":[6,16,85,95,131,137,164,192,195,212,218,227,238,245,255],"technologies":[7],"that":[8,113],"allow":[9],"users":[10],"efficiently":[12],"retrieve":[13],"data":[14,17,35,81,122,160],"from":[15,136],"warehouse":[18,36],"for":[19,33,76,261],"decision-support":[20],"purposes.":[21],"Data":[22],"warehouses":[23,82],"tend":[24,51],"be":[26,38,53],"extremely":[27],"large,":[28],"it":[29,104],"is":[30,206],"quite":[31],"possible":[32],"a":[34,99,152,172,176,207,232,251],"hundreds":[39],"of":[40,87,98,130,194,254],"gigabytes":[41],"terabytes":[43],"in":[44,73,80,145,179,223,244],"size":[45],"(Chauduri":[46],"and":[47,55,66,102,123,159,162,187,258],"Dayal,":[48],"1997).":[49],"Queries":[50],"complex":[54],"ad":[56],"hoc,":[57],"often":[58],"requiring":[59],"computationally":[60],"expensive":[61],"operations":[62,183],"such":[63],"as":[64,116,119,121],"joins":[65],"aggregation.":[67],"Given":[68],"this,":[69],"we":[70,93,150,230,248],"are":[71,134],"interested":[72],"developing":[74],"strategies":[75],"improving":[77],"query":[78,201],"by":[83,108],"exploring":[84],"applicability":[86],"parallel":[88,180,200,208,234],"techniques.":[90],"In":[91],"particular,":[92],"exploit":[94],"natural":[96],"partitionability":[97],"star":[100,177],"schema":[101],"render":[103],"even":[105],"more":[106],"efficient":[107,182],"applying":[109],"DataIndexes-a":[110],"storage":[111],"structure":[112,222],"serves":[114],"both":[115,157],"an":[117],"index":[118],"well":[120],"lends":[124],"itself":[125],"naturally":[126],"vertical":[128],"partitioning":[129,161],"data.":[132],"DataIndexes":[133],"derived":[135],"various":[138],"special":[139],"purpose":[140],"access":[141,257],"mechanisms":[142],"currently":[143],"supported":[144],"commercial":[146],"OLAP":[147,220],"products.":[148],"Specifically,":[149],"propose":[151],"declustering":[153],"strategy":[154,210,229],"which":[155,170],"incorporates":[156],"task":[158],"present":[163],"Parallel":[165],"Star":[166],"Join":[167,214],"(PSJ)":[168],"Algorithm,":[169],"provides":[171],"means":[173],"perform":[175],"join":[178,209,221,235],"using":[181],"involving":[184],"only":[185],"rowsets":[186],"projection":[188],"columns.":[189],"We":[190],"compare":[191],"performance":[193,246],"PSJ":[196],"Algorithm":[197],"with":[198],"two":[199],"strategies.":[203],"The":[204],"first":[205,249],"utilizing":[211],"Bitmap":[213],"Index":[215],"(BJI),":[216],"arguably":[217],"state-of-the-art":[219],"use":[224],"today.":[225],"For":[226],"second":[228],"choose":[231],"well-known":[233],"algorithm,":[236],"namely":[237],"pipelined":[239],"hash":[240],"algorithm.":[241],"To":[242],"assist":[243],"comparison,":[247],"develop":[250],"cost":[252],"model":[253],"disk":[256],"transmission":[259],"costs":[260],"all":[262],"three":[263],"approaches.":[264]},"counts_by_year":[{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}