{"id":"https://openalex.org/W86191609","doi":null,"title":"Processing Relational OLAP Queries with UB-Trees and Multidimensional Hierarchical Clustering","display_name":"Processing Relational OLAP Queries with UB-Trees and Multidimensional Hierarchical Clustering","publication_year":2000,"publication_date":"2000-01-01","ids":{"openalex":"https://openalex.org/W86191609","mag":"86191609"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.35.5820","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.35.5820","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://SunSITE.Informatik.RWTH-Aachen.DE/Publications/CEUR-WS/Vol-28/paper1.pdf","raw_type":"text"},"volume":null,"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/A5002413906","display_name":"Volker Markl","orcid":"https://orcid.org/0009-0009-0964-026X","observed_orcids":["https://orcid.org/0009-0009-0964-026X"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Volker Markl","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5110020072","display_name":"Rudolf Bayer","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rudolf Bayer","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0892,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.84021084,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":null},"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.8065999746322632,"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.8065999746322632,"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/T11106","display_name":"Data Management and Algorithms","score":0.18549999594688416,"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.0008999999845400453,"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/query-processing","display_name":"query processing","score":0.6110000014305115},{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.6269999742507935},{"id":"https://openalex.org/keywords/information-warehouse","display_name":"information warehouse","score":0.824999988079071},{"id":"https://openalex.org/keywords/range-queries","display_name":"range queries","score":0.5099999904632568}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8036779165267944},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6661503314971924},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5982030630111694},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5597255825996399},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5458956956863403},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5420641899108887},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4873712658882141},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.481177419424057},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.4766198694705963},{"id":"https://openalex.org/C92835128","wikidata":"https://www.wikidata.org/wiki/Q1277447","display_name":"Hierarchical clustering","level":3,"score":0.4646237790584564},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.44618314504623413},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4355047941207886},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.4297647178173065},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.4168059229850769},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.41614168882369995},{"id":"https://openalex.org/C136736807","wikidata":"https://www.wikidata.org/wiki/Q818943","display_name":"Range query (database)","level":5,"score":0.4156269133090973},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3927909731864929},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3693944215774536},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3500071167945862},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.30437010526657104},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.25217410922050476},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10336729884147644},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10227063298225403},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.09390521049499512},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.08665719628334045},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.35.5820","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.35.5820","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://SunSITE.Informatik.RWTH-Aachen.DE/Publications/CEUR-WS/Vol-28/paper1.pdf","raw_type":"text"},{"id":"mag:86191609","doi":null,"is_oa":false,"landing_page_url":"http://ceur-ws.org/Vol-28/paper1.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"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":25,"referenced_works":["https://openalex.org/W38346608","https://openalex.org/W151059316","https://openalex.org/W188023883","https://openalex.org/W1494049834","https://openalex.org/W1507719695","https://openalex.org/W1515932031","https://openalex.org/W1522055873","https://openalex.org/W1578663408","https://openalex.org/W1581805425","https://openalex.org/W1894732633","https://openalex.org/W1952220400","https://openalex.org/W1981561414","https://openalex.org/W1982945449","https://openalex.org/W2071425575","https://openalex.org/W2072764742","https://openalex.org/W2074429597","https://openalex.org/W2106642566","https://openalex.org/W2108908993","https://openalex.org/W2111967617","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2117716920","https://openalex.org/W2118269922","https://openalex.org/W2149173084","https://openalex.org/W2158237121"],"related_works":["https://openalex.org/W1540076816","https://openalex.org/W1570020612","https://openalex.org/W7100973259","https://openalex.org/W2093210410","https://openalex.org/W2122990007","https://openalex.org/W135413625","https://openalex.org/W2168044462","https://openalex.org/W2401681794","https://openalex.org/W2746802445","https://openalex.org/W196021272"],"abstract_inverted_index":{"Multidimensional":[0],"access":[1],"methods":[2],"like":[3],"the":[4,40,83,103],"UBTree":[5],"can":[6],"be":[7],"used":[8],"to":[9],"accelerate":[10],"almost":[11],"any":[12],"query":[13,18,49,86],"processing":[14,19,87],"operation,":[15],"if":[16],"proper":[17],"algorithms":[20,52,60],"are":[21],"used:":[22],"Relational":[23],"queries":[24,27,64,109],"or":[25,45,50],"SQL":[26],"consist":[28],"of":[29,42,108,119],"restrictions,":[30],"projections,":[31],"ordering,":[32],"grouping":[33],"and":[34,36,93],"aggregation,":[35],"join":[37],"operations.":[38,56],"In":[39,57,78],"presence":[41],"multidimensional":[43,47,94],"restrictions":[44,69],"sorting,":[46],"range":[48],"Tetris":[51],"efficiently":[53,62],"process":[54],"these":[55,59],"addition,":[58],"also":[61],"support":[63],"that":[65],"generate":[66],"some":[67],"hierarchical":[68,95],"(for":[70],"instance":[71],"by":[72,105],"following":[73],"1:n":[74],"foreign":[75],"key":[76],"relationships).":[77],"this":[79,130],"paper":[80,131],"we":[81],"investigate":[82],"impacts":[84],"on":[85],"in":[88,129],"RDBMS":[89],"when":[90],"using":[91],"UB-Trees":[92],"clustering":[96],"for":[97,110],"physical":[98],"data":[99],"organization.":[100],"We":[101],"illustrate":[102],"benefits":[104],"performance":[106,126],"measurements":[107],"a":[111,115,120],"star":[112],"schema":[113],"from":[114],"real":[116],"world":[117],"application":[118],"SAP":[121],"business":[122],"information":[123],"warehouse.":[124],"The":[125],"results":[127],"reported":[128],"were...":[132]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-08-26T07:47:46.906454","created_date":"2016-06-24T00:00:00"}