{"id":"W2909564896","doi":"10.14778/3352063.3352120","title":"Guided automated learning for query workload re-optimization","year":2019,"lang":"en","type":"preprint","venue":"Proceedings of the VLDB Endowment","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"York University; IBM (Canada); Ontario Tech University","funders":"","keywords":"Computer science; Query optimization; Sargable; Web query classification; Query expansion; Web search query; Query language; SQL; Query plan; Query by Example; Knowledge base; View; SPARQL; Online aggregation; Spatial query; Database; Information retrieval; RDF query language; Data mining; RDF; World Wide Web; Semantic Web; Search engine; Database design","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0005967803,0.000318986,0.000467874,0.0001270101,0.0001792785,0.0001355239,0.001203652,0.0001720579,0.000005153577],"category_scores_gemma":[0.0003151286,0.0002370738,0.0002318467,0.0002519192,0.00004890588,0.0004291637,0.002485057,0.0003439212,0.000004930471],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0001677993,"about_ca_system_score_gemma":0.0001192678,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00006034683,"about_ca_topic_score_gemma":0.000001400127,"domain_scores_codex":[0.9979,0.00001743144,0.0006280646,0.0006686255,0.00044464,0.0003412356],"domain_scores_gemma":[0.9977103,0.00007546852,0.001148648,0.0004675306,0.0005422369,0.00005578752],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00004822862,0.0001015104,0.001027943,0.002444312,0.0001959322,4.324511e-7,0.00174464,0.918273,0.004550199,0.05035177,0.01812813,0.003133936],"study_design_scores_gemma":[0.0006730152,0.0000973591,0.0001201912,0.00234684,0.00005377983,0.000008039998,0.0002378177,0.9520628,0.02382861,0.001849745,0.01820694,0.0005149057],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.003926659,0.0006850238,0.9834601,0.001372371,0.002476285,0.003163055,0.00003622903,0.001060031,0.00382028],"genre_scores_gemma":[0.2716984,0.0003446585,0.7234798,0.000222699,0.0003265735,0.0008705215,0.00004662804,0.00008110121,0.002929599],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.2677718,"threshold_uncertainty_score":0.9667588,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02507103249288796,"score_gpt":0.2745905191098624,"score_spread":0.2495194866169744,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}