{"id":"https://openalex.org/W2058239738","doi":"https://doi.org/10.1145/2484838.2484857","title":"A multidimensional data model with subcategories for flexibly capturing summarizability","display_name":"A multidimensional data model with subcategories for flexibly capturing summarizability","publication_year":2013,"publication_date":"2013-07-29","ids":{"openalex":"https://openalex.org/W2058239738","doi":"https://doi.org/10.1145/2484838.2484857","mag":"2058239738"},"language":"en","primary_location":{"id":"doi:10.1145/2484838.2484857","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2484838.2484857","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th International Conference on Scientific and Statistical Database Management","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/A5007777922","display_name":"Sina Ariyan","orcid":null},"institutions":[{"id":"https://openalex.org/I67031392","display_name":"Carleton University","ror":"https://ror.org/02qtvee93","country_code":"CA","type":"education","lineage":["https://openalex.org/I67031392"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Sina Ariyan","raw_affiliation_strings":["Carleton University, Ottawa, Canada","Carleton University / Ottawa / Canada"],"affiliations":[{"raw_affiliation_string":"Carleton University, Ottawa, Canada","institution_ids":["https://openalex.org/I67031392"]},{"raw_affiliation_string":"Carleton University / Ottawa / Canada","institution_ids":["https://openalex.org/I67031392"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015753842","display_name":"Leopoldo Bertossi","orcid":"https://orcid.org/0000-0002-1144-3179"},"institutions":[{"id":"https://openalex.org/I67031392","display_name":"Carleton University","ror":"https://ror.org/02qtvee93","country_code":"CA","type":"education","lineage":["https://openalex.org/I67031392"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Leopoldo Bertossi","raw_affiliation_strings":["Carleton University, Ottawa, Canada","Carleton University / Ottawa / Canada"],"affiliations":[{"raw_affiliation_string":"Carleton University, Ottawa, Canada","institution_ids":["https://openalex.org/I67031392"]},{"raw_affiliation_string":"Carleton University / Ottawa / Canada","institution_ids":["https://openalex.org/I67031392"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5007777922"],"corresponding_institution_ids":["https://openalex.org/I67031392"],"apc_list":null,"apc_paid":null,"fwci":0.9647,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.75589507,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"12"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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/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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9991000294685364,"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.7947615385055542},{"id":"https://openalex.org/keywords/extension","display_name":"Extension (predicate logic)","score":0.6453065276145935},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6435732841491699},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.6202198266983032},{"id":"https://openalex.org/keywords/hierarchy","display_name":"Hierarchy","score":0.6055468916893005},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6023373007774353},{"id":"https://openalex.org/keywords/cube","display_name":"Cube (algebra)","score":0.60069739818573},{"id":"https://openalex.org/keywords/data-cube","display_name":"Data cube","score":0.5467438101768494},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.5042630434036255},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4986553192138672},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4499902129173279},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4270781874656677},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.42101752758026123},{"id":"https://openalex.org/keywords/expressive-power","display_name":"Expressive power","score":0.41141843795776367},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.401133269071579},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3327398896217346},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.23789912462234497},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.22200044989585876},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2034761905670166},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.127037912607193}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7947615385055542},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.6453065276145935},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6435732841491699},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.6202198266983032},{"id":"https://openalex.org/C31170391","wikidata":"https://www.wikidata.org/wiki/Q188619","display_name":"Hierarchy","level":2,"score":0.6055468916893005},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6023373007774353},{"id":"https://openalex.org/C53051483","wikidata":"https://www.wikidata.org/wiki/Q861555","display_name":"Cube (algebra)","level":2,"score":0.60069739818573},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.5467438101768494},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.5042630434036255},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4986553192138672},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4499902129173279},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4270781874656677},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.42101752758026123},{"id":"https://openalex.org/C195818886","wikidata":"https://www.wikidata.org/wiki/Q5421724","display_name":"Expressive power","level":2,"score":0.41141843795776367},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.401133269071579},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3327398896217346},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.23789912462234497},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.22200044989585876},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2034761905670166},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.127037912607193},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"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/C34447519","wikidata":"https://www.wikidata.org/wiki/Q179522","display_name":"Market economy","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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","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/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2484838.2484857","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2484838.2484857","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.379.4285","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.379.4285","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://people.scs.carleton.ca/~bertossi/papers/ehm-finalCamRead.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W78817961","https://openalex.org/W129837972","https://openalex.org/W152869763","https://openalex.org/W259338706","https://openalex.org/W1495859460","https://openalex.org/W1531163007","https://openalex.org/W1576741398","https://openalex.org/W1581894185","https://openalex.org/W1687820518","https://openalex.org/W1760622754","https://openalex.org/W1920146127","https://openalex.org/W1985239372","https://openalex.org/W1991368089","https://openalex.org/W2004281168","https://openalex.org/W2006315879","https://openalex.org/W2015348866","https://openalex.org/W2026130312","https://openalex.org/W2046769817","https://openalex.org/W2058239738","https://openalex.org/W2077518845","https://openalex.org/W2108971776","https://openalex.org/W2121601564","https://openalex.org/W2132224358","https://openalex.org/W2133054368","https://openalex.org/W2140190241","https://openalex.org/W2143401113","https://openalex.org/W2146380863","https://openalex.org/W2146581901","https://openalex.org/W2165547877","https://openalex.org/W2406071341","https://openalex.org/W2476987438","https://openalex.org/W6634437383","https://openalex.org/W6680704940","https://openalex.org/W6720983725"],"related_works":["https://openalex.org/W1988774479","https://openalex.org/W2366586806","https://openalex.org/W2198278743","https://openalex.org/W2359610078","https://openalex.org/W1578257433","https://openalex.org/W2386977141","https://openalex.org/W2360760838","https://openalex.org/W2381646725","https://openalex.org/W2727179277","https://openalex.org/W2541662483"],"abstract_inverted_index":{"In":[0],"multidimensional":[1],"(MD)":[2],"databases":[3],"and":[4,31,78,107],"data":[5],"warehouses":[6],"we":[7,65,150],"commonly":[8],"prefer":[9],"instances":[10],"that":[11,67,109],"have":[12,19],"summarizable":[13,28],"dimensions.":[14],"This":[15],"is":[16,80],"because":[17],"they":[18],"good":[20],"properties":[21],"for":[22,122],"query":[23,34],"answering.":[24],"Most":[25],"typically,":[26],"with":[27,102,158],"dimensions,":[29],"precomputed":[30,141],"materialized":[32],"aggregate":[33,129],"results":[35,49],"at":[36,50],"lower":[37],"levels":[38,52],"of":[39,53,83,88,140],"the":[40,54,75,84,89,97,104,114,153,162],"dimension":[41],"hierarchy":[42],"can":[43,145,155],"be":[44,146,156],"used":[45],"to":[46,96,112,161],"correctly":[47,147],"compute":[48],"higher":[51],"same":[55],"hierarchy,":[56],"improving":[57],"efficiency.":[58],"Being":[59],"summarizability":[60,76],"such":[61],"a":[62,81,123],"desirable":[63],"property,":[64],"argue":[66],"some":[68],"established":[69],"MD":[70,100,128],"models":[71],"cannot":[72],"properly":[73],"model":[74,101],"condition,":[77],"this":[79],"consequence":[82],"limited":[85],"expressive":[86],"power":[87],"modeling":[90],"languages.":[91],"We":[92,116],"propose":[93,117],"an":[94,118,132],"extension":[95],"Hurtado-Meldelzon":[98],"(HM)":[99],"subcategories,":[103],"EHM":[105,133,154],"model,":[106],"show":[108,151],"it":[110,144],"allows":[111],"capture":[113],"summarizability.":[115],"efficient":[119],"algorithm":[120],"that,":[121],"given":[124],"cube":[125,142],"view":[126],"(i.e.":[127],"query)":[130],"in":[131],"database,":[134],"determines":[135],"from":[136],"which":[137],"minimal":[138],"subset":[139],"views":[143],"computed.":[148],"Finally,":[149],"how":[152],"implemented":[157],"minor":[159],"modifications":[160],"familiar":[163],"ROLAP":[164],"schemas.":[165]},"counts_by_year":[{"year":2019,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}