{"id":"https://openalex.org/W2141581261","doi":"https://doi.org/10.1145/1007568.1007668","title":"Data densification in a relational database system","display_name":"Data densification in a relational database system","publication_year":2004,"publication_date":"2004-06-13","ids":{"openalex":"https://openalex.org/W2141581261","doi":"https://doi.org/10.1145/1007568.1007668","mag":"2141581261"},"language":"en","primary_location":{"id":"doi:10.1145/1007568.1007668","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007668","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-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/A5041752781","display_name":"Abhinav Gupta","orcid":"https://orcid.org/0000-0002-3630-3244"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Abhinav Gupta","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002546424","display_name":"Sankar Subramanian","orcid":"https://orcid.org/0000-0002-2375-3254"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sankar Subramanian","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032089564","display_name":"Srikanth Bellamkonda","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Srikanth Bellamkonda","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003515555","display_name":"Tolga Bozkaya","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tolga Bozkaya","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060178716","display_name":"Nathan Folkert","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nathan Folkert","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100721966","display_name":"Lei Sheng","orcid":"https://orcid.org/0000-0002-5725-1375"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lei Sheng","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5088270000","display_name":"Andrew Witkowski","orcid":"https://orcid.org/0009-0001-6118-8380"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andrew Witkowski","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5041752781"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":0.2318,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.65088813,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"855","last_page":"859"},"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.9998999834060669,"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.9998999834060669,"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.9997000098228455,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9968000054359436,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/computer-science","display_name":"Computer science","score":0.7142459154129028},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.712409257888794},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.7120198607444763},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6835228204727173},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6269235014915466},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5777431726455688},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.553488552570343},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5129520297050476},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.4612957239151001},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.45678719878196716},{"id":"https://openalex.org/keywords/product","display_name":"Product (mathematics)","score":0.42157021164894104},{"id":"https://openalex.org/keywords/row-and-column-spaces","display_name":"Row and column spaces","score":0.4187273383140564},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.41154754161834717},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3788726329803467},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3637131154537201},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.20552188158035278},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.10465133190155029}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7142459154129028},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.712409257888794},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.7120198607444763},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6835228204727173},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6269235014915466},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5777431726455688},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.553488552570343},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5129520297050476},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.4612957239151001},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.45678719878196716},{"id":"https://openalex.org/C90673727","wikidata":"https://www.wikidata.org/wiki/Q901718","display_name":"Product (mathematics)","level":2,"score":0.42157021164894104},{"id":"https://openalex.org/C104140500","wikidata":"https://www.wikidata.org/wiki/Q2088159","display_name":"Row and column spaces","level":3,"score":0.4187273383140564},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.41154754161834717},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3788726329803467},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3637131154537201},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.20552188158035278},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.10465133190155029},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1007568.1007668","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007668","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W2102387332","https://openalex.org/W2102951036","https://openalex.org/W2160967997","https://openalex.org/W6675450584"],"related_works":["https://openalex.org/W2313440505","https://openalex.org/W3123744736","https://openalex.org/W2137691148","https://openalex.org/W1505848319","https://openalex.org/W4281399881","https://openalex.org/W3166006430","https://openalex.org/W4281971614","https://openalex.org/W2049180840","https://openalex.org/W1992086467","https://openalex.org/W3121299875"],"abstract_inverted_index":{"Data":[0],"in":[1,25,43],"a":[2,16,44,67,73,127,193,229],"relational":[3],"data":[4,42,60,115,124,142],"warehouse":[5],"is":[6,116,136,163,237],"usually":[7],"sparse.":[8],"That":[9],"is,":[10],"if":[11,66,114],"no":[12,22,58],"value":[13,92],"exists":[14,24,61],"for":[15,49,62,85,132,150,192],"given":[17],"combination":[18,51,154],"of":[19,30,52,130,139,155,196,201,221],"dimension":[20,53,121],"values,":[21],"row":[23],"the":[26,41,83,102,119,137,153,179,199,210,223],"fact":[27,59],"table.":[28],"Densities":[29],"0.1-2%":[31],"are":[32],"very":[33,238],"common.":[34],"However,":[35],"users":[36,77],"may":[37,78],"want":[38,80],"to":[39,81,94,167,171,178,185,208],"view":[40],"dense":[45,117,123,144],"form,":[46],"with":[47,89,218,240],"rows":[48,131],"all":[50],"values":[54],"displayed":[55],"even":[56],"when":[57],"them.":[63],"For":[64],"example,":[65],"product":[68,84],"did":[69],"not":[70],"sell":[71],"during":[72],"particular":[74],"time":[75,87,111,120],"period,":[76],"still":[79],"see":[82],"that":[86],"period":[88],"zero":[90],"sales":[91],"next":[93],"it.":[95],"Moreover,":[96],"analytic":[97],"window":[98,231],"functions":[99],"[1]":[100],"and":[101,159,169,215],"SQL":[103,148,181],"model":[104],"clause":[105],"[2]":[106],"can":[107],"more":[108],"easily":[109],"express":[110,168],"series":[112],"calculations":[113],"along":[118,198],"because":[122],"will":[125],"fill":[126],"consistent":[128],"number":[129],"each":[133],"period.Data":[134],"densification":[135,151,197],"process":[138],"converting":[140],"spare":[141],"into":[143],"form.":[145],"The":[146],"current":[147],"technique":[149],"(using":[152],"DISTINCT,":[156],"CROSS":[157],"JOIN":[158,161],"OUTER":[160,188],"operations)":[162],"extremely":[164],"unintuitive,":[165],"difficult":[166],"inefficient":[170],"compute.":[172],"Hence,":[173],"we":[174],"propose":[175],"an":[176],"extension":[177],"ANSI":[180],"join":[182,212],"operator,":[183],"referred":[184],"as":[186],"\"PARTITIONED":[187],"JOIN\",":[189],"which":[190,236],"allows":[191],"succinct":[194],"expression":[195],"dimensions":[200],"interest.":[202],"We":[203,226],"also":[204,227],"present":[205],"various":[206],"algorithms":[207],"evaluate":[209],"new":[211,230],"operator":[213],"efficiently":[214],"compare":[216],"it":[217],"existing":[219],"methods":[220],"doing":[222],"equivalent":[224],"operation.":[225],"define":[228],"function":[232],"\"LAST_VALUE":[233],"(IGNORE":[234],"NULLS)\"":[235],"useful":[239],"partitioned":[241],"outer":[242],"join.":[243]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}