{"id":"W4302017498","doi":"10.5753/jidm.2022.2488","title":"Integrating Heterogeneous Stream and Historical Data Sources using SQL","year":2022,"lang":"en","type":"article","venue":"Journal of Information and Data Management","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":4,"is_retracted":false,"has_abstract":true,"ca_institutions":"Western University","funders":"","keywords":"Computer science; SQL; Data integration; Task (project management); Context (archaeology); Stored procedure; Relational database; Point (geometry); Database; Data science; Information retrieval; Query by Example","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.01193068,0.001445918,0.001521893,0.003715543,0.0008413105,0.007601537,0.002720098,0.001114503,0.002268893],"category_scores_gemma":[0.0112476,0.0009403672,0.001808887,0.003650417,0.001108935,0.007967812,0.004327611,0.001907194,0.001440931],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0007883301,"about_ca_system_score_gemma":0.001975677,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003010027,"about_ca_topic_score_gemma":0.002312412,"domain_scores_codex":[0.9917747,0.001703749,0.002110763,0.001095802,0.003035001,0.0002799802],"domain_scores_gemma":[0.9929498,0.0026484,0.0006830267,0.002025612,0.001406267,0.0002869006],"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.002449266,0.001121391,0.02791716,0.002931878,0.001643695,0.004341478,0.009128624,0.06223062,0.08240816,0.2419114,0.02684211,0.5370743],"study_design_scores_gemma":[0.0003354513,0.0005626142,0.005772945,0.0007374975,0.0006408321,0.002362749,0.003210338,0.5219977,0.09468822,0.1771725,0.1920072,0.0005120202],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.009122495,0.0003027978,0.9712666,0.0003501446,0.00004853825,0.0003557111,0.001691138,0.01487365,0.00198898],"genre_scores_gemma":[0.1625772,0.0009398003,0.8212779,0.0005399126,0.0001379698,0.0005144079,0.009640555,0.001776783,0.002595472],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.01193068,"threshold_uncertainty_score":0.06309617,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.05790245111411804,"score_gpt":0.2842145215236848,"score_spread":0.2263120704095668,"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."}}