{"id":"W4200539811","doi":"10.5753/sbbd.2021.17877","title":"Stream and Historical Data Integration using SQL as Standard Language","year":2021,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":true,"ca_institutions":"Western University","funders":"","keywords":"Computer science; SQL; Data integration; Streaming data; Process (computing); Data definition language; Relational database; Contextualization; Database; Point (geometry); Information retrieval; Data mining; Programming language","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.008214831,0.0009550724,0.001056407,0.00291076,0.0006702613,0.005559196,0.001873336,0.000803237,0.003729471],"category_scores_gemma":[0.009737525,0.0007476924,0.001662698,0.003288766,0.001130072,0.007399973,0.003993831,0.001956103,0.001933022],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0006507235,"about_ca_system_score_gemma":0.002022685,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002279082,"about_ca_topic_score_gemma":0.00140146,"domain_scores_codex":[0.9910867,0.001898061,0.002253748,0.001177305,0.003302851,0.0002813207],"domain_scores_gemma":[0.9939278,0.001876055,0.000566549,0.001730076,0.001685384,0.0002141034],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.001171866,0.0004725262,0.01061059,0.001723961,0.0006207933,0.002220642,0.005865964,0.0181313,0.04887539,0.4488456,0.03937017,0.4220912],"study_design_scores_gemma":[0.0001829867,0.0004348816,0.004101542,0.0005427178,0.0003461924,0.002148619,0.002086117,0.1866542,0.08172996,0.2254684,0.4960023,0.0003020566],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.00349783,0.0001979823,0.9840934,0.0002656175,0.00007633409,0.0002016586,0.001253481,0.007711607,0.002702141],"genre_scores_gemma":[0.0899982,0.0007913574,0.8911891,0.0006859985,0.000217114,0.000573796,0.009203578,0.002422878,0.004917915],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.008214831,"threshold_uncertainty_score":0.04344469,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.05652361904121651,"score_gpt":0.315319332826608,"score_spread":0.2587957137853915,"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."}}