{"id":"https://openalex.org/W2124278683","doi":null,"title":"Explaining Differences in Multidimensional Aggregates","display_name":"Explaining Differences in Multidimensional Aggregates","alternate_titles":[],"publication_year":1999,"publication_date":"1999-09-07","ids":{"openalex":"https://openalex.org/W2124278683","mag":"2124278683"},"language":"en","primary_location":{"id":"pmh:oai:dsapce.library.iitb.ac.in:100/2574","doi":null,"is_oa":false,"landing_page_url":"http://dspace.library.iitb.ac.in/xmlui/handle/10054/16220","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,"listed_in":[],"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":"25th International Conference on Very Large Data Bases,EDINBURGH, SCOTLAND,SEP 07-10, 1999","raw_type":"Proceedings Paper"},"parent_works":[],"lineage":["https://openalex.org/W2124278683"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":[],"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/A5031035935","display_name":"Sunita Sarawagi","orcid":"https://orcid.org/0009-0005-9538-6616","observed_orcids":["https://orcid.org/0009-0005-9538-6616"]},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sunita Sarawagi","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5031035935"],"corresponding_institution_ids":["https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":4.5409,"has_fulltext":false,"cited_by_count":171,"citation_normalized_percentile":{"value":0.94415584,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":93,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"42","last_page":"53"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.7465999722480774,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.7465999722480774,"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"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.20579999685287476,"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"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.010900000110268593,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/multidimensional-databases","display_name":"multidimensional databases","score":0.6269999742507935},{"id":"https://openalex.org/keywords/olap","display_name":"OLAP","score":0.9409999847412109},{"id":"https://openalex.org/keywords/dynamic-programming-algorithm","display_name":"dynamic programming algorithm","score":0.9279999732971191},{"id":"https://openalex.org/keywords/one-pass-algorithms","display_name":"one-pass algorithms","score":0.6629999876022339},{"id":"https://openalex.org/keywords/space-efficient-algorithms","display_name":"memory-efficient algorithms","score":0.5270000100135803},{"id":"https://openalex.org/keywords/rolap","display_name":"ROLAP","score":0.6179999709129333}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8937510848045349},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7816076874732971},{"id":"https://openalex.org/C111030470","wikidata":"https://www.wikidata.org/wiki/Q1430460","display_name":"Curse of dimensionality","level":2,"score":0.6890782117843628},{"id":"https://openalex.org/C132010649","wikidata":"https://www.wikidata.org/wiki/Q189222","display_name":"Intuition","level":2,"score":0.614056408405304},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.5472270846366882},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5187066197395325},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5064646005630493},{"id":"https://openalex.org/C51823790","wikidata":"https://www.wikidata.org/wiki/Q504353","display_name":"Greedy algorithm","level":2,"score":0.461905300617218},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4583112895488739},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.38485774397850037},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.37698590755462646},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.21339091658592224},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.16276317834854126},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1493004858493805},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","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/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","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/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"pmh:oai:dsapce.library.iitb.ac.in:100/2574","doi":null,"is_oa":false,"landing_page_url":"http://dspace.library.iitb.ac.in/xmlui/handle/10054/16220","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,"listed_in":[],"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":"25th International Conference on Very Large Data Bases,EDINBURGH, SCOTLAND,SEP 07-10, 1999","raw_type":"Proceedings Paper"},{"id":"mag:2124278683","doi":null,"is_oa":false,"landing_page_url":"https://www.cse.iitb.ac.in/~sunita/papers/vldb99.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.17.8694","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.17.8694","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.it.iitb.ernet.in/~sunita/papers/vldb99.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.58.3439","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.58.3439","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb.org/conf/1999/P4.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1565838812","https://openalex.org/W1578959085","https://openalex.org/W2072764742","https://openalex.org/W2099111195","https://openalex.org/W2114580434","https://openalex.org/W3162744413"],"related_works":["https://openalex.org/W1540704498","https://openalex.org/W1491318920","https://openalex.org/W769870517","https://openalex.org/W2395382225","https://openalex.org/W2075877598","https://openalex.org/W7096198668","https://openalex.org/W1603838668","https://openalex.org/W7096809852","https://openalex.org/W113181503","https://openalex.org/W7099882459"],"abstract_inverted_index":{"Our":[0],"goal":[1],"is":[2,147],"to":[3,44,91,95,130,151],"enhance":[4],"multidimensional":[5],"database":[6],"systems":[7],"with":[8,197,203,211,248],"advanced":[9,73],"mining":[10],"primitives.":[11],"Current":[12],"Online":[13],"Analytical":[14],"Processing":[15],"(OLAP)":[16],"products":[17],"provide":[18],"a":[19,31,104,107,155,183],"minimal":[20],"set":[21,32],"of":[22,33,164,186,189,228,236,243],"basic":[23,34],"aggregate":[24],"operators":[25,36,42],"like":[26,37],"sum":[27],"and":[28,30,39,58,63,88,149,234,240],"average":[29],"navigational":[35],"drill-downs":[38],"roll-ups.":[40],"These":[41],"have":[43],"be":[45],"driven":[46],"entirely":[47],"by":[48],"the":[49,83,93,96,112,128,144,165,180,190,207,212,221,232,237],"analyst's":[50],"intuition.":[51],"Such":[52],"ad":[53],"hoc":[54],"exploration":[55],"gets":[56],"tedious":[57],"error-prone":[59],"as":[60,231],"data":[61,79,166,191,223],"dimensionality":[62,235],"size":[64,233],"increases.":[65],"In":[66,99,178],"earlier":[67],"work":[68],"we":[69,76,102],"presented":[70],"one":[71,162],"such":[72,134],"primitive":[74],"where":[75],"pre-mined":[77],"OLAP":[78,222],"for":[80,117,133,142],"exceptions,":[81],"summarized":[82,115],"exceptions":[84],"at":[85,122],"appropriate":[86],"levels,":[87],"used":[89],"them":[90],"lead":[92],"analyst":[94,113],"interesting":[97],"regions.":[98],"this":[100,218],"paper":[101],"present":[103],"second":[105],"enhancement:":[106],"single":[108],"operator":[109],"that":[110,146,159,174],"lets":[111],"get":[114],"reasons":[116,145],"drops":[118],"or":[119],"increases":[120,239],"observed":[121],"an":[123,138],"aggregated":[124],"level.":[125],"This":[126,193],"eliminates":[127],"need":[129],"manually":[131],"drill-down":[132],"reasons.":[135],"We":[136,153,201],"develop":[137],"information":[139],"theoretic":[140],"formulation":[141],"expressing":[143],"compact":[148],"easy":[150,195],"interpret.":[152],"design":[154],"dynamic":[156],"programming":[157],"algorithm":[158,173,181,230],"requires":[160],"only":[161],"pass":[163],"improving":[167],"significantly":[168],"over":[169],"our":[170,204,229],"initial":[171],"greedy":[172],"required":[175],"multiple":[176],"passes.":[177],"addition,":[179],"uses":[182],"small":[184],"amount":[185],"memory":[187],"independent":[188],"size.":[192],"allows":[194],"integration":[196],"existing":[198],"CLAP":[199],"products.":[200],"illustrate":[202],"prototype":[205,219],"on":[206,217],"DB2/UDB":[208],"ROLAP":[209],"product":[210],"Excel":[213],"Pivot-table":[214],"frontend.":[215],"Experiments":[216],"using":[220],"benchmark":[224],"demonstrate":[225],"(1)":[226],"scalability":[227],"cube":[238],"(2)":[241],"feasibility":[242],"getting":[244],"interactive":[245],"answers":[246],"even":[247],"modest":[249],"hardware":[250],"resources.":[251]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2124278683","counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":8},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":12},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":9},{"year":2015,"cited_by_count":8},{"year":2014,"cited_by_count":8},{"year":2013,"cited_by_count":7},{"year":2012,"cited_by_count":8}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
