{"id":"https://openalex.org/W5925479","doi":null,"title":"On Modeling and Predicting Query Behavior in OLAP Systems.","display_name":"On Modeling and Predicting Query Behavior in OLAP Systems.","publication_year":1999,"publication_date":"1999-01-01","ids":{"openalex":"https://openalex.org/W5925479","mag":"5925479"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.27.7460","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.27.7460","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.forwiss.de/~system42/publications/dmdw99_final.pdf","raw_type":"text"},"volume":null,"type":"article","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/A5000575508","display_name":"Carsten Sapia","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Carsten Sapia","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5000575508"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.2088,"has_fulltext":false,"cited_by_count":51,"citation_normalized_percentile":{"value":0.90294668,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"2","last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.6205999851226807,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.6205999851226807,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.37040001153945923,"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.0019000000320374966,"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/olap-systems","display_name":"OLAP systems","score":0.8050000071525574},{"id":"https://openalex.org/keywords/multidimensional-analysis","display_name":"multidimensional analysis","score":0.8220000267028809},{"id":"https://openalex.org/keywords/data-warehouse-design","display_name":"data warehouse design","score":0.9610000252723694},{"id":"https://openalex.org/keywords/speculative-execution","display_name":"speculative execution","score":0.6610000133514404}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9271626472473145},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8198126554489136},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.616718053817749},{"id":"https://openalex.org/C2779182362","wikidata":"https://www.wikidata.org/wiki/Q17126187","display_name":"Session (web analytics)","level":2,"score":0.5478739738464355},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4539378583431244},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4337162971496582},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3939814567565918},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3568512797355652},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.10983633995056152}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.27.7460","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.27.7460","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.forwiss.de/~system42/publications/dmdw99_final.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.41.2383","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.41.2383","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-19/paper2.pdf","raw_type":"text"},{"id":"mag:5925479","doi":null,"is_oa":false,"landing_page_url":"http://ceur-ws.org/Vol-19/paper2.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":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W38346608","https://openalex.org/W1481595995","https://openalex.org/W1530537858","https://openalex.org/W1568922908","https://openalex.org/W1603838668","https://openalex.org/W2052884373","https://openalex.org/W2071979553","https://openalex.org/W2110451601","https://openalex.org/W2113888164","https://openalex.org/W2119092599","https://openalex.org/W2119783318","https://openalex.org/W2170235279","https://openalex.org/W2183599186","https://openalex.org/W2490591675","https://openalex.org/W2661743557"],"related_works":["https://openalex.org/W2752695557","https://openalex.org/W2353989010","https://openalex.org/W7097002217","https://openalex.org/W2145663758","https://openalex.org/W145966748","https://openalex.org/W2384319907","https://openalex.org/W4392498459","https://openalex.org/W70272761","https://openalex.org/W907081002","https://openalex.org/W2284276478"],"abstract_inverted_index":{"Interactive":[0],"multidimensional":[1,69],"data":[2,17,32,146],"analysis":[3],"tools":[4,12,144],"(mostly":[5],"OLAP":[6,73,118,138],"systems)":[7],"are":[8,140],"the":[9,21,31,40,46,78,86,94,104,132,141],"predominant":[10,142],"frontend":[11,143],"for":[13,64,145],"end":[14],"users":[15],"in":[16,72],"warehouse":[18,33],"environments.":[19],"Thus,":[20],"design":[22,34,42,108],"of":[23,30,48,85,96,131],"these":[24],"systems":[25,119,139],"is":[26,99],"an":[27,113],"important":[28,41],"part":[29],"itself.":[35],"This":[36],"paper":[37],"contributes":[38],"to":[39,115],"step":[43],"by":[44,122],"discussing":[45],"modeling":[47,95],"user":[49,87,97,133],"query":[50,88,134],"behavior":[51,98],"and":[52,60,82,106],"its":[53],"benefits.":[54],"We":[55],"present":[56,112],"a":[57,61,129],"mathematical":[58],"model":[59],"graphical":[62],"notation":[63],"capturing":[65],"knowledge":[66],"about":[67],"typical":[68],"interaction":[70],"patterns":[71],"systems,":[74],"taking":[75],"into":[76],"account":[77],"session":[79],"oriented,":[80],"interactive":[81],"navigational":[83],"nature":[84],"behavior.":[89,135],"To":[90],"exemplarily":[91],"show":[92],"that":[93],"not":[100],"only":[101],"beneficial":[102],"during":[103],"logical":[105],"physical":[107],"phase,":[109],"we":[110],"also":[111],"architecture":[114],"speed":[116],"up":[117],"at":[120],"runtime":[121],"using":[123],"speculative":[124],"execution":[125],"techniques":[126],"based":[127],"on":[128],"prediction":[130],"1":[136],"Introduction":[137],"war...":[147]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":7}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2016-06-24T00:00:00"}