{"id":"https://openalex.org/W2025619570","doi":"https://doi.org/10.1145/1496909.1496927","title":"Managing operational business intelligence workloads","display_name":"Managing operational business intelligence workloads","publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W2025619570","doi":"https://doi.org/10.1145/1496909.1496927","mag":"2025619570"},"language":"en","primary_location":{"id":"doi:10.1145/1496909.1496927","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1496909.1496927","pdf_url":null,"source":{"id":"https://openalex.org/S50071195","display_name":"ACM SIGOPS Operating Systems Review","issn_l":"0163-5980","issn":["0163-5980","1943-586X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGOPS Operating Systems Review","raw_type":"journal-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/A5045738980","display_name":"Umeshwar Dayal","orcid":null},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Umeshwar Dayal","raw_affiliation_strings":["HPL Hewlett-Packard Laboratories, Palo Alto, CA","HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA","institution_ids":["https://openalex.org/I1324840837"]},{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050764028","display_name":"Harumi Kuno","orcid":"https://orcid.org/0009-0007-3553-0254"},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Harumi Kuno","raw_affiliation_strings":["HPL Hewlett-Packard Laboratories, Palo Alto, CA","HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA","institution_ids":["https://openalex.org/I1324840837"]},{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113681033","display_name":"Janet L. Wiener","orcid":null},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Janet L. Wiener","raw_affiliation_strings":["HPL Hewlett-Packard Laboratories, Palo Alto, CA","HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA","institution_ids":["https://openalex.org/I1324840837"]},{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086875579","display_name":"Kevin Wilkinson","orcid":null},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kevin Wilkinson","raw_affiliation_strings":["HPL Hewlett-Packard Laboratories, Palo Alto, CA","HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA","institution_ids":["https://openalex.org/I1324840837"]},{"raw_affiliation_string":"HPL Hewlett-Packard Laboratories, Palo Alto, CA#TAB#","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006677198","display_name":"Archana Ganapathi","orcid":null},"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"]},{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Archana Ganapathi","raw_affiliation_strings":["UCB UC Berkeley, Berkeley, CA"],"affiliations":[{"raw_affiliation_string":"UCB UC Berkeley, Berkeley, CA","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015473130","display_name":"Stefan Krompa\u00df","orcid":null},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Stefan Krompass","raw_affiliation_strings":["TUM Technische Universit\u00e4t M\u00fcnchen,, Munich, Germany"],"affiliations":[{"raw_affiliation_string":"TUM Technische Universit\u00e4t M\u00fcnchen,, Munich, Germany","institution_ids":["https://openalex.org/I62916508"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5045738980"],"corresponding_institution_ids":["https://openalex.org/I1324840837"],"apc_list":null,"apc_paid":null,"fwci":3.4285,"has_fulltext":false,"cited_by_count":20,"citation_normalized_percentile":{"value":0.9274887,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"43","issue":"1","first_page":"92","last_page":"98"},"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.9979000091552734,"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.9979000091552734,"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/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9872000217437744,"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/T11106","display_name":"Data Management and Algorithms","score":0.9861000180244446,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9117039442062378},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7734171748161316},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.6980718374252319},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.5989970564842224},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5852671265602112},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5437541604042053},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5009379386901855},{"id":"https://openalex.org/keywords/skew","display_name":"Skew","score":0.49660593271255493},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.47812286019325256},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.46778547763824463},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.46497273445129395},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4482380449771881},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.4328114688396454},{"id":"https://openalex.org/keywords/resource","display_name":"Resource (disambiguation)","score":0.42505884170532227},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.32939088344573975},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14806270599365234}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9117039442062378},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7734171748161316},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.6980718374252319},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.5989970564842224},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5852671265602112},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5437541604042053},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5009379386901855},{"id":"https://openalex.org/C43711488","wikidata":"https://www.wikidata.org/wiki/Q7534783","display_name":"Skew","level":2,"score":0.49660593271255493},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.47812286019325256},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.46778547763824463},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.46497273445129395},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4482380449771881},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.4328114688396454},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.42505884170532227},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.32939088344573975},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14806270599365234},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.0},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1496909.1496927","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1496909.1496927","pdf_url":null,"source":{"id":"https://openalex.org/S50071195","display_name":"ACM SIGOPS Operating Systems Review","issn_l":"0163-5980","issn":["0163-5980","1943-586X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGOPS Operating Systems Review","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5299999713897705,"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W26718904","https://openalex.org/W27709051","https://openalex.org/W1523227732","https://openalex.org/W1530684339","https://openalex.org/W1596568456","https://openalex.org/W1604438401","https://openalex.org/W1964297545","https://openalex.org/W1991571419","https://openalex.org/W1998085622","https://openalex.org/W2016622853","https://openalex.org/W2026024369","https://openalex.org/W2038057969","https://openalex.org/W2060377179","https://openalex.org/W2100773341","https://openalex.org/W2102166438","https://openalex.org/W2102303750","https://openalex.org/W2112847223","https://openalex.org/W2119414841","https://openalex.org/W2120451551","https://openalex.org/W2124101779","https://openalex.org/W2132567170","https://openalex.org/W2149666876","https://openalex.org/W2150304332","https://openalex.org/W2153231596","https://openalex.org/W2162567058","https://openalex.org/W2535299704","https://openalex.org/W4285719527","https://openalex.org/W6601087826","https://openalex.org/W6631832323"],"related_works":["https://openalex.org/W1555950237","https://openalex.org/W2804682780","https://openalex.org/W2084383859","https://openalex.org/W3166336118","https://openalex.org/W2188262136","https://openalex.org/W834810655","https://openalex.org/W2188975716","https://openalex.org/W171602259","https://openalex.org/W2102729946","https://openalex.org/W2240092424"],"abstract_inverted_index":{"We":[0,160],"explore":[1],"how":[2,69],"to":[3,37,67,107,120,134],"manage":[4],"database":[5],"workloads":[6,136],"that":[7,14,27,83,137],"contain":[8],"a":[9,44,94,145,172],"mixture":[10],"of":[11,93,130,156,167,174],"OLTP-like":[12],"queries":[13,23,42,71,157],"run":[15],"for":[16,29,86,151],"milliseconds":[17],"as":[18,20,53],"well":[19],"business":[21,49],"intelligence":[22],"and":[24,39,59,90,100,147,169],"maintenance":[25],"tasks":[26],"last":[28],"hours.":[30],"As":[31],"data":[32,57],"warehouses":[33],"grow":[34],"in":[35,47,105],"size":[36],"petabytes":[38],"complex":[40],"analytic":[41],"play":[43],"greater":[45],"role":[46],"day-to-day":[48],"operations,":[50],"factors":[51],"such":[52,70,103],"inaccurate":[54,123],"cardinality":[55],"estimates,":[56],"skew,":[58],"resource":[60,88,154],"contention":[61],"all":[62],"make":[63,108],"it":[64],"notoriously":[65],"difficult":[66],"predict":[68],"will":[72],"behave":[73],"before":[74,158],"they":[75],"start":[76],"executing.":[77],"However,":[78],"traditional":[79],"workload":[80,95,110,131],"management":[81,111,132],"assumes":[82],"accurate":[84,149],"expectations":[85],"the":[87,128,153],"requirements":[89],"performance":[91],"characteristics":[92],"are":[96],"available":[97],"at":[98],"compile-time,":[99],"relies":[101],"on":[102,171],"information":[104],"order":[106],"critical":[109],"decisions.":[112],"In":[113],"this":[114],"paper,":[115],"we":[116,126,143],"describe":[117,144],"our":[118,175],"approach":[119],"dealing":[121],"with":[122],"predictions.":[124],"First,":[125],"evaluate":[127],"ability":[129],"algorithms":[133],"handle":[135],"include":[138],"unexpectedly":[139],"long-running":[140],"queries.":[141],"Second,":[142],"new":[146],"more":[148],"method":[150],"predicting":[152],"usage":[155],"runtime.":[159],"have":[161],"carried":[162],"out":[163],"an":[164],"extensive":[165],"set":[166],"experiments,":[168],"report":[170],"few":[173],"results.":[176]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}