{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0007203585,0.00006148475,0.0001052612,0.00013675,0.0002304161,0.0001529303,0.0007417764,0.000007035423,0.000005829089],"category_scores_gemma":[0.00002931116,0.00004967711,0.000008595516,0.000102716,0.00001125255,0.005578417,0.004022923,0.00009404479,4.221403e-7],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00007353387,"about_ca_system_score_gemma":0.00001949959,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003521808,"about_ca_topic_score_gemma":0.000004272633,"domain_scores_codex":[0.9991132,0.00003351573,0.0004019396,0.0001024649,0.000269908,0.00007895575],"domain_scores_gemma":[0.9989074,0.00001931137,0.0003972715,0.0005975892,0.00002900716,0.00004944823],"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.00005410476,0.000078624,0.0008087325,0.0003010817,0.0001677811,0.0001119152,0.002695023,0.004768027,0.0000234224,0.06937823,0.0215784,0.9000347],"study_design_scores_gemma":[0.0002618794,0.00006637611,0.00008032929,0.0000239243,0.00001438655,0.0004372423,0.001697118,0.182805,0.000003535747,0.00007131987,0.8144603,0.00007850278],"study_design_candidate":"design_other","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.006490061,0.0005901087,0.9920171,0.0002631509,0.0002854812,0.00006989119,0.0001182927,0.00001105778,0.0001548378],"genre_scores_gemma":[0.112071,0.0007607318,0.8855058,0.0009612615,0.0001388184,0.000003099997,0.0004699085,0.000007400462,0.00008202576],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.8999562,"threshold_uncertainty_score":0.5014285,"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."}}