{"id":"https://openalex.org/W7225455371","doi":"https://doi.org/10.5281/zenodo.24026463","title":"Predictive Query Computation: Forecasting Future Database Workloads and Proactively Preparing Query Results","display_name":"Predictive Query Computation: Forecasting Future Database Workloads and Proactively Preparing Query Results","publication_year":2026,"publication_date":"2026-11-07","ids":{"openalex":"https://openalex.org/W7225455371","doi":"https://doi.org/10.5281/zenodo.24026463"},"language":"en","primary_location":{"id":"doi:10.5281/zenodo.24026463","doi":"https://doi.org/10.5281/zenodo.24026463","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.24026463","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"volume":null,"type":"preprint","is_traditional":true,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5281/zenodo.24026463","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100638045","display_name":"Jincheng Zhang","orcid":"https://orcid.org/0000-0001-7332-6704","observed_orcids":["https://orcid.org/0000-0001-7332-6704","https://orcid.org/0009-0005-1860-0009"]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Zhang, Jincheng","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0009-0005-1860-0009","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5100638045"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"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.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/T11106","display_name":"Data Management and Algorithms","score":0.0003000000142492354,"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/T10101","display_name":"Cloud Computing and Resource Management","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/workload-prediction","display_name":"workload prediction","score":0.7369999885559082},{"id":"https://openalex.org/keywords/precomputation","display_name":"precomputation","score":0.7429999709129333},{"id":"https://openalex.org/keywords/query-result-reuse","display_name":"query result reuse","score":0.5690000057220459},{"id":"https://openalex.org/keywords/incremental-view-maintenance","display_name":"incremental view maintenance","score":0.9049999713897705},{"id":"https://openalex.org/keywords/cost-aware-optimization","display_name":"cost-aware optimization","score":0.5239999890327454},{"id":"https://openalex.org/keywords/database-consistency","display_name":"database consistency","score":0.3919999897480011},{"id":"https://openalex.org/keywords/workload-scheduling","display_name":"workload scheduling","score":0.3659999966621399},{"id":"https://openalex.org/keywords/materialized-views","display_name":"materialized views","score":0.5720000267028809},{"id":"https://openalex.org/keywords/query-caching","display_name":"query caching","score":0.6230000257492065},{"id":"https://openalex.org/keywords/intermediate-outcomes","display_name":"intermediate outcomes","score":0.4569999873638153},{"id":"https://openalex.org/keywords/cloud-databases","display_name":"cloud databases","score":0.328000009059906}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8730000257492065},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7626000046730042},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6832000017166138},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.659500002861023},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6589000225067139},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6560999751091003},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6371999979019165},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6305999755859375},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5924999713897705},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.572700023651123},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.5526999831199646},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.5430999994277954},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.5146999955177307},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4334000051021576},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.41760000586509705},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.397599995136261},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.32100000977516174},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.31279999017715454},{"id":"https://openalex.org/C136736807","wikidata":"https://www.wikidata.org/wiki/Q818943","display_name":"Range query (database)","level":5,"score":0.3034999966621399},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.30309998989105225},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.30160000920295715},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.298799991607666},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2985999882221222},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.28839999437332153},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.28450000286102295},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.2815000116825104},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.27489998936653137},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.26579999923706055},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.2563000023365021}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5281/zenodo.24026463","doi":"https://doi.org/10.5281/zenodo.24026463","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.24026463","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},{"id":"doi:10.5281/zenodo.24026464","doi":"https://doi.org/10.5281/zenodo.24026464","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.24026464","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.5281/zenodo.24026463","doi":"https://doi.org/10.5281/zenodo.24026463","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.24026463","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"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/W7153615632","https://openalex.org/W4390722850","https://openalex.org/W2182561294","https://openalex.org/W7132844025","https://openalex.org/W7117585604","https://openalex.org/W7084071796","https://openalex.org/W7131379592","https://openalex.org/W4385270244","https://openalex.org/W2025619570","https://openalex.org/W2011300314"],"abstract_inverted_index":{"The":[0,170,298,382,443],"increasing":[1],"complexity":[2],"of":[3,231,245,254,289,394],"modern":[4],"database":[5,29,70,118,141,158,335,371,397,407,433,504,509],"systems":[6,71,510],"has":[7],"introduced":[8],"substantial":[9],"computational":[10,61,88,178,195,243,296,390,465,497],"costs":[11,253,480],"associated":[12],"with":[13,491],"analytical":[14,92],"queries,":[15,86],"transactional":[16],"workloads,":[17,147],"data":[18,262,467],"aggregation,":[19],"multi-table":[20],"joins,":[21],"and":[22,40,101,123,161,183,187,196,223,265,286,294,309,322,358,370,440,474,481,495,514],"recurring":[23,91],"enterprise":[24],"reporting":[25,156],"operations.":[26],"Although":[27],"existing":[28],"optimization":[30,237],"techniques,":[31],"including":[32],"query":[33,38,47,78,148,168,191,206,225,247,256,292,368,428,431,451,462,493,518],"optimization,":[34],"indexing,":[35],"materialized":[36,279],"views,":[37,280],"caching,":[39],"incremental":[41,218],"view":[42],"maintenance,":[43,219,261],"have":[44,64,318],"significantly":[45],"improved":[46],"execution":[48,151,192,285,380,429,479,494],"efficiency,":[49],"their":[50,355],"operational":[51,102],"mechanisms":[52,317],"remain":[53],"largely":[54],"dependent":[55],"on":[56,459],"previously":[57,342],"observed":[58],"workloads":[59,274],"or":[60,90,278,351,405,413],"requests":[62,129,522],"that":[63,114,239,270,315,449],"already":[65],"arrived.":[66],"In":[67],"particular,":[68],"conventional":[69],"generally":[72],"execute":[73],"a":[74,111,235,363,502],"newly":[75],"submitted":[76],"SQL":[77,128,146,203,488],"after":[79],"receiving":[80],"the":[81,137,232,241,252,283,338,386,475],"request,":[82],"even":[83],"when":[84,399],"similar":[85],"shared":[87,181,209,295,464],"structures,":[89],"requirements":[93],"may":[94,409],"be":[95,121,346,410],"anticipated":[96],"from":[97],"historical":[98,145],"workload":[99,163,204,460,489],"patterns":[100],"schedules.":[103],"This":[104,361],"paper":[105],"introduces":[106],"Predictive":[107],"Query":[108],"Computation":[109],"(PQC),":[110],"conceptual":[112],"framework":[113,171,233,299,339,383],"investigates":[115,340,385],"whether":[116,341],"future":[117,167,202,291,367,482,487,517],"queries":[119,135,175],"can":[120,345],"predicted":[122,174,273],"selectively":[124,188,349],"executed":[125],"before":[126,520],"corresponding":[127],"materialize.":[130],"Rather":[131],"than":[132,374],"treating":[133,375],"incoming":[134],"as":[136,377],"exclusive":[138],"triggers":[139],"for":[140],"computation,":[142,313],"PQC":[143,281],"analyzes":[144],"templates,":[149],"temporal":[150],"patterns,":[152,160],"application":[153],"behavior,":[154],"scheduled":[155],"activities,":[157],"update":[159,468],"contextual":[162],"signals":[164],"to":[165,275,329,354,366,388,420,512],"estimate":[166],"requirements.":[169,324,360],"subsequently":[172],"transforms":[173],"into":[176],"candidate":[177],"tasks,":[179],"identifies":[180],"subqueries":[182],"reusable":[184],"intermediate":[185,312],"results,":[186],"performs":[189],"proactive":[190,214,492],"under":[193],"available":[194,412],"storage":[197,403,436,472],"constraints.":[198],"Its":[199,456],"architecture":[200],"integrates":[201],"forecasting,":[205],"template":[207],"prediction,":[208,255],"subquery":[210,307],"identification,":[211],"cost-aware":[212],"precomputation,":[213],"result":[215,221,226,260,425,441,470],"materialization,":[216],"update-aware":[217,330,496],"freshness-aware":[220],"validation,":[222,264],"adaptive":[224],"delivery.":[227],"A":[228],"central":[229],"component":[230],"is":[234,327,418,453],"unified":[236],"formulation":[238],"evaluates":[240],"expected":[242],"benefits":[244],"preparing":[246],"results":[248,293,344],"in":[249,507],"advance":[250,478],"against":[251],"execution,":[257],"intermediate-result":[258],"storage,":[259],"updates,":[263],"unsuccessful":[266],"predictions.":[267],"Unlike":[268],"approaches":[269],"primarily":[271],"use":[272],"select":[276],"indexes":[277],"emphasizes":[282],"predictive":[284,450,503],"lifecycle":[287],"management":[288],"specific":[290],"intermediates.":[297],"further":[300],"distinguishes":[301],"between":[302,477],"complete":[303],"query-result":[304],"reuse,":[305,308,426,498],"partial":[306],"incrementally":[310,347],"maintained":[311],"recognizing":[314],"these":[316],"different":[319],"compatibility,":[320,471],"consistency,":[321],"maintenance":[323],"Particular":[325],"attention":[326],"given":[328],"computation":[331,452,483],"reuse.":[332],"When":[333],"underlying":[334],"records":[336],"change,":[337],"prepared":[343],"maintained,":[348],"invalidated,":[350],"recomputed":[352],"according":[353],"dependency":[356],"relationships":[357],"freshness":[359],"enables":[362],"coordinated":[364],"approach":[365],"prediction":[369,422],"consistency":[372],"rather":[373],"precomputation":[376],"an":[378],"isolated":[379],"operation.":[381],"also":[384],"potential":[387],"schedule":[389],"preparation":[391],"during":[392],"periods":[393],"relatively":[395],"low":[396],"utilization,":[398,435],"CPU,":[400],"GPU,":[401],"memory,":[402],"bandwidth,":[404],"cloud":[406],"resources":[408],"comparatively":[411],"economical.":[414],"An":[415],"experimental":[416],"methodology":[417],"established":[419],"evaluate":[421],"accuracy,":[423],"successful":[424],"total":[427],"expenditure,":[430],"latency,":[432],"resource":[434],"overhead,":[437],"update-maintenance":[438],"cost,":[439],"freshness.":[442],"proposed":[444],"research":[445,500],"does":[446],"not":[447],"assume":[448],"universally":[454],"beneficial.":[455],"effectiveness":[457],"depends":[458],"predictability,":[461],"recurrence,":[463],"structure,":[466],"frequency,":[469],"availability,":[473],"relationship":[476],"avoided.":[484],"By":[485],"connecting":[486],"forecasting":[490],"this":[499],"proposes":[501],"computing":[505],"paradigm":[506],"which":[508],"attempt":[511],"anticipate":[513],"prepare":[515],"selected":[516],"computations":[519],"actual":[521],"arrive.":[523]},"counts_by_year":[],"updated_date":"2026-11-09T13:22:03.289127","created_date":"2026-11-08T00:00:00"}