{"id":"https://openalex.org/W2386545545","doi":null,"title":"An Improved Aggregation Algorithm for Online Analytical Processing","display_name":"An Improved Aggregation Algorithm for Online Analytical Processing","alternate_titles":[],"publication_year":2005,"publication_date":"2005-01-01","ids":{"openalex":"https://openalex.org/W2386545545","mag":"2386545545"},"language":"en","primary_location":{"id":"mag:2386545545","doi":null,"is_oa":false,"landing_page_url":"https://oversea.cnki.net/kcms/detail/detail.aspx?dbcode=CJFD&filename=JSJC20050200S","pdf_url":null,"source":{"id":"https://openalex.org/S2764825856","display_name":"Jisuanji gongcheng","issn_l":"1000-3428","issn":["1000-3428"],"is_oa":false,"is_in_doaj":true,"is_core":true,"listed_in":["cwts-core","doaj","poland-20"],"host_organization":"https://openalex.org/P4361727472","host_organization_name":"East China Computer Technology Research Institute","host_organization_lineage":["https://openalex.org/P4361727472"],"host_organization_lineage_names":["East China Computer Technology Research Institute"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Jisuanji gongcheng","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2386545545"],"child_works_count":0,"type":"article","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/A5010685880","display_name":"Meng Fanhui","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I27357992","display_name":"Dalian University of Technology","ror":"https://ror.org/023hj5876","country_code":"CN","type":"education","lineage":["https://openalex.org/I27357992"]}],"countries":["CN"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Meng Fanhui","raw_affiliation_strings":["Department of Computer Science and Engineering,Dalian University of Technology,Dalian 116023)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering,Dalian University of Technology,Dalian 116023)","institution_ids":["https://openalex.org/I27357992"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5010685880"],"corresponding_institution_ids":["https://openalex.org/I27357992"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9984999895095825,"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.9984999895095825,"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.0007999999797903001,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":9.999999747378752e-05,"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/online-analytical-processing","display_name":"online analytical processing","score":0.9160000085830688},{"id":"https://openalex.org/keywords/olap-queries","display_name":"OLAP queries","score":0.8840000033378601},{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.7080000042915344},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.8090000152587891},{"id":"https://openalex.org/keywords/distributed-databases","display_name":"distributed databases","score":0.6159999966621399},{"id":"https://openalex.org/keywords/query-performance","display_name":"query performance","score":0.375}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.930759847164154},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.6415173411369324},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6265614032745361},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.6243858933448792},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6080827713012695},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5869242548942566},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.540166437625885},{"id":"https://openalex.org/C108094655","wikidata":"https://www.wikidata.org/wiki/Q181593","display_name":"Sorting algorithm","level":3,"score":0.5294650793075562},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.5260534286499023},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4646218717098236},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.42102891206741333},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39007097482681274},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.360740602016449},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3313477039337158},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32824718952178955},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.20685306191444397},{"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}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2386545545","doi":null,"is_oa":false,"landing_page_url":"https://oversea.cnki.net/kcms/detail/detail.aspx?dbcode=CJFD&filename=JSJC20050200S","pdf_url":null,"source":{"id":"https://openalex.org/S2764825856","display_name":"Jisuanji gongcheng","issn_l":"1000-3428","issn":["1000-3428"],"is_oa":false,"is_in_doaj":true,"is_core":true,"listed_in":["cwts-core","doaj","poland-20"],"host_organization":"https://openalex.org/P4361727472","host_organization_name":"East China Computer Technology Research Institute","host_organization_lineage":["https://openalex.org/P4361727472"],"host_organization_lineage_names":["East China Computer Technology Research Institute"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Jisuanji gongcheng","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2385254866","https://openalex.org/W1578428226","https://openalex.org/W2361404969","https://openalex.org/W2102201539","https://openalex.org/W2115678122","https://openalex.org/W214627910","https://openalex.org/W2356817975","https://openalex.org/W2108441106","https://openalex.org/W2043279389","https://openalex.org/W2015659187"],"abstract_inverted_index":{"The":[0],"OLAP":[1],"queries":[2,6],"are":[3],"ad-hoc,":[4],"complex":[5],"and":[7,25,55,75],"the":[8,17,20,26,30,38,45,52,57,62,76,79],"process":[9],"generally":[10],"includes":[11],"aggregate":[12],"operation.":[13,64],"This":[14],"paper":[15],"analyzes":[16],"characteristics":[18],"of":[19,47,78],"star":[21],"schema":[22],"storage":[23],"structure":[24],"data":[27,32],"update":[28],"in":[29,51],"relational":[31],"warehouse,":[33],"considers":[34],"entity":[35],"relation":[36,40],"as":[37],"overall":[39],"which":[41],"is":[42,73],"segmented":[43],"by":[44],"size":[46],"memory":[48],"sorting":[49,63],"buffer":[50],"distributed":[53,58],"database,":[54],"combines":[56],"aggregation":[59,68],"operation":[60],"with":[61,69],"A":[65],"modified":[66],"MuSA(sort-based":[67],"multi-table":[70],"join)":[71],"algorithm":[72,81],"proposed":[74],"performance":[77],"new":[80],"can":[82],"be":[83],"improved":[84],"dramatically.":[85]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2386545545","counts_by_year":[],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
