{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0001005691,0.00005812953,0.00009230935,0.00001954446,0.00006493085,0.00005812104,0.0001545508,0.00001919018,0.00002673437],"category_scores_gemma":[0.00009269127,0.00004656003,0.000008349629,0.0001154219,0.00001140036,0.0008594855,0.0004709693,0.00004754519,0.000004003324],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00008944004,"about_ca_system_score_gemma":0.00009476787,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0005423934,"about_ca_topic_score_gemma":0.0003553309,"domain_scores_codex":[0.9993711,0.00002859159,0.0001040123,0.0002796318,0.0001303295,0.00008639973],"domain_scores_gemma":[0.9991882,0.00002834451,0.0000283913,0.0006627547,0.00004620326,0.00004607179],"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.00001230706,0.00004847626,0.0003768733,0.00003814089,0.00002054931,0.0003770424,0.002098097,0.00001808625,0.02706666,0.6647591,0.008486556,0.2966981],"study_design_scores_gemma":[0.000790234,0.0001614422,0.0002051126,0.0001508703,0.00002206445,0.0006490578,0.003847443,0.1220848,0.05385132,0.001946678,0.8156259,0.0006650821],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01198797,0.0007629676,0.9853855,0.0002596829,0.0001990296,0.00003115404,0.00003511466,0.00005943586,0.001279138],"genre_scores_gemma":[0.08120317,0.00004589582,0.9158927,0.0001984825,0.0001126783,0.000001359759,0.0001106733,0.000006746717,0.002428246],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.8071393,"threshold_uncertainty_score":0.1898663,"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."}}