{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.003888102,0.001329373,0.0008434638,0.00121376,0.0006086152,0.003247274,0.004110447,0.0009913174,0.01560681],"category_scores_gemma":[0.01120292,0.001905191,0.001656984,0.0009859181,0.001156682,0.005203715,0.004877496,0.003821641,0.009105631],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0009796036,"about_ca_system_score_gemma":0.002566619,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001470658,"about_ca_topic_score_gemma":0.002134668,"domain_scores_codex":[0.9967864,0.0005190295,0.0004127682,0.0005090137,0.001401927,0.0003708684],"domain_scores_gemma":[0.9951541,0.002374265,0.00022484,0.001111792,0.0009022431,0.0002327808],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.001315888,0.0006574457,0.004506996,0.001384841,0.0002036594,0.001058453,0.001508717,0.02161512,0.02881287,0.1906482,0.277573,0.4707148],"study_design_scores_gemma":[0.0004937099,0.0002154601,0.001426484,0.0004227516,0.0001018724,0.001062736,0.0003008941,0.3101048,0.0741007,0.1332645,0.478248,0.0002580604],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"software","genre_scores_codex":[0.002461473,0.0001568178,0.8429856,0.0001580326,0.000133614,0.0001576106,0.001562506,0.1469442,0.005440124],"genre_scores_gemma":[0.04230125,0.0003243505,0.8780206,0.0005170684,0.0001071172,0.0006183015,0.008286995,0.06425599,0.005568267],"genre_candidate":"software","genre_consensus":null,"teacher_disagreement_score":0.01560681,"threshold_uncertainty_score":0.05221003,"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."}}