{"id":"W4395686962","doi":"10.1145/3626246.3654743","title":"OpenIVM: a SQL-to-SQL Compiler for Incremental Computations","year":2024,"lang":"en","type":"preprint","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"Nederlandse Organisatie voor Wetenschappelijk Onderzoek","keywords":"Computer science; SQL; Compiler; Stored procedure; Materialized view; Query by Example; Database; Programming language; Online analytical processing; SQL/PSM; PL/SQL; Data definition language; Table (database); Operating system; Data warehouse; View; Information retrieval; Database design; Search engine","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":["metaepi_narrow"],"consensus_categories":[],"category_scores_codex":[0.0002694927,0.000317494,0.0004039656,0.0002103673,0.0001719037,0.0003641699,0.0009056519,0.000108114,0.00004699482],"category_scores_gemma":[0.00002557576,0.0002797544,0.0001756696,0.0002477399,0.00003704921,0.0002298599,0.006461958,0.0003219756,0.0004485985],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.000113623,"about_ca_system_score_gemma":0.000247458,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0003467652,"about_ca_topic_score_gemma":0.0002762844,"domain_scores_codex":[0.9979185,0.0000412191,0.0004642354,0.000957764,0.000288191,0.0003300306],"domain_scores_gemma":[0.9985043,0.0001277254,0.0001049703,0.0009335566,0.000158513,0.0001708803],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[0.000008140915,0.00004660216,0.00001208725,0.0004291258,0.0000875476,0.000013157,0.0007557704,0.003803065,0.0001310314,0.8999062,0.08263735,0.01216995],"study_design_scores_gemma":[0.0005614262,0.0001747841,0.00009598919,0.0008340799,0.00004658908,0.00003691338,0.0004602354,0.2745475,0.00135687,0.04682951,0.6738799,0.001176225],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.0007517969,0.0002056871,0.9861981,0.002394805,0.002620098,0.001680234,0.0008591653,0.0005090095,0.004781089],"genre_scores_gemma":[0.08083081,0.000005757434,0.9129329,0.001392856,0.0003376655,0.0006967169,0.0004279383,0.00003980256,0.003335518],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.8530766,"threshold_uncertainty_score":0.9999655,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04095589281093408,"score_gpt":0.3310760966211035,"score_spread":0.2901202038101694,"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."}}