{"id":"https://openalex.org/W2039952443","doi":"https://doi.org/10.4018/jdm.2007010104","title":"Optimization of Multidimensional Aggregates in Data Warehouses","display_name":"Optimization of Multidimensional Aggregates in Data Warehouses","publication_year":2007,"publication_date":"2007-01-01","ids":{"openalex":"https://openalex.org/W2039952443","doi":"https://doi.org/10.4018/jdm.2007010104","mag":"2039952443"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2007010104","is_oa":true,"landing_page_url":"https://doi.org/10.4018/jdm.2007010104","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.4018/jdm.2007010104","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5081515766","display_name":"Russel Pears","orcid":null},"institutions":[{"id":"https://openalex.org/I39854758","display_name":"Auckland University of Technology","ror":"https://ror.org/01zvqw119","country_code":"NZ","type":"education","lineage":["https://openalex.org/I39854758"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Russel Pears","raw_affiliation_strings":["Auckland University of Technology, New Zealand","Auckland University of Technology; New Zealand"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Auckland University of Technology, New Zealand","institution_ids":["https://openalex.org/I39854758"]},{"raw_affiliation_string":"Auckland University of Technology; New Zealand","institution_ids":["https://openalex.org/I39854758"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007310203","display_name":"Bryan Houliston","orcid":null},"institutions":[{"id":"https://openalex.org/I39854758","display_name":"Auckland University of Technology","ror":"https://ror.org/01zvqw119","country_code":"NZ","type":"education","lineage":["https://openalex.org/I39854758"]}],"countries":["NZ"],"is_corresponding":false,"raw_author_name":"Bryan Houliston","raw_affiliation_strings":["Auckland University of Technology, New Zealand","Auckland University of Technology; New Zealand"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Auckland University of Technology, New Zealand","institution_ids":["https://openalex.org/I39854758"]},{"raw_affiliation_string":"Auckland University of Technology; New Zealand","institution_ids":["https://openalex.org/I39854758"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I39854758"],"apc_list":null,"apc_paid":null,"fwci":0.9972,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.78814038,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"18","issue":"1","first_page":"69","last_page":"93"},"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.9983000159263611,"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.9983000159263611,"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.9979000091552734,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9937000274658203,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8163783550262451},{"id":"https://openalex.org/keywords/haar-wavelet","display_name":"Haar wavelet","score":0.7137056589126587},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6883211135864258},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6693016886711121},{"id":"https://openalex.org/keywords/thresholding","display_name":"Thresholding","score":0.6666247844696045},{"id":"https://openalex.org/keywords/wavelet","display_name":"Wavelet","score":0.6421827077865601},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.5199252963066101},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.5072157382965088},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4881323277950287},{"id":"https://openalex.org/keywords/prime","display_name":"Prime (order theory)","score":0.47571876645088196},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.46530184149742126},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.41995203495025635},{"id":"https://openalex.org/keywords/volume","display_name":"Volume (thermodynamics)","score":0.41762423515319824},{"id":"https://openalex.org/keywords/wavelet-transform","display_name":"Wavelet transform","score":0.31652355194091797},{"id":"https://openalex.org/keywords/discrete-wavelet-transform","display_name":"Discrete wavelet transform","score":0.17344072461128235},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.16518595814704895},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.15342119336128235}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8163783550262451},{"id":"https://openalex.org/C2780423554","wikidata":"https://www.wikidata.org/wiki/Q766198","display_name":"Haar wavelet","level":5,"score":0.7137056589126587},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6883211135864258},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6693016886711121},{"id":"https://openalex.org/C191178318","wikidata":"https://www.wikidata.org/wiki/Q2256906","display_name":"Thresholding","level":3,"score":0.6666247844696045},{"id":"https://openalex.org/C47432892","wikidata":"https://www.wikidata.org/wiki/Q831390","display_name":"Wavelet","level":2,"score":0.6421827077865601},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.5199252963066101},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.5072157382965088},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4881323277950287},{"id":"https://openalex.org/C184992742","wikidata":"https://www.wikidata.org/wiki/Q7243229","display_name":"Prime (order theory)","level":2,"score":0.47571876645088196},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.46530184149742126},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.41995203495025635},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.41762423515319824},{"id":"https://openalex.org/C196216189","wikidata":"https://www.wikidata.org/wiki/Q2867","display_name":"Wavelet transform","level":3,"score":0.31652355194091797},{"id":"https://openalex.org/C46286280","wikidata":"https://www.wikidata.org/wiki/Q2414958","display_name":"Discrete wavelet transform","level":4,"score":0.17344072461128235},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.16518595814704895},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.15342119336128235},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"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/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","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},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdm.2007010104","is_oa":true,"landing_page_url":"https://doi.org/10.4018/jdm.2007010104","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:18:y:2007:i:1:p:69-93","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdm.2007010104","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.4018/jdm.2007010104","is_oa":true,"landing_page_url":"https://doi.org/10.4018/jdm.2007010104","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","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/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"The":[0,12],"computation":[1],"of":[2,19,96,149,181,190,207,216,237,255,266],"multidimensional":[3],"aggregates":[4],"is":[5,15,88,146,212,246,259],"a":[6,51,58,75,82,234,251,262],"common":[7],"operation":[8],"in":[9,46,57,81,187],"OLAP":[10],"applications.":[11],"major":[13],"bottleneck":[14],"the":[16,35,47,71,97,113,126,147,150,156,170,191,199,205,208,217,223,242],"large":[17],"volume":[18],"data":[20,38,48,80,85,92,98,107,210,239,244],"that":[21,53,123],"needs":[22],"to":[23,28,108,131,155,164,198,203,249],"be":[24,165],"processed":[25],"which":[26,258],"leads":[27],"prohibitively":[29],"expensive":[30],"query":[31],"execution":[32],"times.":[33],"On":[34],"other":[36],"hand,":[37],"analysts":[39],"are":[40],"primarily":[41],"concerned":[42],"with":[43,129],"discerning":[44],"trends":[45],"and":[49,105,116,135,211,245],"thus":[50,247],"system":[52],"provides":[54],"approximate":[55,171],"answers":[56,172],"timely":[59],"fashion":[60],"would":[61],"suit":[62],"their":[63],"requirements":[64],"better.":[65],"In":[66,221],"this":[67],"article":[68],"we":[69],"present":[70],"prime":[72,224],"factor":[73,225],"scheme,":[74],"novel":[76],"method":[77,87],"for":[78,178],"compressing":[79,168],"warehouse.":[83,99],"Our":[84],"compression":[86,141,219],"based":[89],"on":[90,93,119,183,230],"aggregating":[91],"each":[94],"dimension":[95],"We":[100],"used":[101,202],"both":[102,132],"real":[103],"world":[104],"synthetic":[106],"compare":[109],"our":[110,117],"scheme":[111,128,226],"against":[112],"Haar":[114,157],"wavelet":[115,218],"experiments":[118],"range-sum":[120],"queries":[121,182],"show":[122],"it":[124],"outperforms":[125],"latter":[127],"respect":[130],"decoding":[133],"time":[134],"error":[136,151,256],"rate,":[137],"while":[138],"maintaining":[139],"comparable":[140],"ratios.":[142],"One":[143],"encouraging":[144],"feature":[145],"stability":[148,257],"rate":[152],"when":[153],"compared":[154],"wavelet.":[158],"Although":[159],"wavelets":[160],"have":[161],"been":[162,196],"shown":[163],"effective":[166],"at":[167],"data,":[169],"they":[173],"provide":[174],"varies":[175],"widely,":[176],"even":[177],"identical":[179,185],"types":[180],"nearly":[184],"values":[186],"distinct":[188],"parts":[189],"data.":[192],"This":[193],"problem":[194],"has":[195],"attributed":[197],"thresholding":[200,231],"technique":[201],"reduce":[204],"size":[206],"encoded":[209],"an":[213],"integral":[214],"part":[215],"scheme.":[220],"contrast":[222],"does":[227],"not":[228],"rely":[229],"but":[232],"keeps":[233],"smaller":[235],"version":[236],"every":[238],"element":[240],"from":[241,261],"original":[243],"able":[248],"achieve":[250],"much":[252],"higher":[253],"degree":[254],"important":[260],"Data":[263],"Analysts":[264],"point":[265],"view.":[267]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-06-11T06:19:23.411458","created_date":"2025-10-10T00:00:00"}