{"id":"W2485497874","doi":"10.1145/2851613.2851657","title":"Improving SQL query performance on embedded devices using pre-compilation","year":2016,"lang":"en","type":"article","venue":"","topic":"Cloud Computing and Resource Management","field":"Computer Science","cited_by":4,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of British Columbia","funders":"Natural Sciences and Engineering Research Council of Canada","keywords":"Computer science; SQL; Mobile device; Overhead (engineering); Relational database; Database; Parsing; Relational database management system; Embedded system; Operating system; Programming language","routes":{"ca_aff":true,"ca_fund":true,"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.0002799522,0.0001195992,0.00009611712,0.0001018043,0.0001799985,0.0001196594,0.0004864254,0.00003352091,0.00001184269],"category_scores_gemma":[0.0000140654,0.00007272818,0.00004077223,0.000180338,0.00001891485,0.00009104147,0.0002961037,0.00005273527,0.00006041313],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00006546199,"about_ca_system_score_gemma":0.00002055548,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003234557,"about_ca_topic_score_gemma":0.000002712877,"domain_scores_codex":[0.9989249,0.00003827545,0.0001850892,0.000354128,0.0002456834,0.0002519832],"domain_scores_gemma":[0.9992715,0.00008355921,0.0001032162,0.0004559573,0.00003543663,0.00005037705],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00001574661,0.00007624795,0.007407087,0.00005862318,0.00002308958,0.000004227657,0.0007292545,0.03225301,0.00872373,0.006793105,0.0002280254,0.9436879],"study_design_scores_gemma":[0.0002289933,0.00008172753,0.01920421,0.0001095614,0.000003663606,0.000003831854,0.0000180241,0.9760767,0.003441983,0.000056149,0.0006080219,0.0001671419],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.6323146,0.00001063878,0.3640145,0.0001864395,0.0001989757,0.00007611422,1.345131e-7,0.0002067377,0.002991884],"genre_scores_gemma":[0.9745474,0.000001119235,0.023419,0.000283225,0.0001252778,0.000002328615,1.709232e-7,0.00000713189,0.001614372],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.9438237,"threshold_uncertainty_score":0.2965769,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01630497032885237,"score_gpt":0.2375031969605302,"score_spread":0.2211982266316778,"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."}}